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

Home » FUDforum Development » Converters » phpBB 2.0.10 -> fud fails
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
phpBB 2.0.10 -> fud fails [message #25993] Tue, 28 June 2005 18:48 Go to next message
oeroer   Finland
Messages: 3
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Beginning Conversion Process
Reading phpBB2 config
Done: Reading phpBB2 config
Importing Smilies: 42
Finished Importing Smilies
Importing Avatar Galleries
    from: /var/vhosts/foo/images/avatars/gallery/
Finished Importing Avatar Galleries, 0 avatars improted
Importing Users 81
Finished Importing Users
Importing Categories 2
Finished Importing Categories
Importing Forums 5
Finished Importing Forums
Importing Moderators
Finished Importing Moderators
Importing Topics 68
Finished Importing Topics
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 ' t.topic_title, p.*, pt.post_subject, pt.post_text FROM oeroer


Ideas?
Re: phpBB 2.0.10 -> fud fails [message #25998 is a reply to message #25993] Wed, 29 June 2005 00:04 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
Apply this patch to the conversion script and the query should work.

http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7065


FUDforum Core Developer
Re: phpBB 2.0.10 -> fud fails [message #26001 is a reply to message #25993] Wed, 29 June 2005 08:59 Go to previous messageGo to next message
oeroer   Finland
Messages: 3
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
"
Our users have posted a total of 0 messages inside 0 topics.
"

but

"
Importing Topics 68
Finished Importing Topics
Importing Messages 575
Finished Importing Messages
"

Am I doing something wrong or is there some bug in the convertion script? There is one my category and four "subcategorys" and these it converts there, but these are empty.
Re: phpBB 2.0.10 -> fud fails [message #26003 is a reply to message #26001] Wed, 29 June 2005 09:16 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 run the consistency checker after running the import script.

FUDforum Core Developer
Re: phpBB 2.0.10 -> fud fails [message #26004 is a reply to message #25993] Wed, 29 June 2005 09:42 Go to previous message
oeroer   Finland
Messages: 3
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Aah. I saw that message and uri in the bottom of the that scripts output and I logged in there, but I just didn't understood to click that thing. Smile

Now it seems to work fine. <3
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: phpBB2 error
Next Topic: UBB.classic
Goto Forum:
  

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

Current Time: Mon Oct 23 07:53:24 EDT 2017

Total time taken to generate the page: 0.01456 seconds