Error after upgrading to 1.85

[mike2]

Error after upgrading to 1.85:

I've been seeing this error in a couple places:

admin-60-Incorrect information in file: './maoptin/lm_chtmld.frm'

The most seriously when I got an email from someone who tried to confirm their subscription via email, he emailed me this and indeed when I tried to click his confirm link I got the same message.  Note he did actually get subscribed to the list.  Here's what he emailed to me:

Hi

Your script is toast. Slap the programmer (well at
Least don't give them any more pizza today

admin-60-Incorrect information in file: './maoptin/lm_chtmld.frm'


Michael Relfe

Please Help, this is somewhat urgent.  I have also PM'd and emailed you this.

This also sort of relates to this thread:  
http://listmailpro.com/forum/index.php?topic=721.0

UPDATE:  I just checked and it's worse then I thought, when clicking a remove link, I get the same thing.  I'm guessing something didn't get updated correctly for me?

[DW]

It sounds like a problem with the lm_chtmld table.  This table has not changed between v1.84 and v1.85.

If you know how (using PhpMyAdmin) you might run the following commands to try to fix any errors:

REPAIR TABLE lm_chtmld

If you don't know how to do this, or it doesn't help, please submit your information to me here and I'll do what I can.

Regards,
DW

[mike2]

As far as I know everything was working fine before the update.

I don't use phpmyadmin, but I know how via the command line.  Tried to repair the table, no luck, here's what i get:

[root@ns1 tmp]# mysqlcheck -re maoptin lm_chtmld -p
Enter password:
maoptin.lm_chtmld
error    : Incorrect information in file: './maoptin/lm_chtmld.frm'

And:

[root@ns1 tmp]# mysqlcheck -r maoptin -p
Enter password:
maoptin.lm_chtml                                   OK
maoptin.lm_chtmld
error    : Incorrect information in file: './maoptin/lm_chtmld.frm'
maoptin.lm_codes                                   OK
maoptin.lm_config                                  OK
maoptin.lm_error                                   OK
maoptin.lm_errord                                  OK
maoptin.lm_follow                                  OK
maoptin.lm_hits                                    OK
maoptin.lm_links                                   OK
maoptin.lm_lists                                   OK
maoptin.lm_saved                                   OK
maoptin.lm_schedule                                OK
maoptin.lm_select                                  OK
maoptin.lm_selectd                                 OK
maoptin.lm_sendp                                   OK
maoptin.lm_sendq                                   OK
maoptin.lm_sent                                    OK
maoptin.lm_users                                   OK

And this is what I get when doing it in "mysql", even when I switch to the DB I get an error:

mysql> use maoptin;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'lm_chtmld'
Database changed
mysql> REPAIR TABLE lm_chtmld;
+-------------------+--------+----------+----------------------------------------------------------+
| Table             | Op     | Msg_type | Msg_text                                                 |
+-------------------+--------+----------+----------------------------------------------------------+
| maoptin.lm_chtmld | repair | error    | Incorrect information in file: './maoptin/lm_chtmld.frm' |
+-------------------+--------+----------+----------------------------------------------------------+
1 row in set (0.00 sec)

Any other suggestions before I setup a temporary access for you to get in and look?

[mike2]

I thought I'd try an myisamchk, here's what I get (some errors):

[root@ns1 maoptin]# myisamchk -r *
myisamchk: error: 'lm_chtmld.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_chtmld.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_chtmld.MYI'
Data records: 24
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_chtml.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_chtml.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_chtml.MYI'
Data records: 4
- Fixing index 1
         
---------

myisamchk: error: 'lm_codes.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_codes.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_codes.MYI'
Data records: 15
- Fixing index 1
- Fixing index 2
- Fixing index 3
         
---------

myisamchk: error: 'lm_config.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_config.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with keycache) MyISAM-table 'lm_config.MYI'
Data records: 1
         
---------

myisamchk: error: 'lm_errord.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_errord.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_errord.MYI'
Data records: 28
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_error.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_error.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_error.MYI'
Data records: 4
- Fixing index 1
         
---------

myisamchk: error: 'lm_follow.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_follow.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_follow.MYI'
Data records: 11
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_hits.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_hits.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_hits.MYI'
Data records: 62
- Fixing index 1
         
---------

myisamchk: error: 'lm_links.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_links.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_links.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
- Fixing index 3
         
---------

myisamchk: error: 'lm_lists.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_lists.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_lists.MYI'
Data records: 4
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_saved.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_saved.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_saved.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_schedule.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: -1 when opening MyISAM-table 'lm_schedule.MYD'

---------

- recovering (with sort) MyISAM-table 'lm_schedule.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_selectd.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: -1 when opening MyISAM-table 'lm_selectd.MYD'

---------

- recovering (with sort) MyISAM-table 'lm_selectd.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_select.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_select.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_select.MYI'
Data records: 1
- Fixing index 1
         
---------

myisamchk: error: 'lm_sendp.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_sendp.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_sendp.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_sendq.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_sendq.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_sendq.MYI'
Data records: 173645
- Fixing index 1
         
---------

myisamchk: error: 'lm_sent.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_sent.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_sent.MYI'
Data records: 51
- Fixing index 1
         
---------

myisamchk: error: 'lm_users.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_users.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_users.MYI'
Data records: 364043
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
[root@ns1 maoptin]#
[root@ns1 maoptin]#
[root@ns1 maoptin]# mysql -p

[mike2]

Ok I went ahead and submitted my server info for you to check out.  Please let me know what you find asap, thanks.

[mike2]

Dean,

Any luck finding out anything on my server?

This is kind of critical, I mail everyday and people are going to start getting mad if they can't unsubscribe.   Please let me know something asap!

[DW]

This is definitely not normal operation of MySQL.  Your data appears to have become corrupted.  Please check the support ticket for my latest response.  We should be able to get this sorted today.

Regards

[mike2]

Dean, this is exactly what happened.  There was a hard drive issue.

Fixed it, and reuploaded a backup.  Please checkout the support ticket for my next request, thanks a ton!