mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
[client_version] => 50012
[connect_errno] => 0
[connect_error] =>
[errno] => 1054
[error] => Unknown column 'maigoo_zhanhui_exhibition.Score' in 'order clause'
[error_list] => Array
(
[0] => Array
(
[errno] => 1054
[sqlstate] => 42S22
[error] => Unknown column 'maigoo_zhanhui_exhibition.Score' in 'order clause'
)
)
[field_count] => 1
[host_info] => 127.0.0.1 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 8.0.18
[server_version] => 80018
[stat] => Uptime: 103182 Threads: 25 Questions: 305573766 Slow queries: 11368 Opens: 61224 Flush tables: 3 Open tables: 20000 Queries per second avg: 2961.502
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 20131541
[warning_count] => 0
)
MySQL Error
Message: MySQL Query Error
SQL: select `maigoo_zhanhui_exhibition`.`Name` as `ExhibitionName`,`maigoo_zhanhui_exhibition`.`JieNum`,`maigoo_zhanhui_exhibition`.`Hall`,`maigoo_zhanhui_exhibition`.`City`,`maigoo_zhanhui`.* from `maigoo_zhanhui_exhibition` left join `maigoo_zhanhui` on `maigoo_zhanhui_exhibition`.`ZhanHuiID`=`maigoo_zhanhui`.`ID` where 1 and `maigoo_zhanhui_exhibition`.`StartYear`='2023' and `maigoo_zhanhui_exhibition`.`Status`='0' order by `maigoo_zhanhui_exhibition`.`Score` desc limit 0,20
Error: Unknown column 'maigoo_zhanhui_exhibition.Score' in 'order clause'
Errno.: 1054
error