doommap Posted December 11, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 30 Reputation: 0 Joined: 11/21/12 Last Seen: April 21, 2021 Share Posted December 11, 2012 i have my server online for 3 weeks now then apparently im having this kind of error i tried this topic already http://rathena.org/board/topic/68445-unknown-column-favorite-in-field-list/ still im having this error, can anyone help me out with this? im using rAthena Version SVN r16928 about the sql injection i just copied and executed this ALTER TABLE `inventory` ADD COLUMN `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`; still same thing happens Quote Link to comment Share on other sites More sharing options...
Brynner Posted December 11, 2012 Group: Members Topic Count: 118 Topics Per Day: 0.03 Content Count: 1942 Reputation: 197 Joined: 01/08/12 Last Seen: Tuesday at 03:14 PM Share Posted December 11, 2012 use this. upgrade_svn16518.sql Quote Link to comment Share on other sites More sharing options...
doommap Posted December 11, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 30 Reputation: 0 Joined: 11/21/12 Last Seen: April 21, 2021 Author Share Posted December 11, 2012 ive injected that already still same thing happens Quote Link to comment Share on other sites More sharing options...
Neo-Mind Posted December 11, 2012 Group: Members Topic Count: 22 Topics Per Day: 0.00 Content Count: 806 Reputation: 220 Joined: 03/13/12 Last Seen: April 16 Share Posted December 11, 2012 Did you see if it was successful after running that SQL injection code? check the inventory table and see if you have a column named 'favorite' actually present. Also make sure the db you are modifying is the same one that the server refers to. Quote Link to comment Share on other sites More sharing options...
doommap Posted December 11, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 30 Reputation: 0 Joined: 11/21/12 Last Seen: April 21, 2021 Author Share Posted December 11, 2012 (edited) yeah i am sure and ive check, and this error still shows up, anyone? please i really need help on this one Edited December 11, 2012 by doommap Quote Link to comment Share on other sites More sharing options...
doommap Posted December 15, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 30 Reputation: 0 Joined: 11/21/12 Last Seen: April 21, 2021 Author Share Posted December 15, 2012 solved Quote Link to comment Share on other sites More sharing options...
Question
doommap
i have my server online for 3 weeks now then apparently im having this kind of error
i tried this topic already http://rathena.org/board/topic/68445-unknown-column-favorite-in-field-list/
still im having this error, can anyone help me out with this?
im using rAthena Version SVN r16928
about the sql injection i just copied and executed this
ALTER TABLE `inventory` ADD COLUMN `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`;
still same thing happens
Link to comment
Share on other sites
5 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.