yabb21 to SMF script failure

[paul_assheton]

I there,

I have been using Yabb 2.1 for some time as my forum but I wish to upgrade to a PHP/SQL based system.  I have picked SMF due to the convertion scripts.  I have installed the latest version of SMF (downloaded this morning) and installed it without problems.  But the conversion script for Yabb 2.1 fails.  I get the following error

Converting...
Converting membergroups... Successful.
Converting members... Unsuccessful!
This query:
ALTER TABLE `db175005267`.smf_members
ORDER BY ID_MEMBER = 0, dateRegistered;
Caused the error:

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 '= 0, dateRegistered' at line 2

My service provider uses MySQL 5.0

What have I done wrong and how can I fix it?

Thank you

[greyknight17]

Not sure here. Do you still have the forum database on your webhost? If so, did you check and repair any errors if found first before trying the conversion?

[metallica48423]

This should be in converters & importers (yabb SE sub board) , i'll move it there for you

That way those of us who know converters better are more likely to see this.

[Joris]

I am having the same problem. Here's my output.
I've spotted a couple of different posts about this, but no real answer. Please help.
MySQL v5.0.41

Converting...
Converting membergroups... Successful.
Converting members...
Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309

Notice: Undefined index: realname in /usr/home/web/snl145978/smf/yabb21_to_smf.php on line 309
Unsuccessful!
This query:
ALTER TABLE `snl145978`.smf_members
ORDER BY ID_MEMBER = 0, dateRegistered;
Caused the error:

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 '= 0, dateRegistered' at line 2

[SleePy]

Is this issue solved or do you still require assistance?

Seems like ID_MEMBER is getting = 0 added to it.
Have you tried editing this query in the SQL to remove the = 0 part?

Look for:

Code Select Expand

ORDER BY ID_MEMBER = 0, dateRegistered;

Replace with:

Code Select Expand

ORDER BY ID_MEMBER, dateRegistered;