美高梅手机版网站-美高梅889900.com官方网站

[10501] PDOException in Connection.php line 687

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `id` <> ORDER BY `sort` ASC,`id` DESC LIMIT 6' at line 1

  1. $this->debug(false, '', $master);
  2. // 返回結果集
  3. return $this->getResult($pdo, $procedure);
  4. } catch (\PDOException $e) {
  5. if ($this->isBreak($e)) {
  6. return $this->close()->query($sql, $bind, $master, $pdo);
  7. }
  8. throw new PDOException($e, $this->config, $this->getLastsql());
  9. } catch (\Throwable $e) {
  10. if ($this->isBreak($e)) {
  11. return $this->close()->query($sql, $bind, $master, $pdo);
  12. }
  13. throw $e;
  14. } catch (\Exception $e) {
  15. if ($this->isBreak($e)) {
  16. return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 687
  2. at Connection->query('SELECT * FROM `sx_ca...', ['ThinkBind_1_' => [0, 1], 'ThinkBind_2_' => [1, 1], 'ThinkBind_3_' => [1, 1]], false, false) in Connection.php line 923
  3. at Connection->select(object(Query)) in Query.php line 3008
  4. at Query->select() in Cases.php line 34
  5. at Cases->getListsByWhere(['limit' => 6, 'addwhere' => [['type', '=', 1], ['style_id', '=', null], ['id', '<>', null]]]) in Cases.php line 187
  6. at Cases->detail()
  7. at ReflectionMethod->invokeArgs(object(Cases), []) in Container.php line 395
  8. at Container->invokeReflectMethod(object(Cases), object(ReflectionMethod), ['id' => '2', 'convert' => false]) in Module.php line 132
  9. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  10. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  11. at Middleware->think\{closure}(object(Request))
  12. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  13. at Middleware->dispatch(object(Request), 'controller') in Module.php line 137
  14. at Module->exec() in Dispatch.php line 168
  15. at Dispatch->run() in App.php line 432
  16. at App->think\{closure}(object(Request), object(Closure), null)
  17. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  18. at Middleware->think\{closure}(object(Request))
  19. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  20. at Middleware->dispatch(object(Request)) in App.php line 435
  21. at App->run() in index.php line 21

Exception Datas

PDO Error Info
SQLSTATE 42000
Driver Error Code 1064
Driver Error Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `id` <> ORDER BY `sort` ASC,`id` DESC LIMIT 6' at line 1
Database Status
Error Code 10501
Error Message SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `id` <> ORDER BY `sort` ASC,`id` DESC LIMIT 6' at line 1
Error SQL SELECT * FROM `sx_cases` WHERE `isdelete` = 0 AND `status` = 1 AND `type` = 1 AND `style_id` = AND `id` <> ORDER BY `sort` ASC,`id` DESC LIMIT 6
Database Config
type mysql
hostname 127.0.0.1
database dwzs_hfsxw_cn
hostport 3306
dsn
params []
charset utf8
prefix sx_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
resultset_type array
auto_timestamp false
datetime_format Y-m-d H:i:s
sql_explain false
builder
query \think\db\Query
break_reconnect false
break_match_str []

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookies
mirror-key 6f4439892f45c758d9deb84661eb1f2f
ASPSESSIONIDSQDATRBT HMLHELFDIOGBNMBNBMDJPHNF
ASPSESSIONIDQQAATQBS PKCEOOICBBLNKLPNDKLNELLL
ASPSESSIONIDQQABTRAT GANOGCMBJMOPHJAONAKDPOJI
ASPSESSIONIDQQDBTRBS KILMMJCABGMDPNFLDJALMNHK
ASPSESSIONIDSSABSRBT EOFENNFDAMFBKHGDICJOLKFN
ASPSESSIONIDSSADQQAT NDKGICJCNFMCJAGMMJBNLDCE
ASPSESSIONIDQQCDRRAT HPDAMGPAHFCNFAOJMMJLEDEC
ASPSESSIONIDSQCCRRAT IMILJMCAECMHKIFJDBKJCHOK
ASPSESSIONIDQSBBTQAT HDBANIPALPEOJMEDAIEBDOAK
ASPSESSIONIDSSCDQRBS JNPEOEJCHBHLOEPFGAELLDMP
ASPSESSIONIDSQCASQBT IIONNHMBFOIPCNKBPGGPGIOO
ASPSESSIONIDSQDBSQBT IFPAMLPAAJDFDDLLKGGPEKCE
ASPSESSIONIDQQAATQAS PIADDPCAAAICBLHPOBGMLCOD
ASPSESSIONIDSQDCQQAT KJEGEDGDCDDFNFLMGOLLBNDN
ASPSESSIONIDQQCBTRAS BOMIIGJCDLOOPPPCLPEAFPAE
ASPSESSIONIDQSDATQAS EAOJJLMBJJAFGGLKOBOEAEJC
ASPSESSIONIDSQCBSQBS MODAPNPAEINJKHBMJCOKCDHO
ASPSESSIONIDQSBASRAT PDPBHCDADFEJMNPDJBBFCIEG
ASPSESSIONIDQSBASQAT IDNMIFGDBCIEKLINBKIELHHM
ASPSESSIONIDSSABSQAT IEKOIJJCCGMEFBNBMCOFKEDC
ASPSESSIONIDQQDBTRBT GMIMHNMBGDOFKPEEBBNJIHMG
ASPSESSIONIDSQCCQRAS DLNEKAABIAPENKLPANMLMCKC
ASPSESSIONIDQQCASQBT LFHLIEDAPMEHOEKMPHEMGAJD
ASPSESSIONIDQSCASRAT KEIGCIGDAPNHPJKJOFDNKECC
ASPSESSIONIDQQDDRQAS GDNKBMJCIONKPPDCMHNONDHE
ASPSESSIONIDQQDASRBT ADMEJPMBBJBOHEJAHMKMCNBI
ASPSESSIONIDQQDBSRAT JKDGGDABDMIBGNLPKCGJBJMG
ASPSESSIONIDSSACQQBT PBOHKHDABOKIGELOHEIMAEKH
ASPSESSIONIDQSABTQAT BBDBALGDDENKBONJPLDCJCCE
ASPSESSIONIDQQCATQBS KDHJMOJCKPIJGPIKEHIPJONI
ASPSESSIONIDQSDBSQBT BOAGECNBNEHPOIJGEHOACMOI
Sessionempty
Server/Request Data
USER www
HOME /home/www
FCGI_ROLE RESPONDER
SCRIPT_FILENAME /www/wwwroot/dwzs.hfsxw.cn/public/index.php
QUERY_STRING s=/casedetail/2
REQUEST_METHOD GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME /index.php
REQUEST_URI /casedetail/2
DOCUMENT_URI /index.php
DOCUMENT_ROOT /www/wwwroot/dwzs.hfsxw.cn/public
SERVER_PROTOCOL HTTP/1.1
REQUEST_SCHEME http
GATEWAY_INTERFACE CGI/1.1
SERVER_SOFTWARE nginx/1.15.10
REMOTE_ADDR 140.205.132.30
REMOTE_PORT 43303
SERVER_ADDR 172.16.56.81
SERVER_PORT 80
SERVER_NAME www.xjaxjz.com
REDIRECT_STATUS 200
PATH_INFO
HTTP_HOST www.xjaxjz.com
HTTP_VIA cn198.l1, l2et2.l2
HTTP_EAGLEEYE_TRACEID 7af6142915892331436501353e
HTTP_ALI_CDN_REAL_PORT 61442
HTTP_ALI_CDN_REAL_IP 45.156.217.122
HTTP_ALI_SWIFT_LOG_HOST www.xjaxjz.com
HTTP_ALI_SWIFT_STAT_HOST all.daweis.com
HTTP_X_FORWARDED_FOR 45.156.217.122
HTTP_X_CLIENT_SCHEME http
HTTP_USER_AGENT Mozilla/5.0 (compatible; Googlebot/2.1; +#)
HTTP_ACCEPT */*
HTTP_ACCEPT_ENCODING gzip
HTTP_COOKIE mirror-key=6f4439892f45c758d9deb84661eb1f2f; ASPSESSIONIDSQDATRBT=HMLHELFDIOGBNMBNBMDJPHNF; ASPSESSIONIDQQAATQBS=PKCEOOICBBLNKLPNDKLNELLL; ASPSESSIONIDQQABTRAT=GANOGCMBJMOPHJAONAKDPOJI; ASPSESSIONIDQQDBTRBS=KILMMJCABGMDPNFLDJALMNHK; ASPSESSIONIDSSABSRBT=EOFENNFDAMFBKHGDICJOLKFN; ASPSESSIONIDSSADQQAT=NDKGICJCNFMCJAGMMJBNLDCE; ASPSESSIONIDQQCDRRAT=HPDAMGPAHFCNFAOJMMJLEDEC; ASPSESSIONIDSQCCRRAT=IMILJMCAECMHKIFJDBKJCHOK; ASPSESSIONIDQSBBTQAT=HDBANIPALPEOJMEDAIEBDOAK; ASPSESSIONIDSSCDQRBS=JNPEOEJCHBHLOEPFGAELLDMP; ASPSESSIONIDSQCASQBT=IIONNHMBFOIPCNKBPGGPGIOO; ASPSESSIONIDSQDBSQBT=IFPAMLPAAJDFDDLLKGGPEKCE; ASPSESSIONIDQQAATQAS=PIADDPCAAAICBLHPOBGMLCOD; ASPSESSIONIDSQDCQQAT=KJEGEDGDCDDFNFLMGOLLBNDN; ASPSESSIONIDQQCBTRAS=BOMIIGJCDLOOPPPCLPEAFPAE; ASPSESSIONIDQSDATQAS=EAOJJLMBJJAFGGLKOBOEAEJC; ASPSESSIONIDSQCBSQBS=MODAPNPAEINJKHBMJCOKCDHO; ASPSESSIONIDQSBASRAT=PDPBHCDADFEJMNPDJBBFCIEG; ASPSESSIONIDQSBASQAT=IDNMIFGDBCIEKLINBKIELHHM; ASPSESSIONIDSSABSQAT=IEKOIJJCCGMEFBNBMCOFKEDC; ASPSESSIONIDQQDBTRBT=GMIMHNMBGDOFKPEEBBNJIHMG; ASPSESSIONIDSQCCQRAS=DLNEKAABIAPENKLPANMLMCKC; ASPSESSIONIDQQCASQBT=LFHLIEDAPMEHOEKMPHEMGAJD; ASPSESSIONIDQSCASRAT=KEIGCIGDAPNHPJKJOFDNKECC; ASPSESSIONIDQQDDRQAS=GDNKBMJCIONKPPDCMHNONDHE; ASPSESSIONIDQQDASRBT=ADMEJPMBBJBOHEJAHMKMCNBI; ASPSESSIONIDQQDBSRAT=JKDGGDABDMIBGNLPKCGJBJMG; ASPSESSIONIDSSACQQBT=PBOHKHDABOKIGELOHEIMAEKH; ASPSESSIONIDQSABTQAT=BBDBALGDDENKBONJPLDCJCCE; ASPSESSIONIDQQCATQBS=KDHJMOJCKPIJGPIKEHIPJONI; ASPSESSIONIDQSDBSQBT=BOAGECNBNEHPOIJGEHOACMOI
HTTP_ORIGIN
HTTP_REFERER
HTTP_ALI_SWIFT_WILDCARD_DNS all.daweis.com
HTTP_X_ALICDN_DA_VIA 122.246.20.175,180.163.190.250
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1589233143.6764
REQUEST_TIME 1589233143
Environment Variablesempty
ThinkPHP Constants
MAX_MENU_LENGTH 3
MAX_SUB_MENU_LENGTH 5
MODULE_NAME cases
ACTION_NAME detail
美高梅手机版网站
Baidu
sogou