FUDforum: Converters » phpBB2 converter fails with sql syntax error

Home » FUDforum Development » Converters » phpBB2 converter fails with sql syntax error

Show: Today's Messages :: Polls :: Message Navigator

phpBB2 converter fails with sql syntax error [message #30327]

Fri, 17 February 2006 22:13

nuno

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

Report message to a moderator

Re: phpBB2 converter fails with sql syntax error [message #30328 is a reply to message #30327] Fri, 17 February 2006 22:59

nuno

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..

Report message to a moderator

Re: phpBB2 converter fails with sql syntax error [message #30341 is a reply to message #30328]

Sun, 19 February 2006 20:30

Ilia

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

Report message to a moderator

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) ] [

]

Current Time: Thu Nov 21 20:21:54 GMT 2024

Total time taken to generate the page: 0.04580 seconds