unknown column 'pincode' in 'field list'

[eduardjr]

When I updated my server to the latest revision, I got this DB error. I already apply the sql-files/upgrades/upgrade_svn17183.sql but when creating new account this is the error showing. I'm using 2012-04-10 client.

 

[status]: Memory manager initialised: log/login-server_sql.exe.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[info]: SVN Revision: '17183'.
[info]: Server supports up to '4096' concurrent connections.
[info]: Finished reading conf/msg_conf/login_msg.conf.
[info]: Finished reading conf/import/inter_conf.txt.
[info]: Finished reading conf/inter_athena.conf.
[info]: Finished reading conf/import/login_conf.txt.
[info]: Finished reading conf/login_athena.conf.
[status]: The login-server is ready (Server is listening on the port 6900).

[info]: Connection request of the char-server 'TestServer' @ 25.32.205.240:6121
(account: 'ragnarok', pass: 'ragnarok', ip: '127.0.0.1')
[Notice]: Authentication accepted (account: ragnarok, id: 1, ip: 127.0.0.1)
[status]: Connection of the char-server 'TestServer' accepted.
[status]: Request for connection of eduardjr_m (ip: 25.32.205.240).

: DB error - Data too long for column 'pincode' at row 1
[Debug]: at ..\src\login\account_sql.c:622 - INSERT INTO `login` (`account_id`,
`userid`, `user_pass`, `sex`, `email`, `group_id`, `state`, `unban_time`, `expir
ation_time`, `logincount`, `lastlogin`, `last_ip`, `birthdate`, `character_slots
`, `pincode`, `pincode_change`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?)
[info]: Closed connection from '25.32.205.240'.

 

[Mootie]

You have to import the upgrade sql. can be found in sql-files upgrade.if you did not wipe your database and you are using old one.

 

But according to your problem its says that your database is outdated

[JiKeidan]

Unfortunately after whiping my rAthena server folder entirely, and re-installing via SVN (r17185)

I configure, compile and run after changing all listening servers to my LAN ip (debian OS, so they have to listen on that device or the router won't forward properly, here nor there)...

 

I now have this issue:

 

 

[SQL]: DB error - Unknown column 'pincode' in 'field list'
[Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`, `pincode_change` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: ***, received pass: ***, ip: 192.168.1.20)
[Notice]: Connection of the char-server 'Moonlight_RO' REFUSED.
[Error]: Can not connect to login-server.

 

which makes perfect sense considering that all cridentials are being queried from sql in 1 string... and when 'pincode' as a column is not found... it throws out the entire statement, thus comparing user *** and pass *** to NULL and NULL (or w/e default value those variables hold)

 

Question is, why is it looking for this pincode column at all?  If I go in and fix login.c to not ask for the pincode column, will there be other side effects?  Is that even the proper solution?

 

***EDIT:

 

I resolved my own issue....

  Running debian 6.0.6 (might be relevent)

I had been using the shell command:

cat main.sql | mysql -u root -p ragnarok

to populate my database, for whatever reason... it doesn't work well... when instead i used:

mysql -u root -p ragnarok < main.sql

it seemed to apply that rule... i don't know if there's much of a difference honestly... could have caught the svn update at a bad time... =\ it's working now though...

 

anyone with a similar issue, check your main.sql and search for 'pincode' ... if it's there, then it should work.

Edited March 9, 2013 by JiKeidan

[JiKeidan]

Solved

You have to import the upgrade sql. can be found in sql-files upgrade.if you did not wipe your database and you are using old one.

 

But according to your problem its says that your database is outdated

 

That may be, I whiped the database, ran 'svn up' on the trunk... and did as explained above... perhaps it all just came together smoothly =P...

 

if you don't mind... will this upgrade sql work with the other problem i've been having?:

 

http://rathena.org/board/topic/79839-unknown-byte-0x970-20120410ragexre-rathena-17179-kro-20121001/

[eduardjr]

Thank you to all who replied!!!