News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

1.1 Converters

Started by Grudge, June 15, 2005, 04:46:34 PM

Previous topic - Next topic

bjp

phpbb 2.0.3 to smf 1.1

Ok, I almost finish the conversion (330 000 topics), but it does not convert my members at all. Except this, everything is ok, but zero member !

Is there a solution ?

davo88

Perhaps it has something to do with the version of phpBB?  ... 2.0.3 is quite old now. Have you thought about upgrading to 2.0.16? - the converter works well on that.

The phpBB upgrade (changed files) package includes everything to upgrade from older versions to 2.0.16.

You can get it here -   http://www.phpbb.com/downloads.php

bjp

Hi
I just look at the phpbb_users table and compare it with 2.16, it's exactly the same.

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default NULL,
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(4,2) NOT NULL default '2.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default 'french',
  `user_dateformat` varchar(14) NOT NULL default '',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '0',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default NULL,
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM;

bjp

I use the convert.php and the last phpbb2_to_smf.sql
Do i have to change something in the convert.php to be use the last phpbb2_to_smf.sql ?

davo88

QuoteI just look at the phpbb_users table and compare it with 2.16, it's exactly the same.

Yes, it does look pretty much the same as 2.0.16. However, maybe the problem is caused by something else in the database that is different.

QuoteDo i have to change something in the convert.php to be use the last phpbb2_to_smf.sql ?

No, I didn't. Just uploaded them and ran convert.php

bjp

Well, I can't use it because of zero member !!!

What is strange is that with or with out this file (phpbb2_to_smf.sql ) I have the same résult. All the post are convert, but not even one member.

dimitrist

Quote from: bjp on July 16, 2005, 08:10:32 AM
phpbb 2.0.3 to smf 1.1

Ok, I almost finish the conversion (330 000 topics), but it does not convert my members at all. Except this, everything is ok, but zero member !

Is there a solution ?

I have excactly the same problem with you using latest phpbb . I even tried to upload a fresh copy of smf 1.05 and update from there but didnt worked also.

Dont know what is the problem i will try tonight with a fresh copy of phpbb cause the only mod that i have installed on phpbb is user details.

I will try tonight without that also and give feedback


[Unknown]

Are you *ENTIRELY SURE* you are not using the old phpbb2_to_smf.php file?  If you have one of these, delete it.  You want convert.php, and it must be the one attached to the first post of this topic.

-[Unknown]

bjp

#48
I only find to download one phpbb2_to_smf.php file, in the download section of this forum.
That the fact. I did not see the new convert.php.
Sorry, I try right now with this.

bjp

Ok, everything is fine. I'm sorry for this error.
Can some one give me an advice how to delete with sql all the Personalized Picture that the people download (avatar) ... delette from FROM `smf_members` .....


Total des sujets: 18505
Total des messages: 346445
Total des membres: 28520


[Unknown]

For uploads, I would suggest doing it through the administration center.  There's an area to manage attachments, and under that, avatars.

You can also take away everyone's avatars with this query:

UPDATE smf_members
SET avatar = '';

What is phpMyAdmin?

-[Unknown]

dimitrist

ok i managed to install it .The way that i did is the followin

if you are using phpbb

Download a fress copy from phpbb

backup you conf.php from the forum folder
upload all the files from phpbb

Run update if you dont know which version you got

restore conf.php in its original position

run the script convert as said

It seems the problem is the mods installed on phpbb.

davo88

#52
Suggestion - Mark all topics as read

[Unknown],

Been testing the phpBB converter and just realized that after conversion, every topic in every forum is displayed as "new" for every user. So once the new SMF forum is established, every user has to go through every forum (37 of them in my case) and hit  "Mark Topics as Read for this Board".

Just wondering if it would it be possible to include an optional switch, so that all topics for all users are marked as "read" in the converted SMF forum?

I realize that any new topics posted in the original phpBB forum and not read by the user before conversion, will be marked as "read" in the new SMF forum. But having them all marked "new" is no better, as they can't tell what's really "new" from what's not really new - plus they then have to go through 37 forums and mark them all as read anyway.

If a switch is not possible, can I do this in the database by running a query of some sort?

Davo

elvenjess

#53
I just ran the OpenBB 1.0.x to SMF convertor on a fresh install of SMF 1.1 Beta 3 Public. It was unsuccesful in converting posts. It showed a huge dump of what looks like various posts and then at the end says:

QuoteCaused the error:

    Duplicate entry '45171' for key 1

Pressing Try Again yields the same result.  :-\

I was able to log into the forum and after using the matience functions it appears that the numbers and members are alright. Trouble is, the categories, topics, and posts are messed up.  :-[

[Unknown]

Quote from: davo88 on July 20, 2005, 08:13:46 PM
Been testing the phpBB converter and just realized that after conversion, every topic in every forum is displayed as "new" for every user. So once the new SMF forum is established, every user has to go through every forum (37 of them in my case) and hit  "Mark Topics as Read for this Board".

Actually, there's a button at the very bottom of the board index to mark everything read.  Since phpBB stores this as a cookie, it's hard to translate.

QuoteJust wondering if it would it be possible to include an optional switch, so that all topics for all users are marked as "read" in the converted SMF forum?

An option might be doable...

Quote
If a switch is not possible, can I do this in the database by running a query of some sort?

INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

What is phpMyAdmin?

Quote from: elvenjess on July 20, 2005, 10:30:27 PM
I just ran the OpenBB 1.0.x to SMF convertor on a fresh install of SMF 1.1 Beta 3 Public. It was unsuccesful in converting posts. It showed a huge dump of what looks like various posts and then at the end says:

Thanks for testing this - you're the first I know of.

Quote
I was able to log into the forum and after using the matience functions it appears that the numbers and members are alright. Trouble is, the categories, topics, and posts are messed up.  :-[

It couldn't finish, so nothing is going to be proper.  Interesting, though.  It almost sounds like there are posts with duplicate IDs or something...

SELECT id, COUNT(id) AS c
FROM obb_posts
GROUP BY id
HAVING c != 1;

If this returns any rows, your database may be... fun to convert.  If it doesn't, I may want to ask for a more complete error message - at least what table it is INSERTing INTO.

-[Unknown]

davo88

Quote from: [Unknown]INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

Thanks for this. It removed the "new" flag successfully, but left the new topic icon switched on next to each board name on the index page.

Thanks for pointing out the "Mark ALL messages as read" link too.

[Unknown]

For that, also use:

INSERT INTO smf_log_boards
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

-[Unknown]

davo88

Reloaded a backup of the database fresh after the conversion from phpBB, then ran this to remove the new flag...

INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;


then this one to turn off the new topic icon...


INSERT INTO smf_log_boards
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;



Second one produced an error message and left the new topic icons on...

SQL-query:

INSERT INTO smf_log_boards(

ID_MEMBER,
ID_BOARD,
logTime
)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP( )
FROM smf_members AS mem, smf_boards AS b
MySQL said: 

#1062 - Duplicate entry '2-1' for key 1


Davo


[Unknown]

Instead of INSERT INTO, try REPLACE INTO.

-[Unknown]

davo88

That did it!  ;D ;D

So for anyone wanting to do a global reset of all message flags for all members after conversion to SMF. run this query to remove the new flag in the topic list.

INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;


Then this one to turn off the new topic icon on the board index...

REPLACE INTO smf_log_boards
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b


Thanks again [Unknown] - your service is legendary. And these little things will make the transition so much smoother.

Advertisement: