pascal Posted March 5, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 25 Reputation: 1 Joined: 02/02/12 Last Seen: December 13, 2012 Share Posted March 5, 2012 Hi, After re-setting up my server i got a weird problem (see picture) i'm missing a few collums suchs as lvl collum, any1 got a solution? or where it gone wrong? Quote Link to comment Share on other sites More sharing options...
Brian Posted March 5, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted March 5, 2012 In r15572, the `account`.`level` column has been replaced with `account`.`group_id` r15572: New GM, Commands & Permissions system Quote Link to comment Share on other sites More sharing options...
LCDTheOG Posted March 5, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 223 Reputation: 36 Joined: 12/13/11 Last Seen: February 1 Share Posted March 5, 2012 if you don't have an active going server atm drop all your tables and run the main sql file. Quote Link to comment Share on other sites More sharing options...
JayPee Posted March 6, 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 March 6, 2012 you can just rename the columns back to level but i suggest if your just going to start a new server use the latest one Quote Link to comment Share on other sites More sharing options...
Brian Posted March 6, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted March 6, 2012 you can just rename the columns back to level but i suggest if your just going to start a new server use the latest one Actually, the column name in SQL must match what is coded in the rAthena source, or else when it does a SQL query, the server won't be able to find what it's looking for. If your rAthena version is before 15572, the column should still be named `login`.`level` For version 15572 and after, the column should be named `login`.`group_id` Quote Link to comment Share on other sites More sharing options...
JayPee Posted March 6, 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 March 6, 2012 you can just rename the columns back to level but i suggest if your just going to start a new server use the latest one Actually, the column name in SQL must match what is coded in the rAthena source, or else when it does a SQL query, the server won't be able to find what it's looking for. If your rAthena version is before 15572, the column should still be named `account`.`level` For version 15572 and after, the column should be named `account`.`group_id` In my test server I was using `level` which is the old structure of login table and when I try to use the new SVN version i just changed the column from `level` to `group_id` and it works fine. Quote Link to comment Share on other sites More sharing options...
Brian Posted March 6, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted March 6, 2012 Yes, just like running upgrade_svn15572.sql Quote Link to comment Share on other sites More sharing options...
pascal Posted March 6, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 25 Reputation: 1 Joined: 02/02/12 Last Seen: December 13, 2012 Author Share Posted March 6, 2012 (edited) just got it 2 days so ill presume is after 15572 Brian was right; In r15572, the `account`.`level` column has been replaced with `account`.`group_id` Thats why i love these forums Edited March 6, 2012 by pascal 1 Quote Link to comment Share on other sites More sharing options...
Question
pascal
Hi, After re-setting up my server i got a weird problem (see picture) i'm missing a few collums suchs as lvl collum, any1 got a solution? or where it gone wrong?
Link to comment
Share on other sites
7 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.