urgent after updated all the file to the latest

[donkeyg]

[sql]: DB error - Unknown column 'favorite' in 'field list'
[Debug]: at char.c:1225 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `favorite`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`=? LIMIT 100
[sql]: DB error - Statement not prepared

i recompiled the server to 16820 version and its work fine, but the problem is player don have any item? why? packet_db and mmo.h don have any problem

Edited October 19, 2012 by donkeyg

[Brynner]

your sql is not updated.upgrade_svn16518.sql

[donkeyg]

your sql is not updated.upgrade_svn16518.sql

how do i update it? open my sql database, and open the Query Window, Copy and paste the word that inside the file, and click "GO" , then done?

[Judas]

yes make sure your databse is selected/highlighted if you use mysql

[donkeyg]

yes make sure your databse is selected/highlighted if you use mysql

how to see it whether selected or highlighted??

and btw, i clicked Yes, and appear this, but i still get empty item in my inventory

Your SQL query has been executed successfully (Query took 0.1090 sec)

Edited October 19, 2012 by donkeyg

[Brynner]

just import those sql. same way you import the main.sql on your mysql server.

[donkeyg]

just import those sql. same way you import the main.sql on your mysql server.

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

why would it happened like this when im trying to add mob_db.sql

hello, would some one please add up my msn? lets have a teamviewer for 3 min.... T_T [email protected]

[Judas]

pm your teamview id/pass to me

[donkeyg]

pm your teamview id/pass to me

already

Thanks Brynner. also judas had solved my problem ^^

[gmpanda08]

same problem how to solve this one? file is to large i just backed up my files, i want to import but the problem is the file is to large please help me

[Brynner]

same problem how to solve this one? file is to large i just backed up my files, i want to import but the problem is the file is to large please help me

this is for importing sql files not all your server files.

[gmpanda08]

yes is sql file, when i import my sql it say file is to large i backup my database.sql but when i import it, it says the file is to large sir

same problem how to solve this one? file is to large i just backed up my files, i want to import but the problem is the file is to large please help me

this is for importing sql files not all your server files.

yes is sql file, when i import my sql it say file is to large i backup my database.sql but when i import it, it says the file is to large sir

[Brynner]

oh it looks like the sql log was enable which cause you a problem.

[gmpanda08]

oh it looks like the sql log was enable which cause you a problem.

what do you mean bro?

[Brynner]

oh it looks like the sql log was enable which cause you a problem.

what do you mean bro?

all the logfiles of your server was save on your sql backup that's why it became large files.