Forum Problems Installing LAMS: Re: Re: http status 404 - Lams


 
Search: 

3: Re: Re: http status 404 - Lams
In response to 2 04/05/09 08:13 PM
[ Reply | Forward ]
Luke,
it is a windows install into the D:\lams. I have zipped up the logs and hopefully they will attach.

thanks
Colin

Posted by colin stead

Attachments:
4: Re: Re: Re: http status 404 - Lams
In response to 3 04/05/09 10:15 PM
[ Reply | Forward ]
Hi Colin,

When you did the update, did you elect to use the stored lams.properties file in /etc/lams2 for the update, or did you edit the lams.properties in the update package yourself?

In the update logs I found database errors, it could not find the tables in the "lams2" database to update them. Is "lams2" the correct name for your lams database?

Luke

Posted by Luke Foxton

5: Re: Re: Re: Re: http status 404 - Lams
In response to 4 04/05/09 10:47 PM
[ Reply | Forward ]
Luke,
I just did the default update. I was not asked about the database file, just the database name and port. Just as I did previously I left the MYSql Host as localhost on port 3306.

I did just no do an update from the restored 2.04 to 2.1 and the installed displayed some of the following error messages.

Error while updating intergation classes
Error: Exception in thread "main" java.sql.SQLException: Table"lams2.lams_organisation' does not exist

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

etc

Colin

Posted by colin stead

6: Re: Re: Re: Re: Re: http status 404 - Lams
In response to 5 04/05/09 10:53 PM
[ Reply | Forward ]
Colin,
I think it is a problem with your database, it appears that some if not all of your database tables are missing or perhaps the database name the updater is using is incorrect.

If you go into the mysql console and do:

use lams2;
show tables;

What appears? are there any tables?

Luke

Posted by Luke Foxton

7: Re: Re: Re: Re: Re: Re: http status 404 - Lams
In response to 6 04/06/09 06:18 PM
[ Reply | Forward ]
I am using moodle 1.93 and I am unsure about getting to the mysql console. If you have any ideas that would be great, if not I will find out it just may take a little time. Sorry for my lack of ability.

Colin

Posted by colin stead

8: Re: Re: Re: Re: Re: Re: http status 404 - Lams
In response to 6 04/22/09 07:27 AM
[ Reply | Forward ]
Luke,
sorry for the delay.

when I type in

mysql> use lams2; the system replies with
Database Changed

mysql> show tables; I get a massive list of tables
+---------------------------------+
| Tables_in_lams2 |
+---------------------------------+
|lams_activity_category |

this continues on down the page

Posted by colin stead

9: Re: Re: Re: Re: Re: Re: Re: http status 404 - Lams
In response to 8 04/22/09 05:50 PM
[ Reply | Forward ]
Colin, from second look at your update logs, it looks like a 2.0.4-2.1 update log... also it seems that the database update has failed. Im not sure how that has happened, but it seems your installation is severely out of wack.

I would suggest getting the backup and following the restore instructions.

First try:
http://wiki.lamsfoundation.org/display/lamsdocs/Revert+To+Windows+Backup

and if that doesnt work, you may need to try:
http://wiki.lamsfoundation.org/display/lamsdocs/Revert+To+Other+Backup

Luke

Posted by Luke Foxton

10: Re: Re: Re: Re: Re: Re: Re: Re: http status 404 - Lams
In response to 9 04/23/09 06:40 PM
[ Reply | Forward ]
I have tried doing a restore from the backups, backup to 2.04, but I am still getting the same error message.

Posted by colin stead

Reply to first post on this page
Back to Problems Installing LAMS