我这个语句为什么报错了我用方法我应该怎么改
迅睿框架 更新 2021-02-26 10:13:15
晓猛seo
晓猛seo
{php $query=urlencode('select * from dede_archives where id in(12,16,14,18)');}
{sql db=dede sql='$query'}
<p>
<a href="{$t.url}" target="_blank" title="{$t.title}">
{$t.title}
</a><em>{$t.pubdate}</em>
</p>
{/sql}我这个语句为什么报错了，我用id in 方法 我应该怎么改
ERROR - 2021-02-09 12:49:58 --> Error connecting to the database: Access denied for user '****'@'%' to database 'dede' CRITICAL - 2021-02-09 12:49:58 --> Unable to connect to the database. #SQL：SELECT * FROM `dr_1_school` WHERE `dr_1_school`.`catid` = 2 AND `dr_1_school`.`status` = 9 ORDER BY `dr_1_school`.`updatetime` DESC #URL：http://wz.entem.cn/index.php?c=html&m=category&ids=&pp=1 #AGENT：Mozilla/5.0 (Windows NT 10.0 Win64 x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36 #REFERER：http://wz.entem.cn/admin.php?c=html&m=category_index& #0 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(602): CodeIgniter\Database\BaseConnection->initialize() #1 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(2143): CodeIgniter\Database\BaseConnection->query() #2 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(1047): Phpcmf\View->_query() #3 /wwwroot/xunruiCMS/cache/template/template_pc_newmoban_home_xila.html.cache.php(350): Phpcmf\View->list_tag() #4 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(222): include('/wwwroot/xunrui...') #5 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(215): Phpcmf\View->display() #6 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(638): Phpcmf\Home\Module->_Category() #7 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(978): Phpcmf\Home\Module->_Create_Category_Html() #8 /wwwroot/xunruiCMS/dayrui/Core/Controllers/Html.php(15): Phpcmf\Home\Module->_Category_Html() #9 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->category() #10 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController() #11 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest() #12 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run() #13 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...') #14 {main}ERROR - 2021-02-09 14:13:37 --> Error connecting to the database: Access denied for user '****'@'%' to database 'dede' CRITICAL - 2021-02-09 14:13:37 --> Unable to connect to the database. #SQL：SELECT * FROM `dr_1_school` WHERE `dr_1_school`.`catid` = 2 AND `dr_1_school`.`status` = 9 ORDER BY `dr_1_school`.`updatetime` DESC #URL：http://wz.entem.cn/index.php?c=html&m=category&ids=&pp=1 #AGENT：Mozilla/5.0 (Windows NT 10.0 Win64 x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36 #REFERER：http://wz.entem.cn/admin.php?c=html&m=category_index& #0 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(602): CodeIgniter\Database\BaseConnection->initialize() #1 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(2143): CodeIgniter\Database\BaseConnection->query() #2 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(1047): Phpcmf\View->_query() #3 /wwwroot/xunruiCMS/cache/template/template_pc_newmoban_home_xila.html.cache.php(350): Phpcmf\View->list_tag() #4 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(222): include('/wwwroot/xunrui...') #5 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(215): Phpcmf\View->display() #6 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(638): Phpcmf\Home\Module->_Category() #7 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(978): Phpcmf\Home\Module->_Create_Category_Html() #8 /wwwroot/xunruiCMS/dayrui/Core/Controllers/Html.php(15): Phpcmf\Home\Module->_Category_Html() #9 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->category() #10 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController() #11 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest() #12 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run() #13 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...') #14 {main}是我根据这个设置得到 我以为cms2是随便起的 后来通过测试这个要填写数据库名称 已经解决了 谢谢