本帖最后由 民审-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 |
作者最近主题
相关贴子
- 我已经付款了
- 【七豆】交友 1.2 DZ学习研究交流(重新采购发布更新)
- Discuz! X3.4 PHP 7.2.0发布 php 7.2更新特性
- 注册短信验证 全功能多接口版阿里大鱼短信接口《注册短信验证》使用手册
- 完美支持安米APP,《注册短信验证》全功能版插件,基于阿里大鱼接口,全新升级
- 仿携程结伴旅游 1.0 DZ学习研究交流
- 自动回帖超人 商业版_7.2 所有马甲数据包 DZ学习研究交流(更新日期03.20)
- 最新赛微Saivi微信营销平台源码v4.21版 全开源+新增订餐打印+多款微信游戏+更新功能
- 织梦[插件模块]DEDECMS TAGS模板选择静态化URL中文路径插件 免费下载
- 在线视频教育手机版 手机版--------下载地址
- 克米19楼大秀场 V1.0--------下载地址
- 我要下载应用,联系客服得不到回复
- SEO静态资源优化 3.0.0 高级版 DZ学习研究交流 专业开源1314
- 【飞鸟】同城活动 运营版 1.1.0 DZ学习研究交流 · 插件
- 百度站内搜索 v2.0.2--------下载地址
- 全站附件下载限制 超值版--------下载地址
- [DZ插件模板] DZ学习研究交流的微信投票插件! x4.0,完全可用,不会没有安装文件了
- 申请【西瓜】一键分享 25.20180330 版本更新
- 【禾今】微信投票 32.0 DZ学习研究交流
- 飞鸟小视频不好正常用,不知道老大可以免费分享一个七豆小视频吗?