本帖最后由 民审-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 |
作者最近主题
相关贴子
- 站长窝会员体验后的反馈
- SEO百度熊掌号推送 V3.6.4 - DZ学习研究交流 · 插件 专业开源[1314]
- 克米19楼今日热点 赞助版V1.0商业版 免费下载(02-21更新)
- discuz x3.4数据库引擎InnoDB和MyISAM的比较优势
- 超宽频简洁摄影模板 摄影网宽频模板-------下载地址
- 万能小程序拖拽式在线制作小程序,自带200套各行业模块,轻松制作任何小程序
- 网盘附件免跳转下载 商业版V5.1(2016.2.19更新)--------下载地址
- 简约仿制pw模板
- 关于 克米帖子二维码 V2.0
- 【亮剑】二手市场 PC+移动版v3.3.5 DZ学习研究交流 · 插件
- 申请【西瓜】分类信息 69.20180531版本更新
- DC帖子付费可见 商业版v1.1.8
- 我支付学习研究交流会员为什么还是没有
- 求SEO超级伪静态 V3.5.1插件
- 【西瓜】分类信息 71.20180614 DZ学习研究交流(站长窝魔方解密全网首发)
- 新版UI短视频点赞任务系统完美运营级别+等级功能+信誉积分+保证金
- 万能投票 正式版v5.38--------下载地址
- 【DZ插件】公众号吸粉看帖密码 1.0.0(文件验证md5密码版)
- 某宝买的WordPress大门户新闻采集站附带免费采集插件
- NVBING5动漫门户 商业版-GBK和商业版-UTF-8 DZ学习研究交流