Sharpienero Posted June 24, 2012 Posted June 24, 2012 (edited) Okay, well I fixed the error. But now I'm getting a new one. When someone tries to register, they get a page saying. "Uh oh, what happened?". That's all it says. It's also not displaying the correct number of players online, and log-ins do not work. Server status was working, now it's not. Edited June 24, 2012 by Sharpienero
Sharpienero Posted June 24, 2012 Author Posted June 24, 2012 Have you re-checked servers.php? Yeah, I think I got it working now. The only thing that's not working is accounts/characters online.
donkeyg Posted June 24, 2012 Posted June 24, 2012 I GOT THE SAME PROBLEM WITH URS here my thread, http://rathena.org/board/topic/66195-urgenthelp-about-transfering-old-cp-to-rathena-database/ i guess u're also move the eathena version to rathena version right?
Xantara Posted June 24, 2012 Posted June 24, 2012 @donkeyg, I'll reply in this thread. To make the registration and login to work, please make sure you have a 'group_id' and 'birthdate' column in your 'login' table. Here are the queries if you don't have them: - (birthdate) https://rathena.svn....de_svn14672.sql - (group_id) https://rathena.svn....de_svn15572.sql However, if you don't have either of them, then that means you are also most likely to be missing other database changes. Although it may not be needed by the CP, it is still best to update as you may experience bugs or errors in your server. If you are switching from eA revision X and updated to rA revision Y. Go to the following link and execute upgrade_svnZ.sql where Z is any number between X and Y. - link: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/ As always, it is recommended to make a backup of your data before making any changes.
donkeyg Posted June 24, 2012 Posted June 24, 2012 (edited) im confusing....should i upgrade which 1?? there's so many .sql files.. edited: and also im trying to add birthdate and group_id on query window but failed SQL query: ALTER TABLE `login` ADD `birthdate` DATE NOT NULL DEFAULT '0000-00-00' MySQL said: #1060 - Duplicate column name 'birthdate' mind to let me add ur acc and chat in msn? Edited June 24, 2012 by donkeyg
Xantara Posted June 24, 2012 Posted June 24, 2012 If the query says there is a duplicate, then that is good thing (in this case). Try the group_id one. I was on MSN (just logged off actually). I messaged you an hour ago but no response so I just posted here =s Gonna go sleep though...
donkeyg Posted June 24, 2012 Posted June 24, 2012 (edited) SQL query: ALTER TABLE `login` CHANGE COLUMN `level` `group_id` TINYINT( 3 ) NOT NULL DEFAULT '0' MySQL said: #1054 - Unknown column 'level' in 'login' i added your msn, please accept me .. i need it urgent... T_T Edited June 24, 2012 by donkeyg
Xantara Posted June 24, 2012 Posted June 24, 2012 I added you yesterday and I waited for you today but now it's 4am so in going to sleep. I'll message you tomorrow... >.>; Oh, and make sure you are using FluxCP-Renewal: https://github.com/calciumkid/fluxcp-renewal (or my AthenaCP lol) Night
donkeyg Posted June 24, 2012 Posted June 24, 2012 (edited) yes, i got all the files inside my WindSCP i didnt receive and contact request ... or u try to add my another msn : [email protected] usually wat time u will on? mine is malaysia time.. currently my time is 8.49PM, i will online until 11.00PM, then next day, i will online at afternoon since 2.00PM until night( GMT + 8) Edited June 24, 2012 by donkeyg
Question
Sharpienero
Okay, well I fixed the error.
But now I'm getting a new one. When someone tries to register, they get a page saying. "Uh oh, what happened?".
That's all it says.
It's also not displaying the correct number of players online, and log-ins do not work.
Server status was working, now it's not.
Edited by Sharpienero10 answers to this question
Recommended Posts