FUDforum: Converters » phpBB2 2.0.21 --> 2.7.6

Home » FUDforum Development » Converters » phpBB2 2.0.21 --> 2.7.6 (Conversion Error)

Show: Today's Messages :: Polls :: Message Navigator

phpBB2 2.0.21 --> 2.7.6 [message #35864]

Sun, 18 February 2007 00:19

Starcitsura

Messages: 9
Registered: February 2007

Karma: 0

Junior Member

Tired of phpBB and having always being fond of FUDforum, I finally decided to make the switch, however I'm having some issues with the conversion, and really have no idea what to do about it.

Quote:

Beginning Conversion Process
Reading phpBB2 config
Done: Reading phpBB2 config
Importing Smilies: 48
Finished Importing Smilies
Importing Avatar Galleries
from: ../forums/images/avatars/gallery/
Finished Importing Avatar Galleries, 0 avatars improted
Importing Users 112
(/home/navaldom/public_html/FUDforum/include/theme/default/db.inc:72
/home/navaldom/public_html/FUDforum/include/theme/default/db.inc:132
/home/navaldom/public_html/FUDforum/phpBB2.php:257
) 1054: Unknown column 'id' in 'field list'
Query: SELECT MAX(id) FROM navaldom_phpb1.phpbb_users
Server Version: 4.1.20-standard-log

Help?

Report message to a moderator

Re: phpBB2 2.0.21 --> 2.7.6 [message #35870 is a reply to message #35864]

Sun, 18 February 2007 16:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Can you do "desc phpbb_users" and show me the output. It seems like the "id" column was removed from this table.

FUDforum Core Developer

Report message to a moderator

Re: phpBB2 2.0.21 --> 2.7.6 [message #35876 is a reply to message #35864]

Sun, 18 February 2007 18:59

Starcitsura

Messages: 9
Registered: February 2007

Karma: 0

Junior Member

This is unfortunately the best I can do at the moment:
index.php?t=getfile&id=2781&private=0

My server is being stupid atm >.>
Looks like they changed it to user_id. I guess I could have figured that out myself, but oh well.

Attachment: desc.jpg
(Size: 278.01KB, Downloaded 2940 times)

Report message to a moderator

Re: phpBB2 2.0.21 --> 2.7.6 [message #35905 is a reply to message #35876]

Mon, 19 February 2007 23:47

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You need to adjust the query to select "user_id AS id" rather then "id".

FUDforum Core Developer

Report message to a moderator

Re: phpBB2 2.0.21 --> 2.7.6 [message #35933 is a reply to message #35864]

Wed, 21 February 2007 00:39

Starcitsura

Messages: 9
Registered: February 2007

Karma: 0

Junior Member

I'm not really sure what I did, but it worked now... I made one change, it didn't work. Undid that change, made another one, which didn't work. Tried the first change again, and then it did work. I'm honestly confused, but it doesn't matter it worked ^_^

Next time I'll just temporarily change the field name to 'id' rather then editing the script. LOL, it was too much for me to handle while tired.

Report message to a moderator

Re: phpBB2 2.0.21 --> 2.7.6 [message #35936 is a reply to message #35933]

Thu, 22 February 2007 00:28

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You don't need to change the name of the field, just make the query alias user_id to id, which is what I suggested.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	IPB 1.2 to FUD 2.7: Import OK, no posts
Next Topic:	Question regarding converter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 17:49:07 GMT 2024

Total time taken to generate the page: 0.03272 seconds