Welcome to the LimeSurvey Community Forum

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

Database upgrade failed

  • veylau
  • veylau's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 10 months ago - 7 years 10 months ago #135268 by veylau
Database upgrade failed was created by veylau
Hi!
I'm having a big problem on my LimeSurvey. It keeps asking for an upgrade, but it also keeps failing.

I don't know if this part is important, but this is when it happened:

I needed to delete some questions from a specific questiongroup and I cmd+clicked a few times on that questiongroup so it opened up a few times in a new tab. Ater that I started clicking on questions in a questiongroup to delete it, next tab to delete again, but than this sudenly came up:

The warning I get everytime I go to mydomain.com/limesurvey/admin



Translation: "Database upgrade - Check the following information before you continue"

I could not do anything else then click the "continue-button", so I did that. After waiting a moment this appears:


Translation: Update failed. Errors:
CDbCommand failed during executing following SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'SessionName' for key 'PRIMARY'

Please fix this error in your database and try again.


I already searched a lot, tried things like remove entry "SessionName" from a table, but nothing helps.
Can somebody please give me a solution? I'd be very greatfull!


Thank you very much!
Last edit: 7 years 10 months ago by veylau.
The topic has been locked.
  • veylau
  • veylau's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 10 months ago #135654 by veylau
Replied by veylau on topic Database upgrade failed
Hi,
Is there nobody who can help me?
Please, I really don't know how to fix this. Do I really need to remake all of my surveys? :o

Laurent
The topic has been locked.
More
7 years 10 months ago #135656 by Drewskie
Replied by Drewskie on topic Database upgrade failed
Could try turning full debugging on to see if it provides more info on the error (in config file)
The topic has been locked.
  • JanE01
  • JanE01's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 10 months ago #135661 by JanE01
Replied by JanE01 on topic Database upgrade failed
Hi Laurent,

If you can give us access to your database in one way (phpMyAdmin?) or another (a database dump), we can take a look. Please contact Tammo or me if you want us to do that.

Jan
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 10 months ago #135662 by tammo
Replied by tammo on topic Database upgrade failed
Hi Laurent (in English or in Dutch :laugh: ),

if you want help, we may be able to help you, but we are not sure. If you can give access to the database (if that is feasible, of course), we can take a look, like JanE said. He is my business partner.

Tammo


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • veylau
  • veylau's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 10 months ago #135665 by veylau
Replied by veylau on topic Database upgrade failed
Hi Tammo and JanE

I've sent the login details to Tammo.
Thank you very much that you are willing to look at it!

Laurent
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 10 months ago #135671 by tammo
Replied by tammo on topic Database upgrade failed
As far as we could see, this was an update from 1.92 to 2.50 and this crashed...


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 10 months ago #135707 by tammo
Replied by tammo on topic Database upgrade failed
Laurent, we have found a solution. Contact me; see your private messages on this forum.


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose