I has some Ploblem about Query 20100808update.sql

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
shoko
Posts: 160
Joined: Sat Jul 28, 2007 11:46 am

I has some Ploblem about Query 20100808update.sql

Post 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.

Image
User avatar
shoko
Posts: 160
Joined: Sat Jul 28, 2007 11:46 am

Re: I has some Ploblem about Query 20100808update.sql

Post by shoko »

I found ploblem all item elementals has remove if I skip update file
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: I has some Ploblem about Query 20100808update.sql

Post by JIV »

thats the point of that update and i think youre doin it rong..
User avatar
Aikimaniac
L2j Inner Circle
L2j Inner Circle
Posts: 3048
Joined: Sun Aug 07, 2005 11:42 pm
Location: Slovakia

Re: I has some Ploblem about Query 20100808update.sql

Post 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 :D
Image
User avatar
shoko
Posts: 160
Joined: Sat Jul 28, 2007 11:46 am

Re: I has some Ploblem about Query 20100808update.sql

Post by shoko »

555 sorry my english is null -*-
I rollback database , It work but aglument just delete
User avatar
Aikimaniac
L2j Inner Circle
L2j Inner Circle
Posts: 3048
Joined: Sun Aug 07, 2005 11:42 pm
Location: Slovakia

Re: I has some Ploblem about Query 20100808update.sql

Post 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...
Image
Post Reply