Database Error In Vbulletin 3.8.6 Invalid Sql
Forum vBulletin 3.8 vBulletin 3.8 Support & Troubleshooting Join us on Facebook, Twitter and YouTube. Welcome to the vBulletin support forums! In the forums you can receive professional support and assistance with any issues you might have with your vBulletin Products. If you are having problems posting in the relevant areas for your software, please see this topic. Announcement Collapse No announcement yet. Database error in vBulletin 3.8.6 Collapse X Collapse Posts Latest Activity Search Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links only Polls only Filtered by: Clear All new posts Previous Next Hagalepues New Member Join Date: Sep 2009 Posts: 19 #1 Database error in vBulletin 3.8.6 Sun 17th Oct '10, 1:58am Hi, I am getting the following error by email of the database: Database error in vBulletin 3.8.6: Invalid SQL: INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate) VALUES ('3a9c246473d3346bfa611078e1fd77c5', 0, '190.28.202.163', '5bc488d8cef8d3a5a902cd5bc5e52bd2', 1287308021, '/index.php', 0, 0, 0, 0, 0, 0, 0, 'Googlebot/2.1 (http://www.googlebot.com/bot.html)Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,image/jpg,image/gif,*/*;q=0.5', 0, 0); MySQL Error : MySQL server has gone away Error Number : 2006 Request Date : Sunday, October 17th 2010 @ 05:33:41 AM Error Date : Sunday, October 17th 2010 @ 05:48:56 AM Script : http://www.website.net/ Referrer : http://www.website.net/ IP Address : xxx.xx.xxx.xxx Username : No Registrado Classname : vB_Database MySQL Version : And.. Database error in vBulletin 3.8.6: Invalid SQL: SELECT thread.threadid
List Today's Posts Search Quick Links Thread Tools #1 10 Jun 2014, 04:46 CaptainAwesome Member Join Date: Apr 2014 Database error when posting I was trying to do a test post on the forum today to see if something took and when i hit the "submit new thread" button i get the following error: Database error in vBulletin 4.2.2: Invalid SQL: INSERT INTO postlog (postid, useragent, ip, dateline) VALUES (7, 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36', 1205820656, 1402374984); MySQL Error : Duplicate entry '7' for key 'PRIMARY' Error Number : 1062 Request http://www.vbulletin.com/forum/forum/vbulletin-3-8/vbulletin-3-8-questions-problems-and-troubleshooting/373634-database-error-in-vbulletin-3-8-6 Date : Tuesday, June 10th 2014 @ 04:36:24 AM Error Date : Tuesday, June 10th 2014 @ 04:36:24 AM Script : http://
06:13 PMI've been getting these errors every 10 minutes: Database error in vBulletin 3.8.6: Invalid SQL: SELECT thread.threadid, thread.title, thread.forumid, thread.postuserid, subscribethread.subscribethreadid , http://www.forumrunner.net/forum/archive/index.php/t-311.html thread.lastpost AS lastposts FROM subscribethread AS subscribethread INNER JOIN thread AS thread USING (threadid) LEFT JOIN user AS user ON (user.userid = subscribethread.userid) WHERE subscribethread.threadid = thread.threadid AND subscribethread.userid = 14304 AND thread.visible = 1 AND subscribethread.canview = 1 AND thread.lastposter != user.username AND thread.lastpost >; MySQL Error : You have an error in your SQL syntax; check the manual database error that corresponds to your MySQL server version for the right syntax to use near '' at line 12 Error Number : 1064 Request Date : Sunday, November 28th 2010 @ 03:38:54 PM Error Date : Sunday, November 28th 2010 @ 03:38:54 PM Script : http://XXX/forum/cron.php?rand=1290976727 Referrer : http://XXX/forum/general-chat/31432-jeep-wrangler-call-duty-black-ops-edition.html IP Address : 75.197.X.X Username : Unregistered Classname : vB_Database MySQL Version : database error in The referrer and IP change each time, but I get the error every 10 minutes on the 8, which appear to be forumrunner's cron job. Additionally, I'm not getting any push notifications on my android device. TerryMason11-28-2010, 06:14 PMFYI, this started about 4 of 5 days ago if memory serves. ClemsonJeeper11-28-2010, 06:48 PMFYI, this started about 4 of 5 days ago if memory serves. Do you use database threadmarking or cookie based? It looks like a corrupted lastread marker. TerryMason11-28-2010, 07:28 PMYou got me. Never heard of threadmarking, so i'm guessing cookie based TerryMason11-29-2010, 08:16 AMAny ideas? I keep getting these every 10 minutes. ClemsonJeeper11-29-2010, 09:39 AMIts under your vBulletin Settings, search for "Inactivity/Cookie". I am travelling today from Vacation but will be back in about 6 hours and will be working on Forum Runner issues. It will likely require some debugging work from you, I will email you. Rob TerryMason11-29-2010, 10:30 AMIt's set to: Inactivity/Cookie Based ClemsonJeeper11-29-2010, 05:14 PMSent you an email, let me know if it fixes the issue. vBulletin v3.8.10 Beta 2, Copyright ©2000-2016, vBulletin Solutions, Inc.