MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Got error 28 from storage enginearray ( 0 => array ( 'file' => '/home/designc/public_html/manager/includes/extenders/dbapi.mysql.class.inc.php', 'line' => 140, 'function' => 'messageQuit', 'class' => 'DocumentParser', 'type' => '->', ), 1 => array ( 'file' => '/home/designc/public_html/manager/includes/extenders/dbapi.mysql.class.inc.php', 'line' => 334, 'function' => 'query', 'class' => 'DBAPI', 'type' => '->', ), 2 => array ( 'file' => '/home/designc/public_html/work/snippets/ShowContests.php', 'line' => 155, 'function' => 'getValue', 'class' => 'DBAPI', 'type' => '->', ), 3 => array ( 'file' => '/home/designc/public_html/manager/includes/document.parser.class.inc.php', 'line' => 816, 'function' => 'snippet_ShowContests', ), 4 => array ( 'file' => '/home/designc/public_html/manager/includes/document.parser.class.inc.php', 'line' => 914, 'function' => 'evalSnippet', 'class' => 'DocumentParser', 'type' => '->', ), 5 => array ( 'file' => '/home/designc/public_html/manager/includes/document.parser.class.inc.php', 'line' => 1067, 'function' => 'evalSnippets', 'class' => 'DocumentParser', 'type' => '->', ), 6 => array ( 'file' => '/home/designc/public_html/manager/includes/document.parser.class.inc.php', 'line' => 484, 'function' => 'parseDocumentSource', 'class' => 'DocumentParser', 'type' => '->', ), 7 => array ( 'file' => '/home/designc/public_html/manager/includes/document.parser.class.inc.php', 'line' => 1266, 'function' => 'outputContent', 'class' => 'DocumentParser', 'type' => '->', ), 8 => array ( 'file' => '/home/designc/public_html/manager/includes/document.parser.class.inc.php', 'line' => 1175, 'function' => 'prepareResponse', 'class' => 'DocumentParser', 'type' => '->', ), 9 => array ( 'file' => '/home/designc/public_html/index.php', 'line' => 141, 'function' => 'executeParser', 'class' => 'DocumentParser', 'type' => '->', ), ) »
SQL: SELECT COUNT(*) FROM (SELECT cu.symbol, 1 as featured, c.* FROM contest c INNER JOIN currency cu ON c.currency = cu.id WHERE status = 2 AND objtype = 0 AND options LIKE "%f%" UNION SELECT cu.symbol, 2 as featured, c.* FROM contest c INNER JOIN currency cu ON c.currency = cu.id WHERE objtype = 0 AND (status = 2 AND options NOT LIKE "%f%" OR status > 2)) as alias1
[Copy SQL to ClipBoard]
Parser timing
MySQL: 2.6480 s (17 Requests)
PHP: 0.0378 s
Total: 2.6858 s
Now i get Modx Parse Error 1st time - Can't access contest and others. After a hour all access is OK. No problem.
Edited by Probir Ghosh, 26 July 2014 - 10:53 AM.