- Posts: 10
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Database upgrade failed
- veylau
- Topic Author
- Offline
- New Member
Less
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!
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 0
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?
Laurent
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?
Laurent
The topic has been locked.
- Drewskie
- Offline
- Junior Member
Less
More
- Posts: 21
- Thank you received: 1
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
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 8
- Thank you received: 3
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
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
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
7 years 10 months ago #135662
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
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
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 0
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
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
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
7 years 10 months ago #135671
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
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
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
7 years 10 months ago #135707
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
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.