Welcome, Guest
Username: Password: Remember me

TOPIC: Error message "Base table or view already exists" while updating from 2 to 2.05

Error message "Base table or view already exists" while updating from 2 to 2.05 2 months 3 weeks ago #111448

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
Attachments:
The administrator has disabled public write access.

Error message "Base table or view already exists" while updating from 2 to 2.05 2 months 3 weeks ago #111459

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 810
  • Thank you received: 115
  • Karma: 93
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.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Error message "Base table or view already exists" while updating from 2 to 2.05 2 months 3 weeks ago #111477

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
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.099 seconds
Donation Image