Syntax error when upgrading database with 3.0.1 installation

Mehr
5 Monate 2 Wochen her #162186 von hgreenwald
hgreenwald erstellte das Thema Syntax error when upgrading database with 3.0.1 installation
I've upgraded my LimeSurvey instance from 2.72.4 to 3.0.1. When I started LimeSurvey, it attempted to update the database from version 328 to 338, but it encountered the following error:

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "NOT" LINE 1: ...ALTER COLUMN "name" TYPE character varying (168) NOT NULL ^

This is a PostgreSQL 9.2.23 database. My SQL knowledge is extremely limited, so any help would be greatly appreciated.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 2 Wochen her #162190 von jelo
jelo antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
You might post a bugreport.
www.limesurvey.org/community/bug-tracker

There are issues with other databases as well.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 2 Wochen her #162191 von hgreenwald
hgreenwald antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
I've tried to get around it by upgrading to PostgreSQL 10. And now my PHP is out of date, so I'm working on that.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 2 Wochen her #162203 von hgreenwald
hgreenwald antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
I upgraded to Postgres 10 and PHP 7, but the syntax error still occurred. I deleted the database and had LS create a new one from scratch, and that caused the following:
Internal Server Error

CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "active" is of type boolean but default expression is of type integer
HINT: You will need to rewrite or cast the expression. #0 /var/www/html/limesurvey/framework/db/CDbCommand.php(1352): CDbCommand->execute()
#1 /var/www/html/limesurvey/installer/create-database.php(276): CDbCommand->createTable('{{plugins}}', Array)
#2 /var/www/html/limesurvey/application/controllers/InstallerController.php(904): createDatabase(Object(DbConnection))
#3 /var/www/html/limesurvey/application/controllers/InstallerController.php(519): InstallerController->_setup_tables('/var/www/html/l...')
#4 /var/www/html/limesurvey/application/controllers/InstallerController.php(82): InstallerController->stepPopulateDb()
#5 /var/www/html/limesurvey/framework/web/CWebApplication.php(282): InstallerController->run('populatedb')
#6 /var/www/html/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...')
#7 /var/www/html/limesurvey/framework/base/CApplication.php(185): CWebApplication->processRequest()
#8 /var/www/html/limesurvey/index.php(195): CApplication->run()
#9 {main}

I think I'll submit a bug report, but if anyone has other suggestions, please let me know.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 1 Woche her #162253 von olle
olle antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
Thank you for your bug report. I will test with Postgres.
Folgende Benutzer bedankten sich: hgreenwald

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 1 Woche her #162314 von olle
olle antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
This is resolved, please wait until release 3.0.2 and try again with this version.
Folgende Benutzer bedankten sich: hgreenwald

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 1 Woche her #162342 von hgreenwald
hgreenwald antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
Thank you for addressing this!

Have you considered posting messages on the download site when you encounter major bugs like this? In this case, you'd want Postgres users to know not to install the 3.0.1 update on their production systems.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
5 Monate 1 Woche her #162343 von olle
olle antwortete auf das Thema: Syntax error when upgrading database with 3.0.1 installation
3.0 is not ready to upgrade from 2.73 (that's why it's not yet visible in ComfortUpdate), but fresh install should work (and have less risk).

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha