Forum Problems Installing LAMS: Trouble restoring ...

Back to Problems Installing LAMS
You may request notification for Trouble restoring ....	Search:

	1: Trouble restoring ... By: Leffe Eriksson		05/18/09 01:37 PM	[ Reply \| Forward ]
1: Installed 2.1, 2.1.1 and 2.2 2: 2.2 Didnt work on win2k3, so I rolled back to 2.1.1 3: LAMS started to act funny, ie, when bringing up 3 noticeboards and typing some in the first, it showed up in the next noticeboard as well - weird as hell! 4: Decided to shutdown LAMS, took a backup using lams-backup.exe 5: Re-installed 2.1 and 2.1.1 and then restored via lams-restore. 6 poff Nothing happens, just a 404 ??? What in the world havr gone wrong ? Do I have to mention that this is a production server in use sigh // Leffe Posted by Leffe Eriksson

	2: Re: Trouble restoring ... By: Leffe Eriksson	In response to 1	05/18/09 01:38 PM	[ Reply \| Forward ]
1½: We managed to create 59 instances before the problem starts ... Posted by Leffe Eriksson

	3: Re: Re: Trouble restoring ... By: Leffe Eriksson	In response to 2	05/19/09 12:48 AM	[ Reply \| Forward ]
I have come to this conclusion that in the attached file, there is something wrong... Posted by Leffe Eriksson
Attachments: C:\Documents and Settings\Administrator.EDUCTUS\Desktop\here_is_the_error_somewhere.sql

	4: Re: Trouble restoring ... By: Leffe Eriksson	In response to 1	05/19/09 11:22 AM	[ Reply \| Forward ]
Ok testing 1: Clean install of 2.1 2: Upgrade it to 2.1.1 3: Manually add repository & dump-dirs to the new install 4: Manually inserting all tables (excluded lams_qtz_xxx) 5: Fired the LAMS-server up again and it works :=) OK further on 6: Upgrading it to 2.2 7: Failed Switched back to 2.1.1 via restore utility and its working again.... Im gonna try once more to 2.2, dump the .sql and copy some logs and paste here later... Posted by Leffe Eriksson

	5: Re: Re: Trouble restoring ... By: Leffe Eriksson	In response to 4	05/19/09 12:28 PM	[ Reply \| Forward ]
No errors is showing up ...... Is it possible to install 2.2 and manually add the working .sql that I have ?? Posted by Leffe Eriksson

	6: Re: Re: Trouble restoring ... By: Leffe Eriksson	In response to 4	05/19/09 02:49 PM	[ Reply \| Forward ]
Installed LAMS locally on my machine... >> 2.1 >> 2.1.1 >> Imported the working copy of sql from the production server >> Fired the server up, just to see if it worked (Answer: YES) >> Stopped and installed 2.2 >> The server is just acting weird, nothing shows up Attached are the logs Posted by Leffe Eriksson
Attachments: log.tgz

	7: Re: Re: Re: Trouble restoring ... By: Luke Foxton	In response to 6	05/19/09 06:33 PM	[ Reply \| Forward ]
Hi Leffe, 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

	8: Re: Re: Re: Re: Trouble restoring ... By: Leffe Eriksson	In response to 7	05/20/09 12:39 AM	[ Reply \| Forward ]
The logs is attached in my last msg.. Posted by Leffe Eriksson

	9: Re: Re: Re: Re: Re: Trouble restoring ... By: Luke Foxton	In response to 8	05/20/09 12:43 AM	[ Reply \| Forward ]
Leffe, 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

	10: Re: Re: Re: Re: Trouble restoring ... By: Leffe Eriksson	In response to 7	05/20/09 01:11 AM	[ Reply \| Forward ]
update-logs attached Posted by Leffe Eriksson
Attachments: update-logs.tgz

	11: Re: Re: Re: Re: Re: Trouble restoring ... By: Luke Foxton	In response to 10	05/20/09 05:42 PM	[ Reply \| Forward ]
Leffe, 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

	12: Re: Re: Re: Re: Re: Re: Trouble restoring ... By: Leffe Eriksson	In response to 11	05/21/09 01:19 AM	[ Reply \| Forward ]
Luke, thanks for your answers! 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

Reply to first post on this page

Back to Problems Installing LAMS