I am currently moving my current server from 3ceam to rathena but I encountered this error when a character is logging in my test server.
login server console:
[03:31:06][1;35m[SQL][0m: DB error - Incorrect integer value: '' for column 'character_slots' at row 1
[03:31:06][1;36m[Debug][0m: at ..\src\login\account.c:679 - UPDATE `login` SET `userid`=?,`user_pass`=?,`sex`=?,`email`=?,`group_id`=?,`state`=?,`unban_time`=?,`expiration_time`=?,`logincount`=?,`lastlogin`=?,`last_ip`=?,`birthdate`=?,`character_slots`=?,`pincode`=?, `pincode_change`=?, `bank_vault`=?, `last_mac`=? WHERE `account_id` = '2000008'
UPDATE `global_reg_value` SET `str` = 'jobchange_level_3rd' WHERE `str` = 'jobchange_level2';
DROP TABLE `skillcooldown`;
Plus I also ran all the queries from sql-files/updates. No significant errors when I ran these updates but I got the error above on login console when a character logs in.
Question
johnbond
I am currently moving my current server from 3ceam to rathena but I encountered this error when a character is logging in my test server.
login server console:
I already ran these queries which i got from here: https://rathena.org/board/topic/69741-switching-3ceam-to-rathena/?p=136265
Plus I also ran all the queries from sql-files/updates. No significant errors when I ran these updates but I got the error above on login console when a character logs in.
What am I missing here?
Thank you.
Link to comment
Share on other sites
6 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.