DB Patcher error

[alfa]

An error with DB Update

Code: Select all

ALTER TABLE instance_spawns_removed ADD CONSTRAINT `FK_instance_spawns` FOREIGN KEY (`spawn_id`) REFERENCES `spawn_location_entry` (`spawn_location_id`) ON UPDATE CASCADE;
1005 - Can't create table 'eq2world.#sql-1314_a' (errno: 121) 

[John Adams]

Try it now.

[alfa]

I have try to wipe all DB, sorry :p it's still update not, all data to get :p

[John Adams]

On a brand new DB, I am getting full tables and data as expected.

Also, updating EQ2TC server after I fixed the Add Constraint, now works for upgrading existing worlds.

17:56:39 I Patcher: Connecting to update server...
17:56:39 I Patcher: Checking for updates.
17:56:39 I Patcher: Found Table Updates.
17:56:40 I Patcher: Update Table: 'instance_spawns_removed' = SUCCESS!
17:56:40 I Patcher: Server is already up-to-date.

If this still isn't working (which a NEW database should), you can always run

Code: Select all

delete from `table_versions` where `name` = '{name of table}';

and it will pull down a new copy of whatever table you removed from `table_versions`. This will re-fetch any table and it's data [but always remember, foreign-key constraints means all similar tables should be replaced, not just 1]

[alfa]

It works, thanks