
=============================================================================
Time:2021-05-27 09:12:41
Type:sql error
Message:
Got error 28 from storage engine
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` ORDER BY RAND() LIMIT 0,4
=============================================================================
Time:2021-05-27 09:12:41
Type:sql error
Message:
Incorrect key file for table '/tmp/#sql_1521_17.MYI'; try to repair it
sql:SELECT a.*,b.`CategoryName` FROM `news` a LEFT JOIN `news_category` b ON a.`CategoryID`=b.`CategoryID` WHERE a.`Visible`='1' AND a.`OnlineTime`<='2021-05-27 09:12:41' ORDER BY a.`OrderNO`,a.`OnlineTime` DESC LIMIT 0,20