Hi,

Just used comfort update to 2.5RC4 Build and getting the following error.

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'SessionName' for key 'PRIMARY'

Is there any recovering from this. All is still running but it is impossible to enter admin. Is there an entry in one of the tables I should be looking at to correct the duplicate. I do notice there is activity in ls_settings_global.

Regards,
Brad.

I am stuck in a loop at the address
index.php/admin/databaseupdate/sa/db

Hi Brady, this is strange because many people updated to RC4 without encountering problems. Could you tell us a little more about the context ? While I'm looking to the update code, you can yet delete the entry "SessionName" in the table prefix_settings-global, it should resolve the problem.

Thank you LoisGac greatly appreciate the response.

We are running CentOS 7 with cPanel. The upgrade appeared to work just fine. After about 4 hours of building a survey the Database Update just suddenly appeared. I clicked update and then the error. I have already experimented by deleting the entry in the table however only to find that a new one has taken its place.

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'printanswers'

If I then cilck on continue after resolving I then revert back to the previous error.

Regards,
Brad.

I have similar symptoms. I was updating from 2.05RC2 to newest. I am running Centos 6. If it matters, I recently updated from newest 1.x to 2.05RC2 using comfort update.

I set debug=1 in config and get:
PHP warning
require(/srv/misc/limesurvey/styles/blobblueish/package/package.php): failed to open stream: No such file or directory

I do not know where this blobblueish is from, but I changed its name andd did ln -s /srv/misc/limesurvey/styles/Bay_of_Many blobblueish

After this all worked. Is it possible that I had old theme that ws not correctly converted to new lime and this broke everything?

i solved this problem, you can try change the table 'lime_settings_global' records with col ''stg_name' value 'admintheme' and change the 'stg_value' to another style like for example 'Apple_Blossom' .

Hi, i have that same problem and i have to delete all the entrys in table lime_settings_global, just leave this params

DBVersion 257
SessionName 07,/"^.!3kfe-k9bbdoeSAasdasasddasdaX"|X|>;0vKF#YHagIsS0Z_{sC^X3D-T|/RV,oq;g=a
sitename LimeSurvey
siteadminname Administrator
siteadminemail email@domain.com
siteadminbounce email@domain.com
defaultlang en

I thinks the most import is:
DBVersion 257

Greetings

Hi,
I have the same problem. I'm really scared to change things in the database. I don't want to make mistakes here. What is helping for this problem?

I'm getting a similar error while attempting to login after a manual install of 2.62.2+170203.

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'Hash'

Current database version: 260
Target database version: 261

Since you're a ComfortUpdate customer you should be able to open a support ticket via www.limesurvey.org/support . Ensure you're logged in. You can find the ticketsystem via the profile as well.

Thanks. I don't use the ComfortUpdate.