NEW DB

[Loki]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, DPS_AF, SPD_ABS, Hand, Type_Damage, Object_Typ' at line 2
[Msg] Finished - Unsuccessfully


while trying to execute batch on itemtemplate

What i doing wrong

Regadrs

[Etaew]

Condition is a reserved keyword in MySQL, not sure how to resolve the exports.

[minimal]

I am assuming this is the DB release provided by DOL DB Team (Overdriven's Announcement) ?

I would have to check on how it was exported, whether Navicat was used or not.
I have found numerous issues with exports using navicat, specifically when trying to reimport the same DB exported by Navicat.

Kinda odd that the program that ran the export wouldn't accept it's input.

Will have to check with OD on how it was exported or dumped and will be able to answer.

Chances are it is looking quotations some place or it could have an extra , somewhere.


EDIT: Okay i downloaded the itemtemplate.sql
Question for you is how are you trying to source the file ?
Navicat, command line, MySQL GUI ?
Please be specific on method of import ?

[Loki]

Navicat GUI batch sorry

[minimal]

Try using Navicat as that is most likely how it was dumped.

MySQL along with command line like to have ` ` surrounding the variables.
Took me awhile to figure this one out as i would export using Navicat but import using command line.

If you still have issues after using Navicat let me know.

[Loki]

i am using navicat to execute batch command m8

[minimal]

Apparently i need to have my eyes checked


Been long day.

The long way to get it fixed is to make sure the variables are set like this.

Code: Select all

INSERT INTO itemtemplate
(`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus1Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `Gold`, `Silver`, `Copper`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`)

These are not all the fields but as you can see they have ` ` around the variable names.

[minimal]

Or you can follow tolakram

ItemTemplate

Error with reserved word Condition. Easy to fix, open the file in an editor that can handle it and do a find of

ty, Condition


and replace with

ty, `Condition`

Note those are back quotes, the one found at the upper left of most keyboards.

MySQL documentation concerning reserved words:

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

Suggestion use Wordpad -> Notepad can do it just sucks the life out of PC

[Loki]

cheers m8ty

[Etaew]

Any suggestions on fixing the Navicat export to include this? how does the mysql command line dump handle it?

[Overdriven]

MySQL> source "D:\whatever.sql";


Works totally.

[Loki]

still not working even command line way, any other suggestions, surley as Navicat is what is recomended it should just be able to import it, anybody have it and care to do sql dump of itemtemplate from new DB

[Tolakram]

http://sqlmanager.net/en/products/mysql ... r/download

Download the Lite version (free), install, import, be happy.

[Loki]

cheers m8ty worked

[Etaew]

Anyone want to write a new tutorial for this new version?