Database Error (Number 130)

[s3nt3nc3d]

I haven't made any changes to my forum software, database, or anything else lately...in fact, I've been dang near computerless for the past couple weeks and over the past few days I've been getting flooded with database error emails stating the following:

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO vB_aaggregate_temp_1219623000
SELECT attachmentid, COUNT(*) AS views
FROM vB_attachmentviews
GROUP BY attachmentid;

MySQL Error : Incorrect file format 'vB_attachmentviews'
Error Number : 130
Date : Sunday, August 24th 2008 @ 06:17:22 PM
Script : http://www.herpfamily.com/cron.php?&rand=254844
Referrer : http://www.herpfamily.com/index.php
IP Address : 69.xx.xxx.70
Username : Unregistered
Classname : vB_Database

I'm clueless what the cause is...the script is always cron.php and the referrer varies...anybody know what's going on and how I would fix this? I haven't received any complaints on my forums so it must not be anything huge, but the number of database error emails coming in is beginning to annoy me. I'm not super advanced with database stuff but I'm not a complete idiot either.

Thanks for any help!

[Steve Machol]

Run these queries to recreate these tables (assuming you have no table prefix):

1:
DROP TABLE IF EXISTS attachmentviews;

2:
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);

Note: I strongly recommend that you upgrade to 3.6.0 PL4 immediately.

[s3nt3nc3d]

Thanks, I tried that so we'll see how it goes...I plan on upgrading soon...just wanna have my computer back 100% so if anything goes wrong, I can fix it in a timely manner.

[s3nt3nc3d]

Run these queries to recreate these tables (assuming you have no table prefix):

1:
DROP TABLE IF EXISTS attachmentviews;

2:
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);

Note: I strongly recommend that you upgrade to 3.6.0 PL4 immediately.

I ran the above queries on my database, but I'm still receiving massive amounts of database errors...any other ideas?

[Steve Machol]

You need to add the tale prefix:

1:
DROP TABLE IF EXISTS vb_attachmentviews;

2:
CREATE TABLE vb_attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);

[s3nt3nc3d]

Thanks...I totally forgot about the table prefix...d'oh!