5.5升级6.0出错了，请帮忙看看是怎么回事

我将team论坛转成了discuz5.5版本，除了帖子中附件有问题外，其他的功能都还算正常，然后将5.5升级到6.0，升级时都没说有什么错误，提示升级完成后，访问论坛，就报错了，页面直接显示以下代码，请问如何解决，先谢谢了！重启过apache和mysql的，还是不行。



Discuz! info: MySQL Query Error

Time: 2011-10-16 2:37am
Script: /post.php

SQL: REPLACE INTO [Table]caches (cachename, type, dateline, data) VALUES ('settings', '1', '1318703844', '$_DCACHE[''settings''] = array (
''accessemail'' => '''',
''adminipaccess'' => '''',
''allowcsscache'' => ''1'',
''archiverstatus'' => ''1'',
''attachbanperiods'' => '''',
''attachimgpost'' => ''1'',
''attachrefcheck'' => ''0'',
''attachsave'' => ''3'',
''authkey'' => ''ea758ckUBxGjdqL9'',
''bannedmessages'' => ''1'',
''bbclosed'' => ''0'',
''bbinsert'' => ''1'',
''bbname'' => ''Discuz! Board'',
''bdaystatus'' => ''0'',
''boardlicensed'' => ''0'',
''censoremail'' => '''',
''censoruser'' => '''',
''creditsformula'' => ''$member[\''extcredits1\'']'',
''creditsformulaexp'' => '''',
''creditspolicy'' =>
array (
''post'' =>
array (
1 => ''3'',
2 => ''5'',
3 => ''2'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''reply'' =>
array (
1 => ''1'',
2 => ''3'',
3 => ''1'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''digest'' =>
array (
1 => ''5'',
2 => ''7'',
3 => ''3'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''postattach'' =>
array (
1 => ''0'',
2 => ''0'',
3 => ''0'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''getattach'' =>
array (
1 => ''0'',
2 => ''0'',
3 => ''0'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''pm'' =>
array (
1 => ''0'',
2 => ''0'',
3 => ''0'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''search'' =>
array (
1 => ''0'',
2 => ''0'',
3 => ''0'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''promotion_visit'' =>
array (
1 => ''1'',
2 => ''5'',
3 => ''3'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
''promotion_register'' =>
array (
1 => 0,
2 => 0,
3 => 0,
4 => 0,
5 => 0,
6 => 0,
7 => 0,
8 => 0,
),
''tradefinished'' =>
array (
1 => 0,
2 => 0,
3 => 0,
4 => 0,
5 => 0,
6 => 0,
7 => 0,
8 => 0,
),
''votepoll'' =>
array (
1 => 0,
2 => 0,
3 => 0,
4 => 0,
5 => 0,
6 => 0,
7 => 0,
8 => 0,
),
''lowerlimit'' =>
array (
1 => ''0'',
2 => ''0'',
3 => ''0'',
4 => ''0'',
5 => ''0'',
6 => ''0'',
7 => ''0'',
8 => ''0'',
),
),
''creditstax'' => ''0.2'',
''creditstrans'' => ''2'',
''dateformat'' => ''Y-n-j'',
''debug'' => ''1'',
''delayviewcount'' => ''0'',
''deletereason'' => '''',
''doublee'' => ''1'',
''dupkarmarate'' => ''0'',
''ec_account'' => '''',
''ec_maxcredits'' => ''1000'',
''ec_maxcreditspermonth'' => ''0'',
''ec_mincredits'' => ''0'',
''ec_ratio'' => ''0'',
''rewritecompatible'' => '''',
''editedby'' => ''1'',
''editoroptions'' => ''1'',
''edittimelimit'' => '''',
''exchangemincredits'' => ''100'',
''extcredits'' =>
array (
1 =>
array (
''title'' => ''积分'',
''unit'' => ''点'',
''ratio'' => 0,
''lowerlimit'' => 0,
''showinthread'' => ''1'',
),
2 =>
array (
''title'' => ''金币'',
''unit'' => ''枚'',
''ratio'' => 0,
''lowerlimit'' => 0,
''showinthread'' => ''1'',
),
3 =>
array (
''title'' => ''魅力'',
''unit'' => ''度'',
''ratio'' => 0,
''lowerlimit'' => 0,
''showinthread'' => ''1'',
),
),
''fastpost'' => ''1'',
''floodctrl'' => ''15'',
''forumjump'' => ''0'',
''globalstick'' => ''1'',
''gzipcompress'' => ''0'',
''hideprivate'' => ''1'',
''hottopic'' => ''10'',
''icp'' => '''',
''initcredits'' => ''0,0,1,1,0,0,0,0,0'',
''ipaccess'' => '''',
''ipregctrl'' => '''',
''jscachelife'' => ''1800'',
''jsrefdomains'' => '''',
''jsstatus'' => ''0'',
''karmaratelimit'' => ''0'',
''loadctrl'' => ''0'',
''losslessdel'' => ''365'',
''maxavatarpixel'' => ''120'',
''maxavatarsize'' => ''20000'',
''maxbdays'' => ''0'',
''maxchargespan'' => ''0'',
''maxfavorites'' => ''100'',
''maxincperthread'' => ''0'',
''maxmodworksmonths'' => ''3'',
''maxonlinelist'' => ''0'',
''maxpolloptions'' => ''10'',
''maxpostsize'' => ''10000'',
''maxsearchresults'' => ''500'',
''maxsigrows'' => ''240'',
''maxsmilies'' => ''3'',
''maxspm'' => ''0'',
''maxsubscriptions'' => ''100'',
''membermaxpages'' => ''100'',
''memberperpage'' => ''25'',
''memliststatus'' => ''1'',
''minpostsize'' => ''10'',
''moddisplay'' => ''flat'',
''modratelimit'' => ''0'',
''modworkstatus'' => ''0'',
''myrecorddays'' => ''30'',
''newbiespan'' => ''0'',
''nocacheheaders'' => ''0'',
''oltimespan'' => ''10'',
''onlinerecord'' => ''1        1040034649'',
''passport_expire'' => ''3600'',
''passport_extcredits'' => ''0'',
''passport_key'' => '''',
''passport_login_url'' => '''',
''passport_logout_url'' => '''',
''passport_register_url'' => '''',
''passport_status'' => '''',
''passport_url'' => '''',
''postbanperiods'' => '''',
''postmodperiods'' => '''',
''postperpage'' => ''10'',
''pvfrequence'' => ''60'',
''ratelogrecord'' => ''5'',
''regadvance'' => ''0'',
''regctrl'' => ''0'',
''regfloodctrl'' => ''0'',
''regstatus'' => ''1'',
''regverify'' => ''0'',
''reportpost'' => ''1'',
''rewritestatus'' => ''0'',
''rssstatus'' => ''1'',
''rssttl'' => ''60'',
''searchbanperiods'' => '''',
''searchctrl'' => ''30'',
''seccodestatus'' => ''0'',
''seodescription'' => '''',
''seohead'' => '''',
''seokeywords'' => '''',
''seotitle'' => '''',
''showemail'' => '''',
''showimages'' => ''1'',
''showsettings'' => ''7'',
''sitename'' => ''Comsenz Inc.'',
''siteurl'' => ''http://www.comsenz.com/'',
''smcols'' => ''4'',
''smileyinsert'' => ''1'',
''starthreshold'' => ''2'',
''statscachelife'' => ''180'',
''statstatus'' => '''',
''styleid'' => ''1'',
''stylejump'' =>
array (
1 => ''默认风格'',
2 => ''喝彩奥运'',
3 => ''深邃永恒'',
4 => ''粉妆精灵'',
5 => ''诗意田园'',
6 => ''春意盎然'',
),
''subforumsindex'' => '''',
''threadmaxpages'' => ''1000'',
''threadsticky'' =>
array (
0 => ''全局置顶'',
1 => ''分类置顶'',
2 => ''本版置顶'',
),
''timeformat'' => ''H:i'',
''timeoffset'' => ''8'',
''topicperpage'' => ''20'',
''transfermincredits'' => ''1000'',
''transsidstatus'' => ''0'',
''userstatusby'' => ''1'',
''visitbanperiods'' => '''',
''visitedforums'' => ''10'',
''vtonlinestatus'' => ''1'',
''wapcharset'' => ''2'',
''wapdateformat'' => ''n/j'',
''wapmps'' => ''500'',
''wapppp'' => ''5'',
''wapstatus'' => ''1'',
''waptpp'' => ''10'',
''watermarkquality'' => ''80'',
''watermarkstatus'' => ''0'',
''watermarktrans'' => ''65'',
''whosonlinestatus'' => ''1'',
''indexname'' => ''index.php'',
''insenz'' =>
array (
),
''thumbstatus'' => ''0'',
''thumbwidth'' => ''400'',
''thumbheight'' => ''300'',
''forumlinkstatus'' => ''1'',
''pluginjsmenu'' => ''插件'',
''magicstatus'' => ''1'',
''magicmarket'' => ''1'',
''maxmagicprice'' => ''50'',
''upgradeurl'' => ''http://localhost/develop/dzhead/develop/upgrade.php'',
''ftp'' =>
array (
''on'' => ''0'',
''ssl'' => ''0'',
''host'' => '''',
''port'' => ''21'',
''username'' => '''',
''password'' => '''',
''attachdir'' => ''.'',
''attachurl'' => '''',
''hideurl'' => ''0'',
''timeout'' => ''0'',
''connid'' => 0,
),
''wapregister'' => ''0'',
''passport_shopex'' => ''0'',
''seccodeanimator'' => ''1'',
''welcomemsgtitle'' => ''{username}，您好，感谢您的注册，请阅读以下内容。'',
''cacheindexlife'' => ''0'',
''cachethreadlife'' => ''0'',
''cachethreaddir'' => ''forumdata/threadcaches'',
''jsdateformat'' => '''',
''seccodedata'' =>
array (
''minposts'' => '''',
''loginfailedcount'' => 0,
''width'' => 150,
''height'' => 60,
''type'' => 0,
''background'' => 1,
''adulterate'' => 1,
''ttf'' => 0,
''angle'' => 0,
''color'' => 1,
''size'' => 0,
''shadow'' => 1,
''animator'' => 0,
),
''frameon'' => ''0'',
''framewidth'' => ''180'',
''smrows'' => ''4'',
''watermarktype'' => ''0'',
''secqaa'' =>
array (
''status'' =>
array (
1 => ''0'',
2 => ''0'',
3 => ''0'',
),
),
''spacestatus'' => ''1'',
''whosonline_contract'' => ''0'',
''attachdir'' => ''D:/team_2_discuz/./attachments'',
''attachurl'' => ''attachments'',
''onlinehold'' => 900,
''msgforward'' => ''a:3:{s:11:"refreshtime";i:3;s:5:"quick";i:1;s:8:"messages";a:13:{i:0;s:19:"thread_poll_succeed";i:1;s:19:"thread_rate_succeed";i:2;s:23:"usergroups_join_succeed";i:3;s:23:"usergroups_exit_succeed";i:4;s:25:"usergroups_update_succeed";i:5;s:20:"buddy_update_succeed";i:6;s:17:"post_edit_succeed";i:7;s:18:"post_reply_succeed";i:8;s:24:"post_edit_delete_succeed";i:9;s:22:"post_newthread_succeed";i:10;s:13:"admin_succeed";i:11;s:17:"pm_delete_succeed";i:12;s:15:"search_redirect";}}'',
''smthumb'' => ''20'',
''yesterdayposts'' => ''0'',
''tagstatus'' => ''1'',
''hottags'' => ''20'',
''viewthreadtags'' => ''100'',
''mail'' => ''a:10:{s:8:"mailsend";i:1;s:6:"server";N;s:4:"port";N;s:4:"auth";N;s:4:"from";N;s:13:"auth_username";N;s:13:"auth_password";N;s:13:"maildelimiter";i:1;s:12:"mailusername";i:1;s:15:"sendmail_silent";i:1;}'',
''spacedata'' =>
array (
''cachelife'' => 900,
''limitmyblogs'' => 8,
''limitmyfavforums'' => 5,
''limitmyfavthreads'' => 0,
''limitmyfriends'' => 0,
''limitmyreplies'' => 5,
''limitmyrewards'' => 5,
''limitmythreads'' => 5,
''limitmytrades'' => 5,
''textlength'' => 300,
''limitmyvideos'' => 0,
),
''watermarktext'' =>
array (
),
''watermarkminwidth'' => ''0'',
''watermarkminheight'' => ''0'',
''userdateformat'' =>
array (
0 => ''Y-n-j'',
1 => '''',
2 => ''Y/n/j'',
3 => '''',
4 => ''j-n-Y'',
5 => '''',
6 => ''j/n/Y'',
),
''regname'' => ''register.php'',
''reglinkname'' => ''注册'',
''activitytype'' => ''朋友聚会
出外郊游
自驾出行
公益活动
线上活动'',
''tradeimagewidth'' => ''200'',
''tradeimageheight'' => ''150'',
''ec_credit'' =>
array (
''maxcreditspermonth'' => 6,
''rank'' =>
array (
1 => 4,
2 => 11,
3 => 41,
4 => 91,
5 => 151,
6 => 251,
7 => 501,
8 => 1001,
9 => 2001,
10 => 5001,
11 => 10001,
12 => 20001,
13 => 50001,
14 => 100001,
15 => 200001,
),
),
''imagelib'' => ''0'',
''historyposts'' => ''0        0'',
''zoomstatus'' => ''1'',
''maxbiotradesize'' => ''400'',
''tradetypes'' =>
array (
),
''baidusitemap'' => ''1'',
''baidusitemap_life'' => ''12'',
''google'' => 0,
''qihoo'' =>
array (
),
''version'' => ''6.0.0'',
''totalmembers'' => ''226'',
''lastmember'' => ''xyn544347587'',
''cachethreadon'' => 0,
''cronnextrun'' => ''1170600452'',
''jsmenu'' =>
array (
1 => true,
2 => true,
3 => true,
4 => true,
),
''stylejumpstatus'' => ''0'',
''globaladvs'' =>
array (
),
''redirectadvs'' =>
array (
),
''invitecredit'' => '''',
''vsiteurl'' => '''',
''vkey'' => '''',
''vpassword'' => '''',
''vsiteid'' => '''',
''videotype'' =>
array (
0 => '''',
),
''videoopen'' => 0,
''exchangestatus'' => false,
''transferstatus'' => true,
''supe'' =>
array (
''status'' => 0,
),
''pluginlinks'' =>
array (
),
''plugins'' =>
array (
),
''hooks'' =>
array (
),
);

')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'extcredits1\'']'',
''creditsformulaexp'' => '''',
''creditspolicy'' =>
ar' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

我的php及mysql的版本如下：
操作系统及 PHP WINNT / PHP v5.2.6
MySQL 版本 5.0.22-community-nt

缓存表出错

你试着重建这个表试试，进入后台校验下数据，看是不是丢失表了

修复下数据库，更新缓存一下 试试。。

用phpMyAdmin修复过数据库，还是老问题，访问整站的文件都报这个错误

重建一下caches表

请问楼上的，如何重建cache表？能详细说一下吗，谢谢

采用了如下代码
================
DROP TABLE IF EXISTS cdb_caches;
CREATE TABLE cdb_caches (
  cachename varchar(32) NOT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  dateline int(10) unsigned NOT NULL,
  expiration int(10) unsigned NOT NULL,
  `data` mediumtext NOT NULL,
  PRIMARY KEY (cachename),
  KEY expiration (`type`,expiration)
) TYPE=MyISAM;
=====================
成功重建了caches表，但是页面依然报错，好像问题不是错在caches表一样，

问题已经解决，将升级的这个工作放到服务器上直接进行了，居然没有报错，估计是家里电脑系统某个服务被我禁用导致的，或mysql有问题、