Sharpienero Posted June 24, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 386 Reputation: 28 Joined: 01/16/12 Last Seen: January 6, 2023 Share 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 Link to comment Share on other sites More sharing options...
Nipsino Posted June 24, 2012 Group: Members Topic Count: 28 Topics Per Day: 0.01 Content Count: 218 Reputation: 16 Joined: 01/24/12 Last Seen: May 24, 2015 Share Posted June 24, 2012 Have you re-checked servers.php? Link to comment Share on other sites More sharing options...
Sharpienero Posted June 24, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 386 Reputation: 28 Joined: 01/16/12 Last Seen: January 6, 2023 Author Share 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. Link to comment Share on other sites More sharing options...
JayPee Posted June 24, 2012 Group: Members Topic Count: 47 Topics Per Day: 0.01 Content Count: 633 Reputation: 78 Joined: 11/14/11 Last Seen: September 20, 2017 Share Posted June 24, 2012 What fluxcp your using? Link to comment Share on other sites More sharing options...
donkeyg Posted June 24, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Share 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? Link to comment Share on other sites More sharing options...
Xantara Posted June 24, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share 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. Link to comment Share on other sites More sharing options...
donkeyg Posted June 24, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Share 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 Link to comment Share on other sites More sharing options...
Xantara Posted June 24, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share 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... Link to comment Share on other sites More sharing options...
donkeyg Posted June 24, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Share 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 Link to comment Share on other sites More sharing options...
Xantara Posted June 24, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share 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 Link to comment Share on other sites More sharing options...
donkeyg Posted June 24, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Share 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 Link to comment Share on other sites More sharing options...
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 SharpieneroLink to comment
Share on other sites
10 answers to this question
Recommended Posts