The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
aaggregate_temp errors ?
Hey everyone!
Ok, I just got back from holiday + my email inbox is full of hundreds of vb errors like this: Code:
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? |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
Quote:
Quote:
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. |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
i have this issue as well, and every so often all users get logged off at the same time.
|
#7
|
||||
|
||||
same problem for me too...!!
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|