Page 1 of 1
I has some Ploblem about Query 20100808update.sql
Posted: Wed Oct 06, 2010 7:24 am
by shoko
L2J Revision Number: 4418
L2JDP Revision Number: 7665
Code: Select all
INSERT INTO item_elementals (itemId, elemType, elemValue) SELECT itemId, elemType, elemValue FROM item_attributes;ALTER TABLE item_attributes DROP COLUMN elemType, DROP COLUMN elemValue;
In table item_attributes not have COLUMN elemType and elemValue
If I skip this file not updated with Oae profit or not there is a problem.
Re: I has some Ploblem about Query 20100808update.sql
Posted: Wed Oct 06, 2010 9:17 am
by shoko
I found ploblem all item elementals has remove if I skip update file
Re: I has some Ploblem about Query 20100808update.sql
Posted: Wed Oct 06, 2010 9:19 am
by JIV
thats the point of that update and i think youre doin it rong..
Re: I has some Ploblem about Query 20100808update.sql
Posted: Wed Oct 06, 2010 11:24 am
by Aikimaniac
JIV wrote:thats the point of that update and i think youre doin it rong..
because its ploblem and not problem at all
Re: I has some Ploblem about Query 20100808update.sql
Posted: Wed Oct 06, 2010 11:27 am
by shoko
555 sorry my english is null -*-
I rollback database , It work but aglument just delete
Re: I has some Ploblem about Query 20100808update.sql
Posted: Wed Oct 06, 2010 12:30 pm
by Aikimaniac
shoko wrote:555 sorry my english is null -*-
I rollback database , It work but aglument just delete
does not google translator works correct in Chiang Mai ?
you should always use update script...