• slider image 58
:::
XOOPS2一般討論

網站搬移後,網頁標題的文字變?號

discuss pic 2009-09-10 14:24:39
目前用2.3版製作,在網站搬移後,幾手所有的標題及文字都變成???或亂碼。這是哪裏出了問題呢?是不是文字編碼的問題?如何解決呢?
謝謝!
discuss pic 2013-02-24 14:53:32
版大您好,請問, 小弟將其架好的xoops2.3.3網站搬移到自己的電腦,前後台都是???符號 (附圖) 也按TAD大的書,將資料編碼為utf8_general_ci,資料庫內中文字都正常 找了很多有關"亂碼"的問題,但只找到此題是最接近狀況.. 懇請協助..謝謝版大.. 遠端主機環境 xoops2.3.3(己升級XOOPS2.4.5) PHP5.2.9 mysql 4.0.27 phpMyAdmin 2.7.0-pl1 自己電腦的環境(搬移後成????) xoops2.3.3 PHP Version 5.1.1 MySQL 版本 5.0.18 phpMyAdmin 2.7.0-pl1 除錯訊息 Errors Notice: Constant TADTOOLS_PATH already defined in file /modules/tadtools/tadtools_header.php line 9 Notice: Constant TADTOOLS_URL already defined in file /modules/tadtools/tadtools_header.php line 10 Notice: Use of undefined constant WEB_THEME - assumed 'WEB_THEME' in file /modules/tadtools/tadtools_header.php line 21 Notice: Undefined variable: xoopsConfig in file /header.php line 40 Notice: Undefined variable: xoopsConfig in file /header.php line 40 Notice: Constant _TAD_NEED_TADTOOLS already defined in file /modules/tad_cbox/language/tchinese_utf8/blocks.php line 21 Notice: Use of undefined constant WEB_THEME - assumed 'WEB_THEME' in file /modules/tadtools/tadtools_header.php line 21 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined variable: xoopsUser in file /include/notification_select.php line 34 Queries SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC SELECT sess_data, sess_ip FROM session WHERE sess_id = '147675d69926b5fe3d7df48de3a09e4a' SELECT * FROM users WHERE uid = '1' SELECT * FROM modules WHERE dirname = 'tad_cal' SELECT * FROM config WHERE (conf_modid = '56') ORDER BY conf_order ASC select `cate_sn`,`enable_group`,`cate_enable` from tad_cal_cate select `cate_sn`,`cate_title`,`cate_bgcolor`,`cate_color` from tad_cal_cate where cate_sn in(0,1,2) order by `cate_sort` select `cate_sn`,`enable_upload_group`,`cate_enable` from tad_cal_cate select cate_sn,cate_title from tad_cal_cate where cate_sn in(0,1,2) order by `cate_sort` SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1) SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,56,-1) AND b.bid IN (222,221,220,217,210,209,208,207,206,205,204,198,197,185,184,186,187,188,189,191,190,74,193,80,69,192,66,57,59,9,92,5,3,2,1,77,39,23,6,250,249,251,228,229,235,240,239,238,237,236) ORDER BY b.weight, m.block_id SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_themes.html') ORDER BY tpl_refid SELECT texto, autor FROM citas ORDER BY RAND() LIMIT 1 SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'random_quote_block.html') ORDER BY tpl_refid SELECT * FROM modules WHERE dirname = 'tad_cbox' SELECT * FROM config WHERE (conf_modid = '22') ORDER BY conf_order ASC SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tad_cbox_block.html') ORDER BY tpl_refid update tad_news set always_top='0' WHERE always_top_date <='2013-02-24 08:34:17' and always_top_date!='0000-00-00 00:00:00' select ncsn,nc_title from tad_news_cate where not_news!='1' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='4' select * from tad_news_cate where ncsn='7' select * from tad_news_cate where ncsn='9' select * from tad_news_cate where ncsn='15' select * from tad_news_cate where ncsn='14' select * from tad_news where enable='1' and (ncsn in(1,4,7,9,15,14) or ncsn='0') and start_day < '2013-02-24 08:34:17' and (end_day > '2013-02-24 08:34:17' or end_day='0000-00-00 00:00:00') order by `always_top` desc , start_day desc limit 0 , 15 select * from tad_news_cate where ncsn='1' SELECT * FROM users WHERE uid = '50' select * from tad_news_cate where ncsn='1' SELECT * FROM users WHERE uid = '37' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='7' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='9' select * from tad_news_cate where ncsn='4' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='1' SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tadnews_content_block.html') ORDER BY tpl_refid select `cate_sn`,`enable_group`,`cate_enable` from tad_cal_cate select * from tad_cal_event where `start` >= '2013-02-24 00:00:00' and `end` <= '2013-03-10 23:59:59' and cate_sn in(0,1,2) order by `start` , `sequence` select a.*,b.title,b.cate_sn from tad_cal_repeat as a join tad_cal_event as b on a.sn=b.sn where a.`start` >= '2013-02-24 00:00:00' and a.`end` <= '2013-03-10 23:59:59' and b.cate_sn in(0,1,2) order by a.`start` SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tad_cal_list.html') ORDER BY tpl_refid SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid SELECT cfgname, cfgvalue FROM logcounterx_cfg SELECT cnt FROM logcounterx_count WHERE ymd = '2013-02-24' SELECT cnt FROM logcounterx_count WHERE ymd = '2013-02-23' SELECT sum(cnt) as CNT FROM logcounterx_count WHERE ymd >= '2013-02-24' SELECT sum(cnt) as CNT FROM logcounterx_count WHERE (ymd like '2013-02-%') OR (ymd like '2013/02/%') SELECT cnt FROM logcounterx_count WHERE (ymd = '1111-11-11') OR (ymd = '1111/11/11') SELECT count(ymd) AS DAYS, sum(cnt) as CNT FROM logcounterx_count WHERE ymd > '1111-11-11' SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'lcx_block_display.html') ORDER BY tpl_refid SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tad_cal_index_tpl.html') ORDER BY tpl_refid select * from tad_themes where `theme_name`='school2012' select conf_value from config where conf_title ='_MD_AM_DEBUGMODE' select a.*,b.slide_width,b.slide_height from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id and b.`theme_name`='school2012' where a.`col_name`='slide' select dirname,name from modules where isactive='1' and hasmain='1' and weight > 0 order by weight Total: 57 queries Blocks ??????HTML?: No Cache ??????HTML?: No Cache ??????HTML?: No Cache ??????HTML?: No Cache ??????HTML?: No Cache ??????HTML?: No Cache ??????HTML?: No Cache ????: No Cache ????: No Cache ?????: No Cache ??????: No Cache ????: No Cache ??????HTML?: No Cache ???: No Cache ????: No Cache Total: 15 blocks Extra Included files: 96 files Memory usage: 47,156 K [Estimated] Timers XOOPS took 1.202 seconds to load. XOOPS Boot took 0.174 seconds to load. Module init took 0.171 seconds to load. XOOPS output init took 0.597 seconds to load. Module display took 0.012 seconds to load. Page rendering took 0.232 seconds to load.
discuss pic 2013-02-24 22:12:35
版大好,承上篇#2

小弟原先照TAD大的書,在主機上早為xoops2.2big,幾年前升級xoops2.3.3big,
是最近照TAD大的2.5X書,成功轉為xoops2.3.3UTF8後,才從主機上備份資料庫與實體檔到電腦中,
而主機上經確認環境後,才升級為2.4.5UTF8,
因主機上為教會網站,不敢屢次測試,深怕無法運作
才會架在自己的電腦中進行各項測試與模組更新,卻頻頻出狀況,

小弟爬了文
http://xoops.tn.edu.tw/modules/xforum/viewtopic.php?topic_id=12446&forum=1&post_id=48349#forumpost48349
也造訪您的網站
http://waterlily-lsl.com/modules/article/view.article.php/c11/182/p1

以及您的發文:
[quote]
便要先將舊資料進行編碼轉換
例如我原來的XOOPS2.0.18 S3 是用 utf 8
實際是以 latin 1 儲存
那麼就用EmEditor Professional 文字編輯器
先指定以 utf 8 編碼開啟資料備份 (假設檔名為 A.sql )
然後將編碼反向過來,指定以 latin 1另存新檔為 B.sql 後將它關閉
再指定以 utf 8 編碼打開 B.sql 看看,資料內容已經還原到正常中文[quote]

好像似乎有點情況相似???只是小弟真不知該從何下手?找不到latin1?懇請您指點,謝謝您!

discuss pic 2013-02-25 00:11:07
這是意料中的事
我在此帖已經說了>>>
參照:
關於您的虛擬主機上的 mysql 4.0.27 版本問題
提供您我在過去曾用過 mysql 4.0.** 的經驗
讓您知道
mysql 4.0 與 mysql 4.1 之間存在一道分水嶺
而低於 mysql 5.5 與 達 mysql 5.5 以上版本尚且存在明顯的不同
更何況 mysql 4.0 與跨上更多道的高版本的 mysql 5.5 呢?


已說明 mysql 4.0 轉到 mysql 4.1 有亂碼問題
何況您的由 mysql 4.0 轉到 mysql 5.0 ?

參照:
小弟原先照TAD大的書,在主機上早為xoops2.2big,幾年前升級xoops2.3.3big,
是最近照TAD大的2.5X書,成功轉為xoops2.3.3UTF8後,才從主機上備份資料庫與實體檔到電腦中,
而主機上經確認環境後,才升級為2.4.5UTF8


先不論 XOOPS 版本混亂及編碼問題
搞定電腦裡的伺服器環境再說
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
discuss pic 2013-02-25 09:45:06
參照:

waterlily 寫道:
搞定電腦裡的伺服器環境[/url]再說


謝謝waterlily的再三強調與提醒,
小弟照做了,安裝了XAMPP1.4.9版本,還沒有正確結果?
結果為下四圖..試問?
1.不知資料表是否編碼正確?第二張有亂碼,但進入第三張卻無亂碼..
2.小弟實體檔在htdocs資料夾裡,mainfile.php也修了,小弟用firefox,http://localhost/進站台,卻一直為http://localhost/xampp/splash.php?是否還要做其它設定呢?謝謝您..
discuss pic 2013-02-25 10:12:36
mainfile.php(或secure.php) 找一下

define( 'XOOPS_DB_CHARSET', 'utf8' );

確定一下這一行有沒有那個[utf8]
discuss pic 2013-02-25 10:30:51
參照:

hirokofan 寫道:
mainfile.php(或secure.php) 找一下

define( 'XOOPS_DB_CHARSET', 'utf8' );

確定一下這一行有沒有那個[utf8]


謝謝回覆
小弟找到了,也補上了UTF8,但用兩個瀏覽器測試截圖為:
圖1,2:chrome,有連接到站台,但中文與亂碼參各半?
圖3:firefox,locahost沒連線到站台..
懇請版大協助,(快成功了 ),真的很謝謝大家!!
discuss pic 2013-02-25 10:49:32
XOOPS2.5的話去[維護]把CACHE清掉再跑一次(2.4以前要去找快取的資料夾砍東西)

去PHPMYADMIN那邊看tad_cbox的資料庫編碼是否有改到UTF-8

第三張圖似乎是之前就已經連不上了?而且要測試的話應該是連index.php吧

參考看看
http://hc.cyc.edu.tw/modules/tadnews/index.php?nsn=56
discuss pic 2013-02-25 11:15:02
參照:

hirokofan 寫道:
XOOPS2.5的話去[維護]把CACHE清掉再跑一次(2.4以前要去找快取的資料夾砍東西)

去PHPMYADMIN那邊看tad_cbox的資料庫編碼是否有改到UTF-8

第三張圖似乎是之前就已經連不上了?而且要測試的話應該是連index.php吧

參考看看
http://hc.cyc.edu.tw/modules/tadnews/index.php?nsn=56


謝謝回應,
1.小弟己清空cache快取三個目錄,亂碼情況還是樣
2.小弟確認firefxo,是用locohost進站台站,卻不知為何會到http://localhost/xampp/splash.php,而無法連接站台。(chrome可以),
只好再來試試wateriliy,有關亂碼轉檔的問題..我很謝謝大家,,我再努力中..
discuss pic 2013-02-25 16:35:36
參照:

qaimut 寫道:
參照:

waterlily 寫道:
搞定電腦裡的伺服器環境[/url]再說


謝謝waterlily的再三強調與提醒,
小弟照做了,安裝了XAMPP1.4.9版本,還沒有正確結果?
結果為下四圖..試問?
1.不知資料表是否編碼正確?第二張有亂碼,但進入第三張卻無亂碼..
2.小弟實體檔在htdocs資料夾裡,mainfile.php也修了,小弟用firefox,http://localhost/進站台,卻一直為http://localhost/xampp/splash.php?是否還要做其它設定呢?謝謝您..


請問waterlily:
是否小弟安裝的xampp1.4.9版本過低造成的,連要安裝xoops2.4.5,也是亂碼?
若您不介意的話,小弟可否請您幫忙看資料庫.sql的編碼呢?約有6M,不知如何傳給您過目?謝謝!
另外,本站台如何修改信箱,我無法修改編輯先前的email!
discuss pic 2013-02-25 17:31:41
請先解決一個問題再問下一個
現在先回覆五樓與七樓帖子的

從附圖看
前台與資料庫方面初步看來大致正常
不需要去做 sql 檔案中文亂碼還原

五樓帖子除圖四外其它都正常 ( 圖二情況就像此帖一樣,所以不算是資料庫問題 )
圖四問題先試試清除 firefox 瀏覽器裡的 cache 再看看

七樓帖子
圖一 網站前台大致正常
僅小部分 tad_cbox 區塊內容亂碼
先請問 tad_cbox 模組首頁下留言內容正常否?

圖二 查看語言檔編碼
圖三 如上覆圖四所言先清除 firefox 快取再看看
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
discuss pic 2013-02-25 20:10:55
參照:

七樓帖子
圖一 網站前台大致正常
僅小部分 tad_cbox 區塊內容亂碼
先請問 tad_cbox 模組首頁下留言內容正常否?

圖二 查看語言檔編碼
圖三 如上覆圖四所言先再看看


很謝謝wateriliy的指導:
1.清除 firefox 快取,己可正常瀏覽
2.查看資料庫的tad_cbox還是亂碼出現,
3.站台的亂碼及tad_cbox要透過瀏覽器切換語系UTF-8才會正常,若沒切換瀏覽器原編碼為英文/西歐語係(截圖)



discuss pic 2013-02-25 21:39:15
[quote]僅小部分 tad_cbox 區塊內容亂碼 先請問 tad_cbox 模組首頁下留言內容正常否?[/quote] 我在上面的意思是查看 [color=ff0000]http://********/modules/tad_cbox/[/color] 此頁面下的留言內容是否正常。 如果該頁面正常僅 tad_cbox 區塊內容亂碼,就試試在 /tad_cbox/index.php 下約189行加入宣告及語言,讓瀏覽器[color=ff0000]自動切換[/color]相應的語言 找出一段 [code] if($_GET['mode']=="box"){ echo "[color=ff0000][/color] [/code] 改為 [code] if($_GET['mode']=="box"){ echo "[color=ff0000] [/color] [/code]
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
discuss pic 2013-02-25 23:14:54
回 10 樓帖子
附圖中安裝第一步頁面下的亂碼,其內容是來是語言檔,跟 xampp 版本沒有關係,試試調整一下您的瀏覽器語言編碼。
不過我查看該頁面的 php 檔,另有新發現,它的最後一行多了 ?>
請編輯更正 XOOPS/install/page_langselect.php 裡的兩個 ?>
去一留一


至於資料庫 sql 檔,若虛擬主機 mysql 4.0.27 ==>> 電腦裡 mysql 4.0.21 之後前台及phpmyadmin 裡皆顯示正常的話就沒有修改sql檔的需要(其實兩者都是 4.0 版本基本上出亂碼問題的機會很低)。若您需要檢查而請我過目,那就寄到 waterlily#waterlily-lsl*com 郵箱去吧

( 請將 # 轉為 @,* 轉為點號 )
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
discuss pic 2013-02-26 08:31:10
謝謝wateriliy: 1.是的,http://localhost/modules/tad_cbox/index.php,首頁(觀看留言正常),僅留言版區塊為亂碼, 小弟找到其檔案,按您提供的語法,如實照貼如下:(186~191行) if($_GET['mode']=="box") {echo " 但其結果還是亂碼,還是我那裡弄錯嗎?我是在自己的電腦用locohost執行觀看,是否那兩個網址要改成本機的路徑呢? 2.小弟己刪除多的?> 3.可是很奇怪的是,瀏覽器(己清快取)一進入安裝頁面,自動就是西歐語系亂碼,改了firefox的語言編碼UTF8,就正常,但安裝下一步,又是西歐語系的亂碼,然後又要再改一次UTF8,如此反覆下一步又回西歐語系亂碼?情況跟進入本機XOOPS站台一樣啊 意即,凡是firefox一進XOOPS,就自動出現西歐語的編碼,改了瀏覽器的語系為UTF8顯示正常,重新整理瀏覽器,又是預設西歐語系的亂碼,下步安裝亦同?.. 4.己傳SQL檔至版大的信箱,非常感謝您的協助!
discuss pic 2013-02-26 22:09:25
sql 已看了
如我所言是不需修改
此檔是 OK 正常的

至於亂碼問題您試試編輯 \xampp\apache\conf\httpd.conf 此檔
利用搜尋功能找出 AddDefaultCharset
將 AddDefaultCharset ISO-8859-1 改為 AddDefaultCharset UTF-8 後重新啟動伺服器
試試看吧
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
discuss pic 2013-02-27 11:59:26
[quote] waterlily 寫道: 至於亂碼問題您試試編輯 \xampp\apache\conf\httpd.conf 此檔 利用搜尋功能找出 AddDefaultCharset 將 AddDefaultCharset ISO-8859-1 改為 [color=000099]AddDefaultCharset UTF-8[/color] 後重新啟動伺服器 試試看吧[/quote] 真的實在是太棒了!!謝謝waterlily的教導: 終於可以正常顯示編碼UTF-8了,架設XOOPS2.4.5,及進入備份的站台都OK了, 但是站台內的模組運作不正常,如圖片,影片及下載附檔的文件,都無法正常顯示,先前在主機上行事曆的內容也不見了!還是mainfile.php的呢?小弟清空快取,更新模組後,還是一樣..附上截圖與偵錯.. 懇請指導!謝謝您! Errors Notice: Constant TADTOOLS_PATH already defined in file /modules/tadtools/tadtools_header.php line 9 Notice: Constant TADTOOLS_URL already defined in file /modules/tadtools/tadtools_header.php line 10 Notice: Use of undefined constant WEB_THEME - assumed 'WEB_THEME' in file /modules/tadtools/tadtools_header.php line 21 Notice: Undefined variable: xoopsConfig in file /header.php line 40 Notice: Undefined variable: xoopsConfig in file /header.php line 40 Notice: Constant _TAD_NEED_TADTOOLS already defined in file /modules/tad_cbox/language/tchinese_utf8/blocks.php line 21 Notice: Use of undefined constant WEB_THEME - assumed 'WEB_THEME' in file /modules/tadtools/tadtools_header.php line 21 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined index: 0 in file /modules/tadnews/blocks/tadnews_content_block.php line 161 Notice: Undefined variable: xoopsUser in file /include/notification_select.php line 34 Queries SET NAMES 'UTF-8' Error number: 1193 Error message: Unknown system variable 'NAMES' SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC SELECT sess_data, sess_ip FROM session WHERE sess_id = '78e0d6b8273ee54d931e5f4b5e721761' SELECT * FROM users WHERE uid = '1' SELECT * FROM modules WHERE dirname = 'tad_cal' SELECT * FROM config WHERE (conf_modid = '56') ORDER BY conf_order ASC select `cate_sn`,`enable_group`,`cate_enable` from tad_cal_cate select `cate_sn`,`cate_title`,`cate_bgcolor`,`cate_color` from tad_cal_cate where cate_sn in(0,1,2) order by `cate_sort` select `cate_sn`,`enable_upload_group`,`cate_enable` from tad_cal_cate select cate_sn,cate_title from tad_cal_cate where cate_sn in(0,1,2) order by `cate_sort` SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1) SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,56,-1) AND b.bid IN (222,221,220,217,210,209,208,207,206,205,204,198,197,185,184,186,187,188,189,191,190,74,193,80,69,192,66,57,59,9,92,5,3,2,1,77,39,23,6,250,249,251,228,229,235,240,239,238,237,236) ORDER BY b.weight, m.block_id SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_themes.html') ORDER BY tpl_refid SELECT texto, autor FROM citas ORDER BY RAND() LIMIT 1 SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'random_quote_block.html') ORDER BY tpl_refid SELECT * FROM modules WHERE dirname = 'tad_cbox' SELECT * FROM config WHERE (conf_modid = '22') ORDER BY conf_order ASC SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tad_cbox_block.html') ORDER BY tpl_refid update tad_news set always_top='0' WHERE always_top_date <='2013-02-27 12:06:11' and always_top_date!='0000-00-00 00:00:00' select ncsn,nc_title from tad_news_cate where not_news!='1' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='4' select * from tad_news_cate where ncsn='7' select * from tad_news_cate where ncsn='9' select * from tad_news_cate where ncsn='15' select * from tad_news_cate where ncsn='14' select * from tad_news where enable='1' and (ncsn in(1,4,7,9,15,14) or ncsn='0') and start_day < '2013-02-27 12:06:11' and (end_day > '2013-02-27 12:06:11' or end_day='0000-00-00 00:00:00') order by `always_top` desc , start_day desc limit 0 , 15 select * from tad_news_cate where ncsn='1' SELECT * FROM users WHERE uid = '50' select * from tad_news_cate where ncsn='1' SELECT * FROM users WHERE uid = '37' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='7' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='9' select * from tad_news_cate where ncsn='4' select * from tad_news_cate where ncsn='1' select * from tad_news_cate where ncsn='1' SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tadnews_content_block.html') ORDER BY tpl_refid select `cate_sn`,`enable_group`,`cate_enable` from tad_cal_cate select * from tad_cal_event where `start` >= '2013-02-27 00:00:00' and `end` <= '2013-03-13 23:59:59' and cate_sn in(0,1,2) order by `start` , `sequence` select a.*,b.title,b.cate_sn from tad_cal_repeat as a join tad_cal_event as b on a.sn=b.sn where a.`start` >= '2013-02-27 00:00:00' and a.`end` <= '2013-03-13 23:59:59' and b.cate_sn in(0,1,2) order by a.`start` SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tad_cal_list.html') ORDER BY tpl_refid SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid SELECT cfgname, cfgvalue FROM logcounterx_cfg SELECT cnt FROM logcounterx_count WHERE ymd = '2013-02-27' SELECT cnt FROM logcounterx_count WHERE ymd = '2013-02-26' SELECT sum(cnt) as CNT FROM logcounterx_count WHERE ymd >= '2013-02-24' SELECT sum(cnt) as CNT FROM logcounterx_count WHERE (ymd like '2013-02-%') OR (ymd like '2013/02/%') SELECT cnt FROM logcounterx_count WHERE (ymd = '1111-11-11') OR (ymd = '1111/11/11') SELECT count(ymd) AS DAYS, sum(cnt) as CNT FROM logcounterx_count WHERE ymd > '1111-11-11' SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'lcx_block_display.html') ORDER BY tpl_refid SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tad_cal_index_tpl.html') ORDER BY tpl_refid select * from tad_themes where `theme_name`='school2012' select conf_value from config where conf_title ='_MD_AM_DEBUGMODE' select a.*,b.slide_width,b.slide_height from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id and b.`theme_name`='school2012' where a.`col_name`='slide' select dirname,name from modules where isactive='1' and hasmain='1' and weight > 0 order by weight Total: 58 queries Blocks 自定義區塊(HTML): No Cache 自定義區塊(HTML): No Cache 自定義區塊(HTML): No Cache 自定義區塊(HTML): No Cache 自定義區塊(HTML): No Cache 自定義區塊(HTML): No Cache 自定義區塊(HTML): No Cache 網站佈景: No Cache 隨機小語: No Cache 即時留言簿: No Cache 本站最新消息: No Cache 近期事項: No Cache 自定義區塊(HTML): No Cache 計數器: No Cache 紀錄區塊: No Cache Total: 15 blocks Extra Included files: 95 files Memory usage: 43,716 K [Estimated] Timers XOOPS took 0.982 seconds to load. XOOPS Boot took 0.115 seconds to load. Module init took 0.169 seconds to load. XOOPS output init took 0.522 seconds to load. Module display took 0.006 seconds to load. Page rendering took 0.155 seconds to load. 小弟還是把mainfile.php請您過目好了: http://www.fsf.org/copyleft/gpl.html * * @copyright The XOOPS project http://www.xoops.org/ * @license http://www.fsf.org/copyleft/gpl.html GNU General Public License (GPL) * @version $Id: mainfile.dist.php 2024 2008-08-31 03:24:12Z phppp $ */ if ( !defined("XOOPS_MAINFILE_INCLUDED") ) { define( 'XOOPS_MAINFILE_INCLUDED', 1 ); // XOOPS Physical Paths // Physical path to the XOOPS documents (served) directory WITHOUT trailing slash define( 'XOOPS_ROOT_PATH', 'D:/xampplite/htdocs' ); // For forward compatibility // Physical path to the XOOPS library directory WITHOUT trailing slash define( 'XOOPS_PATH', 'D:/xampplite/htdocs/hualien_lib' ); // Physical path to the XOOPS datafiles (writable) directory WITHOUT trailing slash define( 'XOOPS_VAR_PATH', 'D:/xampplite/htdocs/hualien_data' ); // Alias of XOOPS_PATH, for compatibility, temporary solution define("XOOPS_TRUST_PATH", XOOPS_PATH); // XOOPS Virtual Path (URL) // Virtual path to your main XOOPS directory WITHOUT trailing slash // Example: define( 'XOOPS_URL', 'http://localhost' ); define( 'XOOPS_URL', 'http://localhost' ); define( 'XOOPS_CHECK_PATH', 1 ); // Protect against external scripts execution if safe mode is not enabled if ( XOOPS_CHECK_PATH && !@ini_get("safe_mode") ) { if ( function_exists("debug_backtrace") ) { $xoopsScriptPath = debug_backtrace(); if ( !count($xoopsScriptPath) ) { die("XOOPS path check: this file cannot be requested directly"); } $xoopsScriptPath = $xoopsScriptPath[0]["file"]; } else { $xoopsScriptPath = isset($_SERVER["PATH_TRANSLATED"]) ? $_SERVER["PATH_TRANSLATED"] : $_SERVER["SCRIPT_FILENAME"]; } if ( DIRECTORY_SEPARATOR != "/" ) { // IIS6 may double the \ chars $xoopsScriptPath = str_replace( strpos( $xoopsScriptPath, "\", 2 ) ? "\" : DIRECTORY_SEPARATOR, "/", $xoopsScriptPath); } if ( strcasecmp( substr($xoopsScriptPath, 0, strlen(XOOPS_ROOT_PATH)), str_replace( DIRECTORY_SEPARATOR, "/", XOOPS_ROOT_PATH)) ) { exit("XOOPS path check: Script is not inside XOOPS_ROOT_PATH and cannot run."); } } // Database // Choose the database to be used define( 'XOOPS_DB_TYPE', 'mysql' ); // Set the database charset if applicable if (defined("XOOPS_DB_CHARSET")) die(); define( 'XOOPS_DB_CHARSET', 'UTF-8' ); // Table Prefix // This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default "xoops". define( 'XOOPS_DB_PREFIX', 'hd' ); // Database Hostname // Hostname of the database server. If you are unsure, "localhost" works in most cases. define( 'XOOPS_DB_HOST', 'localhost' ); // Database Username // Your database user account on the host define( 'XOOPS_DB_USER', 'root' ); // Database Password // Password for your database user account define( 'XOOPS_DB_PASS', 'jjjj' ); // Database Name // The name of database on the host. The installer will attempt to create the database if not exist define( 'XOOPS_DB_NAME', 'hualien' ); // Use persistent connection? (Yes=1 No=0) // Default is "Yes". Choose "Yes" if you are unsure. define( 'XOOPS_DB_PCONNECT', 0 ); define( 'XOOPS_GROUP_ADMIN', '1' ); define( 'XOOPS_GROUP_USERS', '2' ); define( 'XOOPS_GROUP_ANONYMOUS', '3' ); $enable_protector = true; if ( !empty($enable_protector) ) { @include xoops_trust_path."/modules/protector/include/postcheck.inc.php"; } if (!isset($xoopsOption["nocommon"]) && XOOPS_ROOT_PATH != "") { include XOOPS_ROOT_PATH."/include/common.php"; } if ( !empty($enable_protector) ) { @include xoops_trust_path."/modules/protector/include/postcheck.inc.php"; } } ?>
discuss pic 2013-02-27 22:35:39
有沒有將虛擬主機上的 uploads 資料夾下載到電腦裡?
有沒有將資料庫裡的網域例如 ****_tad_themes 裡面的虛擬主機網域改為本機網域?
其它資料表裡若有的話也去改
若本機的 uploads 資料夾已有了
資料庫裡網域也改了
情況仍如此的話
您就在失效圖片上按右鍵複製圖片網址
獨立貼到新頁籤網址欄裡
看看結果如何
顯示什麼錯誤碼
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
discuss pic 2013-02-28 12:59:11
謝謝waterlily:

小弟檢視了:
1.本機站台有uploads的資料夾,其圖片都在這個資料夾裡,
2.其資料庫原先的所有網域也都改成了http://localhost的本機網域,
但還是無法正常顯示站台的所有圖片,
3.在失效圖片上按右鍵複製圖片網址,獨立貼到新頁籤網址欄裡,也是沒效果(截圖)

懇請waterlily指導,或者,我還要再三檢視那個部份呢?謝謝...
discuss pic 2013-02-28 13:33:49
您將 xampp/apache/logs/error.log 和 xampp/apache/logs/access.log 這兩檔記錄寄到我的郵箱去
主頁:睡蓮‧池水間(支援Android4.0+及iOS5+)|論壇:風起漣漪|作品區:軒榭亭臺
第一頁 上一頁 1   2  下一頁 最後頁
:::

即時留言簿


計數器

今天: 238238238
昨天: 313313313
總計: 4096803409680340968034096803409680340968034096803