missing columns in SQL

[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?

[Brian]

In r15572, the `account`.`level` column has been replaced with `account`.`group_id`

r15572: New GM, Commands & Permissions system

[LCDTheOG]

if you don't have an active going server atm drop all your tables and run the main sql file.

[JayPee]

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

[Brian]

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`

[JayPee]

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.

[Brian]

Yes, just like running upgrade_svn15572.sql

[pascal]

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