i add my back up server and i have this error ... HELP ^^
[Err] 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 '(0) NOT NULL,
`charName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_' at line 2
[Err] CREATE TABLE `l2votes` (
`votedate` datetime(0) NOT NULL,
`charName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
INDEX `votedate_idx`(`votedate`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
It is, kind of. Only invited participants have the links. Sorry but not sorry, this forum is dead for ages, so blame whoever you wish to blame. Cheers.
have played many years ago excited to play again on launch. i have seen wonderful things about the server it looks how it should be theres hard work and it shows. it lives up to the glory days of l2 elixir.
I wish the best of luck for the project i will be playing actively!
Question
Bigman
i have error in my sql
i add my back up server and i have this error ... HELP ^^
[Err] 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 '(0) NOT NULL,
Edited by DukeAwesome`charName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_' at line 2
[Err] CREATE TABLE `l2votes` (
`votedate` datetime(0) NOT NULL,
`charName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
INDEX `votedate_idx`(`votedate`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
1 answer to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now