Forum Problems Installing LAMS: Re: Re: Trouble restoring ...

Im not sure exactly what has gone on here, but i'll try to work it out.

1) You installed 2.1
2) You updated to 2.1.1
3) You rebuilt your database using the working 2.1.1 database dump you already had.
4) You updated to 2.2

Are these the steps you took?

If so, you you attach the update-logs in the lams directory? There must be some issue with the update from 2.1.1 to 2.2.

Luke

PS: also make sure you copy the repository and secure directories to the previous locations when restoring the backup, as this contains all the content.

Posted by Luke Foxton

Posted by Leffe Eriksson

I was referring to the update logs located under the install directory. So if you installed lams under C:\lams the logs will be at C:\lams\update-logs

Posted by Luke Foxton

Posted by Leffe Eriksson

It looks like your database was not in correct 2.1.1 state when the update from 2.1.1 to 2.2 occurred. In the update logs it is saying that the new tools (introduced with the 2.2 update) already exist - which is strange.

When you say you "Imported the working copy of sql from the production server" what version of lams was the working version?

Also, how did you import it? Did you delete the existing tables before importing the working copy?

Luke

Posted by Luke Foxton

I do know so much that there is one (or more) errors in the 2.1.1-db, but I cant see where :(

I imported the working sql from 2.1.1
Tried it all - delete, manually add table for table (restarted LAMS between the 'updates'), sectionwise importing the tables(ie lams_a*, restart LAMS, lams_b*, restart aso)

My big question is where the error in sql is ?
Because, I dont wanna end up like this once again :)

Posted by Leffe Eriksson