FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

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 
Switch to threaded view of this topic Create a new topic Submit Reply
phpBB2 2.0.21 --> 2.7.6 [message #35864] Sat, 17 February 2007 19:19 Go to next message
Starcitsura is currently offline  Starcitsura   Canada
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?
Re: phpBB2 2.0.21 --> 2.7.6 [message #35870 is a reply to message #35864] Sun, 18 February 2007 11:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: phpBB2 2.0.21 --> 2.7.6 [message #35876 is a reply to message #35864] Sun, 18 February 2007 13:59 Go to previous messageGo to next message
Starcitsura is currently offline  Starcitsura   Canada
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 1389 times)
Re: phpBB2 2.0.21 --> 2.7.6 [message #35905 is a reply to message #35876] Mon, 19 February 2007 18:47 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: phpBB2 2.0.21 --> 2.7.6 [message #35933 is a reply to message #35864] Tue, 20 February 2007 19:39 Go to previous messageGo to next message
Starcitsura is currently offline  Starcitsura   Canada
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.
Re: phpBB2 2.0.21 --> 2.7.6 [message #35936 is a reply to message #35933] Wed, 21 February 2007 19:28 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Fri Dec 15 20:42:36 EST 2017

Total time taken to generate the page: 0.00556 seconds