Advertisement:

Author Topic: 1.1 Converters  (Read 390675 times)

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Re: 1.1 Converters
« Reply #40 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 ?

Offline davo88

  • Jr. Member
  • **
  • Posts: 140
Re: 1.1 Converters
« Reply #41 on: July 16, 2005, 08:21:21 AM »
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

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Re: 1.1 Converters
« Reply #42 on: July 16, 2005, 08:46:01 AM »
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;

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Re: 1.1 Converters
« Reply #43 on: July 16, 2005, 08:48:41 AM »
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 ?

Offline davo88

  • Jr. Member
  • **
  • Posts: 140
Re: 1.1 Converters
« Reply #44 on: July 16, 2005, 09:01:09 AM »
Quote
I 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.

Quote
Do 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

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Re: 1.1 Converters
« Reply #45 on: July 16, 2005, 09:21:28 AM »
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.

Offline dimitrist

  • Semi-Newbie
  • *
  • Posts: 33
Re: 1.1 Converters
« Reply #46 on: July 16, 2005, 03:08:40 PM »
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


Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: 1.1 Converters
« Reply #47 on: July 16, 2005, 03:51:37 PM »
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]

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Re: 1.1 Converters
« Reply #48 on: July 17, 2005, 02:11:29 AM »
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.
« Last Edit: July 17, 2005, 02:20:55 AM by bjp »

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Re: 1.1 Converters
« Reply #49 on: July 17, 2005, 05:20:07 AM »
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
 

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: 1.1 Converters
« Reply #50 on: July 17, 2005, 06:14:48 PM »
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]

Offline dimitrist

  • Semi-Newbie
  • *
  • Posts: 33
Re: 1.1 Converters
« Reply #51 on: July 17, 2005, 07:54:01 PM »
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.

Offline davo88

  • Jr. Member
  • **
  • Posts: 140
Suggestion - Mark all topics as read
« Reply #52 on: July 20, 2005, 08:13:46 PM »
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
« Last Edit: July 21, 2005, 12:19:49 AM by davo88 »

Offline elvenjess

  • Semi-Newbie
  • *
  • Posts: 25
  • Gender: Male
Re: 1.1 Converters
« Reply #53 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:

Quote
Caused 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.  :-[
« Last Edit: July 20, 2005, 10:35:16 PM by elvenjess »

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: Suggestion - Mark all topics as read
« Reply #54 on: July 21, 2005, 02:16:57 AM »
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.

Quote
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?

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?

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]

Offline davo88

  • Jr. Member
  • **
  • Posts: 140
Re: 1.1 Converters
« Reply #55 on: July 21, 2005, 03:33:32 AM »
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.

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: 1.1 Converters
« Reply #56 on: July 21, 2005, 03:40:11 AM »
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]

Offline davo88

  • Jr. Member
  • **
  • Posts: 140
Re: 1.1 Converters
« Reply #57 on: July 21, 2005, 04:02:42 AM »
Reloaded a backup of the database fresh after the conversion from phpBB, then ran this to remove the new flag...

Code: [Select]
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...


Code: [Select]
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...

Code: [Select]
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


Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: 1.1 Converters
« Reply #58 on: July 21, 2005, 04:03:28 AM »
Instead of INSERT INTO, try REPLACE INTO.

-[Unknown]

Offline davo88

  • Jr. Member
  • **
  • Posts: 140
Re: 1.1 Converters
« Reply #59 on: July 21, 2005, 04:18:44 AM »
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.

Code: [Select]
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...

Code: [Select]
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.