Feng Forum

Support => How To's => : betty_b April 29, 2010, 06:17:41 AM

: Send email - table crash
: betty_b April 29, 2010, 06:17:41 AM

When I go to send an email now, I get an error:

Error:
Query failed with message 'Table './user5635_tsigoo/og_searchable_objects' is marked as crashed and should be repaired'

What does this mean?   How do I fix it?

: Re: Send email - table crash
: ignacio April 29, 2010, 02:50:13 PM

You need to execute the following SQL in your database:

:

REPAIR TABLE `og_searchable_objects`;

Look at the MySQL manual for more details: http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

: Re: Send email - table crash
: betty_b May 03, 2010, 01:42:54 PM

That fixed the problem.   

It's a little concerning though.

1.  What caused this issue?
2.  Is there some preventative maintenance that should be done?
3.  Is my data in danger of being corrupt and/or lost?

: Re: Send email - table crash
: ignacio May 04, 2010, 07:06:44 AM

It could have been caused by MySQL being incorrectly shut down, maybe by not shutting down the server correctly. The MySQL manual should explain the possible causes.

: Re: Send email - table crash
: Arthur Mullard August 16, 2011, 10:39:12 AM

I have the same problem suddenly. The repair only results in:

Table 'og_searchable_objects' is marked as crashed and should be repaired

What does this table do? As backup is quite out of date, is it OK to just restore this table fromt he back up, or must I restore the whole database?

: Re: Send email - table crash
: franponce87 August 19, 2011, 12:48:16 PM

I am not quite sure about this problem in particular, as it seems to be one from an old version that has already been fixed long ago.. but this table contains the objects that can be searched. Meaning that if you want to find something with the Feng Office Search, it must be there.

Best regards,
Francisco

: Re: Send email - table crash
: Arthur Mullard August 19, 2011, 01:32:43 PM

Thanks fcor your reply Francisco. We're running 1.7.3.1

Well I deleted the searchable_objects table and imported the table from the backup. Now things work again although, of course, any search will not now find anything betwwen the date of the backup and today.

I'm presuming the searchable objects records are created at the time an object is created? Its not possible to force Feng to regenerate the searchable objects?

Strangley, we also have a bunch of emails with message content now "null" although all new emails come through correctly.

: Re: Send email - table crash
: franponce87 August 22, 2011, 10:10:55 AM

I am afraid that searchable objects records get created whenever you create another object in FO, so you may not force an automatic creation, unless of course you start tweaking the code.

Best regards,
Francisco