[Release] Reflection's Karazhan Mall (2.4.3)

[helios00100]

Why do I get an error when I extract the Vendors saying "SQL Error: Column Count doesn't match value count at row 1" ? Need help. +Rep if you do.

[Reflection]

Update your database.

[Lets See2]

Nice Bro Great Mall!One Issue Tho Creature_spawns Said Columns Were Messed Up Somehow In Navicat Anyway You Know of To Fix Dis If So Thanks!+REP

[Performer]

Okay this is sexy!!!

[Dartignan]

Guys for those that don't know if your having troubles with the SQl query such as getting the error that says the item/items already exist kinda thing theres a very simple way to fix this problem.

Get the Entire SQL Query and copy and paste it into a notepad type Ctrl+H then where it says Find what type INSERT (all Caps) and where it says Replaace with type REPLACE (all caps) then click the Button that says replace all. Now copy and paste the new SQL Query into the Query Section in your SQL. and RU the Query.

Now Instead of just adding the item. It deletes any items that already has the Entry ID and REPLACES it with the New one....Just Hope you don't lose any of your custom stuff doing it.

And to Reflection +Rep because well ive tried releasing a mall and could never figure out how to get the SQL query of Spawns without typing them myself and well ya no way in hell im typing them lol.

[Reflection]

To Lets See2. Update your database.

To Yimo. Thanks alot

To Dartignan. You can either do that or run the delete SQL first.

[Etna]

Haha nice mall !!

[Reflection]

Thank you

[Dartignan]

To Dartignan. You can either do that or run the delete SQL first.

LoL i didn't know you had a delete SQL or i wouldn't of took the time to write that lol

[Reflection]

Haha. There's a deletemall sql in the rar file.

[Dartignan]

lol o well i guess now people know for future refrence atleast

[Andeby]

You shouldn't do the deletall if you know that you have something with that ID you want to keep, though. Or you will delete whatever that is. You should change the entry of that thing first.

[Reflection]

Indeed. Always look in the SQL if there's something you want to keep.

[Troys]

awesome yet another sexy mall from you keep up the work man =]

[Reflection]

Thank you Troys. I will continue to make things if I continue to get good replies from them.