本帖最后由 民审-M 于 2018-3-22 10:17 编辑
【亮剑】云社区APP 1.0.3管理后台报错[backcolor=rgb(243, 243, 243)](1146) Table 'pre_mall_aljsq_type' doesn't exist[/backcolor]解决办法:
[backcolor=magenta]适用于:[/backcolor]
【亮剑】云社区APP gbk版1.0.3 DZ建站学习研究分享
https://bbs.zhanzhangwo.com/t-32875-1-1.html
(出处: 站长窝源码论坛)
站长窝实测演示效果地址:
http://demo.caogen8.co/x/plugin.php?id=aljsq 【手机扫码访问】
如图所示:
系原版安装文件未定义:{$mall_pluginid} 造成:
修复办法:
【亮剑】云社区APP 1.0.3管理后台报错[backcolor=rgb(243, 243, 243)](1146) Table 'pre_mall_aljsq_type' doesn't exist[/backcolor]解决办法:
[backcolor=magenta]适用于:[/backcolor]
【亮剑】云社区APP gbk版1.0.3 DZ建站学习研究分享
https://bbs.zhanzhangwo.com/t-32875-1-1.html
(出处: 站长窝源码论坛)
站长窝实测演示效果地址:
http://demo.caogen8.co/x/plugin.php?id=aljsq 【手机扫码访问】
如图所示:
系原版安装文件未定义:{$mall_pluginid} 造成:
修复办法:
DROP TABLE IF EXISTS `pre_mall_aljsq_data`; DROP TABLE IF EXISTS `pre_mall_aljsq_data_id`; DROP TABLE IF EXISTS `pre_mall_aljsq_data_goods`; DROP TABLE IF EXISTS `pre_mall_aljsq_data_goods_id`; DROP TABLE IF EXISTS `pre_mall_aljsq_setting`; DROP TABLE IF EXISTS `pre_mall_aljsq_setting_id`; DROP TABLE IF EXISTS `pre_mall_aljsq_picture`; DROP TABLE IF EXISTS `pre_mall_aljsq_form_tablecache_log`; DROP TABLE IF EXISTS `pre_mall_aljsq_data_tablecache_log`; DROP TABLE IF EXISTS `pre_mall_aljsq_type`; CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_data` ( `setting_id` int(10) NOT NULL, `setting_name` varchar(255) NOT NULL, `setting_value` text NOT NULL, `setting_type` varchar(255) NOT NULL, `setting_modid` int(10) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_data_id` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mod_id` int(11) NOT NULL, `mod_tablename` varchar(255) NOT NULL, `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_data_goods` ( `setting_id` int(10) NOT NULL, `setting_name` varchar(255) NOT NULL, `setting_value` text NOT NULL, `setting_type` varchar(255) NOT NULL, `setting_modid` int(10) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_data_goods_id` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mod_id` int(11) NOT NULL, `mod_tablename` varchar(255) NOT NULL, `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_setting` ( `setting_id` int(10) NOT NULL, `setting_name` varchar(255) NOT NULL, `setting_value` text NOT NULL, `setting_type` varchar(255) NOT NULL, `setting_modid` int(10) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_setting_id` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mod_id` int(11) NOT NULL, `mod_tablename` varchar(255) NOT NULL, `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_picture` ( `picture_id` int(10) NOT NULL AUTO_INCREMENT, `picture_mod_id` int(10) NOT NULL, `picture_mod_aid` int(10) NOT NULL, `picture_type` varchar(255) NOT NULL, `picture_path` varchar(255) NOT NULL, `picture_width` int(10) NOT NULL, `picture_height` int(10) NOT NULL, `picture_size` int(10) NOT NULL, `picture_createtime` int(10) NOT NULL, PRIMARY KEY (`picture_id`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_form_tablecache_log` ( `log_modid` int(10) NOT NULL, `log_datatablename` varchar(255) NOT NULL, `log_cachetablename` varchar(255) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL, `finished` int(10) NOT NULL, PRIMARY KEY (`log_modid`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_data_tablecache_log` ( `log_modid` int(10) NOT NULL, `log_datatablename` varchar(255) NOT NULL, `log_cachetablename` varchar(255) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL, `finished` int(10) NOT NULL, PRIMARY KEY (`log_modid`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_type` ( `type_id` int(10) NOT NULL AUTO_INCREMENT, `type_upid` int(10) NOT NULL, `type_name` varchar(255) NOT NULL, `type_displayorder` int(10) NOT NULL, `type_modid` int(10) NOT NULL, `type_logo` varchar(255) NOT NULL, PRIMARY KEY (`type_id`) ); ALTER TABLE `pre_mall_aljsq_setting` ADD PRIMARY KEY (`setting_id`,`setting_name`,`setting_modid`); ALTER TABLE `pre_mall_aljsq_data` ADD PRIMARY KEY (`setting_id`,`setting_name`,`setting_modid`); ALTER TABLE `pre_mall_aljsq_data_goods` ADD PRIMARY KEY (`setting_id`,`setting_name`,`setting_modid`); ALTER TABLE `pre_mall_aljsq_data_id` auto_increment = 1000; ALTER TABLE `pre_mall_aljsq_data_goods_id` auto_increment = 1000; ALTER TABLE `pre_mall_aljsq_setting_id` auto_increment = 1000; ALTER TABLE `pre_mall_aljsq_picture` auto_increment = 1000; ALTER TABLE `pre_mall_aljsq_type` auto_increment = 1000; INSERT INTO `pre_mall_aljsq_setting` (`setting_id`, `setting_name`, `setting_value`, `setting_type`, `setting_modid`, `create_time`, `update_time`) VALUES (1, 'name', 'cache_on', 'address', 3, 1492158958, 1492159160), (1, 'title', '清空缓存', 'address', 3, 1492158958, 1492159160), (1, 'formtype', '5', 'address', 3, 1492158958, 1492159160), (1, 'binddata', '1=是{$install_eol}2=否=default', 'address', 3, 1492158958, 1492159160), (1, 'bindtype', '', 'address', 3, 1492158958, 1492159160), (1, 'placeholder', '', 'address', 3, 1492158958, 1492159160), (1, 'columntype', '2', 'address', 3, 1492158958, 1492159160), (1, 'hide', '0', 'address', 3, 1492158958, 1492159160), (1, 'search', '0', 'address', 3, 1492158958, 1492159160), (1, 'menu_on', '0', 'address', 3, 1492158958, 1492159160), (1, 'used', '1', 'address', 3, 1492158958, 1492159160), (1, 'list', '1', 'address', 3, 1492158958, 1492159160), (2, 'name', 'nav_on', 'address', 3, 1492065249, 1492065610), (2, 'title', '菜单是否显示', 'address', 3, 1492065249, 1492065610), (2, 'formtype', '5', 'address', 3, 1492065249, 1492065610), (2, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 1492065249, 1492065610), (2, 'bindtype', '', 'address', 3, 1492065249, 1492065610), (2, 'placeholder', '', 'address', 3, 1492065249, 1492065610), (2, 'columntype', '2', 'address', 3, 1492065249, 1492065610), (2, 'hide', '0', 'address', 3, 1492065249, 1492065610), (2, 'used', '1', 'address', 3, 1492065249, 1492065610), (2, 'list', '1', 'address', 3, 1492065249, 1492065610), (3, 'name', 'search_on', 'address', 3, 149206526, 1492065616), (3, 'title', '搜索是否显示', 'address', 3, 149206526, 1492065616), (3, 'formtype', '5', 'address', 3, 149206526, 1492065616), (3, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 149206526, 1492065616), (3, 'bindtype', '', 'address', 3, 149206526, 1492065616), (3, 'placeholder', '', 'address', 3, 149206526, 1492065616), (3, 'columntype', '2', 'address', 3, 149206526, 1492065616), (3, 'hide', '0', 'address', 3, 149206526, 1492065616), (3, 'used', '1', 'address', 3, 149206526, 1492065616), (3, 'list', '1', 'address', 3, 149206526, 1492065616), (4, 'name', 'list_on', 'address', 3, 149206553, 1492140873), (4, 'title', '关闭列表页,绑定setting_id', 'address', 3, 149206553, 1492140873), (4, 'formtype', '2', 'address', 3, 149206553, 1492140873), (4, 'binddata', '', 'address', 3, 149206553, 1492140873), (4, 'bindtype', '', 'address', 3, 149206553, 1492140873), (4, 'placeholder', '', 'address', 3, 149206553, 1492140873), (4, 'columntype', '2', 'address', 3, 149206553, 1492140873), (4, 'hide', '0', 'address', 3, 149206553, 1492140873), (4, 'used', '1', 'address', 3, 149206553, 1492140873), (4, 'list', '1', 'address', 3, 149206553, 1492140873), (5, 'name', 'edit_on', 'address', 3, 1492065371, 1492065625), (5, 'title', '是否允许编辑', 'address', 3, 1492065371, 1492065625), (5, 'formtype', '5', 'address', 3, 1492065371, 1492065625), (5, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 1492065371, 1492065625), (5, 'bindtype', '', 'address', 3, 1492065371, 1492065625), (5, 'placeholder', '', 'address', 3, 1492065371, 1492065625), (5, 'columntype', '2', 'address', 3, 1492065371, 1492065625), (5, 'hide', '0', 'address', 3, 1492065371, 1492065625), (5, 'used', '1', 'address', 3, 1492065371, 1492065625), (5, 'list', '1', 'address', 3, 1492065371, 1492065625), (6, 'name', 'delete_on', 'address', 3, 1492065398, 149206561), (6, 'title', '是否允许删除', 'address', 3, 1492065398, 149206561), (6, 'formtype', '5', 'address', 3, 1492065398, 149206561), (6, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 1492065398, 149206561), (6, 'bindtype', '', 'address', 3, 1492065398, 149206561), (6, 'placeholder', '', 'address', 3, 1492065398, 149206561), (6, 'columntype', '2', 'address', 3, 1492065398, 149206561), (6, 'hide', '0', 'address', 3, 1492065398, 149206561), (6, 'used', '1', 'address', 3, 1492065398, 149206561), (6, 'list', '1', 'address', 3, 1492065398, 149206561), (7, 'name', 'navid', 'address', 3, 1492067142, 149206748), (7, 'title', '接收菜单ID', 'address', 3, 1492067142, 149206748), (7, 'formtype', '8', 'address', 3, 1492067142, 149206748), (7, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 1492067142, 149206748), (7, 'bindtype', '', 'address', 3, 1492067142, 149206748), (7, 'placeholder', '', 'address', 3, 1492067142, 149206748), (7, 'columntype', '2', 'address', 3, 1492067142, 149206748), (7, 'hide', '0', 'address', 3, 1492067142, 149206748), (7, 'used', '1', 'address', 3, 1492067142, 149206748), (7, 'list', '1', 'address', 3, 1492067142, 149206748), (8, 'name', 'table_on', 'address', 3, 1492071096, 1492071096), (8, 'title', '选择数据表', 'address', 3, 1492071096, 1492071096), (8, 'formtype', '4', 'address', 3, 1492071096, 1492071096), (8, 'binddata', '1=mall_aljsq_data=default{$install_eol}2=mall_aljsq_data_goods', 'address', 3, 1492071096, 1492071096), (8, 'bindtype', '', 'address', 3, 1492071096, 1492071096), (8, 'placeholder', '', 'address', 3, 1492071096, 1492071096), (8, 'columntype', '2', 'address', 3, 1492071096, 1492071096), (8, 'hide', '0', 'address', 3, 1492071096, 1492071096), (8, 'used', '1', 'address', 3, 1492071096, 1492071096), (8, 'list', '1', 'address', 3, 1492071096, 1492071096), (9, 'name', 'menu_on', 'address', 3, 1492145511, 1492145511), (9, 'title', '是否将状态显示在TAB菜单中', 'address', 3, 1492145511, 1492145511), (9, 'formtype', '5', 'address', 3, 1492145511, 1492145511), (9, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 1492145511, 1492145511), (9, 'bindtype', '', 'address', 3, 1492145511, 1492145511), (9, 'placeholder', '', 'address', 3, 1492145511, 1492145511), (9, 'columntype', '2', 'address', 3, 1492145511, 1492145511), (9, 'hide', '0', 'address', 3, 1492145511, 1492145511), (9, 'search', '0', 'address', 3, 1492145511, 1492145511), (9, 'used', '1', 'address', 3, 1492145511, 1492145511), (9, 'list', '1', 'address', 3, 1492145511, 1492145511), (10, 'displayorder', '2', 'address', 3, 1494430053, 1494430077), (10, 'title', '是否允许添加', 'address', 3, 1494430053, 1494430053), (10, 'name', 'add_on', 'address', 3, 1494430053, 1494430053), (10, 'formtype', '5', 'address', 3, 1494430053, 1494430053), (10, 'max', '', 'address', 3, 1494430053, 1494430053), (10, 'binddata', '1=是=default{$install_eol}2=否', 'address', 3, 1494430053, 1494430053), (10, 'bindtype', '', 'address', 3, 1494430053, 1494430053), (10, 'placeholder', '', 'address', 3, 1494430053, 1494430053), (10, 'columntype', '2', 'address', 3, 1494430053, 1494430053), (10, 'hide', '0', 'address', 3, 1494430053, 1494430053), (10, 'search', '0', 'address', 3, 1494430053, 1494430053), (10, 'menu_on', '0', 'address', 3, 1494430053, 1494430053), (10, 'used', '1', 'address', 3, 1494430053, 1494430053), (10, 'list', '1', 'address', 3, 1494430053, 1494430053); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (1, 1, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (2, 2, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (3, 3, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (4, 4, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (5, 5, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (6, 6, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (7, 7, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (8, 8, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (9, 9, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_setting_id` (`id`, `mod_id`, `mod_tablename`, `create_time`, `update_time`) VALUES (10, 10, 'mall_aljsq_setting', {$install_timestamp}, {$install_timestamp}); INSERT INTO `pre_mall_aljsq_type` (`type_id`, `type_upid`, `type_name`, `type_displayorder`, `type_modid`, `type_logo`) VALUES (1, 0, '社区后台', 1, 1, ''); INSERT INTO `pre_mall_aljsq_type` (`type_id`, `type_upid`, `type_name`, `type_displayorder`, `type_modid`, `type_logo`) VALUES (2, 1, '菜单权限', 1, 1, ''); INSERT INTO `pre_mall_aljsq_type` (`type_id`, `type_upid`, `type_name`, `type_displayorder`, `type_modid`, `type_logo`) VALUES (3, 2, '菜单权限', 1, 1, ''); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_formsetting_cache_3` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `formtype` varchar(255) NOT NULL, `binddata` varchar(255) NOT NULL, `bindtype` varchar(255) NOT NULL, `placeholder` varchar(255) NOT NULL, `columntype` varchar(255) NOT NULL, `hide` int(10) NOT NULL, `search` int(10) NOT NULL, `menu_on` int(10) NOT NULL, `used` varchar(255) NOT NULL, `list` int(10) NOT NULL, `setting_typeid` int(10) NOT NULL, `setting_id` int(10) NOT NULL, `setting_type` varchar(255) NOT NULL, `setting_modid` int(10) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE IF NOT EXISTS `pre_mall_aljsq_data_cache_3` ( `id` int(10) NOT NULL AUTO_INCREMENT, `nav_on` int(10) NOT NULL, `search_on` int(10) NOT NULL, `list_on` int(10) NOT NULL, `edit_on` int(10) NOT NULL, `delete_on` int(10) NOT NULL, `navid` int(10) NOT NULL, `table_on` int(10) NOT NULL, `menu_on` int(10) NOT NULL, `cache_on` int(10) NOT NULL, `setting_id` int(10) NOT NULL, `setting_type` varchar(255) NOT NULL, `setting_modid` int(10) NOT NULL, `create_time` int(10) NOT NULL, `update_time` int(10) NOT NULL, PRIMARY KEY (`id`) );
收藏的用户(0)
X
正在加载信息~
评论
发新帖
主题数 4876 |
帖子数 11296 |
精华数 0 |
注册排名 88 |
作者最近主题
相关贴子
- 我的帐号老是被迫下线
- 商品拍卖 V2.0版 带延迟拍卖组件 DZ学习研究交流+
- 摇一摇积分抽奖 增值版2.0
- 微擎微赞模块抖抖赢口红v2.3.6公众号H5端WAP端
- 搜狐新闻自动采集 V10.01.05自动采集 - DZ学习研究交流 · 插件 专业开源[1314]
- 申请采购手机修改头像资料 1.4
- 求神奇宝贝宠物养成X3GBK版!论坛里面的是UFT8版。我转码之后还是不能。。。
- [1314]超级手机导航 v2.0.4 商业版 - DZ学习研究交流 · 插件 专业开源[1314]
- 全民话题讨论投票 V7.180508
- 克米19楼广播台 V1.0--------下载地址
- 这个插件能不能帮忙关注下
- VIP用户组在线购买加蓝色模板
- 旅游社区主题系列 商业版GBK_15.04.12 DZ学习研究交流
- 微赞商业版 V69.3更新:修复【超人】看房功能(修复分享设置/模板信息设置缺失
- 积分申请开通学习研究交流会员
- it618推广佣金联盟v1.7补丁(修复首页加载不出来bug)
- 自驾越野/骑行分享 商业版GBK--------下载地址
- 微信公众号手机模板 Wx商业版GBK 含diy和模板教程
- 俊目的窗户 2279583091 已记录
- 第六团:品牌空间+大众点评 双系统2合1出售(暂不提供下载)