string(32) "Got error 28 from storage engine"
array(5) {
[0]=>
array(7) {
["file"]=>
string(77) "/home/2006205733/duskin-kakuix-com/public_html/php/ACMS/GET/Entry/Summary.php"
["line"]=>
int(82)
["function"]=>
string(5) "query"
["class"]=>
string(2) "DB"
["object"]=>
object(DB)#1 (3) {
["_connection"]=>
resource(18) of type (mysql link)
["_fetch"]=>
array(0) {
}
["_dsn"]=>
array(3) {
["type"]=>
string(5) "mysql"
["debug"]=>
bool(true)
["charset"]=>
string(5) "UTF-8"
}
}
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
&string(905) "SELECT *
FROM acms_entry
LEFT JOIN acms_blog ON blog_id = entry_blog_id
LEFT JOIN acms_category ON category_id = entry_category_id
INNER JOIN (
SELECT field_eid, field_value AS strfield_sort, field_value + 0 AS intfield_sort
FROM acms_field
WHERE 1
AND field_key = 'pickup'
AND ( 0
OR field_value = 'true'
)
) AS field_end ON field_end.field_eid = entry_id
WHERE 1
AND entry_datetime BETWEEN '1000-01-01 00:00:00' AND '9999-12-31 23:59:59'
AND ( 1
AND entry_start_datetime <= '2023-03-21 08:25:30'
AND entry_end_datetime >= '2023-03-21 08:25:30'
AND entry_status = 'open'
AND entry_approval <> 'pre_approval'
)
AND ( 0
OR category_status IS NULL
OR category_status = 'open'
)
AND entry_blog_id IN ('1')
AND entry_indexing = 'on'
AND entry_primary_image IS NOT NULL
GROUP BY entry_datetime, entry_id
ORDER BY entry_datetime DESC, entry_id DESC
LIMIT 0, 1"
[1]=>
&string(3) "all"
}
}
[1]=>
array(7) {
["file"]=>
string(63) "/home/2006205733/duskin-kakuix-com/public_html/php/ACMS/GET.php"
["line"]=>
int(195)
["function"]=>
string(3) "get"
["class"]=>
string(22) "ACMS_GET_Entry_Summary"
["object"]=>
object(ACMS_GET_Entry_Summary)#127 (33) {
["config":protected]=>
array(35) {
["order"]=>
string(13) "datetime-desc"
["limit"]=>
int(0)
["offset"]=>
int(0)
["indexing"]=>
string(2) "on"
["secret"]=>
string(3) "off"
["notfound"]=>
string(3) "off"
["notfoundStatus404"]=>
string(3) "off"
["noimage"]=>
string(3) "off"
["pagerDelta"]=>
string(1) "3"
["pagerCurAttr"]=>
string(12) " class="cur""
["unit"]=>
string(1) "6"
["newtime"]=>
string(6) "259200"
["imageX"]=>
int(220)
["imageY"]=>
int(165)
["imageTrim"]=>
string(2) "on"
["imageZoom"]=>
string(3) "off"
["imageCenter"]=>
string(3) "off"
["entryFieldOn"]=>
string(2) "on"
["categoryInfoOn"]=>
string(2) "on"
["categoryFieldOn"]=>
string(3) "off"
["userInfoOn"]=>
string(3) "off"
["userFieldOn"]=>
string(3) "off"
["blogInfoOn"]=>
string(3) "off"
["blogFieldOn"]=>
string(3) "off"
["pagerOn"]=>
string(2) "on"
["simplePagerOn"]=>
string(3) "off"
["mainImageOn"]=>
string(2) "on"
["detailDateOn"]=>
string(3) "off"
["fullTextOn"]=>
string(2) "on"
["fulltextWidth"]=>
string(3) "200"
["fulltextMarker"]=>
string(3) "..."
["tagOn"]=>
string(2) "on"
["hiddenCurrentEntry"]=>
string(3) "off"
["loop_class"]=>
string(0) ""
["relational"]=>
string(3) "off"
}
["entries":protected]=>
NULL
["amount":protected]=>
object(SQL_Select)#87 (13) {
["_tables"]=>
array(1) {
[0]=>
array(2) {
["table"]=>
string(5) "entry"
["alias"]=>
NULL
}
}
["_leftJoins"]=>
array(2) {
[0]=>
array(4) {
["table"]=>
string(4) "blog"
["a"]=>
object(SQL_Field)#85 (2) {
["_field"]=>
string(7) "blog_id"
["_scope"]=>
NULL
}
["b"]=>
object(SQL_Field)#104 (2) {
["_field"]=>
string(13) "entry_blog_id"
["_scope"]=>
NULL
}
["where"]=>
NULL
}
[1]=>
array(4) {
["table"]=>
string(8) "category"
["a"]=>
object(SQL_Field)#105 (2) {
["_field"]=>
string(11) "category_id"
["_scope"]=>
NULL
}
["b"]=>
object(SQL_Field)#109 (2) {
["_field"]=>
string(17) "entry_category_id"
["_scope"]=>
NULL
}
["where"]=>
NULL
}
}
["_innerJoins"]=>
array(1) {
[0]=>
array(6) {
["table"]=>
object(SQL_Select)#81 (13) {
["_tables"]=>
array(1) {
[0]=>
array(2) {
["table"]=>
string(5) "field"
["alias"]=>
NULL
}
}
["_leftJoins"]=>
array(0) {
}
["_innerJoins"]=>
array(0) {
}
["_selects"]=>
array(3) {
[0]=>
array(2) {
["field"]=>
object(SQL_Field_Function)#48 (3) {
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(9) "field_eid"
["_scope"]=>
NULL
}
["alias"]=>
NULL
}
[1]=>
array(2) {
["field"]=>
object(SQL_Field_Function)#83 (3) {
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(11) "field_value"
["_scope"]=>
NULL
}
["alias"]=>
string(13) "strfield_sort"
}
[2]=>
array(2) {
["field"]=>
object(SQL_Field_Function)#82 (3) {
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
object(SQL_Field_Operator)#64 (5) {
["_value"]=>
int(0)
["_operator"]=>
string(1) "+"
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(11) "field_value"
["_scope"]=>
NULL
}
["_scope"]=>
NULL
}
["alias"]=>
string(13) "intfield_sort"
}
}
["_havings"]=>
array(0) {
}
["_groups"]=>
array(0) {
}
["_limit"]=>
NULL
["_orders"]=>
array(0) {
}
["_fdOrders"]=>
NULL
["_where"]=>
NULL
["_union"]=>
array(0) {
}
["_straightJoin"]=>
bool(false)
["_wheres"]=>
array(2) {
[0]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#80 (5) {
["_value"]=>
string(6) "pickup"
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(9) "field_key"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[1]=>
array(2) {
["where"]=>
object(SQL_Where)#90 (1) {
["_wheres"]=>
array(1) {
[0]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#86 (5) {
["_value"]=>
string(4) "true"
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(11) "field_value"
["_scope"]=>
NULL
}
["glue"]=>
string(2) "OR"
}
}
}
["glue"]=>
string(3) "AND"
}
}
}
["a"]=>
string(9) "field_eid"
["b"]=>
string(8) "entry_id"
["als"]=>
string(9) "field_end"
["scp"]=>
NULL
["where"]=>
NULL
}
}
["_selects"]=>
array(1) {
[0]=>
array(2) {
["field"]=>
object(SQL_Field_Function)#76 (3) {
["_args"]=>
array(1) {
[0]=>
string(5) "COUNT"
}
["_field"]=>
string(18) "DISTINCT(entry_id)"
["_scope"]=>
NULL
}
["alias"]=>
string(12) "entry_amount"
}
}
["_havings"]=>
array(0) {
}
["_groups"]=>
array(0) {
}
["_limit"]=>
NULL
["_orders"]=>
array(0) {
}
["_fdOrders"]=>
NULL
["_where"]=>
NULL
["_union"]=>
array(0) {
}
["_straightJoin"]=>
bool(false)
["_wheres"]=>
array(6) {
[0]=>
array(2) {
["where"]=>
object(SQL_Field_Operator_Between)#68 (7) {
["_a"]=>
string(19) "1000-01-01 00:00:00"
["_b"]=>
string(19) "9999-12-31 23:59:59"
["_value"]=>
NULL
["_operator"]=>
NULL
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(14) "entry_datetime"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[1]=>
array(2) {
["where"]=>
object(SQL_Where)#100 (1) {
["_wheres"]=>
array(4) {
[0]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#98 (5) {
["_value"]=>
string(19) "2023-03-21 08:25:30"
["_operator"]=>
string(2) "<="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(20) "entry_start_datetime"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[1]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#97 (5) {
["_value"]=>
string(19) "2023-03-21 08:25:30"
["_operator"]=>
string(2) ">="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(18) "entry_end_datetime"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[2]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#96 (5) {
["_value"]=>
string(4) "open"
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(12) "entry_status"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[3]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#95 (5) {
["_value"]=>
string(12) "pre_approval"
["_operator"]=>
string(2) "<>"
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(14) "entry_approval"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
}
}
["glue"]=>
string(3) "AND"
}
[2]=>
array(2) {
["where"]=>
object(SQL_Where)#99 (1) {
["_wheres"]=>
array(2) {
[0]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#93 (5) {
["_value"]=>
NULL
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(15) "category_status"
["_scope"]=>
NULL
}
["glue"]=>
string(2) "OR"
}
[1]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#92 (5) {
["_value"]=>
string(4) "open"
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(15) "category_status"
["_scope"]=>
NULL
}
["glue"]=>
string(2) "OR"
}
}
}
["glue"]=>
string(3) "AND"
}
[3]=>
array(2) {
["where"]=>
object(SQL_Field_Operator_In)#79 (6) {
["_not"]=>
bool(false)
["_value"]=>
array(1) {
[0]=>
string(1) "1"
}
["_operator"]=>
NULL
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(13) "entry_blog_id"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[4]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#78 (5) {
["_value"]=>
string(2) "on"
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(14) "entry_indexing"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[5]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#77 (5) {
["_value"]=>
NULL
["_operator"]=>
string(2) "<>"
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(19) "entry_primary_image"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
}
}
["eids":protected]=>
NULL
["blogSubQuery":protected]=>
object(SQL_Select)#94 (13) {
["_tables"]=>
array(1) {
[0]=>
array(2) {
["table"]=>
string(4) "blog"
["alias"]=>
NULL
}
}
["_leftJoins"]=>
array(0) {
}
["_innerJoins"]=>
array(0) {
}
["_selects"]=>
array(1) {
[0]=>
array(2) {
["field"]=>
object(SQL_Field_Function)#91 (3) {
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(7) "blog_id"
["_scope"]=>
NULL
}
["alias"]=>
NULL
}
}
["_havings"]=>
array(0) {
}
["_groups"]=>
array(0) {
}
["_limit"]=>
NULL
["_orders"]=>
array(0) {
}
["_fdOrders"]=>
NULL
["_where"]=>
NULL
["_union"]=>
array(0) {
}
["_straightJoin"]=>
bool(false)
["_wheres"]=>
array(2) {
[0]=>
array(2) {
["where"]=>
object(SQL_Field_Operator)#89 (5) {
["_value"]=>
int(1)
["_operator"]=>
string(1) "="
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(7) "blog_id"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
[1]=>
array(2) {
["where"]=>
object(SQL_Field_Operator_In)#88 (6) {
["_not"]=>
bool(false)
["_value"]=>
array(1) {
[0]=>
string(4) "open"
}
["_operator"]=>
NULL
["_args"]=>
array(1) {
[0]=>
NULL
}
["_field"]=>
string(11) "blog_status"
["_scope"]=>
NULL
}
["glue"]=>
string(3) "AND"
}
}
}
["categorySubQuery":protected]=>
NULL
["_axis"]=>
array(2) {
["bid"]=>
string(4) "self"
["cid"]=>
string(4) "self"
}
["tpl"]=>
string(1349) "
{module_heading}
noimage
{module_heading}
noimage
Fatal error: Got error 28 from storage engine
SELECT * FROM acms_entry LEFT JOIN acms_blog ON blog_id = entry_blog_id LEFT JOIN acms_category ON category_id = entry_category_id INNER JOIN ( SELECT field_eid, field_value AS strfield_sort, field_value + 0 AS intfield_sort FROM acms_field WHERE 1 AND field_key = 'pickup' AND ( 0 OR field_value = 'true' ) ) AS field_end ON field_end.field_eid = entry_id WHERE 1 AND entry_datetime BETWEEN '1000-01-01 00:00:00' AND '9999-12-31 23:59:59' AND ( 1 AND entry_start_datetime <= '2023-03-21 08:25:30' AND entry_end_datetime >= '2023-03-21 08:25:30' AND entry_status = 'open' AND entry_approval <> 'pre_approval' ) AND ( 0 OR category_status IS NULL OR category_status = 'open' ) AND entry_blog_id IN ('1') AND entry_indexing = 'on' AND entry_primary_image IS NOT NULL GROUP BY entry_datetime, entry_id ORDER BY entry_datetime DESC, entry_id DESC LIMIT 0, 1in /home/2006205733/duskin-kakuix-com/public_html/php/DB.php on line 178