How to make a custom City/Instance/Area Detailed and advanced!

[caeon]

column count doesnt match valud count at row 1

PLEASE hELP!

[caeon]

the problem some are having is that the gameobject table structure has changed since the release of these SQLs. this is the current readout of the structure.

/*
SQLyog Community Edition- MySQL GUI
MySQL - 5.0.27-community-nt
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `gameobject_custom` (
`entry` double ,
`Type` double ,
`DisplayID` double ,
`Name` varchar (300),
`Name2` varchar (300),
`Name3` varchar (300),
`Name4` varchar (300),
`Category` varchar (300),
`CastBarText` varchar (300),
`UnkStr` varchar (300),
`spellfocus` double ,
`sound1` double ,
`sound2` double ,
`sound3` double ,
`sound4` double ,
`sound5` double ,
`sound6` double ,
`sound7` double ,
`sound8` double ,
`sound9` double ,
`unknown1` double ,
`unknown2` double ,
`unknown3` double ,
`unknown4` double ,
`unknown5` double ,
`unknown6` double ,
`unknown7` double ,
`unknown8` double ,
`unknown9` double ,
`unknown10` double ,
`unknown11` double ,
`unknown12` double ,
`unknown13` double ,
`unknown14` double
);


if you add the missing columes it should work.

I get an error when i try execute the batch file.. "[Err] 1136 - Column count doesn't match value count at row 1" and something. Got any ideas?
Does this help and if so how do u put it in the batch file

[akuerus]

Yea i want to thank you very much for this but when i try to put the items in the database it gives me an error like"Colum count dosn't match value count at row 1" Please help me u will get +Rep+Rep+Rep+Rep!!!

[pownedyo]

cool i will definatly try out this, thanks

[stendun]

Great work mate! Keep it up.

[caeon]

I was all pumped and excited to use this and was like BAM
SQL ERROR!
COLUMN COUNT DOESNT MATCH VALUE COUNT ! OMG
Thanks for it though wich it would work

[Asbfaw]

I will so need it in the near future

[sebaara]

Thx Its the most useful guide than i have read in years

[gnom]

This is awesome thnx i just cant get the links to work though but +Rep for the great guide

[colassal]

Thanx for the awesome guide!!! +Rep for the guide

[delv]

helpfull guide thanks +Rep !!!!!

[aramar]

uhm the sql files wouldnt load for me. Im using heidisql and when i try to execute the file it comesu p with a error "Sql Error: Column count doesn't match value count at row 1"

[ownagepkpker]

i got a error,here it is"[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `gameobject_names` VALUES ('70000', '5', '1368', 'Dark Bush', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
"now,are they entered,besides dark bush?

[trx]

lol, havent been in wow scene in like 2 years... you ppl still actually use GO's?

i taught some1 would come up with entire new map and new adt's by now...

like so :

[velocikill]

lol, havent been in wow scene in like 2 years... you ppl still actually use GO's?

i taught some1 would come up with entire new map and new adt's by now...

like so :

Witchcraft!