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 :: Polls :: Message Navigator
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 22:13 Go to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
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 22: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
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 20:30 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
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
  Switch to threaded view of this topic Create a new topic Submit Reply
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: Sun Nov 03 14:25:23 GMT 2024

Total time taken to generate the page: 0.03041 seconds