Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: wildtype on December 17, 2004, 03:31:56 AM

Title: can not convert topics and articles from phpbb2
Post by: wildtype on December 17, 2004, 03:31:56 AM
Hi,

     I try to convert my phpbb2 to smf, I did successfuly convert
my member lists, and board. but failed to convert other,

     I can see there are hundreds of topics in the frontpage, but failed to see the detailed
topics and artilces,:'( hope someone can help!


   Thank you.

   
    version info phpbb2: 2.0.11
                       smf      1.0 rc2



(http://life.nthu.edu.tw/~b831616/smf.gif)
Title: Re: can not convert topics and articles from phpbb2
Post by: Grudge on December 17, 2004, 04:29:59 AM
1) Did you have any major mods installed on phpBB that may have changed tables?
2) Have you tried going to Admin -> Forum Maintenance -> "Repair any errors" THEN "Recount all forum stats"

Did you get any errors during conversion?
Title: Re: can not convert topics and articles from phpbb2
Post by: wildtype on December 17, 2004, 05:08:04 AM
Quote from: Grudge on December 17, 2004, 04:29:59 AM
1) Did you have any major mods installed on phpBB that may have changed tables?
2) Have you tried going to Admin -> Forum Maintenance -> "Repair any errors" THEN "Recount all forum stats"

Did you get any errors during conversion?

first one is hard to say, I installed easymod, attachmod, and topic calendar, I might forgot some minor others

2. yeah, I tried it , it would flush all the topics since smf can't find the topics

3.no, I don't think so, some avatars loss, but I think it should be alright,


    thank you very much for your quick response~

here is the result~

Converting...
Converting ranks... successful.
Converting groups... successful.
Converting members...
Warning: copy(c:\appserv\www\phpbb_clean/images/avatars/7f0000014133e70f60757.jpg): failed to open stream: No such file or directory in c:\appserv\www\temp\phpbb2_to_smf.php on line 503

Warning: copy(c:\appserv\www\phpbb_clean/images/avatars/d34a941141b6acd1e791b.jpg): failed to open stream: No such file or directory in c:\appserv\www\temp\phpbb2_to_smf.php on line 503

Warning: copy(c:\appserv\www\phpbb_clean/images/avatars/ac140a9d41b9552ef0a72.jpg): failed to open stream: No such file or directory in c:\appserv\www\temp\phpbb2_to_smf.php on line 503

Warning: copy(c:\appserv\www\phpbb_clean/images/avatars/ac140ab1413eb45685666.jpg): failed to open stream: No such file or directory in c:\appserv\www\temp\phpbb2_to_smf.php on line 503

Warning: copy(c:\appserv\www\phpbb_clean/images/avatars/8c723f2341b9715734e5d.gif): failed to open stream: No such file or directory in c:\appserv\www\temp\phpbb2_to_smf.php on line 503
successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... successful.
Converting messages... (this may take some time) successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (step 2)... successful.
Converting topic notifications... successful.
Converting board access... successful.
Converting group access permissions... successful.
Copying avatar image files... successful.
Converting censored words... successful.
Converting reserved names... successful.
Converting ban list... successful.
Converting misc settings... successful.
Recalculating forum statistics... successful.

Convert Smileys?
Title: Re: can not convert topics and articles from phpbb2
Post by: Grudge on December 17, 2004, 05:36:39 AM
Ummm... so after conversion can you tell me how many lines are in:
a) The topics table
b) The messages table
c) The boards table

You'll need to browse with phpMyAdmin for this
Title: Re: can not convert topics and articles from phpbb2
Post by: packman on December 17, 2004, 08:24:34 AM
I've only tested the converter up to phpBB2 v2.0.10 on Linux. You're using phpBB2 2.0.11 and I'm not sure what differences there are between those versions, or whether there's anything Linux specific in the code.
Title: Re: can not convert topics and articles from phpbb2
Post by: wildtype on December 17, 2004, 08:01:13 PM
Quote from: Grudge on December 17, 2004, 05:36:39 AM
Ummm... so after conversion can you tell me how many lines are in:
a) The topics table
b) The messages table
c) The boards table

You'll need to browse with phpMyAdmin for this


:)

in topics table, there are 744 items,
message table, 0  :-[
boards table 15 items,

obviously, there are some problem in message table conversion,

I think there are two possible reason, maybe due to phpbb2 mods or the character set(big5)

still working on to find out the reason

thank you~
Title: Re: can not convert topics and articles from phpbb2
Post by: [Unknown] on December 17, 2004, 11:34:31 PM
I don't suppose you could post the result of the following queries, could you?

SHOW CREATE TABLE phpbb_posts;
SHOW CREATE TABLE phpbb_post_text;

I'm pretty sure those are the table names they use...

-[Unknown]
Title: Re: can not convert topics and articles from phpbb2
Post by: wildtype on December 19, 2004, 08:08:24 PM
Quote from: [Unknown] on December 17, 2004, 11:34:31 PM
I don't suppose you could post the result of the following queries, could you?

SHOW CREATE TABLE phpbb_posts;
SHOW CREATE TABLE phpbb_post_text;

I'm pretty sure those are the table names they use...

-[Unknown]


seems there is some problem,

I can see the phpbb_post and  phpbb_post_post tables,

but when I try to run the sql above, the message showed

"Table 'phpbb_test.phpbb_post_text' doesn't exist"


can I try it manually? It seems even harder to work it manually.

thank you, guys



Here is the result,
SQL 語法 : 

SHOW CREATE TABLE phpbb_post_text

MySQL 傳回:


Table 'phpbb_test.phpbb_post_text' doesn't exist
Title: Re: can not convert topics and articles from phpbb2
Post by: Jerry on December 19, 2004, 08:21:45 PM
Quote from: packman on December 17, 2004, 08:24:34 AM
I've only tested the converter up to phpBB2 v2.0.10 on Linux. You're using phpBB2 2.0.11 and I'm not sure what differences there are between those versions, or whether there's anything Linux specific in the code.

I converted from phpBB2.0.11, only file changes from 2.0.10 for security I think. . . nothing changed with the database.
Title: Re: can not convert topics and articles from phpbb2
Post by: packman on December 20, 2004, 03:02:36 AM
It could be the character set. I think Big5 is a double byte character set like Unicode? If so, I'm not sure how the converter would handle double byte characters. I certainly wasn't thinking of any special handling in the mods I made to it...in fact I'm not even sure what would need to be done differently to handle a character set like Big5.
Title: Re: can not convert topics and articles from phpbb2
Post by: [Unknown] on December 20, 2004, 03:49:43 AM
What happens with simply:

SHOW TABLES LIKE '%post_text';

-[Unknown]