-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 4.1.16-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema jiangsur_update
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ jiangsur_update;
USE jiangsur_update;
--
-- Table structure for table `jiangsur_update`.`node`
--
DROP TABLE IF EXISTS `node`;
CREATE TABLE `node` (
`nid` int(10) unsigned NOT NULL auto_increment,
`type` varchar(32) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`uid` int(10) NOT NULL default '0',
`status` int(4) NOT NULL default '1',
`created` int(11) NOT NULL default '0',
`changed` int(11) NOT NULL default '0',
`comment` int(2) NOT NULL default '0',
`promote` int(2) NOT NULL default '0',
`moderate` int(2) NOT NULL default '0',
`sticky` int(2) NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`,`vid`),
UNIQUE KEY `vid` (`vid`),
KEY `node_type` (`type`(4)),
KEY `node_title_type` (`title`,`type`(4)),
KEY `status` (`status`),
KEY `uid` (`uid`),
KEY `node_moderate` (`moderate`),
KEY `node_promote_status` (`promote`,`status`),
KEY `node_created` (`created`),
KEY `node_changed` (`changed`),
KEY `node_status_type` (`status`,`type`,`nid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jiangsur_update`.`node`
--
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
你检查一下你使用的
你检查一下你使用的的themes源代码里是不是有中文,如果有中文就会出现这样的问题
您再说详细点好吗?
我查了THEMES的代码, 没有中文. 是不是与SETTING (设置)有什么关系? 请多指教, 拜谢先!
把原来4.6的数据库重
把原来4.6的数据库重新导出一下试试
你用的mysql版本是什么?
--------------------------------------------------
我的Drupal试验田:http://drupal.verydummy.com
--------------------------------------------------
您是否指要我把4.6.5的
您是否指要我把4.6.5的数据库从新升级一次? HOSTING公司的MYSQL是4.1.20, 我的测试MYSQL是4.1.16.
你导出的4.6的数据库CH
你导出的4.6的数据库CHARSET是什么?打开那个文件看看,我猜测应该不是utf-8
--------------------------------------------------
我的Drupal试验田:http://drupal.verydummy.com
--------------------------------------------------
到出的数据库CHARSET是U
到出的数据库CHARSET是UTF8. 而且如果用4.6的CODE接上升级后的DATABASE, 显示的是正确的中文. 束手无策!!
4.6 到 4.7
4.6 到 4.7 的数据库的默认编码更改了。你在从 4.6 升级到 4.7 运行 update.php 时,有没有出现任何的 error message?评论,分类词等是否是乱码?
-------------------
欢迎访问我的blog: http://www.kzeng.info/
如果不能访问,feed地址: http://feeds.feedburner.com/kzeng_stupid_words
难题依旧
过节回来, 问题依旧. 从 4.6 升级到 4.7 运行 update.php 时,没有出现任何的 error message. 但是评论,分类词, 页面都是乱码. 真想把备份的数据库FILE上传给哪为专家看看 ...
请大侠出手相救!!!!
哈哈,那就贴一个table
哈哈,那就贴一个table让大家看看?
--------------------------------------------------
我的Drupal试验田:http://drupal.verydummy.com
--------------------------------------------------
贴一个4.6 升级到4.7后的table
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 4.1.16-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema jiangsur_update
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ jiangsur_update;
USE jiangsur_update;
--
-- Table structure for table `jiangsur_update`.`node`
--
DROP TABLE IF EXISTS `node`;
CREATE TABLE `node` (
`nid` int(10) unsigned NOT NULL auto_increment,
`type` varchar(32) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`uid` int(10) NOT NULL default '0',
`status` int(4) NOT NULL default '1',
`created` int(11) NOT NULL default '0',
`changed` int(11) NOT NULL default '0',
`comment` int(2) NOT NULL default '0',
`promote` int(2) NOT NULL default '0',
`moderate` int(2) NOT NULL default '0',
`sticky` int(2) NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`,`vid`),
UNIQUE KEY `vid` (`vid`),
KEY `node_type` (`type`(4)),
KEY `node_title_type` (`title`,`type`(4)),
KEY `status` (`status`),
KEY `uid` (`uid`),
KEY `node_moderate` (`moderate`),
KEY `node_promote_status` (`promote`,`status`),
KEY `node_created` (`created`),
KEY `node_changed` (`changed`),
KEY `node_status_type` (`status`,`type`,`nid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jiangsur_update`.`node`
--
/*!40000 ALTER TABLE `node` DISABLE KEYS */;
INSERT INTO `node` (`nid`,`type`,`title`,`uid`,`status`,`created`,`changed`,`comment`,`promote`,`moderate`,`sticky`,`vid`) VALUES
(333,'story','å¯†è¥¿æ ¹æ±Ÿè‹åŒä¹¡ä¼šåº”é‚€å‚åŠ â€œæµ·å¤–æ±Ÿè‹ä¹‹å‹æ',52,1,1154749877,1169092368,2,1,0,0,333),
(332,'story','ç¾Žå›½å¯†è¥¿æ ¹æ±Ÿè‹åŒä¹¡ä¼šæˆç«‹ã€€é¦–任会长胡红星',52,1,1132285758,1169094065,0,1,0,0,332),
(47,'poll','ä½ å¦‚ä½•å¾—çŸ¥æˆ‘ä»¬',1,1,1140038255,1168465346,2,0,0,0,47),
(48,'survey','用户问å·',1,1,1140039001,1140039509,0,0,0,0,48),
(325,'page','æ¯æœˆä¸€æŒ - Jan 2007',1,1,1168904958,1168912322,2,0,0,0,325),
(326,'page','æ¯æœˆä¸€æŒ',1,1,1168917505,1168918619,2,0,0,0,326),
(327,'directlink','TEST EXCEL',1,1,1168960902,1168960932,2,1,0,0,327),
(329,'filestore2','TEST EXCEL 2',1,1,1168961251,1168963142,2,1,0,0,329),
(330,'story','â€œå¯†è¥¿æ ¹æ±Ÿè‹åŒä¹¡ä¼šâ€æˆç«‹',1,1,1125004968,1169093910,2,1,0,0,330);
INSERT INTO `node` (`nid`,`type`,`title`,`uid`,`status`,`created`,`changed`,`comment`,`promote`,`moderate`,`sticky`,`vid`) VALUES
(63,'page','谢谢您的访问',1,1,1141329056,1142057824,0,0,0,0,63),
(64,'page','è”系我们',1,1,1141442950,1168757036,0,1,0,0,64),
(319,'flexinode-2','第一次会议',1,1,1168759098,1168759344,0,1,0,0,319),
(304,'page','最新的评论汇总',1,1,1168747211,1168747316,0,1,0,0,304),
(291,'forum','露个脸',1,1,1168549610,1168661128,2,0,0,0,291),
(292,'image','月亮',1,1,1168660396,1168660550,2,1,0,0,292),
(293,'forum','æå‡ºç”³è¯·',1,1,1168660647,1168660702,2,1,0,0,293),
(331,'story','“乡音乡情金秋晚会â€å°†äºŽ10月20日晚上6点åŠç',52,1,1160018721,1169129481,0,0,0,0,331),
(311,'page','滑雪心得',1,1,1168753291,1168753344,2,1,0,0,311),
(312,'image','集体活动',1,1,1168753586,1168754041,2,1,0,0,312),
(313,'image','第一次会议',1,1,1168753771,1168754000,2,1,0,0,313);
INSERT INTO `node` (`nid`,`type`,`title`,`uid`,`status`,`created`,`changed`,`comment`,`promote`,`moderate`,`sticky`,`vid`) VALUES
(314,'image','江è‹åœ°å›¾',1,1,1168754119,1168754164,2,1,0,0,314),
(315,'page','江è‹ä»‹ç»',1,1,1168754825,1168970814,2,1,0,0,315),
(316,'flexinode-5','CAGD',1,1,1168755972,1168756011,2,1,0,0,316),
(317,'flexinode-5','底特律美ä¸å•†ä¼š',1,1,1168756029,1168756083,2,1,0,0,317),
(318,'page','勿ƒ…连结',1,1,1168756099,1168756430,0,1,0,0,318),
(320,'flexinode-2','GOLF OUTING',1,1,1168759438,1168759771,0,1,0,0,320),
(321,'forum','å”±ä¸€é¦–æŒæµ‹è¯•一下html是å¦å·¥ä½œ',51,1,1168879303,1168879303,2,1,0,0,321),
(322,'forum','æ–°å¹´å‘åŒä¹¡ä»¬çŒ®æŒï¼šæ··å£°é‡å”±ã€Šé›ªç»’花》',51,1,1168879703,1168879703,2,1,0,0,322),
(323,'forum','åŒä¹¡ä¼šç½‘页讨论',51,1,1168880729,1168880729,2,1,0,0,323),
(299,'image','镇江金山寺',1,1,1168708944,1168758248,2,1,0,0,299);
INSERT INTO `node` (`nid`,`type`,`title`,`uid`,`status`,`created`,`changed`,`comment`,`promote`,`moderate`,`sticky`,`vid`) VALUES
(301,'dashboard','åŒä¹¡ä¼šæ¬¢è¿Žæ‚¨',1,1,1168712825,1169094443,0,1,0,0,301),
(305,'page','åŒä¹¡ä¼šç« 程',1,1,1168752308,1168752365,2,1,0,0,305),
(306,'page','åŒä¹¡ä¼šç½‘站测试欢迎',1,1,1168752785,1168752853,2,1,0,0,306),
(307,'page','FIRST BOARD MEETING',1,1,1168752871,1168752915,2,1,0,0,307),
(335,'story','åœ¨é‚£ä¸€ç‰‡ä»¤äººæŒ¯å¥‹å’Œä¾æ‹çš„æ•…土上 。。。',52,1,1169092739,1169094392,2,1,0,0,335),
(310,'page','å—京游山玩水',1,1,1168753227,1168753278,2,1,0,0,310),
(290,'flexinode-2','新年晚会-2007',1,1,1168489172,1168489316,0,0,0,0,290),
(324,'forum','å¤§å®¶è´¡çŒ®ç‚¹å’Œæ±Ÿè‹æœ‰å…³çš„è¯—è¯æ–‡ç« ç‰å¥½å—?',52,1,1168889031,1168889031,2,1,0,0,324),
(336,'blog','å—京游山玩水',1,1,1169094369,1169094414,2,1,0,0,336);
INSERT INTO `node` (`nid`,`type`,`title`,`uid`,`status`,`created`,`changed`,`comment`,`promote`,`moderate`,`sticky`,`vid`) VALUES
(183,'blog','æµ·å—çœå±…室ä½å®…装饰装修示范åˆåŒ',33,1,1144912516,1144912516,2,1,0,0,183),
(272,'page','å¯†è¥¿æ ¹æ±Ÿè‹åŒä¹¡ä¼šæ¬¢è¿Žæ‚¨!',1,1,1147729421,1168752419,0,1,0,0,272);
/*!40000 ALTER TABLE `node` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
我回想搭建4.6时
我回想搭建4.6时, 我第一次安装MYSQL, 我把MYSQL的DEFAULT CHARSET设成UTF8, 然后安装的4.6.