Check out the LimeSurvey source code on GitHub!

ComfortUpdate broke my installation

More
4 years 10 months ago #75583 by Rhiannon
Yesterday I ran the 3-click comfort update to upgrade to 1.91. It said it was backing everything up, and gave me a whole list of files it said it was changing. I assumed it knew what it was doing, so I told it to go ahead.

Now when I try to go to the directory it's installed in, I'm given the error message 'Can't connect to LimeSurvey database. Reason: Access denied for user 'root'@'localhost' (using password: NO)'

So it seems to have lost my username and password – presumably it's reset the options files. Along with… hmm… things like custom templates that I'd made. However, the actual surveys are still in their database. Why would it have done this?

I'd like to revert, but I can't find the backups it said it had made. Where would it have put them?

Please Log in to join the conversation.

More
4 years 10 months ago #75599 by Mazi
1. Did you try the "forgot password" feature?
Help to reset the password can be found here: docs.limesurvey.org/General+FAQ&structur...._How_do_I_reset_it_

2. I think all backups are located at /limesurvey/tmp

3. Templates won't be touched during update and should be located at /limesurvey/upload/templates


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The following user(s) said Thank You: Rhiannon

Please Log in to join the conversation.

More
4 years 10 months ago #75606 by DenisChenu

Rhiannon wrote: Now when I try to go to the directory it's installed in, I'm given the error message 'Can't connect to LimeSurvey database. Reason: Access denied for user 'root'@'localhost' (using password: NO)'

So it seems to have lost my username and password – presumably it's reset the options files.

:blink: I made the automatic update too oand don't have this problem :S . Did you have a backup of you config.php ?

Along with… hmm… things like custom templates that I'd made. However, the actual surveys are still in their database. Why would it have done this?

Can you see if you have your template in upload/templates ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
4 years 10 months ago #75612 by Rhiannon
Thanks Mazi. The reset password didn't work (just got the same error) but the templates and backups were where you said they'd be. I've now restored the old config.php and it seems to be working: it's updated my database and everything seems to be there. Thanks!

I'm puzzled why this should have happened though. Could it be something to do with the fact that the initial installation was done through Fantastico?

Please Log in to join the conversation.

More
4 years 10 months ago #75615 by Mazi
To sum this up: Restoring the config.php file worked for you and solved the problem?

In this case it could be related to Fantastico, they might have used a different config file or the like.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
4 years 10 months ago - 4 years 10 months ago #75618 by Rhiannon
Yes, restoring the config.php solved the problem.

I'll update through Fantastico next time!

Thanks for your help!
Last Edit: 4 years 10 months ago by Rhiannon.

Please Log in to join the conversation.

More
4 years 10 months ago #75623 by Mazi
You're welcome!

Keep in mind that Fantastico will offer updates far later while ComfortUpdate always takes the latest version directly from our repository.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
4 years 10 months ago #75626 by Rhiannon
That's a good point. So would it be possible to fix things in my setup so that ComfortUpdate can cope without rewriting config.php? Is there a manual change I can make to the file that would do this?

Please Log in to join the conversation.

More
4 years 10 months ago #75628 by Rhiannon
Ah, I think I see a possibility. The config.php that comes with the install files has the line:

* $Id: config.php 9651 2010-12-16 14:25:20Z c_schmitz $

while my config.php has the line:

* $Id: config-defaults.php 4334 2008-02-25 13:21:10Z c_schmitz $

Would I be right in thinking that ComfortUpdate looks at this line and therefore thought I didn't have a config.php, so gave me the default one? If so, would I be able to swap this line and get it to work?

Please Log in to join the conversation.

More
4 years 10 months ago #75662 by Mazi
This might have caused the update problem.

I think if you once update your system manually ( docs.limesurvey.org/Upgrading+from+a+pre...tions+for+LimeSurvey ), you should be able to use ComfortUpdate later without any problems.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form