03laceys Posted June 22, 2008 Share Posted June 22, 2008 Ok firstly i was looking can't fint the right board for this so please move if needed... Ok i have added the time travel flights modification to my game but when adding the sql i get the error.... #1064 - 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 'ALTER TABLE `cities` ADD `citytime` INT( 11 ) NOT NULL' at line 2 How do i fix this error. Thank you. Quote Link to comment Share on other sites More sharing options...
Spudinski Posted June 22, 2008 Share Posted June 22, 2008 Re: Sql error help with fixing please? * Topic Moved * Please post in the correct place next time. Quote Link to comment Share on other sites More sharing options...
03laceys Posted June 22, 2008 Author Share Posted June 22, 2008 Re: Sql error help with fixing please? Sorry i did try looking couldn't find the right section... just got back from the pub when i wrote is :lol: Any help guys? Quote Link to comment Share on other sites More sharing options...
Guest Anonymous Posted June 22, 2008 Share Posted June 22, 2008 Re: Sql error help with fixing please? Copy & paste the query your trying to run. Quote Link to comment Share on other sites More sharing options...
03laceys Posted June 22, 2008 Author Share Posted June 22, 2008 Re: Sql error help with fixing please? Fixed thank you anyway ze0n. Still dont have a clue what was wrong :? Quote Link to comment Share on other sites More sharing options...
Spudinski Posted June 22, 2008 Share Posted June 22, 2008 Re: Sql error help with fixing please? I'm speaking under correction here, but you have to specify a default value if you assigned "NOT NULL" the the column. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.