|
Page 1 of 1
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Informpro
Joined: October 2008
Posts: 1110
Location:
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
Try mine in local, if you have backup as I said, If it works move it to your online site, if not try again :p.
|
#2 Sun 10 Jan, 2010 11:07 |
|
Danielc
Joined: August 2006
Posts: 248
Location:
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
I think i have seen a guide to convert PHPBB3 to IP, in this forum..
|
#3 Sun 10 Jan, 2010 17:26 |
|
Ripley
Joined: October 2009
Posts: 76
Location: Ufa
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
We converted phpbb3 to smf than to phpbb2 and when upgrading to ip everything moving but posts...
The script does not combines the 2 phpbb tables into one ip _posts
Please advice me how to solve the problem?
|
#4 Fri 15 Jan, 2010 16:56 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
The script should do that automatically... anyway it is quite easy doing it via SQL in PHPMyAdmin (I have added also the conversion for PMs Table):
CREATE TABLE `___posts___` (
`post_id` mediumint(8) unsigned NOT NULL auto_increment,
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`poster_id` mediumint(8) NOT NULL default '0',
`post_time` int(11) NOT NULL default '0',
`poster_ip` varchar(8) NOT NULL default '',
`post_username` varchar(25) default NULL,
`post_subject` varchar(255) default NULL,
`post_text` TEXT NOT NULL,
`post_text_compiled` TEXT NOT NULL,
`enable_bbcode` tinyint(1) NOT NULL default '1',
`enable_html` tinyint(1) NOT NULL default '0',
`enable_smilies` tinyint(1) NOT NULL default '1',
`enable_autolinks_acronyms` tinyint(1) NOT NULL default '1',
`enable_sig` tinyint(1) NOT NULL default '1',
`edit_notes` MEDIUMTEXT,
`post_edit_time` int(11) default NULL,
`post_edit_count` smallint(5) unsigned NOT NULL default '0',
`post_edit_id` mediumint(8) NOT NULL default '0',
`post_attachment` tinyint(1) NOT NULL default '0',
`post_bluecard` tinyint(1) default NULL,
PRIMARY KEY (`post_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster_id`),
KEY `post_time` (`post_time`)
);
INSERT INTO `___posts___`
SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time, p.poster_ip, p.post_username, t.post_subject, t.post_text, t.post_text_compiled, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_autolinks_acronyms, p.enable_sig, t.edit_notes, p.post_edit_time, p.post_edit_count, p.post_edit_id, p.post_attachment, p.post_bluecard
FROM `phpbb_posts` p, `phpbb_posts_text` t
WHERE p.post_id = t.post_id
ORDER BY p.post_id;
RENAME TABLE `phpbb_posts` TO `_old_phpbb_posts`;
RENAME TABLE `phpbb_posts_text` TO `_old_phpbb_posts_text`;
RENAME TABLE `___posts___` TO `phpbb_posts`;
CREATE TABLE `___privmsgs___` (
`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
`privmsgs_type` tinyint(4) NOT NULL default '0',
`privmsgs_subject` varchar(255) NOT NULL default '',
`privmsgs_text` TEXT NOT NULL,
`privmsgs_from_userid` mediumint(8) NOT NULL default '0',
`privmsgs_to_userid` mediumint(8) NOT NULL default '0',
`privmsgs_date` int(11) NOT NULL default '0',
`privmsgs_ip` varchar(8) NOT NULL default '',
`privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
`privmsgs_enable_html` tinyint(1) NOT NULL default '0',
`privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
`privmsgs_enable_autolinks_acronyms` tinyint(1) NOT NULL default '0',
`privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
`privmsgs_attachment` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`privmsgs_id`),
KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
);
INSERT INTO `___privmsgs___`
SELECT p.privmsgs_id, p.privmsgs_type, p.privmsgs_subject, t.privmsgs_text, p.privmsgs_from_userid, p.privmsgs_to_userid, p.privmsgs_date, p.privmsgs_ip, p.privmsgs_enable_bbcode, p.privmsgs_enable_html, p.privmsgs_enable_smilies, p.privmsgs_enable_autolinks_acronyms, p.privmsgs_attach_sig, p.privmsgs_attachment
FROM `phpbb_privmsgs` p, `phpbb_privmsgs_text` t
WHERE p.privmsgs_id = t.privmsgs_text_id
ORDER BY p.privmsgs_id;
RENAME TABLE `phpbb_privmsgs` TO `_old_phpbb_privmsgs`;
RENAME TABLE `phpbb_privmsgs_text` TO `_old_phpbb_privmsgs_text`;
RENAME TABLE `___privmsgs___` TO `phpbb_privmsgs`;
Make sure you are using the right prefix for your tables.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#5 Sat 23 Jan, 2010 11:53 |
|
Ripley
Joined: October 2009
Posts: 76
Location: Ufa
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
Quote: Make sure you are using the right prefix for your tables.
The problem solved, we were using wrong prefix
|
#6 Fri 05 Feb, 2010 20:23 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
So you managed to do the full process from phpBB 3 to phpBB 2?
Can you please share the full procedure and the files used for that?
Thank you very much.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#7 Sat 06 Feb, 2010 20:13 |
|
Ripley
Joined: October 2009
Posts: 76
Location: Ufa
|
Re: Downgrade Fromphpbb3 To2 Version,how To?
So you managed to do the full process from phpBB 3 to phpBB 2?
Can you please share the full procedure and the files used for that?
Thank you very much.
I ask one guy to convert forum and I do not really know all technical details , I found few topics here, gave him links to smf converter and he converted phpbb3 to smf and than to phpbb2. He do not know english as well to explain the full procedure But we were using advices which are at this forum and in my first message of this topic.
|
#8 Sun 07 Feb, 2010 13:50 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|