Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Update error

  • testls
  • testls's Avatar Topic Author
  • Offline
  • New Member
  • New Member
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.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • 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?
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago #177584 by holch
Replied by holch on topic Update error

I would like to update my limesurvey server.
Source version is 1.7.2
Target version 2

So you are going to update from a very, very, very, very outdated version to a very, very outdated version?

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
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago #177591 by tpartner
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
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago #177609 by DenisChenu
Replied by DenisChenu on topic Update error

tpartner wrote: Note that you can import the complete survey, data and assets with a .lsa export.

Not for 1.7.2 (or any 1.X) version ;)

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.

Lime-years ahead

Online-surveys for every purse and purpose