join

I've been getting this error a lot. Not sure for how long, because I only noticed it recently. Then someone found that if you view a thread in hybrid mode, there's a database error. Sure enough it's this one. I'm not sure if this has been the only thing that's been causing the error this whole...

I just purchased and installed Advanced Post Thanks Like pro version and it brings my board down with errors and mysql messages. I disabled the product and my board came back online. Here are the errors. Database error in vBulletin 4.2.2: Invalid SQL: SELECT post.*, post.username...

Shop purchases take anywhere from 2 - 90 seconds. This is from the slow query log: # Query_time: 89.359487 Lock_time: 0.000049 Rows_sent: 355263 Rows_examined: 17523704 SET timestamp=1464027158; SELECT pointstable_4.reputation AS points_4...

We had a new member join us yesterday but whenever you try to view his profile or clicking on his username a database error is created. I have been through all our plug-ins and it appears that the Advanced Post Thanks mod is creating this error for some unknown reason. If I disable it, you can...

Hi there, Everyone seems to be getting this MYSQL error when viewing the arcade. Database error in vBulletin 4.2.3: Invalid SQL: SELECT u.*, a.avatarpath, NOT ISNULL(c.userid) AS hascustomavatar, c.dateline AS avatardateline, c.width AS avwidth, c.height AS avheight, c.height_thumb AS...

Nope this is still broken. I downloaded the updated ZIP file and uploaded all the files to my server with overwrite and imported the XML. When I went to my forum home page I get this: #1 : vbstop() called in [path]/dbtech/gallery/hooks/forumhome_complete.php on line 52 #2 ...

Upon install of the Lite version and importing the XML when I click the Gallery tab I get the following database SQL error: Database error in vBulletin 4.2.2: Invalid SQL: SELECT gi.*, gc.catname, u.username, ga.hidden, ga.title as albumname FROM...

After upgrade to pl2 getting this: Database error in vBulletin 4.2.3: Invalid SQL: SELECT gi.*, gc.catname, u.username, ga.hidden, ga.title as albumname FROM dbtech_gallery_images AS gi LEFT JOIN dbtech_gallery_categories AS gc ON(gc.catid =...

When I click on a notification I get this database error using my admin account on Firefox. Database error in vBulletin 4.2.3 Beta 3: Invalid SQL: SELECT entry.*, user.username, user.usergroupid, user.membergroupids, user.infractiongroupid...

Hi, I've just purchased "Advanced Post Thanks - Like v3.2.9" and tried to deploy on vBulletin 4.2.2. I followed the directions in the Readme_import.txt: When I go to mysite/admincp/thanksimport.php I get a "database error" The error emailed to the site admin is as follows: I've tried...

Hi, just updated to 3.1.4 lite and it caused database errors when clicking on any thread. I had to go back to 3.1.3 to get my forum running again. Some of the DB errors

Removed some PII for confidentiality reasons, but getting this error ever since running the most recent upgrade? I have disabled the plugin temporarily.

Test on localhost Upgrade 3.1.3 to 3.1.4 if you go to any thread: Database error in vBulletin 3.8.8: Invalid SQL: SELECT IF(visible = 2, 1, 0) AS isdeleted, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadrate.vote,threadread.readtime AS...

Hi Filip, Since updating to the latest version, I keep getting the following error message. Database error in vBulletin 4.2.2: Invalid SQL: SELECT entry.*, user.username, user.usergroupid, user.membergroupids, user.infractiongroupid...