[問題]PHPBB PLUS 1.3

[大佬]

how to upgrade phpbb 2.06 to phpbb plus 1.3 ?

[文]

不建議裝PLUS1.3，雖然功能很多，很吸引新手
但真的不建議裝。。。我剛開始玩沒多久
也是被PLUS吸引過去。。。結果裝沒多久就拆掉了

１、竹貓PLUS分站的人蠻少的...問問題很久才有答案
２、裝了一堆沒用的東西。。。想拆又拆不掉(因為你不知道怎麼裝上去的)

[maxbrice]

我的做法如下(大約說一下)
1.你假如沒有安裝其他的mod的話,那就可以直接由phpBB2 plus 1.3內的安裝說明來進行安裝..
如下:

代碼: 選擇全部

Upgrade from existing phpBB 2.0.6
If you are already using Mods in your Forums that required Database Changes you may have problems installing this version. The included Database Update tool only creates fresh tables for the Mods and does NOT update any existing MODs you are using to the latest version. So what does that mean ? If you are running a phpBB 2.0.5 with for example Attachment Mod 2.3.5 or Lower you first have to update your Database to the Attachment Mod 2.3.8 that is included in phpBB2 plus. Check the directory docs/mods for information on the versions that are used in phpBB2 plus. If you have no Mods in your Forum that required Databse Changed just ignore this and go on.
Backup all your Data ! All Files from your FTP and also your SQL Database ! Don't cry if something goes wrong and you have no Backup !
Unzip the phpBB2 plus zipfile to a directory on your local harddisk
Upload only the File update/update_phpbb206_to_plus13.php to your existing phpBB2 Directory on the webserver
Login to your Forum as Administrator
Now open the File you uploadet before in your browser (http://your.forums.com/phpBB2/update_phpbb206_to_plus13.php)
You should see that additional tables are created now (Added/Updated)
Download the file config.php from your existing phpBB2 Forum and put it in a secure place (You need it later !)
If you used the attachment mod before you should backup your /files directory now. Also backup the users avatar directory which is images/avatars to use them later again.
Did you already Backup your old Data ? If not, now it's the last chance to do it !
Delete all Files of your old forums now (If you have own templates, images or graphics backup them first)
Copy all Files from the phpBB2 directory of the phpBB2 plus 1.3 package to your Webserver (including directory structure)
Copy the file config.php that you backup'd before to your phpBB2 Dir on the Webserver (overwrite the one that exists)
Delete or rename the directory /install
Change Permissions (CHMOD) to 777 on the directorys /files and /images/avatars and album_mod/upload and album_mod/upload/cache
Upload the "old" avatars and maybe files directory to your new Forum
Use the new Forum ;)

2.但你假如有裝最新的Attachment Mod 2.3.9的話,有可能跟我一樣升級無法順利\r
,會出現錯誤訊息.
那我建議先安裝新的phpBB2 plus 1.3(安裝的資料庫要更新檔名,這樣你才不會
跟之前的phpbb2.06混淆,也有個好處就是你安裝完後若覺得不好用的話,可以直\r
接把phpBB2 plus 1.3砍掉,一點都不會後悔),然後再把原先的phpBB2.06裡的資
料庫資料用phpmyadmin匯出..
匯出的步驟 :
1.打網址http://localhost/phpmyadmin/
2.選擇phpbb2.06資料庫裡的資料表例如:phpbb_users-->輸出(右上角)-->
勾選**使用 完整新增指令**及**下載儲存**
下載檔案裡的資料如下:

代碼: 選擇全部

資料庫 phpbb - 資料表 phpbb_users 在 localhost 執行 
# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# 主機: localhost
# 建立日期: Dec 20, 2003, 03:51 AM
# 伺服器版本: 4.0.16
# PHP 版本: 4.3.4
# 
# 資料庫: `phpbb`
# --------------------------------------------------------

#
# 資料表結構： `phpbb_users`
#

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
........................................
........................................  FULLTEXT KEY `username_2` (`username`)
) TYPE=MyISAM;

#
# 列出以下資料庫的數據： `phpbb_users`
#
INSERT INTO `phpbb_users` (`user_id`, `user_active`, `username`, `user_password`, `user_session_time`, `user_session_page`, `user_lastvisit`, `user_regdate`, `user_level`, `user_posts`, `user_timezone`, `user_style`, `user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_emailtime`, `user_viewemail`, `user_attachsig`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, `user_allow_pm`, `user_allow_viewonline`, `user_notify`, `user_notify_pm`, `user_popup_pm`, `user_rank`, `user_avatar`, `user_avatar_type`, `user_email`, `user_icq`, `user_website`, `user_from`, `user_sig`, `user_sig_bbcode_uid`, `user_aim`, `user_yim`, `user_msnm`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`) VALUES (-1, 0, 'Anonymous', '', 0, 0, 0, 1027939322, 0, 357, '0.00', NULL, '', '', 0, 0, 1070721566, NULL, 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '');
INSERT INTO `phpbb_users` (`user_id`, `user_active`, `username`, `user_password`, `user_session_time`, `user_session_page`, `user_lastvisit`, `user_regdate`, `user_level`, `user_posts`, `user_timezone`, `user_style`, `user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_emailtime`, `user_viewemail`, `user_attachsig`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, `user_allow_pm`, `user_allow_viewonline`, `user_notify`, `user_notify_pm`, `user_popup_pm`, `user_rank`, `user_avatar`, `user_avatar_type`, `user_email`, `user_icq`, `user_website`, `user_from`, `user_sig`, `user_sig_bbcode_uid`, `user_aim`, `user_yim`, `user_msnm`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`) VALUES (2, 1, 'root', 'fdfds27d7fdfsff908635a158fdsf', 13433219, 0, 1043227927, 1027939322, 1, 9, '0.00', 1, 'chinese_traditional_taiwan', 'd M Y h:i a', 0, 0, 0, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, '', 0, 'root@localhost', '', '', '', '', '', '', '', '', '', '', '', '');

...............................................
.......................................

然後先把前兩個INSERT INTO 的帳號刪掉(一個是匿名,以個管理者帳號,這兩個帳號在你安裝新的plus1.3就會有了,故要刪掉),

代碼: 選擇全部

INSERT INTO `phpbb_users` (`user_id`, `user_active`, `username`, `user_password`, `user_session_time`, `user_session_page`, `user_lastvisit`, `user_regdate`, `user_level`, `user_posts`, `user_timezone`, `user_style`, `user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_emailtime`, `user_viewemail`, `user_attachsig`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, `user_allow_pm`, `user_allow_viewonline`, `user_notify`, `user_notify_pm`, `user_popup_pm`, `user_rank`, `user_avatar`, `user_avatar_type`, `user_email`, `user_icq`, `user_website`, `user_from`, `user_sig`, `user_sig_bbcode_uid`, `user_aim`, `user_yim`, `user_msnm`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`) VALUES (-1, 0, 'test', '', 0, 0, 0, 1027939322, 0, 357, '0.00', NULL, '', '', 0, 0, 1070721566, NULL, 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '');

還有以下這行文字以上的東西也要刪掉,因為沒有用了....

代碼: 選擇全部

#
# 列出以下資料庫的數據： `phpbb_users`
#

3.回到資料表 phpbb_users-->SQL-->瀏覽檔案(重新顯示 SQL 語法
或 文字檔案的位置 ,把剛才的檔案匯入).-->按執行,就會執行SQL語
法了..
4.其他的資料表匯入方式大同小異 (你可以比對phpBB2 plus 1.3及
phpbb2.06的資料表哪些,把你phpbb2.06裡資料表內的內容匯入到\r
phpBB2 plus 1.3裡面),這樣匯入可以保留以前的他人帳號
及密碼和基本設定並且之前的討論的資料也一併轉移.只是粉麻煩,若留言
筆數 太多的話會執行相當的慢..
我建議是在本機把資料庫做完,再把資料庫上傳至網路上
會比較快也有機會一錯再錯.
若你真的按照我這樣做的話代表你很傻,但相\r
對的你對phpbb的資料庫結構會有更深的了解 .....