Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Error 500 while upgrading DB from v1.95 to v2.05

Error 500 while upgrading DB from v1.95 to v2.05 5 months 4 days ago #108941

  • Anurag
  • Anurag's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 29
  • Karma: 0
Environment: Windows Server 2008 (IIS), SQL Server 2012, PHP 5.3, php_pdo_sqlsrv driver

What I'm trying to do: Upgrade a DB used with Limesurvey v1.95 to v2.05.

Very similar to the issue posted earlier:
www.limesurvey.org/en/forum/installation...rade-from-192-to-200

I am getting Error 500 after 45-60 seconds of waiting for the upgrade to complete (on clicking "Click here to continue link; /index.php?r=admin/update/sa/db/continue/yes). I have "debug" set to 1 inside config.php. Earlier, the 500 error was because of memory getting exhausted (as per LS's debug message and PHP error log). I increased the memory limit to 2GB, but still the error persists. Sadly, now no error is getting logged in PHP error log.

I am absolutely clueless where to go from here. :dry:

P.S.: I started with a fresh installation of v2.05, and wizard-based installation of Limesurvey succeeded (including populating of DB). I just changed the DB connectionstring to point to an older DB version.
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.95 to v2.05 5 months 4 days ago #108944

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 807
  • Thank you received: 115
  • Karma: 93
There is no version 1.95
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.95 to v2.05 5 months 4 days ago #108949

  • holch
  • holch's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 2851
  • Thank you received: 359
  • Karma: 124
So what you are saying is that you actually did not "upgrade", but make a completely new install and than changed the to another (older) database by hand???
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 3 days ago #108975

  • Anurag
  • Anurag's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 29
  • Karma: 0
My bad. It's 1.92+.

P.S.: I can't find an option to change the topic of this thread. Perhaps a moderator than change it from 1.95 to 1.92+? Thanks.
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 3 days ago #108976

  • Anurag
  • Anurag's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 29
  • Karma: 0
holch wrote:
So what you are saying is that you actually did not "upgrade", but make a completely new install and than changed the to another (older) database by hand???

Yes, holch. The whole point of this exercise is to test upgrade the DB in staging environment before implementing the same on production. I don't see a difference between just upgrading the DB and upgrading both web files & DB. Unless, of course, I'm mistaken?

Thanks
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 3 days ago #108977

  • holch
  • holch's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 2851
  • Thank you received: 359
  • Karma: 124
I assume that during the upgrade process the database will be adapted as well (new tables, new columns, etc.).

If you first install a completely new installation including the set up of a new database, this process is not done for the old database.

I am not an expert on this, but for me it is quite logic that there might be problems involved, as you basically will skip a step.

You are also going directly from 1.92 to 2.05, with a few versions in between. I am not surprised that this won't work perfectly.

If I understood your process correctly, this is no upgrade at all.

If you want to test in a test enviroment how the upgrade would work, you would have to clone your old database and then do an upgrade on top of the old cloned installation.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 3 days ago #108979

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 807
  • Thank you received: 115
  • Karma: 93
Just changing the DB should be fine.

Sounds to me like it could be a simple script timeout.
Did you also try to raise max_execution_time in PHP?
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 2 days ago #109067

  • Anurag
  • Anurag's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 29
  • Karma: 0
c_schmitz wrote:
Just changing the DB should be fine.

Sounds to me like it could be a simple script timeout.
Did you also try to raise max_execution_time in PHP?

Indeed. Although it was not because of a small max_execution_time, but because of a small activity timeout in FastCGI settings in IIS. Error 500 went away on increasing that parameter.

But now I'm faced with another error (comes after approx. 3 minutes of initiating the upgrade):
pastebin.com/cXm0PG2k

Is the only solution to try and upgrade incrementally, as suggested by holch? If so, what version should I start with first?

Thanks
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 1 day ago #109082

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 807
  • Thank you received: 115
  • Karma: 93
This is usually caused by an incomplete earlier update try . You will need to restore the database from a clean version (you did a backup before you started this whole ordeal, didn't you?)
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Error 500 while upgrading DB from v1.92 to v2.05 5 months 1 day ago #109084

  • Anurag
  • Anurag's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 29
  • Karma: 0
Aha! That seems quite possible. Yep, I have the original DB intact :)

I'll try and get back.
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.124 seconds
Donation Image