Welcome, Guest
Username: Password: Remember me

TOPIC: ComfortUpdate broke my installation

ComfortUpdate broke my installation 2 years 8 months ago #75583

  • Rhiannon
  • Rhiannon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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?
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75599

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5426
  • Thank you received: 307
  • Karma: 252
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)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: Rhiannon

Re: ComfortUpdate broke my installation 2 years 8 months ago #75606

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6551
  • Thank you received: 869
  • Karma: 257
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 ?
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75612

  • Rhiannon
  • Rhiannon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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?
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75615

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5426
  • Thank you received: 307
  • Karma: 252
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)limesurvey.org'"
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75618

  • Rhiannon
  • Rhiannon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
Yes, restoring the config.php solved the problem.

I'll update through Fantastico next time!

Thanks for your help!
Last Edit: 2 years 8 months ago by Rhiannon.
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75623

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5426
  • Thank you received: 307
  • Karma: 252
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)limesurvey.org'"
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75626

  • Rhiannon
  • Rhiannon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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?
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75628

  • Rhiannon
  • Rhiannon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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?
The administrator has disabled public write access.

Re: ComfortUpdate broke my installation 2 years 8 months ago #75662

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5426
  • Thank you received: 307
  • Karma: 252
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)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.113 seconds
Donation Image