aaggregate_temp errors ?

[okgaz]

Hey everyone!

Ok, I just got back from holiday + my email inbox is full of hundreds of vb errors like this:

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO aaggregate_temp_1207491000
SELECT attachmentid, COUNT(*) AS views
FROM attachmentviews
GROUP BY attachmentid;

MySQL Error  : Can't open file: 'attachmentviews.MYI'. (errno: 130)
Error Number : 1016
Date         : Sunday, April 6th 2008 @ 04:10:43 PM
Script       : http://sitename.com/cron.php?rand=592288
Referrer     : http://sitename.com/forumname/4631-threadname.html
IP Address   : 195.91.46.41
Username     : Unregistered
Classname    : vB_Database

I checked phpmyadmin + my forum database contains hundreds of empty tables with names such as:

(0 Rows) aaggregate_temp_1207174200
(0 Rows) aaggregate_temp_1207177800
(0 Rows) aaggregate_temp_1207192200
(0 Rows) aaggregate_temp_1207195800


each containing the empty rows:

attachmentid int(10)
views int(10)

Anybody know what's up + how to make the madness stop?

[Marco van Herwaarden]

MySQL error code 130: Incorrect file format

Try to repair your database.

PS A lot of these aaggregate_ tables might indicate that the MySQL user does not have full permissions to the database (delete permission)

[okgaz]

Originally Posted by Marco van Herwaarden

MySQL error code 130: Incorrect file format

Try to repair your database.

I tried repairing and optimising the tables via vbulletin a couple of hours ago + the errors are still coming I'm afraid :S

Originally Posted by Marco van Herwaarden

PS A lot of these aaggregate_ tables might indicate that the MySQL user does not have full permissions to the database (delete permission)

Sounds reasonable, any ideas what I should look at? I know how to use phpmyadmin but am a noob when it comes to permissions etc. It's worth noting though that I'm using the same mysql db/table/user as I have done for the last year + these errors have only just started recently.

Note: Not sure if it could be related but I recently switched from php4 to php5, the errors didn't start until a couple of weeks later though.

[Marco van Herwaarden]

Maybe your host also upgraded MySQL. Later versions have more permissions that might have been turned off by default. I suggest you start by asking your host to assis with this.

Does the server have any type of control panel like cPanel?

[suraja]

Hi,

I have same trouble on my Vbull.
What should I ask to my host about this, I'm not expert on this.

Please help

[manuelg1201]

i have this issue as well, and every so often all users get logged off at the same time.

[Naan-Kadavul]

same problem for me too...!!