Comfort Update 2.5RC4 Build

More
2 years 3 days ago #129175 by brady
brady created the topic: Comfort Update 2.5RC4 Build
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.

Please Log in to join the conversation.

More
2 years 3 days ago #129176 by brady
brady replied the topic: Comfort Update 2.5RC4 Build
I am stuck in a loop at the address
index.php/admin/databaseupdate/sa/db

Please Log in to join the conversation.

More
2 years 2 days ago #129178 by LouisGac
LouisGac replied the topic: Comfort Update 2.5RC4 Build
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.

Please Log in to join the conversation.

More
2 years 2 days ago #129183 by brady
brady replied the topic: Comfort Update 2.5RC4 Build
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.

Please Log in to join the conversation.

More
2 years 2 days ago - 2 years 2 days ago #129193 by artol
artol replied the topic: Comfort Update 2.5RC4 Build
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?
Last Edit: 2 years 2 days ago by artol. Reason: Added info.

Please Log in to join the conversation.

More
1 year 11 months ago #129805 by spycomb
spycomb replied the topic: Comfort Update 2.5RC4 Build
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' .
	UPDATE `YOURDBNAME`.`lime_settings_global` SET `stg_value` = 'Apple_Blossom' WHERE `YOURDBNAME`.`stg_name` = 'admintheme';

Please Log in to join the conversation.

More
1 year 8 months ago #133433 by chalusk8
chalusk8 replied the topic: Comfort Update 2.5RC4 Build
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 This email address is being protected from spambots. You need JavaScript enabled to view it.
siteadminbounce This email address is being protected from spambots. You need JavaScript enabled to view it.
defaultlang en

I thinks the most import is:
DBVersion 257

Greetings

Please Log in to join the conversation.

More
1 year 7 months ago #135163 by veylau
veylau replied the topic: Comfort Update 2.5RC4 Build
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?

Please Log in to join the conversation.

More
9 months 3 weeks ago #148727 by Kevin
Kevin replied the topic: Comfort Update 2.5RC4 Build
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

Please Log in to join the conversation.

More
9 months 3 weeks ago #148736 by jelo
jelo replied the topic: Comfort Update 2.5RC4 Build
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.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
9 months 3 weeks ago #148745 by Kevin
Kevin replied the topic: Comfort Update 2.5RC4 Build
Thanks. I don't use the ComfortUpdate.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!