Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » phpBB 2.0.19 -> FUDforum 2.7.6 problems
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
phpBB 2.0.19 -> FUDforum 2.7.6 problems [message #34950] Sun, 26 November 2006 19:21 Go to next message
capleton is currently offline  capleton   Sweden
Messages: 1
Registered: November 2006
Location: Sweden
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi, im getting some problems when i try import my phpBB2 DB to FUD, everything goes well till i get to the user imports.. it fails on a certain id which i can't figure out why.. the SQL error i get is:
Importing Users 3502
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' users_opt=(users_opt & ~ 4194304)|8388608, avatar_loc='
Query: UPDATE fud_users SET avatar=, users_opt=(users_opt & ~ 4194304)|8388608, avatar_loc='<img src="http://localhost/forum/images/custom_avatars/47.gif" width="130" height="130">' WHERE id=49
Server Version: 5.0.27-community-nt

Any help i can get is appreciated!
Re: phpBB 2.0.19 -> FUDforum 2.7.6 problems [message #34961 is a reply to message #34950] Mon, 27 November 2006 18:59 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Core Developer
remove from buddy list
ignore all messages by this user
Here is the patch that should fix the problem

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Convert Invision Power Board 2.0 to FUDforum
Next Topic: IPB 1.2 to FUD 2.7: Import OK, no posts
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 28 18:35:44 EST 2021

Total time taken to generate the page: 0.00762 seconds