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

By: Luke Foxton

[ 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

By: colin stead

[ 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

By: Luke Foxton

[ 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

By: colin stead

[ 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

By: colin stead

[ 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

By: Luke Foxton

[ 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

By: colin stead

[ 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