• 0
Papa_Rimskiy

Error updating sql

Question

Hey.
Please tell me, when updating the databases I have such an error takes off

SQL-Befehl:

 

ALTER TABLE container ADD `abandoned` DATETIME DEFAULT NULL;
 

MySQL meldet: Dokumentation

# 1060 - Duplicate column name 'abandoned'

This occurs after upgrade upgrade-0.9.41-to-0.9.60.sql
A clear answer, I have not found, can someone tell me what's the problem?

Edited by Papa_Rimskiy

Share this post


Link to post
Share on other sites

4 answers to this question

  • 0

Good.
And why is it then when you next update sql "upgrade-0.9.60-to-0.9.80.sql"
again gives an error ??

ALTER TABLE territory DROP COLUMN `flag_steal_message`
A MySQL: Documentation

# 1091 - You can not delete (DROP) 'flag_steal_message'. Make sure that the column / key does exist

I set everything in order:
exile.sql - established
upgrade-0.9.40-to-0.9.41.sql - established
upgrade-0.9.41-to-0.9.60.sql - error
upgrade-0.9.60-to-0.9.80.sql - error

Share this post


Link to post
Share on other sites
Advertisement
  • 0

Guys, there are some solutions?
Maybe somebody will throw a ready database sql latest version? exile.sql in one file))

Edited by Papa_Rimskiy

Share this post


Link to post
Share on other sites
  • 0

Papa_Rimskiy, I believe the "exile.sql" file is the current one if your installing a new database. The others are only used for updating an older database to the current one. So if I understand this correctly the reason your getting the errors are your trying to "update" a database that already has the tables installed. 

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.