购买了木子装修1.4无法安装，一直出错

一线影视 · 发表于 2018-6-20 15:49:10

麻烦技术远程帮忙搞下

民审-M · 发表于 2018-6-20 16:36:59

请详细描述具体报错内容

一线影视 · 发表于 2018-6-21 11:01:45

民审-M 发表于 2018-6-20 16:36
请详细描述具体报错内容

民审-M · 发表于 2018-6-21 17:50:42

一线影视发表于 2018-6-21 11:01

你mysql无法查询大语句，请在phpmyadmin中，一条条逐条手工创建数据库表：如图所示，复制如下（一条条复制建表）
QQ截图20180621175023.jpg

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_designer` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL,
`touxiang` char(255) NOT NULL,
`zhicheng` char(20) NOT NULL,
`linian` char(50) NOT NULL,
`jianjie` varchar(1000) NOT NULL,
`sid` smallint(3) unsigned NOT NULL,
`indexsort` smallint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_gongdi` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` char(50) NOT NULL,
`thumb` char(255) NOT NULL,
`sid` int(10) unsigned NOT NULL,
`qid` int(10) unsigned NOT NULL,
`huxing` tinyint(1) unsigned NOT NULL,
`fengge` tinyint(1) unsigned NOT NULL,
`yusuan` tinyint(1) unsigned NOT NULL,
`islook` tinyint(1) unsigned NOT NULL DEFAULT '1',
`uptime` int(10) unsigned NOT NULL,
`fangan` varchar(500) NOT NULL,
`content1` text NOT NULL,
`content2` text NOT NULL,
`content3` text NOT NULL,
`content4` text NOT NULL,
`content5` text NOT NULL,
`status` tinyint(1) unsigned NOT NULL DEFAULT '3',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sid` int(10) unsigned NOT NULL DEFAULT '0',
`typeid` int(10) unsigned NOT NULL,
`typeurl` varchar(10) NOT NULL,
`istop` tinyint(1) unsigned NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL,
`keywords` varchar(100) NOT NULL,
`desc` varchar(200) NOT NULL,
`thumb` varchar(255) DEFAULT NULL,
`content` text NOT NULL,
`click` int(10) NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL,
`status` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_news_type` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`typename` varchar(50) NOT NULL,
`typeurl` varchar(10) NOT NULL,
`sort` int(10) unsigned NOT NULL DEFAULT '100',
`isindex` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_parameter` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` char(100) NOT NULL,
`ename` char(100) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_quyu` (
`id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
`name` char(30) NOT NULL,
`sort` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_shop` (
`id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL,
`name` char(30) NOT NULL,
`pic` char(255) NOT NULL,
`address` char(100) NOT NULL,
`tel` char(20) NOT NULL,
`quyu` tinyint(2) unsigned NOT NULL,
`desc` varchar(5000) NOT NULL,
`fuwu` char(100) NOT NULL,
`bbsurl` char(100) NOT NULL,
`click` int(10) unsigned NOT NULL DEFAULT '0',
`istop` tinyint(3) unsigned NOT NULL DEFAULT '0',
`casenums` smallint(4) unsigned NOT NULL DEFAULT '0',
`gongdinums` smallint(4) unsigned NOT NULL DEFAULT '0',
`designernums` smallint(4) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`indexsort` smallint(3) unsigned NOT NULL DEFAULT '0',
`openid` varchar(2000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_building` (
`id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL,
`name` char(30) NOT NULL,
`pic` char(255) NOT NULL,
`address` char(100) NOT NULL,
`tel` char(20) NOT NULL,
`quyu` tinyint(2) unsigned NOT NULL,
`desc` varchar(5000) NOT NULL,
`contentname1` char(255) NOT NULL,
`contentval1` varchar(5000) NOT NULL,
`contentname2` char(255) NOT NULL,
`contentval2` varchar(5000) NOT NULL,
`contentname3` char(255) NOT NULL,
`contentval3` varchar(5000) NOT NULL,
`contentname4` char(255) NOT NULL,
`contentval4` varchar(5000) NOT NULL,
`fuwu` varchar(1000) NOT NULL,
`buildingtype` smallint(2) unsigned NOT NULL,
`bbsurl` char(100) NOT NULL,
`click` int(10) unsigned NOT NULL DEFAULT '0',
`istop` tinyint(3) unsigned NOT NULL DEFAULT '0',
`casenums` smallint(4) unsigned NOT NULL DEFAULT '0',
`gongdinums` smallint(4) unsigned NOT NULL DEFAULT '0',
`designernums` smallint(4) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`indexsort` smallint(3) unsigned NOT NULL DEFAULT '0',
`openid` varchar(2000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_tuce` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` char(100) NOT NULL,
`keywords` varchar(100) DEFAULT NULL,
`desc` varchar(500) DEFAULT NULL,
`sid` int(10) unsigned NOT NULL,
`did` int(10) unsigned NOT NULL,
`dname` char(50) NOT NULL,
`huxing` tinyint(1) unsigned NOT NULL,
`fengge` tinyint(1) unsigned NOT NULL,
`yusuan` tinyint(1) unsigned NOT NULL,
`content` text NOT NULL,
`thumb` varchar(500) NOT NULL,
`vrurl` char(255) NOT NULL,
`click` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(3) unsigned NOT NULL DEFAULT '1',
`tuijian` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

CREATE TABLE IF NOT EXISTS `pre_zimucms_zhuangxiu_yuyue` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL,
`phone` char(20) NOT NULL,
`sid` int(10) unsigned DEFAULT NULL,
`content` varchar(2000) DEFAULT NULL,
`beizhu` varchar(2000) NOT NULL,
`type` tinyint(1) unsigned NOT NULL DEFAULT '1',
`addtime` int(10) unsigned NOT NULL,
`status` smallint(2) unsigned DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

复制代码

一线影视 · 发表于 2018-6-22 09:10:07

民审-M 发表于 2018-6-21 17:50
你mysql无法查询大语句，请在phpmyadmin中，一条条逐条手工创建数据库表：如图所示，复制如下（一条条复 ...

一线影视 · 发表于 2018-6-22 09:15:07

民审-M 发表于 2018-6-21 17:50
你mysql无法查询大语句，请在phpmyadmin中，一条条逐条手工创建数据库表：如图所示，复制如下（一条条复 ...

一线影视 · 发表于 2018-6-22 09:47:45

民审-M 发表于 2018-6-21 17:50
你mysql无法查询大语句，请在phpmyadmin中，一条条逐条手工创建数据库表：如图所示，复制如下（一条条复 ...

没法搞啊！能不能远程帮忙搞下啊

民审-M · 发表于 2018-6-22 11:29:22

一线影视发表于 2018-6-22 09:47
没法搞啊！能不能远程帮忙搞下啊

粘贴复制到你phpmyadmin或论坛后台——站长——数据库升级提交即可。

民审-M · 发表于 2018-6-22 14:32:38

一线影视发表于 2018-6-21 11:01

你的Mysql 出现Error 1118 Row size too large的情况，主要在于你mysql版本,my.ini配置文件相关问题，可尝试：

解决步骤

1. 在MySQL的配置文件中添加：

[mysqld]

max_allowed_packet=16M

2. 在MySQL的配置文件中添加：

[mysqld]

innodb_file_per_table=1

3. 修改MySQL全局变量：

SET GLOBAL innodb_file_format='Barracuda';

插件是应用中心原版完整插件，该插件安装会有自动创建数据库表的过程，你这个报错是建表遇到问题，请检查自己mysql配置或版本问题。按照上述方案检查下。

一线影视 · 发表于 2018-6-22 17:46:40

民审-M 发表于 2018-6-22 14:32
你的Mysql 出现Error 1118 Row size too large的情况，主要在于你mysql版本,my.ini配置文件相关问题，可 ...

数据库不会玩啊

[已处理] 购买了木子装修1.4无法安装，一直出错

相关帖子

浏览过的版块

个人中心