MySQL server error repor sql] => select region_id, region_name from `shuguoshijie`.`ecs_region` wher

最新推荐文章于 2024-12-30 23:56:55 发布

原创最新推荐文章于 2024-12-30 23:56:55 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

php 同时被 2 个专栏收录

284 篇文章

订阅专栏

ecshop网店系统二次开发

98 篇文章

订阅专栏

本文记录了一次因SQL语法错误导致的数据库查询问题及两种解决方法：一是通过后台商店设置进行调整；二是清除缓存来解决问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#0 cls_mysql->ErrorMsg() called at [D:\wwwroot\shuguoshijie\wwwroot\includes\cls_mysql.php:274] #1 cls_mysql->query(select region_id, region_name from `shuguoshijie`.`ecs_region` where parent_id=) called at [D:\wwwroot\shuguoshijie\wwwroot\includes\cls_mysql.php:476] #2 cls_mysql->getAll(select region_id, region_name from `shuguoshijie`.`ecs_region` where parent_id=) called at [D:\wwwroot\shuguoshijie\wwwroot\goods.php:372] MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select region_id, region_name from `shuguoshijie`.`ecs_region` where parent_id= ) [2] => Array ( [error] => 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 '' at line 1 ) [3] => Array ( [errno] => 1064 ) )

方法1 后台 -》商店设置