本帖最后由 民审-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 |
作者最近主题
相关贴子
- 公司企业_餐饮美食 商业版-------下载地址
- DZ学习研究交流的我的勋章 3.8 商业版 再次升级
- DX2.5克米19楼风格,自己从2.0升级上来的,附带多出美化
- 搜索引擎友好的图片 标准版4.0.2--------下载地址
- 仿电视台滚动字幕 商业版(11.12更新)--------下载地址
- dz论坛生成文章报错(1054) Unknown column 'pro' in 'where clause'解决办法
- 登录地点异常?
- 一元云购系统v3.1.8商业版|一元云购程序v3.1.8手机WAP版微信支付
- 求论坛用的每日签到插件
- 积分提现银行余额宝 201607160000全组件刷单版(1146) Table 'lev_bank_yycode'does...
- [万美]美化个人设置 1.120141215
- 链接失效:[1314]SEO超级PING V3.1.0商业版
- 希望能增加个和万能下载系统(PHPxms)差不多的源码 谢谢
- 某宝买的正宗烧烤技术配方培训视频教程
- 亮剑猜拳和赌大小插件什么时候有呢?
- 用户组每天免费下载收费附件次数限制 1.1 DZ学习研究交流(06.27更新)
- 申请【视频课堂直播点播 】 高级教育版v4.6.5版本更新
- [深蓝]多商户团购 功能强,人气王7.0 DZ学习研究交流
- 申请年费会员差价补齐请尽快查收开通
- 已充值年VIP 请通过