sorry i dont use navicat so not sure where the execute button is myself but if you use HeidiSQL then there should be a Blue arrow at the menu bar who execute the SQL. updating thread in a sec little busy
sorry i dont use navicat so not sure where the execute button is myself but if you use HeidiSQL then there should be a Blue arrow at the menu bar who execute the SQL. updating thread in a sec little busy
kk thx
---------- Post added at 10:39 PM ---------- Previous post was at 10:36 PM ----------
wait on heidisql is it a blue arrow like this ? > it says query?
its just a "Triangle" pointing against right. but you have to paste the "Text" jerry provided into the SQL Box. there is a big box there.
a guide i wrote for long time ago
1. open heidisql.
2. click on world.
3. Click on Query
4. paste the text into the box under
5. hit the execute button
6. if it doesnt come up any error message it was succesful.
ok thx for taking time to help me ^^ m8
---------- Post added at 10:48 PM ---------- Previous post was at 10:46 PM ----------
eh man... i dont have the database world ... :P
which ones do you have then ?
Nice, good job!
Error occured at:2010-12-05 19:12:53
Line no.:2
Error Code: 1054 - Unknown column 'modelid_A' in 'field list'
SOS PLS :S
thank for share
Does this work with latest Amber?
---------- Post added at 05:03 PM ---------- Previous post was at 04:47 PM ----------
[Err] 1054 - Unknown column 'modelid_A' in 'field list'
[Err] insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('800004', '31962', '0', '0', '0', "Misc & Quest items Vendor", "", '80', '80', '1905120', '1905120', '7333248', '7333248', '500000000', '35', '35', '129', '2.50', '8.00', '1.15', '1', '200000', '200000', '100', '0', '7', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I got this error with Shiva's latest Amber release. Any way to fix that? Thanks
Thanks for sharing to this comminuty! :)
Bookmarks