Control Panel Error And Question

Hi --

I have 2 questions about parts of the admin control panel. First, when I click on the "Error/Debug log" link, I receive the following error:

Code:

MYSQL ERROR:
Can't open file: 'error_log.MYD'. (errno: 145)
in query:
SELECT * FROM error_log ORDER BY time DESC LIMIT 0,20

AND

Code:

MYSQL ERROR:
Can't open file: 'error_log.MYD'. (errno: 145)
in query:
INSERT INTO error_log (member_id, time, remote_addr, url, referrer, error) VALUES (NULL, NOW(), '4.43.253.57', '/member/admin/error_log.php?PHPSESSID=88bf33c6577014d09705f97636f67df0', '', 'MYSQL ERROR:
Can't open file: 'error_log.MYD'. (errno: 145)
in query:
SELECT * rn FROM error_log rn ORDER BY time DESC rn LIMIT 0,20')

Any solution?

Also, I need to be clear about amember pro and the way it's handling my subscriptions. I have a recurring product that bills every month. When someone signs up, I notice in their "User Payments/Subscriptions" area, it says "04/17/2003 - 12/31/2012." When their next payment is billed (I use 2checkout), am I supposed to manually go into their subscriptions and add the new month so it's accurate and current OR is amember supposed to add each month? Because, as it stands now, amember isn't adding their new mothly payments.

Thanks for a top quality script!

Josh

the MySQL table "error_log" has been corrupted. Run mysql query:
REPAIR TABLE error_log;

Your second question answered in the FAQ. 2Checkout recurring subscription cannot be handled
automatically, so you have to disable subscription in aMember manually when it terminated.

Hey Alex,

Ok, I'm clear now about the error log. However, I'm not completely understanding the answer to my second question. You said that it is answered in the FAQ section... the FAQ of this forum, cuz I looked there and only a Paypal thread regarding the issue.

So basically, do I need to go into the control panel each month that a new month is billed for a member and add it myself? I realize if I don't that they will still have access since it creates their membership to expire in the year 2012. But in order to keep an accurate account for payments and such, do I need to do it manually?

Thanks.

Josh

About 2checkout: It doesn't send any notifications to the script about events with recurring subscription, nor about recurring payments, nor about payments failure.
So we decide this way:
- as user subscribed, expiration date set to 2099-12-31 (lifetime)
- admin must review 2Checkout reports and disable members, which subscription has been terminated
I know it is painfull, but all questions must be directed to 2Checkout, as they don't implemented necessary integration
abilities.