Could not get "most read or most read by tag" list MySQL says: Disk full (/tmp/#sql_4ab_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") AeMySQLQueryException in system/core.php:2 1. index.php:5 e2 () 2. system/core.php:2 e2m_tag ( array ( 'tag-alias' => 'shostakovich', 'page' => '1', '*tags' => array ( 0 => array ( 'ID' => '330', 'SubsetID' => '1', 'Keyword' => 'Шостакович', 'OriginalAlias' => 'shostakovich', 'PageTitle' => '', 'Description' => '', 'Summary' => '', 'Uploads' => '', 'IsVisible' => '1', 'IsFavourite' => '0', ), ), '*tag' => array ( 'ID' => '330', 'SubsetID' => '1', 'Keyword' => 'Шостакович', 'OriginalAlias' => 'shostakovich', 'PageTitle' => '', 'Description' => '', 'Summary' => '', 'Uploads' => '', 'IsVisible' => '1', 'IsFavourite' => '0', ), ) ) 3. system/core.php:2 a2 ( '330' ) 4. system/core.php:2 s2 ( '330', array ( ) ) 5. system/core.php:2 getNotesCTree () 6. system/core.php:2 run () 7. system/core.php:2 prepareCacheableData () 8. system/core.php:2 {closure} () 9. system/core.php:2 xn ( 'SELECT n.*, a.`EntityID`, SUM(a.`ReadCount`) `AggregateReadCount` FROM `IlyaBirmanActions` a, `IlyaBirmanNotes` n JOIN `IlyaBirmanNotesKeywords` nk ON nk.`NoteID` = n.`ID` WHERE a.`SubsetID`=1 AND n.`SubsetID`=1 AND nk.`SubsetID` = 1 AND nk.`KeywordID` = 330 AND a.`Stamp` > -9223372035201699929 AND n.`IsPublished` = 1 AND n.`IsFavourite` = 1 AND (n.`IsVisible` = 1 AND n.`Stamp` <= 1653075878) AND a.`EntityID` = n.`ID` GROUP BY a.`EntityID` ORDER BY `IsFavourite` DESC, `AggregateReadCount` DESC LIMIT 10', 'get "most read or most read by tag" list' )
Could not get limited full notes "e2m_tag" list MySQL says: Disk full (/tmp/#sql_4ab_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") AeMySQLQueryException in system/core.php:2 1. index.php:5 e2 () 2. system/core.php:2 e2m_tag ( array ( 'tag-alias' => 'shostakovich', 'page' => '1', '*tags' => array ( 0 => array ( 'ID' => '330', 'SubsetID' => '1', 'Keyword' => 'Шостакович', 'OriginalAlias' => 'shostakovich', 'PageTitle' => '', 'Description' => '', 'Summary' => '', 'Uploads' => '', 'IsVisible' => '1', 'IsFavourite' => '0', ), ), '*tag' => array ( 'ID' => '330', 'SubsetID' => '1', 'Keyword' => 'Шостакович', 'OriginalAlias' => 'shostakovich', 'PageTitle' => '', 'Description' => '', 'Summary' => '', 'Uploads' => '', 'IsVisible' => '1', 'IsFavourite' => '0', ), ) ) 3. system/core.php:2 getTotalNotes () 4. system/core.php:2 run () 5. system/core.php:2 prepareCacheableData () 6. system/core.php:2 xn ( 'SELECT n.*, COUNT(*) FROM `IlyaBirmanNotes` n JOIN `IlyaBirmanNotesKeywords` nk ON nk.`NoteID` = n.`ID` WHERE n.`SubsetID`=1 AND nk.`SubsetID`=1 AND (nk.`KeywordID`=330) AND IsPublished=1 AND (n.`IsVisible` = 1 AND n.`Stamp` <= 1653075878) GROUP BY n.`ID` HAVING COUNT(*)>=1 ORDER BY n.`Stamp` DESC LIMIT 0, 10', 'get limited full notes "e2m_tag" list' )