ถามเกี่ยวกับการ install ครับแค่อยากรู้

pencil · โพสต์ 2008-8-28 09:13:25

1.copy database กับ forum มาจากเครื่องอื่นพอมารันแล้วขึ้น

Discuz! info: MySQL Query Error
Time: 2008-8-28 8:49am
Script: /forum/index.php
SQL: SELECT f.fid, f.fup, f.type, f.name, f.threads, f.posts, f.todayposts, f.lastpost, f.inheritedmod, f.forumcolumns, f.simple, ff.description, ff.moderators, ff.icon, ff.viewperm, ff.redirect FROM [Table]forums f
LEFT JOIN [Table]forumfields ff USING(fid)
WHERE f.status>0 ORDER BY f.type, f.displayorder
Error: Table './caznew/[Table]forumfields' was created with a different version of MySQL and cannot be read
Errno.: 1033
Similar error report has beed dispatched to administrator before.

คัดลอกไปที่คลิปบอร์ด

pencil · โพสต์ 2008-8-28 09:14:14

2.ลงใหม่ แต่ก่อนก็เคยลงได้ในเครื่องเดียวกันนี้แต่พอมาลงอีกทีทำไมมันเป็บแบบนี้

Discuz! info: MySQL Query Error
Time: 2008-8-28 10:11am
Script: /forum/index.php
SQL: REPLACE INTO [Table]caches (cachename, type, dateline, data) VALUES ('settings', '1', '1219889488', '$_DCACHE[''settings''] = array (
''accessemail'' => '''',
''adminipaccess'' => '''',
''allowcsscache'' => ''1'',
''archiverstatus'' => ''1'',
''attachbanperiods'' => '''',
''attachimgpost'' => ''1'',
''attachrefcheck'' => ''0'',
''attachsave'' => ''3'',
''authkey'' => ''96722djPbhelLSsW'',
''bannedmessages'' => ''1'',
''bbclosed'' => '''',
''bbinsert'' => ''1'',
''bbname'' => ''Discuz! Board'',
''bdaystatus'' => ''0'',
''boardlicensed'' => ''0'',

คัดลอกไปที่คลิปบอร์ด

pencil · โพสต์ 2008-8-28 09:15:39

ต่อ

''censoremail'' => '''',
''censoruser'' => '''',
''creditsformula'' => ''$member[\''extcredits1\'']'',
''creditsformulaexp'' => '''',
''creditspolicy'' =>
array (
''post'' =>
array (
),
''reply'' =>
array (
),
''digest'' =>
array (
1 => 10,
),
''postattach'' =>
array (
),
''getattach'' =>
array (
),
''pm'' =>
array (
),
''search'' =>
array (
),
),
''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'',
''editedby'' => ''1'',
''editoroptions'' => ''1'',
''edittimelimit'' => '''',
''exchangemincredits'' => ''100'',
''extcredits'' =>
array (
1 =>
array (
''title'' => ''จิตพิศัย'',
''showinthread'' => '''',
),
2 =>
array (
''title'' => ''Money'',
''showinthread'' => '''',
),
),
''fastpost'' => ''1'',
''floodctrl'' => ''15'',
''forumjump'' => ''0'',
''globalstick'' => ''1'',
''gzipcompress'' => ''0'',
''hideprivate'' => ''1'',
''hottopic'' => ''10'',
''icp'' => '''',
''initcredits'' => ''0,0,0,0,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'' => ''100'',
''maxsmilies'' => ''10'',
''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'',
''qihoo'' =>
array (
),
''ratelogrecord'' => ''5'',
''regadvance'' => ''0'',
''regctrl'' => ''0'',
''regfloodctrl'' => ''0'',
''regstatus'' => ''1'',
''regverify'' => ''0'',
''reportpost'' => ''1'',
''rewritestatus'' => ''0'',
''rssstatus'' => ''1'',
''rssttl'' => ''60'',
''runwizard'' => ''1'',
''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 => ''Default'',
),
''subforumsindex'' => '''',
''threadmaxpages'' => ''1000'',
''threadsticky'' =>
array (
0 => ''Sticky III'',
1 => '' Sticky II'',
2 => '' Sticky I'',
),
''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'' => ''forums.php'',
''spacedata'' =>
array (
''cachelife'' => ''900'',
''limitmythreads'' => ''5'',
''limitmyreplies'' => ''5'',
''limitmyrewards'' => ''5'',
''limitmytrades'' => ''5'',
''limitmyvideos'' => ''0'',

คัดลอกไปที่คลิปบอร์ด

pencil · โพสต์ 2008-8-28 09:16:25

สุดท้าย

''limitmyblogs'' => ''8'',
''limitmyfriends'' => ''0'',
''limitmyfavforums'' => ''5'',
''limitmyfavthreads'' => ''0'',
''textlength'' => ''300'',
),
''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'' => ''C:/Inetpub/wwwroot/forum/./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'',
''tagstatus'' => ''1'',
''hottags'' => ''20'',
''viewthreadtags'' => ''100'',
''rewritecompatible'' => '''',
''imagelib'' => ''0'',
''regname'' => ''register.php'',
''reglinkname'' => ''สมัครสมาชิก'',
''activitytype'' => ''朋友聚會
出外郊遊
自駕出行
公益活動
線上活動'',
''userdateformat'' =>
array (
0 => ''Y-n-j'',
1 => ''Y/n/j'',
2 => ''j-n-Y'',
3 => ''j/n/Y'',
),
''tradetypes'' =>
array (
),
''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,
),
),
''mail'' => ''a:10:{s:8:"mailsend";s:1:"1";s:6:"server";s:13:"smtp.21cn.com";s:4:"port";s:2:"25";s:4:"auth";s:1:"1";s:4:"from";s:26:"Discuz <username@21cn.com>";s:13:"auth_username";s:17:"username@21cn.com";s:13:"auth_password";s:8:"password";s:13:"maildelimiter";s:1:"0";s:12:"mailusername";s:1:"1";s:15:"sendmail_silent";s:1:"1";}'',
''watermarktext'' =>
array (
),
''watermarkminwidth'' => ''0'',
''watermarkminheight'' => ''0'',
''historyposts'' => ''0 0'',
''zoomstatus'' => ''1'',
''maxbiotradesize'' => ''400'',
''insenz'' =>
array (
),
''google'' => 0,
''baidusitemap'' => ''1'',
''baidusitemap_life'' => ''12'',
''aggregation'' => ''2'',
''version'' => ''6.0.0'',
''totalmembers'' => ''1'',
''lastmember'' => ''admin'',
''cachethreadon'' => 0,
''cronnextrun'' => ''1219892157'',
''jsmenu'' =>
array (
1 => true,
2 => true,
3 => true,
4 => true,
),
''stylejumpstatus'' => ''1'',
''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

คัดลอกไปที่คลิปบอร์ด

mysql ในเครื่องที่มีปัญหา VER 14.7 Distrib 4.1.22 for win32 (ia32)

[ แก้ไขล่าสุด pencil เมื่อ 2008-8-28 09:18 ]

pencil · โพสต์ 2008-8-28 13:07:05

สาเหตุ ข้อ 1 ทำได้แล้ว และพอเข้าไปใน admin แล้ว อัพเดทไฟล์ซ่อน มีขึ้นแบบ ข้อ 2 ทำไงดี

สาเหตุข้อ 1 แก้โดยการเปลี่ยน version mysql 4.1.2 ==> version 5.067

acaz · โพสต์ 2008-8-28 21:10:26

โหลด tools3.0 UC ไปลองดูครับตรงลายเซ็นคลิ๊กเลย

pencil · โพสต์ 2008-8-29 08:18:47

ต้นฉบับโพสโดย acaz เมื่อ 2008-8-28 21:10
โหลด tools3.0 UC ไปลองดูครับตรงลายเซ็นคลิ๊กเลย

ติดตรงมันใช้ยังไง

บัญชี		จำสถานะนี้ไว้ในครั้งหน้า	ลืมรหัสผ่าน
รหัสผ่าน			สมัครสมาชิก