2025-12-30 14:21:30 — PHP8.1.34 — sitemap.txt

CodeIgniter\Database\Exceptions\DatabaseException #1271

Illegal mix of collations for operation 'UNION'
SELECT url,updatetime,mid FROM (SELECT url,updatetime,'product' AS mid FROM `dr_1_product` UNION ALL SELECT url,updatetime,'news' AS mid FROM `dr_1_news` UNION ALL SELECT url,updatetime,'cases' AS mid FROM `dr_1_cases` UNION ALL SELECT url,updatetime,'screeningpic' AS mid FROM `dr_1_screeningpic` ) as my order by updatetime desc limit 1000

/var/www/www.jsjhdz.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 #1271
    Illegal mix of collations for operation 'UNION'    
    /var/www/www.jsjhdz.com/dayrui/System/Database/MySQLi/Connection.php:332    
    Caused by:
    mysqli_sql_exception #1271
    Illegal mix of collations for operation 'UNION'    
    /var/www/www.jsjhdz.com/dayrui/System/Database/MySQLi/Connection.php:327    
  1. /var/www/www.jsjhdz.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. /var/www/www.jsjhdz.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. /var/www/www.jsjhdz.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. /var/www/www.jsjhdz.com/dayrui/App/Sitemap/Models/Sitemap.php : 378   —  CodeIgniter\Database\BaseConnection->query ()

    371             } else {
    372                 $sql.=' limit '.(($page 1) * $pagesize).','.$pagesize;
    373             }
    374         }
    375 
    376         $data = [];
    377 
    378         $query = $this->db->query($sql);
    379         if ($query) {
    380             $rows $query->getResultArray();
    381             if ($rows) {
    382                 foreach ($rows as $t) {
    383                     if (!$t['url']) {
    384                         continue;
    385                     }
    
  5. /var/www/www.jsjhdz.com/dayrui/App/Sitemap/Models/Sitemap.php : 292   —  Phpcmf\Model\Sitemap\Sitemap->_sitemap_module_data ()

    285                                 }
    286                             }
    287                         }
    288                         $config['sitemap'][$mid] = 0;
    289                     }
    290                 }
    291 
    292                 $data = $this->_sitemap_module_data($siteid, $config['sitemap'], $page, $pagesize, $limit);
    293                 if ($data) {
    294                     /*
    295                     usort($data, function($a, $b) {
    296                         if ($a['time'] == $b['time'])
    297                             return 0;
    298                         return ($a['time'] > $b['time']) ? -1 : 1;
    299                     });*/
    
  6. /var/www/www.jsjhdz.com/dayrui/App/Sitemap/Controllers/Home.php : 11   —  Phpcmf\Model\Sitemap\Sitemap->sitemap_txt ()

     4 {
     5 
     6     public function index() {
     7         header('Content-Type: text/plain');
     8         echo \Phpcmf\Service::M('sitemap''sitemap')->sitemap_txt(
     9             max(1intval($_GET['p'])),
    10             dr_safe_filename($_GET['mid']),
    11             intval($_GET['catid'])
    12         );exit;
    13     }
    14 
    15     public function xml() {
    16         header('Content-Type: text/xml');
    17         echo \Phpcmf\Service::M('sitemap''sitemap')->sitemap_xml(
    18             max(1intval($_GET['p'])),
    
  7. /var/www/www.jsjhdz.com/dayrui/System/Extend/Run.php : 148   —  Phpcmf\Controllers\Home->index ()

    141                         'value' => $value
    142                     ]);
    143 
    144                 }
    145             }
    146         }
    147 
    148         $app->$method();
    149 
    150         if (CI_DEBUG) {
    151             $tool = new \CodeIgniter\Debug\Toolbar(config(\Config\Toolbar::class));
    152             $tool->prepare($this);
    153         }
    154         
    155        
    
  8. /var/www/www.jsjhdz.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 /var/www/www.jsjhdz.com/dayrui/Fcms/Init.php   —   require()

  10. require /var/www/www.jsjhdz.com/public/index.php   —   require()

$_SERVER

Key Value
USER www-data
HOME /var/www
HTTP_HOST www.jsjhdz.com
HTTP_REFERER http://www.jsjhdz.com/sitemap.txt
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 */*
REDIRECT_STATUS 200
SERVER_NAME www.jsjhdz.com
SERVER_PORT 443
SERVER_ADDR 10.0.0.44
REMOTE_PORT 20885
REMOTE_ADDR 216.73.216.84
SERVER_SOFTWARE nginx/1.29.4
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/2.0
DOCUMENT_ROOT /var/www/www.jsjhdz.com/public
DOCUMENT_URI /index.php
REQUEST_URI /sitemap.txt
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING
SCRIPT_NAME /index.php
SCRIPT_FILENAME /var/www/www.jsjhdz.com/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT
1767075690.7306
REQUEST_TIME
1767075690

Constants

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

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

                                                                    
IS_POST

                                                                    
IS_AJAX_POST

                                                                    
SYS_TIME
1767075690
SYS_DEBUG
0
SYS_ADMIN_CODE
0
SYS_ADMIN_LOG
1
SYS_AUTO_FORM
0
SYS_ADMIN_PAGESIZE
100
SYS_CRON_AUTH
SYS_TABLE_ISFOOTER
0
SYS_SMS_IMG_CODE
0
SYS_GO_404
0
SYS_THEME_ROOT_PATH
0
SYS_301
0
SYS_NOT_UPDATE
1
SYS_URL_ONLY
0
SYS_URL_REL
0
SYS_KEY PHPCMFABE4CB7A5DCE9
SYS_API_TOKEN
SYS_CSRF
1
SYS_CSRF_TIME
1
SYS_API_REL
0
SYS_HTTPS
1
SYS_NOT_ADMIN_CACHE
0
SYS_ADMIN_MODE
0
SYS_ADMIN_LOGINS
10
SYS_ADMIN_LOGIN_AES
SYS_ATTACHMENT_DOWN_REMOTE
SYS_ATTACHMENT_DOWN_SIZE
SYS_ADMIN_LOGIN_TIME
0
SYS_LOGIN_AES
0
SYS_ADMIN_OAUTH
0
SYS_ADMIN_SMS_LOGIN
0
SYS_ADMIN_SMS_CHECK
0
SYS_ATTACHMENT_DB
1
SYS_ATTACHMENT_PAGESIZE
100
SYS_ATTACHMENT_GUEST
0
SYS_ATTACHMENT_CF
1
SYS_ATTACHMENT_REL
0
SYS_ATTACHMENT_PATH
SYS_ATTACHMENT_SAVE_TYPE
0
SYS_ATTACHMENT_SAVE_DIR
SYS_ATTACHMENT_SAVE_ID
0
SYS_ATTACHMENT_URL
SYS_AVATAR_PATH
SYS_AVATAR_URL
SYS_API_CODE
0
SYS_ATTACHMENT_SAFE
0
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
72
SYS_CACHE_LIST
72
SYS_CACHE_SEARCH
72
SYS_CACHE_SMS
0
SYS_CACHE_CRON
3
SYS_CACHE_CLEAR
1
FC_NOW_URL https://www.jsjhdz.com/sitemap.txt
FC_NOW_HOST https://www.jsjhdz.com/
DOMAIN_NAME www.jsjhdz.com
WEB_DIR /
CMSURI sitemap.txt
IS_API

                                                                    
IS_USE_MEMBER /var/www/www.jsjhdz.com/dayrui/App/Member/
IS_USE_MODULE /var/www/www.jsjhdz.com/dayrui/App/Module/
APPPATH /var/www/www.jsjhdz.com/dayrui/App/Sitemap/
APP_DIR sitemap
IS_MEMBER

                                                                    
IS_HOME
1
FRAME_PHP_VERSION 8.1
FRAME_NAME CodeIgniter
FRAME_VERSION 4.2
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 网商CMS
CMF_VERSION 4.7.1.20251215
CMF_UPDATE_TIME 1767075531
SITE_ID
1
SITE_URL https://www.jsjhdz.com/
SITE_MURL https://www.jsjhdz.com/
SITE_NAME 江苏金涵电子有限公司
SITE_LOGO /static/assets/logo-web.png
SITE_IS_MOBILE
0
SITE_IS_MOBILE_HTML
0
SITE_MOBILE_DIR mobile
SITE_MOBILE_NOT_PAD
0
SITE_THUMB_WATERMARK
0
SITE_THEME jinhan
SITE_SEOJOIN -
SITE_REWRITE
0
SITE_TEMPLATE jinhan
SITE_LANGUAGE zh-cn
SITE_TIME_FORMAT Y-m-d H:i:s
ADMIN_URL https://www.jsjhdz.com/
PAY_URL https://www.jsjhdz.com/
ROOT_URL https://www.jsjhdz.com/
OAUTH_URL https://www.jsjhdz.com/
THEME_PATH https://www.jsjhdz.com/static/
LANG_PATH https://www.jsjhdz.com/api/language/zh-cn/
ROOT_THEME_PATH https://www.jsjhdz.com/static/
HOME_THEME_PATH https://www.jsjhdz.com/static/jinhan/
MOBILE_THEME_PATH https://www.jsjhdz.com/static/jinhan/
SYS_UPLOAD_PATH /var/www/www.jsjhdz.com/public/uploadfile/
SYS_UPLOAD_URL https://www.jsjhdz.com/uploadfile/
CLIENT_URL https://www.jsjhdz.com/
CLIENT_NAME pc
IS_CLIENT
MEMBER_URL https://www.jsjhdz.com/index.php?s=member
SITE_FID
0
MEMBER_CNAME 姓名
SITE_ICP 苏ICP备19028378号
SITE_TONGJI
SITE_LOGIN_TIME
36000
SITE_SCORE 金币
SITE_EXPERIENCE 经验
IS_API_HTTP
0
USER_HTTP_CODE ef7207fe35205fa5f45d294d113818cb
  1. /var/www/www.jsjhdz.com/public/index.php
  2. /var/www/www.jsjhdz.com/dayrui/Fcms/Init.php
  3. /var/www/www.jsjhdz.com/config/custom.php
  4. /var/www/www.jsjhdz.com/cache/config/system.php
  5. /var/www/www.jsjhdz.com/cache/config/cache.php
  6. /var/www/www.jsjhdz.com/config/rewrite.php
  7. /var/www/www.jsjhdz.com/cache/config/domain_app.php
  8. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/Helper.php
  9. /var/www/www.jsjhdz.com/dayrui/System/Init.php
  10. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/Auto.php
  11. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/Service.php
  12. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/Hooks.php
  13. /var/www/www.jsjhdz.com/dayrui/System/Extend/Run.php
  14. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/Phpcmf.php
  15. /var/www/www.jsjhdz.com/dayrui/System/Extend/Controller.php
  16. /var/www/www.jsjhdz.com/dayrui/App/Ueditor/Config/Filters.php
  17. /var/www/www.jsjhdz.com/dayrui/App/Member/Config/Hooks.php
  18. /var/www/www.jsjhdz.com/dayrui/App/Form/Config/Auto.php
  19. /var/www/www.jsjhdz.com/dayrui/App/Tag/Config/Hooks.php
  20. /var/www/www.jsjhdz.com/dayrui/App/Module/Config/Auto.php
  21. /var/www/www.jsjhdz.com/dayrui/App/Module/Config/Hooks.php
  22. /var/www/www.jsjhdz.com/dayrui/App/Module/Config/Filters.php
  23. /var/www/www.jsjhdz.com/dayrui/System/Config/Services.php
  24. /var/www/www.jsjhdz.com/dayrui/System/Config/BaseService.php
  25. /var/www/www.jsjhdz.com/dayrui/System/Config/Factories.php
  26. /var/www/www.jsjhdz.com/dayrui/System/Config/Factory.php
  27. /var/www/www.jsjhdz.com/dayrui/System/Config/BaseConfig.php
  28. /var/www/www.jsjhdz.com/dayrui/System/Config/Exceptions.php
  29. /var/www/www.jsjhdz.com/dayrui/System/Debug/Exceptions.php
  30. /var/www/www.jsjhdz.com/dayrui/System/Events/Events.php
  31. /var/www/www.jsjhdz.com/dayrui/System/Debug/Timer.php
  32. /var/www/www.jsjhdz.com/dayrui/System/Config/Toolbar.php
  33. /var/www/www.jsjhdz.com/dayrui/System/Debug/Toolbar.php
  34. /var/www/www.jsjhdz.com/dayrui/System/Debug/Toolbar/Collectors/Database.php
  35. /var/www/www.jsjhdz.com/dayrui/System/Debug/Toolbar/Collectors/BaseCollector.php
  36. /var/www/www.jsjhdz.com/dayrui/System/Config/Database.php
  37. /var/www/www.jsjhdz.com/dayrui/System/Database/Config.php
  38. /var/www/www.jsjhdz.com/dayrui/System/Debug/Toolbar/Collectors/Views.php
  39. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/View.php
  40. /var/www/www.jsjhdz.com/dayrui/System/Debug/Toolbar/Collectors/Files.php
  41. /var/www/www.jsjhdz.com/dayrui/System/Debug/Toolbar/Collectors/Routes.php
  42. /var/www/www.jsjhdz.com/dayrui/App/Sitemap/Controllers/Home.php
  43. /var/www/www.jsjhdz.com/cache/config/site.php
  44. /var/www/www.jsjhdz.com/dayrui/My/Config/Version.php
  45. /var/www/www.jsjhdz.com/dayrui/Fcms/Library/Cache.php
  46. /var/www/www.jsjhdz.com/dayrui/Fcms/Library/Lang.php
  47. /var/www/www.jsjhdz.com/public/api/language/zh-cn/lang.php
  48. /var/www/www.jsjhdz.com/dayrui/Fcms/Library/Input.php
  49. /var/www/www.jsjhdz.com/dayrui/Fcms/Library/Security.php
  50. /var/www/www.jsjhdz.com/dayrui/Fcms/Model/Member.php
  51. /var/www/www.jsjhdz.com/dayrui/Fcms/Core/Model.php
  52. /var/www/www.jsjhdz.com/dayrui/System/Extend/Model.php
  53. /var/www/www.jsjhdz.com/config/database.php
  54. /var/www/www.jsjhdz.com/dayrui/System/Database/Database.php
  55. /var/www/www.jsjhdz.com/dayrui/System/Database/MySQLi/Connection.php
  56. /var/www/www.jsjhdz.com/dayrui/System/Database/BaseConnection.php
  57. /var/www/www.jsjhdz.com/dayrui/System/Database/ConnectionInterface.php
  58. /var/www/www.jsjhdz.com/dayrui/App/Module/Config/Run.php
  59. /var/www/www.jsjhdz.com/cache/config/domain_client.php
  60. /var/www/www.jsjhdz.com/public/api/fclient/sync.php
  61. /var/www/www.jsjhdz.com/dayrui/Fcms/Library/Router.php
  62. /var/www/www.jsjhdz.com/dayrui/App/Member/Libraries/Member_auth.php
  63. /var/www/www.jsjhdz.com/config/hooks.php
  64. /var/www/www.jsjhdz.com/dayrui/System/Extend/Hook.php
  65. /var/www/www.jsjhdz.com/dayrui/App/Member/Libraries/Member.php
  66. /var/www/www.jsjhdz.com/dayrui/App/Sitemap/Models/Sitemap.php
  67. /var/www/www.jsjhdz.com/cache/config/sitemap.php
  68. /var/www/www.jsjhdz.com/cache/config/domain_site.php
  69. /var/www/www.jsjhdz.com/dayrui/App/Module/Libraries/Category.php
  70. /var/www/www.jsjhdz.com/dayrui/System/Database/Query.php
  71. /var/www/www.jsjhdz.com/dayrui/System/Database/QueryInterface.php
  72. /var/www/www.jsjhdz.com/dayrui/System/Database/MySQLi/Result.php
  73. /var/www/www.jsjhdz.com/dayrui/System/Database/BaseResult.php
  74. /var/www/www.jsjhdz.com/dayrui/System/Database/ResultInterface.php
  75. /var/www/www.jsjhdz.com/dayrui/System/Database/Exceptions/DatabaseException.php
  76. /var/www/www.jsjhdz.com/dayrui/System/Exceptions/RuntimeException.php
  77. /var/www/www.jsjhdz.com/dayrui/System/Exceptions/ExceptionInterface.php
  78. /var/www/www.jsjhdz.com/dayrui/System/Database/Exceptions/ExceptionInterface.php
  79. /var/www/www.jsjhdz.com/dayrui/System/Exceptions/HasExitCodeInterface.php
  80. /var/www/www.jsjhdz.com/dayrui/System/Debug/ExceptionHandler.php
  81. /var/www/www.jsjhdz.com/dayrui/System/Debug/BaseExceptionHandler.php
  82. /var/www/www.jsjhdz.com/dayrui/System/Debug/ExceptionHandlerInterface.php
  83. /var/www/www.jsjhdz.com/dayrui/System/Exceptions/Views/html/error_exception.php