Upon upgrading the databases, I noticed the addition of the roulette database is proving to be difficult.
The query from the update:
--
-- Table structure for `db_roulette`
--
CREATE TABLE IF NOT EXISTS `db_roulette` (
`index` int(11) NOT NULL default '0',
`level` smallint(5) unsigned NOT NULL,
`item_id` smallint(5) unsigned NOT NULL,
`amount` smallint(5) unsigned NOT NULL DEFAULT '1',
`flag` smallint(5) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`index`)
) ENGINE=MyISAM;
ends up with error 1064. However, I don't see where a mistake in the syntax is made to cause that.
Running MySQL 5.5, this was tested in MySQL WorkBench with the full error being:
Error Code: 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 '`index` int(11) NOT NULL default '0', `level` smallint(5) unsigned NO' at line 1
I've replaced the whole text once and typed it out myself to prevent possible characters being mistaken, but I think that shouldn't throw this error if there was something wrong in that to start with. What can be done to fix this simple issue?
Question
Tranquility
Hello,
Upon upgrading the databases, I noticed the addition of the roulette database is proving to be difficult.
The query from the update:
ends up with error 1064. However, I don't see where a mistake in the syntax is made to cause that.
Running MySQL 5.5, this was tested in MySQL WorkBench with the full error being:
I've replaced the whole text once and typed it out myself to prevent possible characters being mistaken, but I think that shouldn't throw this error if there was something wrong in that to start with. What can be done to fix this simple issue?
Kind regards,
Tranquility
Link to comment
Share on other sites
2 answers to this question
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.