Specc

sql 1.0.3 to 1.0.4 error

8 posts in this topic

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

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

  • Like 1

Share this post


Link to post
Share on other sites
Advertisement

 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

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

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
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.