Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Error updating database from 6.17.7 to 7.0.1

More
1 day 23 hours ago #274528 by jclanco_fiupm
Please help us help you and fill where relevant:
LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]  LimeSurvey Community Edition   Versión 6.17.7+260610
Own server or LimeSurvey Cloud: Own server OpenSuse 15.6, mariadb-10.11.15, php php8-8.2.30
Survey theme/template:
==================
I've maintaining a installation of LimeSurvey for several years and I've been update from various versions to the actual 6.17.7

I've downloaded and installed (as always) the new 7.0.1 version and start the admin page of our installation, since there is an version upgrade I've had a confirmation request for the database upgrade 
Actualización de la estructura de la base de datosAsegúrate de guardar una copia de seguridad de la base de datos antes de continuar.Por favor verifique la siguiente información antes de continuar con la actualización de la estructura de la base de datos:Tipo de base de datos:mysqlNombre de la base de datos:limesurveyPrefijo de las tablas:lime_Nombre del sitio:xxxxxURL raíz:xxxxxxVersión de base de datos actual:651Versión objetivo de la base de datos:708
After confirmation the update seems to start but the process crash with the error:
CDbCommand falló al ejecutar la sentencia SQL: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lime_responses_113543' already exists. The SQL statement executed was: CREATE TABLE `lime_responses_113543` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`submitdate` datetime DEFAULT NULL,
`lastpage` int(11) DEFAULT NULL,
`startlanguage` varchar(20) NOT NULL,
`seed` varchar(31) DEFAULT NULL,
`startdate` datetime NOT NULL,
`datestamp` datetime NOT NULL,
`ipaddr` text DEFAULT NULL,
`Q31490_S31528` varchar(5) DEFAULT NULL,
`Q31490_S31530` varchar(5) DEFAULT NULL,
`Q31494` text DEFAULT NULL,
...

This table exists on the current database and I don't kown why is triying to create it (I can't see a previous name change of this table) 

Please Log in to join the conversation.

More
1 day 18 hours ago #274533 by holch
No need to post twice. Posts from new members first need to be approved by moderators.

I will delete your second post with the same title here in the approval queue.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

More
1 day 3 hours ago #274537 by jclanco_fiupm
Thanks for your reply, I think I've included the information you request it en the post headers (sorry if this is not the right method)
I'm triying to upgrade our local installation of LS from 6.17.7 to 7.0.1
LS is installed in our own server (proxmox VM)which is an OpenSuse 15.6 with mariadb-10.11.15, php php8-8.2.30

The error occurs when upgrading the database schema

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose