Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Downgrade Fromphpbb3 To2 Version,how To? 
 
Hello! Please tell me where can I get downgrader from forum version phpbb3 to phpbb2 ? I need this becauseyou wrote that I can convert phpbb forum into ip only from second version, and I haveversion 3.0.5
Please help me  

I found this script http://www.icyphoenix.com/viewtopic...ingle_Post_View  and that topic http://www.icyphoenix.com/viewtopic.php?f=35&t=5812 , guess something will work  
 



 
RipleySend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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.
 



 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Downgrade Fromphpbb3 To2 Version,how To? 
 
I think i have seen a guide to convert PHPBB3 to IP, in this forum..
 



 
DanielcSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 



 
RipleySend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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):

Code: [Download] [Hide] [Select]
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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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  
 



 
RipleySend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Downgrade Fromphpbb3 To2 Version,how To? 
 
Mighty Gorgon wrote: [View Post]
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.
 



 
RipleySend private messageVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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