Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Possible bug on migrating database to 2.05+

Possible bug on migrating database to 2.05+ 8 Monate 1 Woche her #102630

Hello,

I am running Limesurvey Versión 1.90+ Build 9642 and PostgreSQL 8.4.9 on x86_64, compiled by GCC gcc (GCC) 4.4.5 20110214, 64-bit. (This actually is the RPM build by the Postgres people published on their repository).

On the Postgres ecosystem, we have this:
CREATE ROLE lime LOGIN
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
And we have the database limesurvey_db with the lime owner.

Then querying the lime_settings_global table the record "DBVersion" is set to "143".

To proceed with an upgrade, I made a complete copy of the database called limesurvey_db_test.
#su - postgres
$psql
$createdb --template=limesurvey_db --owner=lime limesurvey_db_test

Then, I prepared a complete new server with Centos 6.5 and extracted the last version of Limesurvey 2.05+ (limesurvey205-build131209.tar.gz to this date).

After installing all the requirements and optional packages:



The wizard reads the parameters to migrate the database, pointed to the limesurvey_db_test and then appears an error without details.

Looking forward the way to debug I changed the limesurvey/application/config/config.php file with debug=>2 and debugsql=>1.

Finally I got this output:
CDbCommand failed to execute the SQL statement: SQLSTATE[25P02]: 
In failed sql transaction: 7 
ERROR: current transaction is aborted, commands ignored until end of transaction block. 
The SQL statement executed was: 
ALTER TABLE lime_labels ALTER COLUMN language SET NOT NULL

And the Postgres Log
ERROR:  column "language" is in a primary key
STATEMENT:  ALTER TABLE lime_labels ALTER COLUMN language DROP NOT NULL
ERROR:  current transaction is aborted, commands ignored until end of transaction block
STATEMENT:  ALTER TABLE lime_labels ALTER COLUMN language SET NOT NULL

This looks like a bug to me than anything else. It is supposed to be a smooth migration.

Some clues? Or another way to debug? Where are these update instructions?
Letzte Änderung: 8 Monate 1 Woche her von CrystalBlood.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Possible bug on migrating database to 2.05+ 8 Monate 1 Woche her #102632

I studied the line where these statements were built, in the file ./application/helpers/update/updatedb_helper.php

I compare the final structure that would provide the function alterColumn with this specific call (line 504):
alterColumn('{{labels}}','language',"{$sVarchar}(20)",false , 'en');
And was exactly the same, so I proceed to comment that line to see how behaves.

But now throws another error on another table:
CDbCommand failed to execute the SQL statement: 
SQLSTATE[25P02]: In failed sql transaction: 7 
ERROR: current transaction is aborted, commands ignored until end of transaction block. 
The SQL statement executed was: UPDATE "lime_user_groups" SET "name"=:name WHERE name is NULL. Bound with :name=''

On Postgres Log:
ERROR:  index "email" does not exist
STATEMENT:  DROP INDEX "email"
ERROR:  current transaction is aborted, commands ignored until end of transaction block
STATEMENT:  UPDATE "lime_user_groups" SET "name"='' WHERE name is NULL

Is not that straightforward as the documentations says about these versions. There is some recommended old release to migrate first? and then to 2.05?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Possible bug on migrating database to 2.05+ 8 Monate 20 Stunden her #102953

Somebody have a clue/advice?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Possible bug on migrating database to 2.05+ 6 Monate 3 Wochen her #104774

  • atisne
  • atisnes Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 1
  • Dank erhalten: 1
  • Karma: 5
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: DenisChenu

Possible bug on migrating database to 2.05+ 6 Monate 3 Wochen her #104778

Hey! Thanks atisne!

I will try the patch and then I will post it. Ok?

Best regards
Letzte Änderung: 6 Monate 3 Wochen her von CrystalBlood.
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.486 Sekunden
Donation Image