[10501] PDOException in Connection.php line 388

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

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

    Call Stack

    1. in Connection.php line 388
    2. at Connection->query('SELECT * FROM `qs_ca...', [], false, false) in Query.php line 227
    3. at Query->query('SELECT * FROM `qs_ca...', [], false, false) in Query.php line 2509
    4. at Query->find() in ArcController.php line 36
    5. at ArcController->show()
    6. at ReflectionMethod->invokeArgs(object(ArcController), []) in App.php line 342
    7. at App::invokeMethod([object(ArcController), 'show'], []) in App.php line 594
    8. at App::module(['pc', 'arc', 'show'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 456
    9. at App::exec(['type' => 'module', 'module' => ['pc', 'arc', 'show']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
    10. at App::run() in index.php line 35

    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 ') LIMIT 1' 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 ') LIMIT 1' at line 1
    Error SQL SELECT * FROM `qs_category` WHERE ( id= ) LIMIT 1
    Database Config
    type mysql
    hostname localhost
    database syh1199
    hostport 3306
    dsn
    params []
    charset utf8mb4
    prefix qs_
    debug true
    deploy 0
    rw_separate false
    master_num 1
    slave_no
    fields_strict true
    result_type 2
    resultset_type collection
    auto_timestamp false
    datetime_format false
    sql_explain false
    builder
    query \think\db\Query
    break_reconnect false
    authcode NJA48meoduEM7ZCebo

    Environment Variables

    GET Data
    empty
    POST Data
    empty
    Files
    empty
    Cookies
    empty
    Session
    empty

    Server/Request Data

    _FCGI_X_PIPE_
    \\.\pipe\IISFCGI-8e11ec22-7eaf-4681-b82d-e78093d273be
    PHP_FCGI_MAX_REQUESTS
    10000
    ALLUSERSPROFILE
    C:\ProgramData
    APPDATA
    C:\Windows\system32\config\systemprofile\AppData\Roaming
    APP_POOL_CONFIG
    C:\inetpub\temp\apppools\AppPool_20_7\AppPool_20_7.config
    APP_POOL_ID
    AppPool_20_7
    CommonProgramFiles
    C:\Program Files (x86)\Common Files
    CommonProgramFiles(x86)
    C:\Program Files (x86)\Common Files
    CommonProgramW6432
    C:\Program Files\Common Files
    COMPUTERNAME
    INSTANCE-58RB9V
    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\;
    PATHEXT
    .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    PROCESSOR_ARCHITECTURE
    x86
    PROCESSOR_ARCHITEW6432
    AMD64
    PROCESSOR_IDENTIFIER
    Intel64 Family 6 Model 63 Stepping 2, GenuineIntel
    PROCESSOR_LEVEL
    6
    PROCESSOR_REVISION
    3f02
    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
    INSTANCE-58RB9V$
    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/pc/arc/show/id/68.html
    URL
    /index.php
    SERVER_SOFTWARE
    Microsoft-IIS/7.5
    SERVER_PROTOCOL
    HTTP/1.1
    SERVER_PORT_SECURE
    0
    SERVER_PORT
    80
    SERVER_NAME
    www.oblasts.com
    SCRIPT_NAME
    /index.php
    SCRIPT_FILENAME
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\index.php
    REQUEST_URI
    /pc/arc/show/id/68.html
    REQUEST_METHOD
    GET
    REMOTE_USER
    REMOTE_PORT
    59442
    REMOTE_HOST
    62.60.208.130
    REMOTE_ADDR
    62.60.208.130
    QUERY_STRING
    PATH_TRANSLATED
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\index.php\pc\arc\show\id\68.html
    PATH_INFO
    /pc/arc/show/id/68.html
    LOGON_USER
    LOCAL_ADDR
    192.168.0.20
    INSTANCE_META_PATH
    /LM/W3SVC/179
    INSTANCE_NAME
    SYH1199.COM
    INSTANCE_ID
    179
    HTTPS_SERVER_SUBJECT
    HTTPS_SERVER_ISSUER
    HTTPS_SECRETKEYSIZE
    HTTPS_KEYSIZE
    HTTPS
    off
    GATEWAY_INTERFACE
    CGI/1.1
    DOCUMENT_ROOT
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot
    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:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\
    APPL_MD_PATH
    /LM/W3SVC/179/ROOT
    IIS_UrlRewriteModule
    7.1.0871.0
    HTTP_X_ORIGINAL_URL
    /pc/arc/show/id/68.html
    HTTP_USER_AGENT
    Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
    HTTP_HOST
    www.oblasts.com
    HTTP_ACCEPT
    */*
    HTTP_CONTENT_LENGTH
    0
    FCGI_ROLE
    RESPONDER
    PHP_SELF
    /index.php/pc/arc/show/id/68.html
    REQUEST_TIME_FLOAT
    1567195184.6874
    REQUEST_TIME
    1567195184
    Environment Variables
    empty

    ThinkPHP Constants

    APP_DEBUG
    true
    CMF_ROOT
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/
    APP_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/app/
    CMF_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/simplewind/cmf/
    PLUGINS_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/public/plugins/
    EXTEND_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/simplewind/extend/
    VENDOR_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/simplewind/vendor/
    RUNTIME_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/data/runtime/
    THINKCMF_VERSION
    5.0.180123
    THINK_VERSION
    5.0.14
    THINK_START_TIME
    1567195184.6874
    THINK_START_MEM
    163104
    EXT
    .php
    DS
    \
    THINK_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\simplewind\thinkphp\
    LIB_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\simplewind\thinkphp\library\
    CORE_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\simplewind\thinkphp\library\think\
    TRAIT_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\simplewind\thinkphp\library\traits\
    ROOT_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\
    LOG_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/data/runtime/log\
    CACHE_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/data/runtime/cache\
    TEMP_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/data/runtime/temp\
    CONF_PATH
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot/app/
    CONF_EXT
    .php
    ENV_PREFIX
    PHP_
    IS_CLI
    false
    IS_WIN
    true
    HTMLPURIFIER_PREFIX
    D:\www\web\syh1199.com_ln4km0vJYkMAuuQoPLwM\wwwroot\simplewind\vendor\ezyang\htmlpurifier\library
    QINIU_FUNCTIONS_VERSION
    7.2.1
    CONTROLLER_NAME
    Arc
    DOMDOCUMENT
    DOMDocument
    DOMELEMENT
    DOMElement
    DOMNODELIST
    DOMNodeList
    DOMNODE
    DOMNode