Page 1 of 1
DB Patcher error
Posted: Fri Oct 19, 2012 3:27 pm
by 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)
Re: DB Patcher error
Posted: Fri Oct 19, 2012 3:29 pm
by John Adams
Try it now.
Re: DB Patcher error
Posted: Fri Oct 19, 2012 3:41 pm
by alfa
I have try to wipe all DB, sorry :p it's still update not, all data to get :p
Re: DB Patcher error
Posted: Fri Oct 19, 2012 5:57 pm
by 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]
Re: DB Patcher error
Posted: Fri Oct 19, 2012 6:59 pm
by alfa
It works, thanks