donkeyg Posted October 19, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Share Posted October 19, 2012 (edited) [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 Quote Link to comment Share on other sites More sharing options...
Brynner Posted October 19, 2012 Group: Members Topic Count: 120 Topics Per Day: 0.02 Content Count: 1962 Reputation: 202 Joined: 01/08/12 Last Seen: 18 hours ago Share Posted October 19, 2012 your sql is not updated.upgrade_svn16518.sql 1 Quote Link to comment Share on other sites More sharing options...
donkeyg Posted October 19, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Author Share Posted October 19, 2012 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? Quote Link to comment Share on other sites More sharing options...
Judas Posted October 19, 2012 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 2244 Reputation: 182 Joined: 11/19/11 Last Seen: September 15, 2024 Share Posted October 19, 2012 yes make sure your databse is selected/highlighted if you use mysql Quote Link to comment Share on other sites More sharing options...
donkeyg Posted October 19, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Author Share Posted October 19, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Brynner Posted October 19, 2012 Group: Members Topic Count: 120 Topics Per Day: 0.02 Content Count: 1962 Reputation: 202 Joined: 01/08/12 Last Seen: 18 hours ago Share Posted October 19, 2012 just import those sql. same way you import the main.sql on your mysql server. Quote Link to comment Share on other sites More sharing options...
donkeyg Posted October 19, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Author Share Posted October 19, 2012 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] Quote Link to comment Share on other sites More sharing options...
Judas Posted October 19, 2012 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 2244 Reputation: 182 Joined: 11/19/11 Last Seen: September 15, 2024 Share Posted October 19, 2012 pm your teamview id/pass to me Quote Link to comment Share on other sites More sharing options...
donkeyg Posted October 19, 2012 Group: Members Topic Count: 344 Topics Per Day: 0.07 Content Count: 1060 Reputation: 1 Joined: 02/13/12 Last Seen: November 14, 2016 Author Share Posted October 19, 2012 pm your teamview id/pass to me already Thanks Brynner. also judas had solved my problem ^^ Quote Link to comment Share on other sites More sharing options...
gmpanda08 Posted June 17, 2013 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 4 Reputation: 0 Joined: 04/27/13 Last Seen: February 1, 2017 Share Posted June 17, 2013 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 Quote Link to comment Share on other sites More sharing options...
Brynner Posted June 17, 2013 Group: Members Topic Count: 120 Topics Per Day: 0.02 Content Count: 1962 Reputation: 202 Joined: 01/08/12 Last Seen: 18 hours ago Share Posted June 17, 2013 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. Quote Link to comment Share on other sites More sharing options...
gmpanda08 Posted June 17, 2013 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 4 Reputation: 0 Joined: 04/27/13 Last Seen: February 1, 2017 Share Posted June 17, 2013 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 Quote Link to comment Share on other sites More sharing options...
Brynner Posted June 17, 2013 Group: Members Topic Count: 120 Topics Per Day: 0.02 Content Count: 1962 Reputation: 202 Joined: 01/08/12 Last Seen: 18 hours ago Share Posted June 17, 2013 oh it looks like the sql log was enable which cause you a problem. Quote Link to comment Share on other sites More sharing options...
gmpanda08 Posted June 17, 2013 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 4 Reputation: 0 Joined: 04/27/13 Last Seen: February 1, 2017 Share Posted June 17, 2013 oh it looks like the sql log was enable which cause you a problem. what do you mean bro? Quote Link to comment Share on other sites More sharing options...
Brynner Posted June 17, 2013 Group: Members Topic Count: 120 Topics Per Day: 0.02 Content Count: 1962 Reputation: 202 Joined: 01/08/12 Last Seen: 18 hours ago Share Posted June 17, 2013 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. Quote Link to comment Share on other sites More sharing options...
Question
donkeyg
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 by donkeygLink to comment
Share on other sites
14 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.