- Posts: 6
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Error message "Base table or view already exists" while updating from 2 to 2.05
- polarbearcv
- Topic Author
- Offline
- New Member
Less
More
9 years 8 months ago #111448
by polarbearcv
Error message "Base table or view already exists" while updating from 2 to 2.05 was created by polarbearcv
I'm trying to update my Limesurvey installation from 2.00+ build 130708 to 2.05 stable version.
My server configuration is
Ubuntu server 13.10
Apache 2.4.6
PHP 5.5.3
MySQL 5.5.37
I first took a copy of my installation to another server to test the update.
When I run the Comfortupdate the 4 steps of the Limesurvey installation itself go well.
Then I get an information screen for the update of the database. (see below)
Database-upgrade
Controleer de volgende informatie voordat u doorgaat met de upgrade van de database:
Database-type: mysql
Database-naam: limesurvey2
Tabel voorvoegsel: lime_
Naam website: Testmanager
Root-URL: /limesurvey2/index.php/admin/update
But when I continue I always (i already tried a few times) get the errormessage:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`limesurvey2`.`lime_plugins`' already exists
I tried to locate this lime_plugins table in the phpmyadmin interface of my database but it isn't there.
I tried raising the memory_limit to 2048MB in the php.ini and the config-defaults.php since my database is 134 MB big (size on harddisk)
Can someone help me with this problem?
Thanks in advance and best regards,
Marc
My server configuration is
Ubuntu server 13.10
Apache 2.4.6
PHP 5.5.3
MySQL 5.5.37
I first took a copy of my installation to another server to test the update.
When I run the Comfortupdate the 4 steps of the Limesurvey installation itself go well.
Then I get an information screen for the update of the database. (see below)
Database-upgrade
Controleer de volgende informatie voordat u doorgaat met de upgrade van de database:
Database-type: mysql
Database-naam: limesurvey2
Tabel voorvoegsel: lime_
Naam website: Testmanager
Root-URL: /limesurvey2/index.php/admin/update
But when I continue I always (i already tried a few times) get the errormessage:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`limesurvey2`.`lime_plugins`' already exists
I tried to locate this lime_plugins table in the phpmyadmin interface of my database but it isn't there.
I tried raising the memory_limit to 2048MB in the php.ini and the config-defaults.php since my database is 134 MB big (size on harddisk)
Can someone help me with this problem?
Thanks in advance and best regards,
Marc
Attachments:
The topic has been locked.
- c_schmitz
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 304
- Thank you received: 86
9 years 8 months ago #111459
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
Replied by c_schmitz on topic Error message "Base table or view already exists" while updating from 2 to 2.05
Just a hint: If your update failed you need to restore the backup and try again - continuing on the database of a failed try will produce unrelated errors.
Best regards
Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
- polarbearcv
- Topic Author
- Offline
- New Member
Less
More
- Posts: 6
- Thank you received: 0
9 years 8 months ago #111477
by polarbearcv
Replied by polarbearcv on topic Error message "Base table or view already exists" while updating from 2 to 2.05
I tried a few times to reinstall my backup first but its the same problem.
I also tried to check the consistency of the database which advised me to delete some old tables which I did but nothing else.
Is there anything I can check or do to debug this problem?
Best regards,
Marc
I also tried to check the consistency of the database which advised me to delete some old tables which I did but nothing else.
Is there anything I can check or do to debug this problem?
Best regards,
Marc
The topic has been locked.