NoName Mobile

登录

NoName » Project Parasy » 1.5安装错误SQL执行出错

1.5安装错误SQL执行出错

by junweigu at 2009-12-8 19:47

Discuz! info: MySQL Query Error

Time: 2009-12-8 11:45am
Script: /installer.php

SQL: CREATE TABLE IF NOT EXISTS [Table]geo_usage_simple ( `gus_geo` varchar(100) NOT NULL default 'earth', `gus_name_cn` varchar(100) NOT NULL default '地球', `gus_name_en` varchar(100) NOT NULL default 'Earth', `gus_hits` int(10) unsigned NOT NULL default '0', `gus_lastupdated` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`gus_geo`), UNIQUE KEY `INDEX_NAME_CN` (`gus_name_cn`), UNIQUE KEY `INDEX_NAME_EN` (`gus_name_en`)) ENGINE=MYISAM DEFAULT CHARSET=utf8
Error: Invalid default value for 'gus_name_cn'
Errno.: 1067

麻烦问问是什么原因。感谢

# 1 - junweigu at 2009-12-8 20:01

我将默认编码改为了utf-8,可能中文字符这会有些问题

# 2 - junweigu at 2009-12-8 20:03

果然，将默认编码改成GBK就解决了，请问如果非要用UTF-8的话怎么办

# 3 - junweigu at 2009-12-8 21:33

黑板报错误：

Warning: Invalid argument supplied for foreach() in E:\User\web\techcn\RC\bbs\parasy\ParasyCore.php on line 386

Warning: krsort() expects parameter 1 to be array, null given in E:\User\web\techcn\RC\bbs\parasy\ParasyCore.php on line 417

© 2007 NoNameMagazine