::NoName Magazine 无名杂志 » Project Parasy » 1.5安装错误SQL执行出错


2009-12-8 19:47 junweigu
1.5安装错误SQL执行出错

[font=Verdana, Tahoma][size=11px][b]Discuz! info[/b]: MySQL Query Error

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

[b]SQL[/b]: 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
[b]Error[/b]: Invalid default value for 'gus_name_cn'
[b]Errno.[/b]: 1067[/size][/font]

[font=Verdana, Tahoma][size=11px]麻烦问问是什么原因。感谢[/size][/font]

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

2009-12-8 20:03 junweigu
果然,将默认编码改成GBK就解决了,请问如果非要用UTF-8的话怎么办

2009-12-8 21:33 junweigu
黑板报错误:

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

页: [1]
查看完整版本: 1.5安装错误SQL执行出错


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.