News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

YABB SE converter bug (and fix)

Started by batkins, July 15, 2006, 10:52:15 AM

Previous topic - Next topic

batkins

MySQL 5.0 has new precedence rules for commas and joins.  The upshot of this is that the YABBSE converter cannot import boards or topics from YABBSE with MySQL 5.0 (YABBSE can't use MySQL 5.0, either, because this precedence change affects all kinds of queries in its code).

The fix is simple.  Go to the query beginning on line 493 in yabbse_to_smf.php .  Change it to the following:

"
         SELECT $select
         FROM ({$from_prefix}boards AS b, {$from_prefix}categories AS c) LEFT JOIN {$from_prefix}topics AS t ON (t.ID_TOPIC = b.ID_LAST_TOPIC)
         WHERE c.ID_CAT = b.ID_CAT
         LIMIT $_REQUEST[start], 500"

The only change is that parentheses have been added around the two tables in the FROM clause.  With this change, the converter can import YABBSE's topics and boards without a problem.

Advertisement: