I have the same problem with easyphp and Postgresql 9.1
error message when trying to contact: update.limesurvey.org / updates

If I typed in the address: update.limesurvey.org / updates
I get this:
1:53:33 p.m. "}}

how to build value found?
I do not have version 1.92 + on my server.

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13706

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13708

I updated to Build 140116 via Comfort-Update and got the same Error.

After Fixing as recommended here, now i get this Error:

"CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "active" is of type boolean but expression is of type integer
LINE 1: ...NSERT INTO "plugins" ("name", "active") VALUES ('Authdb', 1)
^
HINT: You will need to rewrite or cast the expression."

What should i do?

When exactly do you get this error? Did you activate any plugins?

No I just updatet to Build 140116 via Comfort-Update. Step 4 showed a white screen.
After that i got the error:

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.

After fixing it with the procedure her (08519) i get this errors:

"CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "active" is of type boolean but expression is of type integer
LINE 1: ...NSERT INTO "plugins" ("name", "active") VALUES ('Authdb', 1)
^
HINT: You will need to rewrite or cast the expression."

The error appears, when i want to get to the admin-panel

Did you apply both patches below?

yes, i did.

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13712

Did some more changes - please let me know if it is alright now.

Still get the error:

"CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "active" is of type boolean but expression is of type integer
LINE 1: ...NSERT INTO "plugins" ("name", "active") VALUES ('Authdb', 1)
^
HINT: You will need to rewrite or cast the expression."

With an empty postgress-database everything works.
But if i refer to the existing postgress-database i get the error.

The dump of the postgress is the dump after the failed update.
What should i do to get to the data of the after-update-failed-dump in lime survey?

I think I found the issue.

It should be enough to change the column 'active' in table 'plugins' to type 'integer'.

Did that.
Now i have access to my old label set and to my user-administration.
But the old survey are not shown.

After i did that, If i install a ne LS i get this Error-Message:
"The table "{{permissions}}" for active record class "Permission" cannot be found in the database."

If i install with an empty database and edit the config-file later to a cleaned-up dump i only get access to the label set and the user-administration

Data-Integrity-Check:

Couldn't make backup of the survey table. Please try again. The database reported the following error:
exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "umfragen_survey_958369" does not exist' in /var/www/forschungbackup4/framework/db/CDbCommand.php:358 Stack trace: #0 /var/www/forschungbackup4/framework/db/CDbCommand.php(1336): CDbCommand->execute() #1 /var/www/forschungbackup4/application/controllers/admin/checkintegrity.php(382): CDbCommand->renameTable('{{survey_958369...', '{{old_survey_95...') #2 /var/www/forschungbackup4/application/controllers/admin/checkintegrity.php(41): CheckIntegrity->_checkintegrity() #3 [internal function]: CheckIntegrity->index() #4 /var/www/forschungbackup4/framework/web/actions/CAction.php(108): ReflectionMethod->invokeArgs(Object(CheckIntegrity), Array) #5 /var/www/forschungbackup4/application/core/Survey_Common_Action.php(99): CAction->runWithParamsInternal(Object(CheckIntegrity), Object(ReflectionMethod), Array) #6 /var/www/forschungbackup4/framework/web/CController.php(308): Survey_Common_Action->runWithParams(Array) #7 /var/www/forschungbackup4/framework/web/CController.php(286): CController->runAction(Object(CheckIntegrity)) #8 /var/www/forschungbackup4/framework/web/CController.php(265): CController->runActionWithFilters(Object(CheckIntegrity), Array) #9 /var/www/forschungbackup4/application/controllers/AdminController.php(169): CController->run('checkintegrity') #10 /var/www/forschungbackup4/framework/web/CWebApplication.php(282): AdminController->run('checkintegrity') #11 /var/www/forschungbackup4/framework/web/CWebApplication.php(141): CWebApplication->runController('admin/checkinte...') #12 /var/www/forschungbackup4/framework/base/CApplication.php(180): CWebApplication->processRequest() #13 /var/www/forschungbackup4/index.php(190): CApplication->run() #14 {main}

I can access the formular of each survey, modifying the specific "sid" in the url, but the surveys are not shown up in the admin Panel.

I
A) Set up a new LS with new postgress-database "test" ans install in folder /var/www/test/.
B) Set up a second new LS with your old postgres-database and install in /var/www/old/.
C) Dump the empty db "test"
D) Open db "test" and search for "permissions", copy the SQL-Code with "permissions" inside and execute it in the db-old.
E) Now the old surveys appear in the admin panel in /var/www/old/

if i click on them i get this error:

"Fehler

No permission"

it looks to me like the rest of your problems are coming from incomplete update tries.

You will need to revert your database to the state from before you tried the update for the first time (I hope you created a backup before you updated).

Then do the update again.

Actually i was so dumb, to not dump the db before.
Any method to rescue The Data?

YOu will need to add permissions in the permission table. Check the permissions on the new installation then try to replicate that in the old one.

Thanks a lot. Here the way i did it:

for each survey execute in Postgres this SQL:

INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'responses', 1, 1, 1, 1, 1, 1, 'survey', NUMBER_STARTING_FROM_100);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'assessments', 1, 1, 1, 1, 0, 0, 'survey', NUMBER_STARTING_FROM_x+1);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'translations', 0, 1, 1, 0, 0, 0, 'survey', NUMBER_STARTING_FROM_x+2);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'statistics', 0, 1, 0, 0, 0, 0, 'survey', NUMBER_STARTING_FROM_x+3);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'quotas', 1, 1, 1, 1, 0, 0, 'survey', NUMBER_STARTING_FROM_x+4);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'surveylocale', 0, 1, 1, 0, 0, 0, 'survey', NUMBER_STARTING_FROM_x+5);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'survey', 0, 1, 0, 1, 0, 0, 'survey' 'survey', NUMBER_STARTING_FROM_x+6);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'surveysettings', 0, 1, 1, 0, 0, 0, 'survey', NUMBER_STARTING_FROM_x+7);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'surveysecurity', 1, 1, 1, 1, 0, 0, 'survey', NUMBER_STARTING_FROM_x+8);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'surveyactivation', 0, 0, 1, 0, 0, 0, 'survey', NUMBER_STARTING_FROM_x+9);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'surveycontent', 1, 1, 1, 1, 1, 1, 'survey', NUMBER_STARTING_FROM_x+10);
INSERT INTO permissions VALUES (SID_OF_YOUR_SURVEY, 1, 'tokens', 1, 1, 1, 1, 1, 1, 'survey', NUMBER_STARTING_FROM_x+11);

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13733

2.05+ Build 140125 released