Quick Login   
 
Register AdminFusion Tutorials
 
Featured Sponsors

One.com Domain and Hosting


Register
Register
Forum of the Month
Australian Webmaster
fotm

A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.

Tag Cloud
404 activity advertising ban board brawl broadcastingworld browsers cgi cheap cheap hosting contest contests css dedicated servers domain domains error exchange fanrage fighting for sale forum forum of the month fotm free google host hosting hostquack host quack introduction ipb leads license link exchange logo march madness men movies music mysql perl php phpbb posting service posts promotion redmatrix ftw! revenue ruby. sales sell selling seo seovb shared hosting skin soundboy rules sweet 16 tag cloud tech555 tradeshow traffic update vbseo vbulletin vbulletin 3.7 web hosting wordpress youtube
Latest Threads
Forum Stats
7,900 Members
165,094 Posts
41 Users Online

Please welcome our newest member, Jors308932!

Affiliates
vBulletin Forum Software

Spice up your web site with the ultimate community message board solution!

Fake Id's

Get fake Id's made right now!

vBSEO

Search Engine Optimization for your VBulletin Forum.

Go Back AdminFusion » Getting Started » Software » Mysql error
Welcome to the AdminFusion. AdminFusion is the ultimate resource for forum administrators and moderators. With exclusive articles, interviews with the experts, free downloadable skins, and the revolutionary post exchange system - PostFusion, AdminFusion is the place to go for all of your forum needs.  By joining AdminFusion, you will become part of a thriving admin community and immediately gain access to all of these resources. Registration is fast, simple and absolutely free so please join us today!
Want more than our forums? Try these: Post Fusion Forum Matrix
Old 11-24-2006, 09:38 AM   #1

Dan Gamble's Avatar

Title: Apprentice

Points: 3,698, Level: 17Points: 3,698, Level: 17Points: 3,698, Level: 17
Level up: 18%, 152 Points neededLevel up: 18%, 152 Points neededLevel up: 18%, 152 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jan 2006

Posts: 455

Location: Cambridge (U.K)

Dan Gamble has a spectacular aura aboutDan Gamble has a spectacular aura about
Send a message via MSN to Dan Gamble  
 
Mysql error
Quote:
Server Replied: ERROR 1064 (42000) at line 8989: 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 'show int(11) NOT NULL default '1',
order2 tinyint(4) NOT NULL default '0',
P' at line 6
ERROR 1064 (42000) at line 8998: 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 'show, order2) VALUES('1','loginbox','Login Box','left','1','2')' at line 1
ERROR 1064 (42000) at line 8999: 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 'show, order2) VALUES('3','stats','Statistics','middle','1','2')' at line 1
ERROR 1064 (42000) at line 9000: 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 'show, order2) VALUES('4','new_members','New Members','left','0','4')' at line 1
ERROR 1064 (42000) at line 9001: 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 'show, order2) VALUES('5','top_posters','Top Posters','left','0','5')' at line 1
ERROR 1064 (42000) at line 9002: 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 'show, order2) VALUES('6','calendar','Calendar','left','0','6')' at line 1
ERROR 1064 (42000) at line 9003: 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 'show, order2) VALUES('7','latest_downloads','Latest Downloads','left','1','3')' at line 1
ERROR 1064 (42000) at line 9004: 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 'show, order2) VALUES('8','custom_content','Custom Content','left','0','8')' at line 1
ERRO
Its what it says but it appears to have imported fine :s

Any ideas? =]
Reply With Quote
Old 11-29-2006, 11:30 PM   #2

njoker555's Avatar

Title: Member

Points: 1,876, Level: 12Points: 1,876, Level: 12Points: 1,876, Level: 12
Level up: 13%, 274 Points neededLevel up: 13%, 274 Points neededLevel up: 13%, 274 Points needed
Activity: 4%Activity: 4%Activity: 4%

Join Date: Nov 2006

Posts: 127

njoker555 is an unknown quantity at this point
 
 
ask ur host about it, i dont really know, but u can check ur settings.php file or watever it is u use there, and see if its pointing to that SQL Database, a couple months ago with a joomla site, i was going crazy cuz i forgot to change the file to point to that lol, at the end i had to slap myself, but im not really getting that error message, u should ask ur host for more info but u should also check that file first
Reply With Quote
Old 11-30-2006, 03:39 AM   #3

bdude's Avatar

Title: Forum Addict

Points: 9,275, Level: 28Points: 9,275, Level: 28Points: 9,275, Level: 28
Level up: 29%, 75 Points neededLevel up: 29%, 75 Points neededLevel up: 29%, 75 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jul 2006

Posts: 1,629

Location: Australia

bdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant futurebdude has a brilliant future
Send a message via AIM to bdude Send a message via MSN to bdude Send a message via Yahoo to bdude Send a message via Skype™ to bdude  
 
Why do i get a query syntax error 1064 from MySQL when the syntax seems correct?


You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved word in your query such as "when" or "order".

MySQL 4 has additional reserved words that you cannot use and the full list of them is at http://www.mysql.com/doc/en/Reserved_words.html.

--- from the internet
__________________
Reply With Quote
Reply

« Problem with transfering vbulletin and phpfox license | 'New Posts' option.. »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

 
Posting Rules

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help converting please AnnCP SMF 1 09-18-2006 05:02 PM
MySQL to Fight Oracle With Fire(bird)? shellspeare Graphics and Design 0 03-01-2006 09:12 AM
MySQL 5 gprime Graphics and Design 0 10-25-2005 02:34 AM
PostgreSQl vs MySQL gprime Handling Problem Members 3 10-13-2005 07:50 AM

AdminFusion
Home RSS Feeds - Contact Us - Home - Archive - Top

All times are GMT +1. The time now is 05:04 AM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0 © 2005-2008 AdminFusion - All Rights Reserved



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72