update bugs

[phantomghost]

When you source the SQL in, if a table exists it will not add another, so you either delete your table or make your table columns match. If there is any data in the table that duplicates you'll need to clear it. So, easiest way if you want to use 100% of the table from SQL file is just drop the whole table and source it in... It should then actually source the other table in because it won't get an error prior.

[spiritchaser]

Originally Posted by phantomghost

When you source the SQL in, if a table exists it will not add another

That was the point of my topic but it was focusing on the fact that when you first install the server then run the update script to fully update your database you don't get some of the updates because of that (missing tables after install).

[jaspen]

Originally Posted by spiritchaser

That was the point of my topic but it was focusing on the fact that when you first install the server then run the update script to fully update your database you don't get some of the updates because of that (missing tables after install).

Seems I wasn't the only one who had this issue. I posted a couple of days before you concerning the character_auras not being created and update errors. Glad to see it wasn't a problem on my end but a problem on theirs. Is there an official place to post bugs like this so that they can be corrected?