Author Topic: lm_users' is marked as crashed and last (automatic?) repair  (Read 1688 times)

bhl007

  • Posts: 75
    • View Profile
lm_users' is marked as crashed and last (automatic?) repair
« on: October 01, 2007, 09:08:07 am »
"Table 'lm_users' is marked as crashed and last (automatic?) repair failed"

Error

SQL query: Documentation

SELECT *
FROM `lm_users`
LIMIT 0 , 30

MySQL said: Documentation
#1195 - Table 'lm_users' is marked as crashed and last (automatic?) repair failed


I not able to view any of my subscribers after login to my listmailpro admin area.

Any idea to repair or solve this?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
lm_users' is marked as crashed and last (automatic?) repair
« Reply #1 on: October 02, 2007, 03:20:59 am »
Try manually running the following queries with a tool like PhpMyAdmin:
Code: [Select]
REPAIR TABLE lm_users
If that fails, try:
Code: [Select]
REPAIR TABLE lm_users USE_FRM
Here's the MySQL documentation on the REPAIR command:
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

These two repair queries will soon be possible from within ListMail.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting