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
--------------------------------------------------
Https://lineage2dex.com
Discord link : https://discord.com/channels/786506979493281794/814778540893536307/1424434670690504874
## Dexters!
**Our x25 server is celebrating its first week!**
🔥 Online stays strong at peak levels! New players are joining every day, with 200+ new master accounts registered daily — amazing results!
✨ Tomorrow we launch a new episode along with the first event. Full details will be shared in the morning(October 6).
🎁 And for this little celebration, here’s a bonus code with a small gift for you!
## O05-IIW
**Contains: **
* x3 - Training Potion 200% (20 min)
* x200 - Mana Potions Loyatly (no weight)
*The code will remain active until October 6, 7 AM(server time). And be sure, you have at less 20 slots free on inv before using a code.*
**👉 How to redeem:**
1. Log in to your Master Account on site.
2. Click the Redeem Bonus Code button at the top of the panel, type code click redeem.
3. Select the account and character you want to receive the gift.
**Codes work only 1 time for 1 Master Account!**
### Enjoy your adventure, Dexters!
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