auto responders showing error reposting

[lombadas]

Hi Dr Quek

several of my auto responders showing error when accessing subscriber manager using Pro version error details below



117xmas autoresponder
SQL error:
SELECT count(*) AS count FROM swd_doiaccounts WHERE fk_user=27650
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and
should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com),
giving this error message and the time and date of the error.

all-lists autoresponder
SQL error:
SELECT count(*) AS count FROM swd_doiaccounts WHERE fk_user=27548
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and
should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com),
giving this error message and the time and date of the error.


mbc autoresponder

SQL error:
SELECT count(*) AS count FROM swd_doiaccounts WHERE fk_user=27643
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and
should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com),
giving this error message and the time and date of the error.


mmg autoresponder
SQL error:
SELECT count(*) AS count FROM swd_doiaccounts WHERE fk_user=27605
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and
should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com),
giving this error message and the time and date of the error

opa autoresponder
SQL error:
SELECT count(*) AS count FROM swd_doiaccounts WHERE fk_user=27626
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and
should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com),
giving this error message and the time and date of the error.

tnyga autoresponder
SQL error:
SELECT count(*) AS count FROM swd_doiaccounts WHERE fk_user=27623
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and
should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com),
giving this error message and the time and date of the error



inside the database
Error
SQL query:

SHOW INDEX FROM `swd_doiaccounts` ;

MySQL said:

#145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and should be
repaired


from lib/dbfunc.pm line 142.

sub Error{
my $sql=shift;
# print $q->header if $DBI::err;
die "SQL error: \n $sql \n : ERROR: $DBI::err - $DBI::errstr" if $DBI::err;
}



Warm Regards

Peter

[drquek]

Did the error occurs suddenly ie, were the scripts installed correctly before?

Also, please PM me your purchase receipt.

[lombadas]

Dr Quek I have emailed purchase details to you

these responders have been working ok for 2 or 3 months till around 4/5 January
regarding when the responder stopped working I noticed that I was no longer receiving optins from several giveaway sites that I had submitted a free gift to

when I clicked on subscriber manager on all the responders I got the error messages I also did a test message to one of my free gift optin pages and got the similar error message as follows

SQL error:
INSERT INTO swd_doiaccounts (`fk_account` , `fk_doi` , `fk_user`) VALUES ('23' , '1399' , '27690')
: ERROR: 145 - Table './fumpauto/swd_doiaccounts' is marked as crashed and should be repaired at lib/dbfunc.pm line 142.
For help, please send mail to the webmaster (root@unix15.servage.com), giving this error message and the time and date of the error.


you can see this message if you try to sign up to this site

http://24x7dot.com/fbs1/gadl/jvga/

regards peter

[drquek]

I tried to subscribe myself and got the same error message.

I suggest you:

1. Use PHPMYADMIN to try and repair the database automatically.
2. Contact your tech about your mySQL and database permissions.