Advertisement:

Author Topic: can not convert topics and articles from phpbb2  (Read 22578 times)

Offline wildtype

  • Newbie
  • *
  • Posts: 4
can not convert topics and articles from phpbb2
« 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
 



Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: can not convert topics and articles from phpbb2
« Reply #1 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?
I'm only a half geek really...

Offline wildtype

  • Newbie
  • *
  • Posts: 4
Re: can not convert topics and articles from phpbb2
« Reply #2 on: December 17, 2004, 05:08:04 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?

Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: can not convert topics and articles from phpbb2
« Reply #3 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
I'm only a half geek really...

Offline packman

  • Jr. Member
  • **
  • Posts: 394
  • Gender: Male
  • Watch out for boggarts!
    • Weather-Watch
Re: can not convert topics and articles from phpbb2
« Reply #4 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.
Chris

Offline wildtype

  • Newbie
  • *
  • Posts: 4
Re: can not convert topics and articles from phpbb2
« Reply #5 on: December 17, 2004, 08:01:13 PM »
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~
« Last Edit: December 17, 2004, 08:08:44 PM by wildtype »

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: can not convert topics and articles from phpbb2
« Reply #6 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]

Offline wildtype

  • Newbie
  • *
  • Posts: 4
Re: can not convert topics and articles from phpbb2
« Reply #7 on: December 19, 2004, 08:08:24 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

Offline Jerry

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,903
  • Gender: Male
  • What? I can't hear you over my awesomeness!!
    • PlanetSMF
Re: can not convert topics and articles from phpbb2
« Reply #8 on: December 19, 2004, 08:21:45 PM »
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.
- Jerry
Find me on:
Facebook
Twitter
PlanetSMF

"If all you look for is the negative in things, you will never see the positive."

Offline packman

  • Jr. Member
  • **
  • Posts: 394
  • Gender: Male
  • Watch out for boggarts!
    • Weather-Watch
Re: can not convert topics and articles from phpbb2
« Reply #9 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.
Chris

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: can not convert topics and articles from phpbb2
« Reply #10 on: December 20, 2004, 03:49:43 AM »
What happens with simply:

SHOW TABLES LIKE '%post_text';

-[Unknown]