Error while mass-deleting users via prune.

[CMilne]

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:
DELETE FROM access WHERE userid IN(171,184,159,183,155,160,182,148,186,149,198,168 ,175,177,170,164,143,188,193,161,167,181,158,147,1 62,180,146,154,173,152,172,163,166,179,156,144,153 ,176,157,169,178,211,174,151);

MySQL Error : Table 'sgatalkc_sgatalk.access' doesn't exist
Error Number : 1146
Date : Friday, July 29th 2005 @ 04:49:37 AM
Script : http://sgatalk.com/admincp/user.php
Referrer : http://sgatalk.com/admincp/user.php
IP Address : *.*.*.*
Username : SGFreak
Classname : vb_database

Users never get deleted.

[Steve Machol]

You are missing the access table. Is this a fresh install or an upgrade?

[CMilne]

it was an upgrade. First installed version of these forums was 3.0.3, then 3.0.7, 3.5.0 Beta 1, 3.5.0 RC 1. I have been having an issue like this since Beta 1.

[Steve Machol]

Hmmm...then something happened to delete your access table.

Run this query to recreate this table:

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)
);

[CMilne]

Affected Rows: 0

I can now delete users, huzzah! I still dont know how the access table came to be deleted, as I rarely ( if ever ) touch the sql side of things, and even then, thats only to edit time stamps or add things that you cant add normally.