Database Error In Vbulletin 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. Database error in vBulletin 4.2.2: Invalid SQL Collapse X Collapse Posts Latest Activity Search Page of 2 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 1 2 Next inshoot Member Join Date: Oct 2010 Posts: 44 #1 Database error in vBulletin 4.2.2: Invalid SQL Mon 14th Oct '13, 4:13am I get a hundred or more of these each day, and have since upgrading to 4.2.1. I have reported it to the host, and it has them stumped. What gives? EDITED: Please see added attachments below. Last edited by inshoot; Mon 14th Oct '13, 4:22am. Tags: None inshoot Member Join Date: Oct 2010 Posts: 44 #2 Mon 14th Oct '13, 4:17am Added screenshots 2 Photos Last edited by inshoot; Mon 14th Oct '13, 4:23am. Comment Post Cancel Teascu Dorin Senior Member Join Date: Aug 2010 Posts: 256 #3 Mon 14th Oct '13, 4:42am Maybe this will help you: http://www.vbulletin.com/forum/forum...66#post4000466 Cu Respect / Best Regards / Mit freundlichen Gren roStyles Design LLC CEO & Founder (Design and Support) Romanian Translator Teascu Dorin dorin.teascu@yahoo.com https://www.rostyles.com Comment Post Cancel inshoot Member Join Date: Oct 2010 Posts: 44 #4 Mon 14th Oct '13, 4:55am This has been happening prior to 4.2.2 1 Photo Comment Post Cancel brucec Member Join Date: May 2011 Posts: 32 #5 Mon 14th Oct '13, 5:23am I also have been getting database errors since upgrading to 4.2.2 and that annoying activity stream keeps coming up also. Comment Post Cancel inshoot Member Join Date: Oct 2010 Posts: 44 #6 Mon 14th Oct '13, 9:59am I did this and it didn't work Settings > Options > Plugin/Hook System and then set the "PHP Compatability" setting to 'Yes'. Comment Post Cancel wda2015 Senior Member Join Date: May 2001 Posts: 1136 #7 Mon 14th Oct '13, 11:14am what PHP version you got?. and the Mysql error number might help us. Simple Straight Forward EU cPanel vBulletin Web Hosting Provider. Comment Post Cancel Wayne Luke vBulletin Technical Support Lead Join Date: Aug 2000 Posts: 55076 #8 Mon 14t
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 users! cPanel Forums > Server Administration and Customization > Workarounds and Optimization > This site uses cookies. By continuing to use this site, you are agreeing to http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4001606-database-error-in-vbulletin-4-2-2-invalid-sql 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, 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 https://forums.cpanel.net/threads/problem-in-database-error-in-vbulletin-4-2-0.363711/ 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_cache_size=16M tmp_table_size=32M max_heap_table_size=256M thread_cache_size=4 max_allowed_packet=32M key_buffer_size=963M query_cache_limit=1M open_files_limit=43042Click to expand... can you help me for resolve? Thanks. خرید هاست #1 morteza3245, Sep 27, 2013 Aaron.Edwards Active Member Joined: Sep 21, 2013 Messages: 36 Likes Received: 0 Trophy Points: 6 cPanel Access Level: Root Administrator 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.ope
for new thread or new nreply ? Register Help Members List Today's Posts Search Quick Links Thread Tools #1 12 Jul 2012, 22:17 nomoreturn Member Join Date: Apr 2009 Real name: mastdunya.com How To Fix Database http://www.vbulletin.org/forum/showthread.php?t=285483 error in vBulletin 4.2.0 for new thread or new nreply ? How i can fix this Database error it came up when we submit a new thread or new reply i disable plugin and try and still have this error please help me to fix this thanks : Invalid SQL: INSERT INTO vb_searchcore_text (searchcoreid, title, keywordtext) VALUES ( 51, 'Admin اِیڈمن', '' ) ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), database error keywordtext = VALUES(keywordtext); MySQL Error : Table './mast***_so**/vb_searchcore_text' is marked as crashed and should be repaired Error Number : 145 Request Date : Thursday, July 12th 2012 @ 06:11:11 PM Error Date : Thursday, July 12th 2012 @ 06:11:11 PM Script : http://www.mastdunya.com/newreply.ph...streply&t=2880 Referrer : http://www.mastdunya.com/newreply.ph...streply&t=2880 IP Address : **.**.**.** Username : admin Classname : vB_Database MySQL Version : 5.1.63-cll __________________ DirtyPolitix.com A New Way To Share Share Your Views On Pakistani Politics ! database error in The following members like this post: hps5001 nomoreturn View Public Profile Find all posts by nomoreturn Likes Received: 1 #2 12 Jul 2012, 23:36 soniceffect Coder Join Date: Feb 2005 Real name: Marc You need to repair the table in question. Go to phpmyadmin Select the table vb_searchcore_text Select repair table from the menu at the bottom __________________ Husky-Owners.com - A forum for all dog lovers. Specialising in Huskies. Developer{Base} - For all your coding and development needs No members have liked this post. soniceffect View Public Profile Visit soniceffect's homepage! Find all posts by soniceffect Likes Received: 20 #3 15 Jul 2012, 23:21 nomoreturn Member Join Date: Apr 2009 Real name: mastdunya.com Thanks for reply i check in myphp and i saw this code in it SHOW FULL FIELDS FROM `vb_searchcore_text`; but i dont know how to repair it i can see any option there for repair so can you please let me know how i can fix this. __________________ DirtyPolitix.com A New Way To Share Share Your Views On Pakistani Politics ! No members have liked this post. nomoreturn View Public Profile Find all posts by nomoreturn Likes Received: 1 #4 16 Jul 2012, 03:57 Lynne Administrator Join Date: Sep 2004 Real name: Lynne Use an application like phpMyAd