Specc 0 Report post Posted March 11, 2018 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? Share this post Link to post Share on other sites
Spazz711 23 Report post Posted March 11, 2018 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 1 Share this post Link to post Share on other sites
Specc 0 Report post Posted March 11, 2018 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! Share this post Link to post Share on other sites
Spazz711 23 Report post Posted March 11, 2018 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? Share this post Link to post Share on other sites
dekela 129 Report post Posted March 12, 2018 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 Share this post Link to post Share on other sites
koriaba 7 Report post Posted March 12, 2018 I have the same mistake.can someone give a backup file with customized tables 1.0.4? type 180312230000.psc Share this post Link to post Share on other sites
Anhor 17 Report post Posted March 12, 2018 Maybe this helps ....... exile exile escape exile pineapple update Share this post Link to post Share on other sites
koriaba 7 Report post Posted March 12, 2018 thanks already done, took a db from last year Share this post Link to post Share on other sites