- Posts: 7
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Update error
- testls
- Topic Author
- Offline
- New Member
Less
More
5 years 3 months ago #177578
by testls
Update error was created by testls
Hello,
I would like to update my limesurvey server.
Source version is 1.7.2
Target version 2
I have an error when I launch database upgrade.
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 'autoload_url'
I cannot find this column and I don't know in which table.
How can I find this duplicate?
Thanks.
I would like to update my limesurvey server.
Source version is 1.7.2
Target version 2
I have an error when I launch database upgrade.
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 'autoload_url'
I cannot find this column and I don't know in which table.
How can I find this duplicate?
Thanks.
The topic has been locked.
- LouisGac
- Visitor
5 years 3 months ago #177580
by LouisGac
Replied by LouisGac on topic Update error
I'd rather suggest you export/import your survey on a fresh installation.
Do you have many of them?
Do you have many of them?
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11756
- Thank you received: 2753
5 years 3 months ago #177584
by holch
Both versions are not supported anymore. And there are various branches in version 2.
Anyway, I would highly suggest to update to version 3, which is currently the only version that is supported and received updates.
As Louis suggests, I would also go for a clean install. Your current version is so old, that it is probably not clear what can happen during update and I also think there is no one willing to look into fixing things for these old versions. Just doesn't make sense.
Go for 3.x and don't look back.
Of course, if you have many surveys and many users this might be some work, but I don't think it makes any sense to go to V 2 (which ever of the 2 branches).
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Update error
So you are going to update from a very, very, very, very outdated version to a very, very outdated version?I would like to update my limesurvey server.
Source version is 1.7.2
Target version 2
Both versions are not supported anymore. And there are various branches in version 2.
Anyway, I would highly suggest to update to version 3, which is currently the only version that is supported and received updates.
As Louis suggests, I would also go for a clean install. Your current version is so old, that it is probably not clear what can happen during update and I also think there is no one willing to look into fixing things for these old versions. Just doesn't make sense.
Go for 3.x and don't look back.
Of course, if you have many surveys and many users this might be some work, but I don't think it makes any sense to go to V 2 (which ever of the 2 branches).
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: LouisGac
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10630
- Thank you received: 3696
5 years 3 months ago #177591
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Update error
Note that you can import the complete survey, data and assets with a .lsa export.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 3 months ago #177609
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Update error
Not for 1.7.2 (or any 1.X) versiontpartner wrote: Note that you can import the complete survey, data and assets with a .lsa export.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.