Paid Subscription Problem

[nsusa]

I do have a problem with the scheduled task for my paid subscriptions. The scheduled task does not run anymore (for quite a while actually). I checked about the footer template and that has not been modified and shows the piece for the scheduled tasks.

However, when I run the scheduled task manually I receive an error that the table "access" is missing.

Invalid SQL:

SELECT COUNT(*) AS masks
FROM access
WHERE userid = 11268;

MySQL Error : Table 'vb36x.access' doesn't exist
Error Number : 1146
Date : Wednesday, September 26th 2007 @ 11:08:50 AM
Script : http://www.domain.com/forums/admincp...ncron&cronid=6
Referrer : https://www.domain.com/forums/adminc....php?do=modify
IP Address : xxx.xxx.xxx.xxx
Username : Administrator
Classname : vb_database

Not sure how the table disappeared, but for now I am more concerned how to get things working again. What do I need as information to recreate the table? How can I fix this issue?

Chris

[Steve Machol]

First, are you using a table prefix?

If not, then please provide your vB version.

[nsusa]

No prefix. 3.6.8 is my current version.

Thanks.

Chris

[Steve Machol]

Here's the query to recreate this table in 3.6.8:

CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
);

[nsusa]

Thanks. That did the trick

Chris