• Support will be limited until May 8th, as I will be out of the office travelling. Thank you for your patience and understanding.

query

  1. T

    Bug Points not working when points column is not in user table

    I'm attempting to use another mod's existing points; vbexperience to be exact. I noticed that they are stored in two different locations. Once in the user table, and another in 'xperience_stats' > 'points_xperience'. However when I choose the xperience_stats as the Points Table the points do...
  2. ringnews24

    Bug Invalid query: Duplicate entry

    Invalid query: Duplicate entry '28804' for key 'PRIMARY'56 When I click certain threads/categorys I get the above error. I had Vbulletin look into the problem and they didn't know what it was. They suggested I disable SEO and remove the SEO code in .htaccess and the problem went away. I am...
  3. angeljs

    Bug Database error on import

    Upon importing the latest version of the mod, i received the following message: Database error in vBulletin 4.2.2: Invalid SQL: ### INSERT QUERY GENERATED BY fetch_query_sql() ### INSERT IGNORE INTO dbtech_thanks_recententry (`entryid`, `varname`, `userid`, `contenttype`, `contentid`...
  4. 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...
  5. J

    Bug performance issues on big-boards with lots of thanks/likes

    We're having very similar problems to http://www.dragonbyte-tech.com/f37/absolutely-abysmal-performance-14410/ but I didn't want to hijack his thread. We've added quite a few indexes to the dbtech_thanks_entry table to get it perform acceptably, however now that we're well over 7.5 million...
  6. 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...
  7. sevenmix

    Bug Error.log

    Hi I have lot of this on error_log: [07-Mar-2014 12:11:24 Europe/Berlin] PHP Warning: preg_match() [<a href='function.preg-match'>function.preg-match</a>]: Compilation failed: missing terminating ] for character class at offset 102 in...
  8. S

    Bug No Automatic Sitemap Generation after upgrade to 1.0.4

    Hi, i post all of it here http://www.dragonbyte-tech.com/f239/no-automatic-sitemap-generation-after-upgrade-1-0-4-a-14122/ and i reduce the number of items and test it (5000 and a day later 500) but no chance. Do you have any ideas?
  9. 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...
  10. 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...
  11. W

    Bug Error in Search After Install

    Parse error: syntax error, unexpected $end in /home2/public_html/forum/dbtech/thanks/actions/admin/search.php on line 55 Line 55 is a blank line... I am testing this on my local host before I move to my production board.
  12. P

    Bug Forum Performance Issues

    We have been experience site performance issues with vBulletin. I have inquired with our system administrator and this is what he said: "I'm seeing a TON of slow queries on DB01 (master), and there are some queries running related to vbShop points logs which are using up alot of resources...
  13. Force

    Bug htaccess

    Fatal error: Call to a member function query_write() on a non-object in /home3/maxces/public_html/global.php(29) : eval()'d code on line 133 When I put the info in the htaccess file I get this error if clicking on any forum section I can send any admin my htaccess if needed
  14. C

    Bug 400 bad request can't mark forums read

    I have vbseo and installed dbseo and imported the older vbseo setting so now- 1) mark forms read does not work I just get a white page 2) some links work and some don't link this one- 400 Bad Request I'm using the default htppacess file need help asap!
  15. Nirjonadda

    Bug Transaction Log

    If got to view transaction log and get error : /vbshop.php?do=transactionlog Warning: mysqli::query() [mysqli.query]: (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible = 1 AND dateline...
  16. S

    Bug Images/ Attachments not loading and generating vbdb errors

    Was running vbseo and vb3.8 previously and recently upgraded to vb4.2.2 and DBseo. I installed a cert and urls should be https.... performed the vBseo import and disabled the plug in. So tot he best of my knowledge I should be squared, however I getting db error the appear to pointing to http...
  17. mrderanged

    Bug Error on Install

    getting an error when trying to install reviews lite. everything seems to be going fine, then it starts upgrading to 1.0.0 It rebuilds the styles and then it comes up with: Invalid SQL (this is huge and it never posts when I paste it in here, so it's in the attached .txt file) MySQL Error...
  18. M

    Bug Listing Notification (1 Item Awaiting)

    Hi Mokonzi, First off thank you very much for the notification system - I love that, that will be so helpful!!! Just a quick one regarding the notification system. I have to explain that since the early betas I have had one item awaiting moderation in the queue but there is nothing that...
  19. J

    Bug Database load increase

    I've tried to transfer my forum from vbseo to dbseo tonight, but there was a significant increase in database load and had to revert the procedure. There was a huge spike in query numbers with dbseo and althought the queries themselves didn't seem to be very intensive - the sheer number of them...
  20. M

    Bug Php-error

    Hi Mokonzi, Found this little error in my php-error logs. As said in another thread this might be something to do with my site, but thought I would report it :) Call to a member function query_first() on a non-object in /**********/forum/dbtech/classifieds_pro/hooks/notifications_list.php...
Back
Top