sql 1.0.3 to 1.0.4 error

[Specc 0]

exile.sql   works

exileEscape.sql works

upgrade 1.0.2-1.0.3.sql works

upgrade 1.03-1.04  will not read correctly

 Query upgrade-1.0.3-1.0.4 start

	[ERR] 1060 - Duplicate column name 'territory_id'

	[ERR] ALTER TABLE vehicle ADD `territory_id` int(11) unsigned DEFAULT NULL AFTER `vehicle_texture`;

	ALTER TABLE vehicle ADD `nickname` varchar(64) NOT NULL DEFAULT '' AFTER `territory_id`;

	ALTER TABLE vehicle ADD KEY `vehicle_ibfk_2_idx` (`territory_id`);

	ALTER TABLE vehicle ADD CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE;

	[SQL] Finished with error

anyone have a good one?

[Spazz711 23]

If you already had Exad VG the column would already be there. Simply remove the first line from the sql script and run it again

[Specc 0]

 Query upgrade-1.0.3-1.0.4 start

	[ERR] 1060 - Duplicate column name 'nickname'

	[ERR] ALTER TABLE vehicle ADD `nickname` varchar(64) NOT NULL DEFAULT '' AFTER `territory_id`;

	ALTER TABLE vehicle ADD KEY `vehicle_ibfk_2_idx` (`territory_id`);

	ALTER TABLE vehicle ADD CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE;

	[SQL] Finished with error

Now there are 3 errors without the first line!

Its the new Official download and should work normally!

[Spazz711 23]

Well by the sounds of that it has already executed the script?

When you first ran it did it say it completed the other 3 lines? or did stop the script when it errored on the first?

[dekela 129]

If you had ExAd VG originally, run each line individually. It will error but will update when you close out of db and open it again. You should see the new column and keys 

[koriaba 7]

I have the same mistake.
can someone give a backup file with customized tables 1.0.4?

type 180312230000.psc

[Anhor 17]

Maybe this helps .......

exile

exile escape

exile pineapple update

[koriaba 7]

thanks already done, took a db from last year