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

Home » FUDforum Development » Converters » phpBB2 converter fails with sql syntax 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 converter fails with sql syntax error [message #30327] Fri, 17 February 2006 17:13 Go to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi Ilia,

I was trying to convert one more forum to FUDforum, but the phpBB2 converter is failing. While I think this is a MySQL error, I would like to know if you have a workaround.

Quote:


Beginning Conversion Process
Reading phpBB2 config
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 '-golf.golf_config' at line 1


The query is: "SELECT * FROM FORUM-golf.golf_config"

The server is running MySQL 4.1.14. I've checked the MySQL's manual, and it says this is a valid syntax, so this is probably a bug in MySQL's parser.

Nuno
Re: phpBB2 converter fails with sql syntax error [message #30328 is a reply to message #30327] Fri, 17 February 2006 17:59 Go to previous messageGo to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ok, I've fixed the problem Smile It is now slowly building the search index..

I've changed:
<?php
$bb2 
$dbname '.' $table_prefix;
?>


to:
<?php
mysql_select_db
($dbname$ib);
$bb2 $table_prefix;
?>



Nuno

P.S.: It seems that the part that downloads & checks the remote avatars could be optimized. It now downloads them twice..
Re: phpBB2 converter fails with sql syntax error [message #30341 is a reply to message #30328] Sun, 19 February 2006 15:30 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
Conversion process happens once, so I am not too concerned about speed. If you can offer an optimization patch I'd definately review it and consider it for inclusion.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: php-nuke (phpbb) to fudforum 2.7.4 converter
Next Topic: FUD to other Forum
Goto Forum:
  

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

Current Time: Wed Oct 18 07:12:36 EDT 2017

Total time taken to generate the page: 0.00769 seconds