本帖最后由 民审-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} 造成：
修复办法：

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`)
);