本帖最后由 民审-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 |
作者最近主题
相关贴子
- Gift商业版DZ学习研究交流求站长加精置顶
- 移动适配伪静态 v1.4.5 移动适配伪静态使用手册.doc
- 云盘链接失效(微信三级分销)
- [深蓝]多商户团购 功能强,人气王4.8--------下载地址
- 微赞安装出错1005无法创建数据库(如图)
- 平安夜之礼-----机锋网橙色风格模板 商业版(首发)
- 【西瓜】微信全套插件:西瓜分类信息、商圈、分站、优惠、砍价、认证、合伙人等说明
- 宣传中心6.2解压密码
- SEO超级伪静态 V3.6.9 高级版 - DZ学习研究交流 · 插件 专业开源[1314]
- 智答-更好用的语音问答 V6.0.4 微擎功能模块
- 什么意思? 开通了提交网站认证好几天不给审核?
- 怎么被踢出站长窝学习研究交流群了
- 火车头企业版分享
- 大美-乐享生活 商业【永久完整版】 DZ学习研究交流
- 微擎商业版点击管理公众号报错Warning: Illegal string offset 'ext' in解决办法
- 【三瑞】电话114 商业版 1.143--------下载地址
- Discuz插件开发提高 PHP 代码质量的 36 计
- 免费网站VIP账号 微信支付版1.7 DZ学习研究交流(开放下载)
- 恩斯道炫彩商业模板双编码版本
- DC帖子付费可见 商业版 v1.1.7--------下载地址