Forum LAMS for Tech-Heads - General Forum: Re: Previewing or Viewing Sequence from moodle

Back to LAMS for Tech-Heads - General Forum
	Search:

	2: Re: Previewing or Viewing Sequence from moodle By: Jun-Dir Liew	In response to 1	10/20/09 06:15 PM	[ Reply \| Forward ]
No, updating LAMS wouldn't give you back the missing table. What you need to do is find the missing table or point lams at the correct location (if for some reason you have multiple lams databases lying around?) If you absolutely cannot restore the table, you'll have to redeploy the Share Resources tool, which will lose existing Share Resource data (in lessons, sequences, etc). Beforehand you should be able to export sequences at least, depending on whether other tables are also missing or not. First thing to check would be the MySQL logs - /path/to/mysql/mysql server 5.x/data/{hostname}.err. If the problem is data corruption of some sort, you'll find out here. Second thing (or maybe the first?), check the state of your database backups... Posted by Jun-Dir Liew

	3: Re: Re: Previewing or Viewing Sequence from moodle By: Samuel Persse	In response to 2	10/22/09 02:46 AM	[ Reply \| Forward ]
Hi thanks for your response. checked my backups for the LAMS database, on the 06/07/09 the table exists in the backup, the next day they don't exist... not sure what happened here... could i just restore these tables to the database now, would that fix it? the tables were tl_larsrc11_attachment tl_larsrc11_item_instruction tl_larsrc11_item_log tl_larsrc11_resource tl_larsrc11_resource_item tl_larsrc11_session tl_larsrc11_user Posted by Samuel Persse

	4: Re: Re: Re: Previewing or Viewing Sequence from moodle By: Jun-Dir Liew	In response to 3	10/22/09 05:15 PM	[ Reply \| Forward ]
Those seem like all the Share Resource tables. Yes, restoring those would probably fix your problem. There'd be no issue with replacing newer data, because well, there's no newer data to be worried about! Posted by Jun-Dir Liew

	5: Re: Re: Re: Re: Previewing or Viewing Sequence from moodle By: Samuel Persse	In response to 4	10/23/09 08:51 AM	[ Reply \| Forward ]
thanks restoring the tables to the database makes everything work... can't for the life of me work out why they went in the first place though sam Posted by Samuel Persse

Reply to first post on this page

Back to LAMS for Tech-Heads - General Forum