2026-04-19 11:42:17 — PHP8.2.28 — address-CentralVisayas-schoolid-36.html

CodeIgniter\Database\Exceptions\DatabaseException #1054

Unknown column 'school' in 'where clause'
SELECT *
FROM `ccc3_1_school`
WHERE area in(7,56,57,58,59,60,61,62) and school=36

/www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseConnection.php at line 684

677                     }
678                 }
679 
680                 // Let others do something with this query.
681                 Events::trigger('DBQuery'$query);
682 
683                 if ($exception instanceof DatabaseException) {
684                     throw new DatabaseException(
685                         $exception->getMessage().'<br>'.$query,
686                         $exception->getCode(),
687                         $exception,
688                     );
689                 }
690 
691                 return false;
    Caused by:
    CodeIgniter\Database\Exceptions\DatabaseException #1054
    Unknown column 'school' in 'where clause'    
    /www/wwwroot/new.cnphedu.com/dayrui/System/Database/MySQLi/Connection.php:332    
    Caused by:
    mysqli_sql_exception #1054
    Unknown column 'school' in 'where clause'    
    /www/wwwroot/new.cnphedu.com/dayrui/System/Database/MySQLi/Connection.php:327    
  1. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/MySQLi/Connection.php : 327   —  mysqli->query ()

    320             $this->connID->next_result();
    321             if ($res $this->connID->store_result()) {
    322                 $res->free();
    323             }
    324         }
    325 
    326         try {
    327             return $this->connID->query($this->prepQuery($sql), $this->resultMode);
    328         } catch (mysqli_sql_exception $e) {
    329             log_message('error', (string) $e);
    330 
    331             if ($this->DBDebug) {
    332                 throw new DatabaseException($e->getMessage(), $e->getCode(), $e);
    333             }
    334         }
    
  2. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseConnection.php : 729   —  CodeIgniter\Database\MySQLi\Connection->execute ()

    722      */
    723     public function simpleQuery(string $sql)
    724     {
    725         if (empty($this->connID)) {
    726             $this->initialize();
    727         }
    728 
    729         return $this->execute($sql);
    730     }
    731 
    732     /**
    733      * Disable Transactions
    734      *
    735      * This permits transactions to be disabled at run-time.
    736      *
    
  3. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseConnection.php : 646   —  CodeIgniter\Database\BaseConnection->simpleQuery ()

    639 
    640             return $query;
    641         }
    642 
    643         // Run the query for real
    644         try {
    645             $exception      null;
    646             $this->resultID = $this->simpleQuery($query->getQuery());
    647         } catch (DatabaseException $exception) {
    648             $this->resultID false;
    649         }
    650 
    651         if ($this->resultID === false) {
    652             $query->setDuration($startTime$startTime);
    653 
    
  4. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseBuilder.php : 1649   —  CodeIgniter\Database\BaseConnection->query ()

    1642 
    1643         if ($limit !== null) {
    1644             $this->limit($limit$offset);
    1645         }
    1646 
    1647         $result $this->testMode
    1648             $this->getCompiledSelect($reset)
    1649             : $this->db->query($this->compileSelect(), $this->binds, false);
    1650 
    1651         if ($reset) {
    1652             $this->resetSelect();
    1653 
    1654             // Clear our binds so we don't eat up memory
    1655             $this->binds = [];
    1656         }
    
  5. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Model.php : 563   —  CodeIgniter\Database\BaseBuilder->get ()

    556             } else {
    557                 $builder->limit($a);
    558             }
    559         } elseif ($num) {
    560             $builder->limit($num);
    561         }
    562 
    563         $query = $builder->get();
    564         if (!$query) {
    565             $this->_clear();
    566             return [];
    567         }
    568 
    569         $rt $query->getResultArray();
    570         if ($rt && $key) {
    
  6. /www/wwwroot/new.cnphedu.com/dayrui/App/Linkage/Controllers/Home.php : 130   —  Phpcmf\Model->getAll ()

    123         if (!empty($modules)) {
    124             $count count($modules);
    125             if (!empty($get['schoolid']) && $count 2) {
    126                 $all_data[$val['module']]['fieldname'] .= 'school=' $get['schoolid'] . ' and ';
    127             }
    128             foreach ($all_data as $key => $val) {
    129                 $where rtrim($val['fieldname'], 'and ');
    130                 $data = \Phpcmf\Service::M()->table(SITE_ID . '_' . $val['table'])->where($where)->getAll();
    131                 $all_data[$key]['where'] = $where;
    132                 $all_data[$key]['data'] = $data;
    133                 $last_data end($data);
    134                 foreach ($data as $val2) {
    135                     if (in_array($val2['school'], $val2) && !in_array($val2['school'], $schoolid)) {
    136                         $all_data[$key]['schoolid'][] = $schoolid[] = $val2['school'];
    137                     }
    
  7. /www/wwwroot/new.cnphedu.com/dayrui/System/Extend/Run.php : 149   —  Phpcmf\Controllers\Home->index ()

    142                         'value' => $value
    143                     ]);
    144 
    145                 }
    146             }
    147         }
    148 
    149         $app->$method();
    150 
    151         if (CI_DEBUG) {
    152             $tool = new \CodeIgniter\Debug\Toolbar(config(\Config\Toolbar::class));
    153             $tool->prepare($this);
    154         }
    155         
    156        
    
  8. /www/wwwroot/new.cnphedu.com/dayrui/System/Init.php : 402   —  Frame\Run->bootWeb ()

    395         $tool->respond();
    396     });
    397 }
    398 
    399 
    400 // 启动框架
    401 $run = new \Frame\Run();
    402 $run->bootWeb();
    403 
    404 
    
  9. require /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Init.php   —   require()

  10. require /www/wwwroot/new.cnphedu.com/public/index.php   —   require()

$_SERVER

Key Value
USER www
HOME /home/www
SCRIPT_NAME /index.php
REQUEST_URI /address-CentralVisayas-schoolid-36.html
QUERY_STRING
REQUEST_METHOD GET
SERVER_PROTOCOL HTTP/1.1
GATEWAY_INTERFACE CGI/1.1
REDIRECT_URL /address-CentralVisayas-schoolid-36.html
REMOTE_PORT 23859
SCRIPT_FILENAME /www/wwwroot/new.cnphedu.com/public/index.php
SERVER_ADMIN webmaster@example.com
CONTEXT_DOCUMENT_ROOT /www/wwwroot/new.cnphedu.com/public
CONTEXT_PREFIX
REQUEST_SCHEME http
DOCUMENT_ROOT /www/wwwroot/new.cnphedu.com/public
REMOTE_ADDR 216.73.216.49
SERVER_PORT 80
SERVER_ADDR 10.2.0.17
SERVER_NAME new.cnphedu.com
SERVER_SOFTWARE Apache
SERVER_SIGNATURE
Apache Server at new.cnphedu.com Port 80
LD_LIBRARY_PATH /www/server/apache/lib
PATH /www/server/panel/pyenv/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/root/bin
HTTP_CONNECTION keep-alive
HTTP_CACHE_CONTROL max-age=259200
HTTP_X_FORWARDED_FOR 10.1.18.225
HTTP_VIA 1.1 squid-proxy-5b5d847c96-ll6r2 (squid/6.13)
HTTP_HOST new.cnphedu.com
HTTP_ACCEPT_ENCODING gzip, br, zstd, deflate
HTTP_USER_AGENT Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT */*
proxy-nokeepalive 1
REDIRECT_STATUS 200
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT
1776570137.2954
REQUEST_TIME
1776570137

Constants

Key Value
IS_DEV
1
IS_EDIT_TPL
0
ROOTPATH /www/wwwroot/new.cnphedu.com/public/
WEBPATH /www/wwwroot/new.cnphedu.com/public/
FCPATH /www/wwwroot/new.cnphedu.com/dayrui/
WRITEPATH /www/wwwroot/new.cnphedu.com/cache/
CONFIGPATH /www/wwwroot/new.cnphedu.com/config/
SELF index.php
IS_ADMIN

                                                                    
IS_VERSION
1
FRAMEPATH /www/wwwroot/new.cnphedu.com/dayrui/System/
CMSPATH /www/wwwroot/new.cnphedu.com/dayrui/Fcms/
MAX_CATEGORY
300
COREPATH /www/wwwroot/new.cnphedu.com/dayrui/Fcms/
BASEPATH /www/wwwroot/new.cnphedu.com/dayrui/System/System/
APPSPATH /www/wwwroot/new.cnphedu.com/dayrui/App/
MYPATH /www/wwwroot/new.cnphedu.com/dayrui/My/
TPLPATH /www/wwwroot/new.cnphedu.com/template/
IS_XRDEV
0
MOBILE_TPL_DIR mobile
UEDITOR_IMG_TITLE {cms_img_title}
TESTPATH /www/wwwroot/new.cnphedu.com/cache/tests/
TEMPPATH /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Temp/
COMPOSER_PATH /www/wwwroot/new.cnphedu.com/public/vendor/autoload.php
IS_AJAX

                                                                    
IS_POST

                                                                    
IS_AJAX_POST

                                                                    
SYS_TIME
1776570137
SYS_DEBUG
1
SYS_ADMIN_CODE
0
SYS_ADMIN_LOG
0
SYS_AUTO_FORM
0
SYS_ADMIN_PAGESIZE
10
SYS_CRON_AUTH
0
SYS_TABLE_ISFOOTER
SYS_SMS_IMG_CODE
0
SYS_GO_404
SYS_THEME_ROOT_PATH
1
SYS_301
1
SYS_NOT_UPDATE
1
SYS_URL_ONLY
0
SYS_URL_REL
1
SYS_KEY PHPCMF376b3d40bc103fac9705f4e0c54c52f2
SYS_API_TOKEN
SYS_CSRF
0
SYS_CSRF_TIME
0
SYS_API_REL
SYS_HTTPS
0
SYS_NOT_ADMIN_CACHE
0
SYS_ADMIN_MODE
SYS_ADMIN_LOGINS
SYS_ADMIN_LOGIN_AES
SYS_ATTACHMENT_DOWN_REMOTE
SYS_ATTACHMENT_DOWN_SIZE
SYS_ADMIN_LOGIN_TIME
SYS_LOGIN_AES
0
SYS_ADMIN_OAUTH
SYS_ADMIN_SMS_LOGIN
SYS_ADMIN_SMS_CHECK
SYS_ATTACHMENT_DB
SYS_ATTACHMENT_PAGESIZE
SYS_ATTACHMENT_GUEST
SYS_ATTACHMENT_CF
SYS_ATTACHMENT_REL
SYS_ATTACHMENT_PATH
SYS_ATTACHMENT_SAVE_TYPE
SYS_ATTACHMENT_SAVE_DIR
SYS_ATTACHMENT_SAVE_ID
SYS_ATTACHMENT_URL
SYS_AVATAR_PATH
SYS_AVATAR_URL
SYS_API_CODE
SYS_ATTACHMENT_SAFE
IS_ADMIN_CACHE 1
SQGS 迅睿CMS开源框架
CI_DEBUG
1
IS_FB_DEBUG
0
ENVIRONMENT development
SYS_CACHE
0
SYS_CACHE_TYPE
0
SYS_CACHE_SHOW
0
SYS_CACHE_LIST
0
SYS_CACHE_SEARCH
0
SYS_CACHE_SMS
0
SYS_CACHE_CRON
0
SYS_CACHE_CLEAR
0
FC_NOW_URL http://new.cnphedu.com/address-CentralVisayas-schoolid-36.html
FC_NOW_HOST http://new.cnphedu.com/
DOMAIN_NAME new.cnphedu.com
WEB_DIR /
CMSURI address-CentralVisayas-schoolid-36.html
IS_API

                                                                    
IS_USE_MEMBER /www/wwwroot/new.cnphedu.com/dayrui/App/Member/
IS_USE_MODULE /www/wwwroot/new.cnphedu.com/dayrui/App/Module/
APPPATH /www/wwwroot/new.cnphedu.com/dayrui/App/Linkage/
APP_DIR linkage
IS_MEMBER

                                                                    
IS_HOME
1
FRAME_PHP_VERSION 8.0
FRAME_NAME System
FRAME_VERSION 4.7
EXIT_SUCCESS
0
EXIT_ERROR
1
EXIT_CONFIG
3
EXIT_UNKNOWN_FILE
4
EXIT_UNKNOWN_CLASS
5
EXIT_UNKNOWN_METHOD
6
EXIT_USER_INPUT
7
EXIT_DATABASE
8
EXIT__AUTO_MIN
9
EXIT__AUTO_MAX
125
EVENT_PRIORITY_LOW
200
EVENT_PRIORITY_NORMAL
100
EVENT_PRIORITY_HIGH
10
IS_COMMON
1
IS_SITES
0
CMF_NAME 迅睿框架开源版
CMF_VERSION 4.7.1
CMF_UPDATE_TIME 1776214697
SITE_ID
1
SITE_URL http://new.cnphedu.com/
SITE_MURL http://new.cnphedu.com/
SITE_NAME 菲律宾留学
SITE_LOGO http://new.cnphedu.com/uploadfile/202007/cnphedu.webp
SITE_IS_MOBILE
0
SITE_IS_MOBILE_HTML
0
SITE_MOBILE_DIR mobile
SITE_MOBILE_NOT_PAD
0
SITE_THUMB_WATERMARK
0
SITE_THEME phschool
SITE_SEOJOIN -
SITE_REWRITE
0
SITE_TEMPLATE phschool
SITE_LANGUAGE zh-cn
SITE_TIME_FORMAT Y-m-d H:i:s
ADMIN_URL http://new.cnphedu.com/
PAY_URL http://new.cnphedu.com/
ROOT_URL http://new.cnphedu.com/
OAUTH_URL http://new.cnphedu.com/
THEME_PATH /static/
LANG_PATH /api/language/zh-cn/
ROOT_THEME_PATH /static/
HOME_THEME_PATH /static/phschool/
MOBILE_THEME_PATH http://new.cnphedu.com/static/phschool/
SYS_UPLOAD_PATH /www/wwwroot/new.cnphedu.com/public/uploadfile/
SYS_UPLOAD_URL http://new.cnphedu.com/uploadfile/
CLIENT_URL http://new.cnphedu.com/
CLIENT_NAME pc
IS_CLIENT
MEMBER_URL http://new.cnphedu.com/index.php?s=member
SITE_FID
0
MEMBER_CNAME 姓名
SITE_ICP 京ICP备2021009336号-1
SITE_TONGJI
SITE_LOGIN_TIME
36000
SITE_SCORE 金币
SITE_EXPERIENCE 经验
IS_API_HTTP
0
USER_HTTP_CODE 84da87e37fc918585207fffd2de7bc12
  1. /www/wwwroot/new.cnphedu.com/public/index.php
  2. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Init.php
  3. /www/wwwroot/new.cnphedu.com/config/custom.php
  4. /www/wwwroot/new.cnphedu.com/cache/config/system.php
  5. /www/wwwroot/new.cnphedu.com/config/rewrite.php
  6. /www/wwwroot/new.cnphedu.com/cache/config/domain_app.php
  7. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Helper.php
  8. /www/wwwroot/new.cnphedu.com/dayrui/System/Init.php
  9. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Auto.php
  10. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Service.php
  11. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Hooks.php
  12. /www/wwwroot/new.cnphedu.com/dayrui/System/Extend/Run.php
  13. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Phpcmf.php
  14. /www/wwwroot/new.cnphedu.com/dayrui/System/Extend/Controller.php
  15. /www/wwwroot/new.cnphedu.com/dayrui/App/Mform/Config/Auto.php
  16. /www/wwwroot/new.cnphedu.com/dayrui/App/Mform/Config/Hooks.php
  17. /www/wwwroot/new.cnphedu.com/dayrui/App/Dever/Config/Hooks.php
  18. /www/wwwroot/new.cnphedu.com/dayrui/App/Module/Config/Auto.php
  19. /www/wwwroot/new.cnphedu.com/dayrui/App/Module/Config/Hooks.php
  20. /www/wwwroot/new.cnphedu.com/dayrui/App/Module/Config/Filters.php
  21. /www/wwwroot/new.cnphedu.com/dayrui/App/Page/Config/Hooks.php
  22. /www/wwwroot/new.cnphedu.com/dayrui/App/Form/Config/Auto.php
  23. /www/wwwroot/new.cnphedu.com/dayrui/App/Member/Config/Hooks.php
  24. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Services.php
  25. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/BaseService.php
  26. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Factories.php
  27. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Factory.php
  28. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/BaseConfig.php
  29. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Exceptions.php
  30. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Exceptions.php
  31. /www/wwwroot/new.cnphedu.com/dayrui/System/Events/Events.php
  32. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Timer.php
  33. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Toolbar.php
  34. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Toolbar.php
  35. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Toolbar/Collectors/Database.php
  36. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Toolbar/Collectors/BaseCollector.php
  37. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Database.php
  38. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/Config.php
  39. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Toolbar/Collectors/Views.php
  40. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/View.php
  41. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Toolbar/Collectors/Files.php
  42. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/Toolbar/Collectors/Routes.php
  43. /www/wwwroot/new.cnphedu.com/dayrui/App/Linkage/Controllers/Home.php
  44. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/App.php
  45. /www/wwwroot/new.cnphedu.com/cache/config/site.php
  46. /www/wwwroot/new.cnphedu.com/dayrui/My/Config/Version.php
  47. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Library/Cache.php
  48. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Library/Lang.php
  49. /www/wwwroot/new.cnphedu.com/public/api/language/zh-cn/lang.php
  50. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Library/Input.php
  51. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Library/Security.php
  52. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Model/Member.php
  53. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Core/Model.php
  54. /www/wwwroot/new.cnphedu.com/dayrui/System/Extend/Model.php
  55. /www/wwwroot/new.cnphedu.com/config/database.php
  56. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/Database.php
  57. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/MySQLi/Connection.php
  58. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseConnection.php
  59. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/ConnectionInterface.php
  60. /www/wwwroot/new.cnphedu.com/dayrui/App/Module/Config/Run.php
  61. /www/wwwroot/new.cnphedu.com/cache/config/domain_client.php
  62. /www/wwwroot/new.cnphedu.com/dayrui/Fcms/Library/Router.php
  63. /www/wwwroot/new.cnphedu.com/dayrui/App/Member/Libraries/Member_auth.php
  64. /www/wwwroot/new.cnphedu.com/config/hooks.php
  65. /www/wwwroot/new.cnphedu.com/dayrui/System/Extend/Hook.php
  66. /www/wwwroot/new.cnphedu.com/dayrui/App/Member/Libraries/Member.php
  67. /www/wwwroot/new.cnphedu.com/dayrui/System/Extend/Cache.php
  68. /www/wwwroot/new.cnphedu.com/dayrui/System/Config/Cache.php
  69. /www/wwwroot/new.cnphedu.com/dayrui/System/Cache/CacheFactory.php
  70. /www/wwwroot/new.cnphedu.com/dayrui/System/Cache/Handlers/FileHandler.php
  71. /www/wwwroot/new.cnphedu.com/dayrui/System/Cache/Handlers/BaseHandler.php
  72. /www/wwwroot/new.cnphedu.com/dayrui/System/Cache/CacheInterface.php
  73. /www/wwwroot/new.cnphedu.com/dayrui/System/Helpers/filesystem_helper.php
  74. /www/wwwroot/new.cnphedu.com/dayrui/System/I18n/Time.php
  75. /www/wwwroot/new.cnphedu.com/dayrui/System/I18n/TimeTrait.php
  76. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/MySQLi/Builder.php
  77. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseBuilder.php
  78. /www/wwwroot/new.cnphedu.com/dayrui/System/Traits/ConditionalTrait.php
  79. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/Query.php
  80. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/QueryInterface.php
  81. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/MySQLi/Result.php
  82. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/BaseResult.php
  83. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/ResultInterface.php
  84. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/Exceptions/DatabaseException.php
  85. /www/wwwroot/new.cnphedu.com/dayrui/System/Exceptions/RuntimeException.php
  86. /www/wwwroot/new.cnphedu.com/dayrui/System/Exceptions/ExceptionInterface.php
  87. /www/wwwroot/new.cnphedu.com/dayrui/System/Database/Exceptions/ExceptionInterface.php
  88. /www/wwwroot/new.cnphedu.com/dayrui/System/Exceptions/HasExitCodeInterface.php
  89. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/ExceptionHandler.php
  90. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/BaseExceptionHandler.php
  91. /www/wwwroot/new.cnphedu.com/dayrui/System/Debug/ExceptionHandlerInterface.php
  92. /www/wwwroot/new.cnphedu.com/dayrui/System/Exceptions/Views/html/error_exception.php