[10501] PDOException in Connection.php line 362

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 'acs LIMIT 4' at line 1

  1. // 参数绑定
  2. $this->bindValue($bind);
  3. // 执行查询
  4. $result = $this->PDOStatement->execute();
  5. // 调试结束
  6. $this->debug(false);
  7. $procedure = in_array(strtolower(substr(trim($sql), 0, 4)), ['call', 'exec']);
  8. return $this->getResult($class, $procedure);
  9. } catch (\PDOException $e) {
  10. throw new PDOException($e, $this->config, $this->queryStr);
  11. }
  12. }
  13. /**
  14. * 执行语句
  15. * @access public
  16. * @param string $sql sql指令
  17. * @param array $bind 参数绑定
  18. * @return int

Call Stack

  1. in Connection.php line 362
  2. at Connection->query('SELECT * FROM `ka_in...', [], false, false) in Query.php line 228
  3. at Query->query('SELECT * FROM `ka_in...', [], false, false) in Query.php line 1969
  4. at Query->select() in Wine.php line 75
  5. at Wine->wine3()
  6. at ReflectionMethod->invokeArgs(object(Wine), []) in App.php line 234
  7. at App::invokeMethod([object(Wine), 'wine3'], []) in App.php line 405
  8. at App::module(['index', 'wine', 'wine3'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 140
  9. at App::run() in start.php line 18
  10. at require_once('D:\HOSTS\yqwine1\www...') in index.php line 17

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 'acs LIMIT 4' 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 'acs LIMIT 4' at line 1
Error SQL SELECT * FROM `ka_infoimg` WHERE ( classid=5 and delstate!="true" and album=1 ) ORDER BY orderid acs LIMIT 4
Database Config
type mysql
hostname localhost
database yqwine1
username yqwine1
password 5963070a
hostport
dsn
params []
charset utf8
prefix ka_
debug false
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict true
resultset_type \think\Collection
auto_timestamp true
sql_explain false
builder
query \think\db\Query
datetime_format Y-m-d H:i:s

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
_FCGI_X_PIPE_ \\.\pipe\IISFCGI-0845a5f9-7932-46e0-8dcc-ffd1ab77d9c0
PHP_FCGI_MAX_REQUESTS 10000
PHPRC c:\php\5.6
ALLUSERSPROFILE C:\ProgramData
APPDATA C:\Windows\system32\config\systemprofile\AppData\Roaming
APP_POOL_CONFIG C:\inetpub\temp\apppools\1_FreeHost_1\1_FreeHost_1.config
APP_POOL_ID 1_FreeHost_1
CommonProgramFiles C:\Program Files (x86)\Common Files
CommonProgramFiles(x86) C:\Program Files (x86)\Common Files
CommonProgramW6432 C:\Program Files\Common Files
COMPUTERNAME 11305630-5-130
ComSpec C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK NO
LOCALAPPDATA C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS 4
OS Windows_NT
Path C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\MySQL\MySQL Server 5.5\bin;
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE x86
PROCESSOR_ARCHITEW6432 AMD64
PROCESSOR_IDENTIFIER Intel64 Family 6 Model 13 Stepping 3, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 0d03
ProgramData C:\ProgramData
ProgramFiles C:\Program Files (x86)
ProgramFiles(x86) C:\Program Files (x86)
ProgramW6432 C:\Program Files
PSModulePath C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC C:\Users\Public
SystemDrive C:
SystemRoot C:\Windows
TEMP C:\Windows\TEMP
TMP C:\Windows\TEMP
USERDOMAIN WORKGROUP
USERNAME 11305630-5-130$
USERPROFILE C:\Windows\system32\config\systemprofile
windir C:\Windows
windows_tracing_flags 3
windows_tracing_logfile C:\BVTBin\Tests\installpackage\csilogfile.log
ORIG_PATH_INFO /index.php/index/wine/wine3
URL /index.php
SERVER_SOFTWARE Microsoft-IIS/7.5
SERVER_PROTOCOL HTTP/1.1
SERVER_PORT_SECURE 0
SERVER_PORT 80
SERVER_NAME www.yqwine.cn
SCRIPT_NAME /index.php
SCRIPT_FILENAME D:\HOSTS\yqwine1\www\public\index.php
REQUEST_URI /index/wine/wine3
REQUEST_METHOD GET
REMOTE_USER
REMOTE_PORT 38002
REMOTE_HOST 192.168.5.249
REMOTE_ADDR 192.168.5.249
QUERY_STRING
PATH_TRANSLATED D:\HOSTS\yqwine1\www\public\index.php\index\wine\wine3
PATH_INFO /index/wine/wine3
LOGON_USER
LOCAL_ADDR 192.168.5.130
INSTANCE_META_PATH /LM/W3SVC/604
INSTANCE_NAME YQWINE1_SITE
INSTANCE_ID 604
HTTPS_SERVER_SUBJECT
HTTPS_SERVER_ISSUER
HTTPS_SECRETKEYSIZE
HTTPS_KEYSIZE
HTTPS off
GATEWAY_INTERFACE CGI/1.1
DOCUMENT_ROOT D:\HOSTS\yqwine1\www\public
CONTENT_TYPE
CONTENT_LENGTH 0
CERT_SUBJECT
CERT_SERIALNUMBER
CERT_ISSUER
CERT_FLAGS
CERT_COOKIE
AUTH_USER
AUTH_PASSWORD
AUTH_TYPE
APPL_PHYSICAL_PATH D:\HOSTS\yqwine1\www\public\
APPL_MD_PATH /LM/W3SVC/604/ROOT
IIS_UrlRewriteModule 7.1.1952.0
HTTP_X_ORIGINAL_URL /index/wine/wine3
HTTP_X_FORWARDED_FOR 3.237.186.170
HTTP_USER_AGENT claudebot
HTTP_HOST www.yqwine.cn
HTTP_ACCEPT */*
HTTP_CONTENT_LENGTH 0
HTTP_CONNECTION close
FCGI_ROLE RESPONDER
PHP_SELF /index.php/index/wine/wine3
REQUEST_TIME_FLOAT 1711653442.083
REQUEST_TIME 1711653442
Environment Variablesempty
ThinkPHP Constants
APP_PATH D:\HOSTS\yqwine1\www\public/../application/
THINK_VERSION 5.0.4
THINK_START_TIME 1711653442.0986
THINK_START_MEM 150840
EXT .php
DS \
THINK_PATH D:\HOSTS\yqwine1\www\thinkphp\
LIB_PATH D:\HOSTS\yqwine1\www\thinkphp\library\
CORE_PATH D:\HOSTS\yqwine1\www\thinkphp\library\think\
TRAIT_PATH D:\HOSTS\yqwine1\www\thinkphp\library\traits\
ROOT_PATH D:\HOSTS\yqwine1\www\
EXTEND_PATH D:\HOSTS\yqwine1\www\extend\
VENDOR_PATH D:\HOSTS\yqwine1\www\vendor\
RUNTIME_PATH D:\HOSTS\yqwine1\www\runtime\
LOG_PATH D:\HOSTS\yqwine1\www\runtime\log\
CACHE_PATH D:\HOSTS\yqwine1\www\runtime\cache\
TEMP_PATH D:\HOSTS\yqwine1\www\runtime\temp\
CONF_PATH D:\HOSTS\yqwine1\www\public/../application/
CONF_EXT .php
ENV_PREFIX PHP_
IS_CLI false
IS_WIN true
PC_PATH /public/
STATIC_PATH /public/static/
UPLOADS_PATH /public/uploads/