ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: mike2 on December 09, 2005, 03:11:51 pm
-
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?
-
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 (http://listmailpro.com/support?t=other) and I'll do what I can.
Regards,
DW
-
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?
-
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
-
Ok I went ahead and submitted my server info for you to check out. Please let me know what you find asap, thanks.
-
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!
-
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
-
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!