[SOLVED] Problem with HeidiSQL ( Merge.sql)

[fonigou]

Hey guys,
I have a problem with my HeidiSQL. I need to get the merge.sql file (who is in Source>sql>updates>merge)
into my world database in HeidiSQL. So I can load my Merge.sql file into HeidiSQL but when I run it, this error pops up :
Error SQL (1054) Unknown column "VerifiedBuild" in "field list".
I also noticed that my Merge.sql file isn't as much big as it should be, It's only 172 Ko
So i skipped this step and everything went fine until I Opened my worldserver.exe. What should I do ?

 

[Tommy]

I would suggest EmuDevs EDB: http://emudevs.com/forumdisplay.php/226-EDB

A lot of the WDBVerified was changed to VerifiedBuild. I changed this a long time ago in EDB, so, you can either use that or look at which WDBVerified columns were changed to VerifiedBuild.

 

[fonigou]

Sorry for choosing the wrong forum I'm going to switch my thread to EDB, but I still don't understand what you explained to me, where should i go and whats should I change ?

 

[Zero]

I think what Tommy meant was take a look at EmuDevs DB instead of TDB.

As for your error, by the sounds of it you didn't merge all the SQLs and missed out one of them which updated the item_template structure. Make sure you run the update files in order and if they're not merging properly, try doing them one by one.

 

[Tommy]

Sorry for choosing the wrong forum I'm going to switch my thread to EDB, but I still don't understand what you explained to me, where should i go and whats should I change ?

Your thread is on the correct forum. I just said that you should use EDB instead of TDB. This thread is related to TDB, is it? If so, you're in the correct section.

 

[fonigou]

Ok, I'm sorry I misunderstood, I will try to fix it by switching to EDB like you said. Thanks