Database Error In Vbulletin 4.2.0 Invalid Sql
4 vB4 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. Invalid SQL - Database error in vBulletin 4.2.0 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 m!dn!ght Member Join Date: Apr 2009 Posts: 30 #1 [Forum] Invalid SQL - Database error in vBulletin 4.2.0 Wed 28th Nov '12, 1:31am hello I have received many emails like below Database error in vBulletin 4.2.0: Invalid SQL: SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid , thread.prefixid FROM thread AS thread LEFT JOIN user AS user ON (user.userid = thread.lastposterid) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(374,75,76,96,108,133,16,321,274,275,18,323,271,272,273,50,51,212,225,,336,337,338,339,3 40,341,375,376,378,379) ORDER BY lastpost DESC LIMIT 0, 15; MySQL Error : 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 '336,337,338,339,340,341,375,376,378,379) ORDER BY lastpost DESC LIMIT 0, 1' at line 4 Error Number : 1064 Request Date : Wednesday, November 28th 2012 @ 01:18:44 PM Error Date : Wednesday, November 28th 2012 @ 01:18:45 PM Classname : vB_Database what is this for? how can i fix it? thanks Tags: None Hartmut Senior Member Join Date: Nov 2007 Posts: 2881 #2 Wed 28th Nov '12, 1:34am First of all, please disable all products and plugins. Then, use AdminCP -> Maintenance -> Repair / Optimize Tables. Select all tables and run the tool. Does this solve the issue? No private support, only PM me when I ask for it. Support in the forums only. Comment Post Cancel m!dn!ght Member Join Date: Apr 2009 Posts: 30 #3 Thu 29th Nov '12, 12:43am i do that unfortunately no, problem still exist I have received emails again Database error in vBullet
Plans & Pricing Partners Support Resources Preview Forums Forums Quick Links Search Forums New Posts Search titles only Posted by Member: Separate names with a comma. Newer Than: Search this thread only Search this forum only Display results as threads More... Useful Searches Recent Posts Resources Resources Quick Links Search Resources Most Active Authors Latest Reviews Feature Requests Defects Menu Log in Sign up The Community Forums Interact with an entire community of cPanel & WHM http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/421615-invalid-sql-database-error-in-vbulletin-4-2-0 users! cPanel Forums > Server Administration and Customization > Workarounds and Optimization > This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More. Problem in Database error in vBulletin 4.2.0: Discussion in 'Workarounds and Optimization' started by morteza3245, Sep 27, 2013. morteza3245 Well-Known Member Joined: Sep 16, https://forums.cpanel.net/threads/problem-in-database-error-in-vbulletin-4-2-0.363711/ 2013 Messages: 97 Likes Received: 0 Trophy Points: 6 cPanel Access Level: Root Administrator Hello Sometime server send me following email error: Database error in vBulletin 4.2.0: Invalid SQL: SELECT COUNT(*) as cnt,max(lastpost) as lastupdate FROM thread AS thread INNER JOIN tagcontent AS tagcontent ON (tagcontent.tagid = 1 AND tagcontent.contentid = thread.threadid) WHERE thread.forumid IN() AND thread.visible = 1 AND thread.sticky IN (0, 1) AND thread.open <> 10 GROUP BY tagcontent.tagid; MySQL Error : 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 thread.visible = 1 AND thread.sticky IN (0, 1)' at line 5 Error Number : 1064 Request Date : Wednesday, September 25th 2013 @ 04:01:28 PM Error Date : Wednesday, September 25th 2013 @ 04:01:28 PM Script : http://www.site1.com/cron.php?rand=1380124884 Referrer : http://www.site1.com/forum.php IP Address : 212.7.212.113 Username : not registered Classname : vB_Database MySQL Version :Click to expand... my config in my.cnf is: [mysqld] local-infile=0 join_buffer_size=512 query_ca
thread in the support forum Dismiss Notice Errors, Double Postings, Random Thread Subscriptions Discussion in 'vBulletin Discussion' started by OhSoBlonde, Oct 21, 2012. Thread Status: Not open for further replies. OhSoBlonde New Member Joined: Sep https://support.tapatalk.com/threads/errors-double-postings-random-thread-subscriptions.14760/ 12, 2010 Messages: 17 Likes Received: 2 Hey guys, Having some issues with the latest release. http://www.dragonbyte-tech.com/f107/vbulletin-database-error-10186/ We run vB, we have the latest patch on the board and the most recent version of Tapatalk. We had started experiencing random double & triple postings by members back with the 4.1.0. When users go to reply, the hit "Submit" and the page hangs and returns an error "Are you sure you want to leave this page". Unless the user closes database error that and moves on, the reply is posted as many times as they click "Stay on page". I thought that I had found the solution by changing some of the Tapatalk settings in the Admin CP. I was not setup at the time to receive emails on database errors, so I don't know if that was happening as well. Random thread subscriptions is another issue as well. These errors appear to happen to users who are not database error in using Tapatalk, but are visiting the site through their browser. Once this 4.2.0 version came out, the double postings returned along with a flood of database errors. I have turned off all mods to see which one affects these issues and the only one is Tapatalk. Once I disabled it, the double postings & database errors have stopped. Random thread subscriptions are still happening, so I do not believe those are related to this app. Any suggestions? You guys are setup on our forum already as a user (www.jadedcinderellas.com) if you want to check out issues. Let me know and I will turn Tapatalk back on. This does not happen with every post. This is random users, using different browsers and the majority of them are not Tapatalk users at all. Thoughts? winter likes this. OhSoBlonde, Oct 21, 2012 #1 OhSoBlonde New Member Joined: Sep 12, 2010 Messages: 17 Likes Received: 2 c&p of the database errors: Database error in vBulletin 4.2.0: Invalid SQL: SELECT subscribe.userid FROM subscribeforum AS subscribe INNER JOIN forum AS forum ON (subscribe.forumid = forum.forumid) INNER JOIN tapatalk_users AS tt_user ON (subscribe.userid = tt_user.userid AND tt_user.newtopic = 1) WHERE subscribe.forumid = 2; MySQL Error : Unknown column 'tt_user.newtopic' in 'on clause' Error Number : 1054 Request Date : Thursday, October 18th 2012 @ 11:26:49 AM Error Date : Thursday, October 18th 2012 @ 11:26:50 AM S
made mods, skins and customizations for vBulletin and custom skins for IPB and xenForo. Click here for info. Become one of our happy customers In addition to our testimonial box, we have also conducted surveys of customer satisfaction. The result? 98% of customers would recommend us to a friend. Serving some of your favourite companies Have you seen our "Also Runs On" box? Companies like the Curse Network, Tom's Hardware, Gearbox Software and XDA Developers rely on DragonByte Tech for their forum improvement needs. Want to test our full range of products? You can visit DBTechs alternate site - www.DBTech.co and browse and post as normal but with the added bonus of being able to access and try all of our products. Join In Our Feedback Surveys You can sign up to receive our infrequent surveys which help us by giving us invaluable feedback on how you, our customers, feel about various parts of our service and our upcoming plans. You also get entered into exclusive prize draws! Click here to sign up! Store Forum New Posts Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders Live Streams vBActivity Mailing Lists User Tagging Statistics Hash Tag Subscriptions Thanks / Like Statistics Hottest Threads / Posts Custom Work Site Directory Member Map Classifieds Live Streams What's New? Search Forum DragonByte Technologies Product Support AJAX Threads AJAX Threads Lite Support [vB 4.2.x] vBulletin Database Error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. We have recently been made aware that servers using the "BoxTrapper" anti-spam measure will not receive our emails, because BoxTrapper sends the verification email to a non-existent email address. In order to ensure you will receive our emails, please add dragonbyte-tech.com to your BoxTrapper Whitelist as per the documentation before attempting to register to DBTech or purchasing from us. Sorry for the inconvenience. - DragonByte Tech Staff User Tag List Thanks: 0 Likes: 0 Dislikes: 0 Results 1 to 2 of 2 Thread: vBulletin Database Error Forum: AJAX Threads Lite Support Questions & Answers for AJAX Threads. Click here to buy! Thread Tools Show Printable Version Email this Page&he