Bug Database error

[OlijO]

Hi,
since some weeks we experiment some problem with this mod.
We have this error when visiting the url :
Les Forums Soudeurs.com

Database error in vBulletin 4.2.1:

Invalid SQL:

    SELECT
        pointslog.*,
        user.*
        , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb            
        
    FROM dbtech_vbactivity_pointslog AS pointslog
    LEFT JOIN user AS user ON (user.userid = pointslog.userid)
    
    LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
    LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
    
    WHERE 
        user.dbtech_vbactivity_excluded_tmp = '0'
    ORDER BY dateline DESC            
    LIMIT 0, 20;

MySQL Error   : Incorrect key file for table '/var/lib/mysql/#sql_530_0.MYI'; try to repair it
Error Number  : 126
Request Date  : Wednesday, November 13th 2013 @ 07:12:06 PM
Error Date    : Wednesday, November 13th 2013 @ 07:13:01 PM
Script        : http://www.soudeurs.com/vbactivity.php?do=activity
Referrer      : 
IP Address    : 80.201.119.145
Username      : Olivier
Classname     : vB_Database
MySQL Version : 5.5.32-cll

To have it working again we lauch "OPTIMIZE TABLE" and it works again.
The table is 600mb.
What can i do to solve definitively this problem, we are on or own server.
Regards,
Olivier

 

[Fillip H.]

That's not an issue with this mod, it's an issue with the MySQL server. it's completely random that it's happening to this mod's tables (or it could be related to the size of the table), as it could happen to any table.

Does it always start happening at a specific time?

 

[OlijO]

Nothing really specific.
But if you look this screenshot : there are 234144 pages to show.
I think the request is to heavy, it take each time we try to access to this page 1 min 30 sec to be showed, it's not normal.

It's not possible to only show the requested first page ?
Regards,
Olivier

 

[Fillip H.]

You should disable that page via vBulletin Options.