Error Number 1064 Vbulletin
Contents |
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. jinstaller install sql error db function failed with error number 1064 If you are having problems posting in the relevant areas for your software, please see this
Mysql Error Number 1064
topic. Announcement Collapse No announcement yet. vBulletin 4.2 Data Base Error Number : 1064 email messages !!! Collapse X Collapse Posts Latest Activity error number 1064 codeigniter 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 firassameer Member Join Date: Aug 2011 Posts: 41 #1 [Forum] vBulletin 4.2 Data Base Error Number : 1064 email messages !!! Mon 9th Jul '12, 6:21am Guys I NEED your HELP please !!! I receive a lot a lot of emails from my forum without any actions from my side or my users... the emails basically are two one comes after one every time.. the first email contains: Email Subject: Re: Your mail to admin@al-sindbad.com Contents (this content is from the auto-responder I made for any email sent to the admin email): Thank you for contacting us... We will respond to your inquiry as soon as possible.. Admin After this email by 1 minute another email comes: Email Subject: vBulletin Database Error! Contents Database error in vBulletin 4.2.0: Invalid SQL: (); 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 ')' at line 1 Error Number : 1064 Request Date : Monday, July 9th 2012 @ 09:51:48 AM Error Date : Monday, July 9th 2012 @ 09:51:49 AM Script : http://al-sindbad.com/usercp.php Referrer : http://al-sindbad.com/usercp.php IP Address : 109.162.65.196 Username : Penf_fook Classname : vB_Database MySQL Version : The user name and IP address in the second message changes in every single email.. those two emails I receive many times a day of them.. IS this error related to the problem of not receiving notifications on new posts and threads in my forum?? Kindly advice.. thanks Last edited by firassameer; Mon 9th Jul '12, 6:39am. Tags: error number : 1064, mysql error, vbulletin 4.2 kh99 vB.org Team Join Date: Aug 2009 Posts: 537 #2 Mon 9th Jul '12, 8:23am In "Site Name / URL / Contact Details" (in the adminCP settings), do you have the webmaster's email set to "admin@al-sindbad.com"? That would explain why you're
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 http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/413981-vbulletin-4-2-data-base-error-number-1064-email-messages 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 error in vBulletin 4.2.0: Invalid https://forums.cpanel.net/threads/problem-in-database-error-in-vbulletin-4-2-0.363711/ 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 COUNT(*) as cnt,max(lastpost) as lastupdate FROM thread AS thread INNER JOIN tag
New? Today's Posts FAQ Rules Guidelines Search Advanced Search Forum :: Server side development MySQL Resolved DB Error 1064 If this is your first visit, be sure to check out http://www.codingforums.com/mysql/168633-db-error-1064-a.html the FAQ by clicking the link above. You may have to register before you https://support.tapatalk.com/threads/mysql-error-during-plugin-import-installation-vbulletin-3-8-x.14682/ 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. Enjoy an ad free experience by logging in. Not a member yet? Register. Results 1 to 7 of 7 Thread: DB Error 1064 Thread Tools Show Printable Version Email error number this Page… Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible 06-09-2009,08:08 PM #1 Sigma View Profile View Forum Posts New to the CF scene Join Date Jun 2009 Posts 4 Thanks 0 Thanked 0 Times in 0 Posts DB Error 1064 I can't figure out how to fix the syntax error. The script has been working for over a year and error number 1064 today it stopped working. Code: Database error in vBulletin 3.8.2: Invalid SQL: SELECT * FROM usergroup WHERE usergroupid IN (4,6,8,36,43,34,33,84,71,52,7,37,42,44,35,2,45,66,53,54,59,74,55,73,41,78,67,57,65,83,62,69,63,79,80,) ORDER BY title; 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 ') ORDER BY title' at line 1 Error Number : 1064 Request Date : Tuesday, June 9th 2009 @ 01:03:11 PM Error Date : Tuesday, June 9th 2009 @ 01:03:11 PM Script : http://www.renegadegaming.com/superpm.php? Referrer : Username : RGC Sigma Classname : vB_Database MySQL Version : 5.0.75-community-log Last edited by Sigma; 06-10-2009 at 05:58 PM. Reply With Quote 06-09-2009,08:40 PM #2 Fumigator View Profile View Forum Posts UE Antagonizer Join Date Dec 2005 Location Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant Posts 7,691 Thanks 42 Thanked 637 Times in 625 Posts You can't end a list of values in your "IN" clause with a comma. I heart Hostmonster Reply With Quote 06-09-2009,10:12 PM #3 Sigma View Profile View Forum Posts New to the CF scene Join Date Jun 2009 Posts 4 Thanks 0 Thanked 0 Times in 0 Posts That's what I thought. The li
thread in the support forum Dismiss Notice MySQL error during plugin import/installation (vBulletin 3.8.x) Discussion in 'vBulletin Discussion' started by nargalzius, Oct 16, 2012. Thread Status: Not open for further replies. nargalzius New Member Joined: Oct 16, 2012 Messages: 6 Likes Received: 0 Hi there, I just purchased the iPad app and was attempting to install this on my community's board on vB 3.8.6. But I keep on getting this error (marked out with an x the info I deemed non-important): Code: Database error in vBulletin 3.8.6: Invalid SQL: CREATE TABLE IF NOT EXISTS board2_tapatalk_users ( userid int(10) NOT NULL, announcement smallint(5) NOT NULL DEFAULT '1', pm smallint(5) NOT NULL DEFAULT '1', subscribe smallint(5) NOT NULL DEFAULT '1', updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (userid) ); 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 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY K Error Number : 1064 Request Date : Monday, October 15th 2012 @ 05:29:25 PM Error Date : Monday, October 15th 2012 @ 05:29:30 PM Script : http://xxxxxxxxxx.com/board/admincp/plugin.php?do=productimport Referrer : http://xxxxxxxxxx.com/board/admincp/plugin.php?do=productadd IP Address : xxxxxxxxxxx Username : xxxxxxxxxxx Classname : vB_Database MySQL Version : 4.0.30-log Based on the error, I guess it's a matter of using syntax incompatible with MySQL 4. Is there anything I can edit on the install files to make it work on my MySQL version? nargalzius, Oct 16, 2012 #1 euhow Product Staff Member Joined: Jul 17, 2012 Messages: 1,955 Likes Received: 210 Hi nargalzius, thank you for your reporting, we will release a new plugin version for vb3 in this week and we will fix this problem for you, you can download the latest one and install then, would you mind waitting for few days? euhow, Oct 16, 2012 #2 nargalzius New Member Joined: Oct 16, 2012 Messages: 6 Likes Received: 0 I've downloaded the updated installation files, but I'm still getting the same (or similar error) Code: Database error in vBulletin 3.8.6: Invalid SQL: CREATE TABLE IF NOT EXISTS board2_tapatalk_users ( userid int(10) NOT NULL, announcement smallint(5) NOT NULL DEFAULT '1', pm smallint(5) NOT NULL DEFAULT '1', subscribe smallint(5) NOT NULL DEFAULT '1', updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (userid) ); MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to y