Author Topic: Send email - table crash  (Read 5675 times)

betty_b

  • Newbie
  • *
  • Posts: 6
    • View Profile
    • Email
Send email - table crash
« on: 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?

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: Send email - table crash
« Reply #1 on: April 29, 2010, 02:50:13 pm »
You need to execute the following SQL in your database:

Code: [Select]
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

betty_b

  • Newbie
  • *
  • Posts: 6
    • View Profile
    • Email
Re: Send email - table crash
« Reply #2 on: 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?

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: Send email - table crash
« Reply #3 on: 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.

Arthur Mullard

  • Jr. Member
  • **
  • Posts: 73
    • View Profile
Re: Send email - table crash
« Reply #4 on: 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?

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Send email - table crash
« Reply #5 on: 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
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!

Arthur Mullard

  • Jr. Member
  • **
  • Posts: 73
    • View Profile
Re: Send email - table crash
« Reply #6 on: 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.

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Send email - table crash
« Reply #7 on: 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
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!