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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic

phpBB2 2.0.21 --> 2.7.6 [message #35864]

Sat, 17 February 2007 19:19

Starcitsura

Messages: 9
Registered: February 2007

Karma: 0

Junior Member

add to buddy list
ignore all messages by this user

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

Rate author: +1 -1

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

Sun, 18 February 2007 11:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

add to buddy list
ignore all messages by this user

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

Rate author: +1 -1

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

Sun, 18 February 2007 13:59

Starcitsura

Messages: 9
Registered: February 2007

Karma: 0

Junior Member

add to buddy list
ignore all messages by this user

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 1606 times)

Report message to a moderator

Rate author: +1 -1

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

Mon, 19 February 2007 18:47

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

add to buddy list
ignore all messages by this user

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

FUDforum Core Developer

Report message to a moderator

Rate author: +1 -1

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

Tue, 20 February 2007 19:39

Starcitsura

Messages: 9
Registered: February 2007

Karma: 0

Junior Member

add to buddy list
ignore all messages by this user

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

Rate author: +1 -1