mysql

  1. B

    Question Https + cdn

    Hi, I tried to activate the CDN Integration of vB Optimise. When I enter my Windows Azure details everything seems to work fine. The data syncs and the site works fine in Firefox and Opera. However one browser tells me, that not everything is as it should be: Internet Explorer is precise and...
  2. F

    Bug DB Error

    Trying to use vbArcade Lite to see whether I want to purchase it. It installed okay, at least I thought it did, but I keep getting this error. Database error in vBulletin 5.1.1: Invalid SQL: SELECT...
  3. R

    Bug Database error on search

    If extra spaces or * characters are in the search it fails. Database error in vBulletin 4.2.2: Invalid SQL: SELECT COUNT(imageid) AS imagecount FROM dbtech_gallery_images WHERE instanceid = 1 && approved...
  4. anicolac

    Question My Feedback History - Blank page after Feedback received

    Hello. Please, can someone tell me what can I do to fix this? It happens both with the English language as the Spanish I tried it in Safari, Firefox and Chrome. I have AdBlock disabled Version server: Linux: PHP 5.4.4, MySQL 5.5 I searched the forum and have not found anyone that happened In a...
  5. anicolac

    Question Time format error in Spanish language

    [solved] Time format error in Spanish language Hello. Does anyone know what files I need to modify to fix this? If I have selected the Spanish language, date / time, only one "r". url: Apple Maníacos with the English language, yes it looks good I thought it may come caused by...
  6. M

    Question Sitemap - Can't Manual Build

    I can't get the Sitemap to build. It keeps hanging. Every time it runs it stops at processing.... and no other part of the script is run. Here is what I have done to solve - Re-uploaded the files (twice) Checked all mysql settings as previous suggested disabled / re-enabled I am prepared to...
  7. H

    Question Slow Queries

    This particular query started running really slow today: # User@Host: root[root] @ [10.0.0.3] # Thread_id: 443035 Schema: lipstick_forum QC_hit: No # Query_time: 979.511385 Lock_time: 781.017818 Rows_sent: 0 Rows_examined: 0 SET timestamp=1398816291; DELETE FROM dbtech_thanks_recententry...
  8. AnjaC

    Bug Update error on 1.0.14

    Hi! When we update any modification we always close the board during the install and file upload process. When updating dbseo to the latest version we can´t open or reclose the board because of the following error: Warnung: require([path]/dbtech/dbseo/hooks/admin_options_processing.php)...
  9. B

    Question Database errors

    Hello Need some help ... today get many database errors Database error in vBulletin 4.2.2: Invalid SQL: INSERT INTO aaggregate_temp_1398445800 SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid; MySQL Error : Incorrect file format 'attachmentviews'...
  10. J

    Bug Slow Forum when DBSEO is installed

    Hello Since i installed this mod on my forum, it has become very slow, it is also crashing sometimes and causing very high mysql usage & CPU usage. I cannot see anything suspicious in mysqld.log file nor in the apache error log file. Any ideas why this is happening ? If i disable the mod...
  11. Em Kay

    Bug Recent Search returns a Database Error

    Database error in vBulletin 4.2.2: Invalid SQL: SELECT COUNT(*) AS count FROM ( SELECT COUNT(*) AS count FROM forum_dbtech_classifieds_listing AS l LEFT JOIN forum_dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid LEFT JOIN forum_attachment AS a ON...
  12. Em Kay

    Bug Small feedback issue

    While the feedback appears to be calculating correctly, the neg feedback is not showing in the number counts.. NM the arrows under the months thingy :P PS Thank you so much for the quick work on the updates for the bugs. Ill have my people run through this update and give it a good hammering...
  13. J

    Bug Feedback System a bit screwed up

    OK, So a member just recently reported that when he left feedback he ended doing it for himself rather than giving feedback to the person who bought something from. I checked this out when I got a notification that I was left feedback and that feedback is marked as if I left it rather than the...
  14. G

    Bug Crashing of datavbase server.

    I am having a problem when installing vBNotifications to my server. When importing the xml file I get the following errors... Warning: mysqli_query() [function.mysqli-query]: (HY000/2006): MySQL server has gone away in ..../includes/class_core.php on line 1393 So you can see what line 1393...
  15. R

    Bug Absolutely abysmal performance

    We had extremely high hopes for this addon but it absolutely crippled our database. We have roughly 8 million 'thanks' in our system and upon activating this product, we went from 0% CPU usage on our DB server to 25% nearly instantly. Eventually the connections piled up and the database server...
  16. M

    Bug Database Error

    Got this error in my logs for the arcade: ##################################### ===================================================== Database error in vBulletin 4.2.2: Invalid SQL: SELECT COUNT(*) AS plays, SUM(timefinish - timestart) AS timespent FROM theforumprefix__dbtech_vbarcade_session...
  17. M

    Bug Sitemap Building Error

    I'm getting the below error when I try to manually build the sitemap Database error in vBulletin 4.1.12: Invalid SQL: REPLACE INTO hcw_adminutil (title, text) VALUES ('sitemapsession'...
  18. J

    Bug Manage Listings (edit) , ended listings not checked

    Hi, When in admin; using the manage listings then choosing any listing that has ended the group radio options to say if the auction has ended are both not selected. And should you be able to restart the auction from here as when you choose no and submit it again it then defaults to no radio...
  19. J

    Question Performance question

    Hi Fillip H., sorry to bother you in another place but in my quest for vbseo removal I need to take care of thanks/vbseo likes. I've successfuly installed the lite version of the plugin and imported the vbseo likes. Recreated statistics and turned the plugin on. But the load on mysql server...
  20. M

    Bug Slow MYsql Query

    Found these in my slow query Log: Not sure if this is vbulletin Tags or the advanced tags???? Feel free to delete if nothing to do with this modification :) # Time: 140225 9:23:19 # User@Host: ****** @ [127.0.0.1] # Thread_id: 317407 Schema: vb44 QC_hit: No # Query_time: 10.502251...
Back
Top