zencart后台管理中选项名称和选项内容和属性控制页面出错解决办法 WARNING: An Error occurred, please refresh the page and try again
2024-09-05 22:40:39
后台管理中选项名称和选项内容和属性控制出现以下错误的解决办法
WARNING: An Error occurred, please refresh the page and try again
zen cart v1.5.1 的一个bug,重新下载更新的zencart安装包,然后取出以下三个文件替换:
admin/attributes_controller.php
admin/option_names_manager.php
admin/option_values_manager.php
或者手工修复如下:
打开文件 /admin/attributes_controller.php
查找
$chk_option_values = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_name = 'TEXT' and products_options_values_id=" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID);
替换为
$chk_option_values = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id=" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID);
查找
$db->Execute("INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, " . (int)$languages[$i]['id'] . ", 'TEXT')");
替换为
$db->Execute("INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) VALUES (" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID . ", " . (int)$languages[$i]['id'] . ", 'TEXT')");
打开文件 /admin/option_names_manager.php
查找
$chk_option_values = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_name = 'TEXT' and products_options_values_id=" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID);
替换为
$chk_option_values = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id=" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID);
查找
$db->Execute("INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, " . (int)$languages[$i]['id'] . ", 'TEXT')");
替换为
$db->Execute("INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) VALUES (" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID . ", " . (int)$languages[$i]['id'] . ", 'TEXT')");
打开文件 /admin/option_values_manager.php
查找
$chk_option_values = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_name = 'TEXT' and products_options_values_id=" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID);
替换为
$chk_option_values = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id=" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID);
查找
$db->Execute("INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, " . (int)$languages[$i]['id'] . ", 'TEXT')");
替换为
$db->Execute("INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) VALUES (" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID . ", " . (int)$languages[$i]['id'] . ", 'TEXT')");
打完收工!
最新文章
- 场景9 深入RAC运行原理
- hibernate快速入门
- ajax 一个 gbk 目标后内容乱码的解决方案
- Java数据结构漫谈-Vector
- Dos命令打印文件以及Dos打印到USB打印端口
- Kotlin基础(二)函数的定义与调用
- windows下安装Mysql—图文详解
- linux下安装mysql解决乱码、时间差、表的大小写问题
- 配置ssm 时, web.xml 文件无 # 自动代码提示
- 『OpenCV3』Mat简介
- os.path.md
- ScreenToGif 代码分析
- wcf服务查看工具
- BZOJ 4448: [Scoi2015]情报传递 树链剖分 主席树
- 转载:30多条mysql数据库优化方法,千万级数据库记录查询轻松解决
- 关于git的reset、checkout、revert
- Dictionary tabPage使用
- 【ajax+php】动态展示4级单位(省、市、县、镇)
- Git—怎样Windows操作系统中安装Git
- iOS学习笔记(三)——iOS系统架构