Author Topic: All User Lists are gone! (Read 2161 times)

Victoria · « **on:** January 21, 2006, 01:18:06 pm »

Today I discovered that all my User Databases are gone,
and when I try to add a user manually, I get this error message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/pem/vhosts/17325/webspace/httpdocs/mail/edituser.php on line 182

What do I do now?

Victoria

DW · « **Reply #1 on:** January 22, 2006, 11:16:55 am »

Victoria,

What you should do is manually access your database with PhpMyAdmin (usually available in your hosting control panel databases section - it could be called something like "MySQL manager" or similar). Once in PhpMyAdmin run the following command / SQL query on your ListMailPRO database:

REPAIR TABLE lm_users;

I will consider implementing checking and the ability to automatically try a repair on the ListMail login page so that this is easier in the future.

Regards

Victoria · « **Reply #2 on:** January 22, 2006, 12:00:37 pm »

Dean,
Is this repair something I should ask my host support to do?

I'll try the fix you've given me, but I'm not tech saavy on these things.

Did I do something to cause this problem? I'd like to know so that I don't do it again.

DW · « **Reply #3 on:** January 22, 2006, 12:16:06 pm »

If it is a damaged MySQL table it should be very rare for this to happen. It's possible someone tripped over the power cord or something at your web host during an email send or a write operation to the user database.

I located your server info in a previous support ticket, opened up PhpMyAdmin, verified the table had 'crashed', ran 'repair table lm_users', and now it seems fine!

If this happens again let me know and I'll help out. If it happens regularly you might talk to your host about server stability and/or ask me to put in an auto repair feature in LMP.

Regards, DW

BGSWebDesign · « **Reply #4 on:** January 22, 2006, 07:36:44 pm »

Hi DW,

Quote

or ask me to put in an auto repair feature in LMP

I think you've answered it, IF someone has to ask you this once, you can bet you will be asked it AGAIN - so please, put a Repair Table button somewhere - on the Config Screen?

Victoria · « **Reply #5 on:** January 23, 2006, 06:44:13 am »

Thanks Dean for doing the fix. It's working perfectly again.
I tried following your fix instructions, but when I got into the PhpMyAdmain
area, couldn't figure out how to run the fix command.

Hope it never happens again, but if it does....

Victoria

DW · « **Reply #6 on:** January 23, 2006, 07:56:58 am »

Brett/Victoria,

I plan to put in an auto check/fix, possibly in dailymail or on the login page, ASAP. This seems to be a very rare occurance (I get about 1 request every few months on this), but if you need it sooner, let me know.

You can run the command manually in PhpMyAdmin (once logged in) by clicking your ListMail database on the left hand side of the screen. Then, click the "SQL" button at the top of the page. Here you can enter your custom commands, such as the following which repairs the user table:

REPAIR TABLE lm_users;

Regards