Jump to content

Question

Posted (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 by Sharpienero

10 answers to this question

Recommended Posts

Posted

@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.

Posted (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 by donkeyg
Posted

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...

Posted (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 by donkeyg
Posted (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 by donkeyg
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...