Database Error In Vbulletin 4.2.0
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 Grüßen 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 > Opt
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 http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4001606-database-error-in-vbulletin-4-2-2-invalid-sql 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, 2013 Messages: 97 Likes Received: 0 Trophy Points: 6 cPanel Access Level: Root Administrator Hello Sometime server send me following email error: Database https://forums.cpanel.net/threads/problem-in-database-error-in-vbulletin-4-2-0.363711/ 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_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 CO
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 http://www.dragonbyte-tech.com/f49/database-error-vbulletin-4-2-2-a-16673/ 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 http://www.vb-os.com/issue/290-Database-error-with-vBulletin-4-search-feature 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 database error - 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 database error in 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 InfoPanels InfoPanels Lite Support [vB 4.2.x] Database error in vBulletin 4.2.2: 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: 1 Post #86435 (1) Likes: 0
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. Issue: Database error with vBulletin 4 search feature Issue Tools View Comments 03-03-2013 03:34 PM Pitchoune Project Lead Number of reported issues by Pitchoune: 112 Database error with vBulletin 4 search feature Database error in vBulletin 4.2.0: Invalid SQL: SELECT DISTINCT pt_projectversion.versionname from vb4pt_projectversion AS pt_projectversion WHERE projectversionid IN (0); MySQL Error : Unknown column 'pt_projectversion.versionname' in 'field list' Error Number : 1054 Issue Details Issue Number 290 Issue Type Bug Project Project Tools Category Show Stopper Status Fixed Priority 1 - Highest Affected Version 2.2.0 Fixed Version 2.2.0 Milestone v2.2.0 Users able to reproduce bug 0 Users unable to reproduce bug 0 Attachments 0 Assigned Users Pitchoune Tags MySQL Error Filter responses to show Comments (0) Petitions (0) Changes (3) All Note: This issue contains some replies but it seems you don't have the permission to show them. To see them, you should log in. Once logged in, if the administrator decided it, you can still be able to not see replies. + Reply Assigned Users Please Wait Tags Please Wait -- Default Style -- Default Mobile Style Contact Us vBulletin Open Source Archive Top All times are GMT. The time now is 02:16 PM. Powered by vBulletin Version 4.2.3 Beta 3 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved. X vBulletin 4.2.3 Beta 3 Debug Information Page Generation 0.03952 seconds Memory Usage 5,122KB Queries Executed 17 (?) More Information Template Usage (25): (1)ad_footer_end(1)ad_footer_start(1)ad_global_above_footer(1)ad_global_below_navbar(1)ad_global_header1(1)ad_global_header2(1)ad_navbar_below(1)download_tab(1)editor_clients