[SMF Converter] YaBB SE 1.5.4

Started by JayBachatero, January 08, 2007, 11:25:48 AM

Previous topic - Next topic

SleePy

Reupload the file. It sounds like it is corrupted :|

It might actually be easier, since you are using YaBB SE, to just get the large upgrade package from the downloads page. Since SMF came form YaBB SE the upgrade package was designed so it should work all the way from YaBB SE.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

TheRealWaldo

Re-downloaded and re-uploaded several times, confirmed file is identical to what was downloaded.  It appears the code itself is redeclaring a function it already declared.

I'm using fantastico, I don't think that package will suit my needs as SMF is already installed.

TheRealWaldo

I confirmed this as the problem, and edited the attached SQL file as follows:

Line 490, added

if (!function_exists('ip2range')) {

and 511, added

}

So now the before the function is redeclared, a check to see if it is already declared is run first.

It executes without problems after those changes.

W.

Neplug

#123
On this moment I try to convert a forum of my wife. Its a Yabbse forum and I use the files from here and became the follow error(I'm convert in a test site)

Converting...
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting attachments... Successful.
Converting activity logs... Successful.
Converting banning logs... Successful.
Converting mark as read history... Successful.
Converting karma logs... Successful.
Converting topic view logs... Successful.
Converting moderators... Successful.
Converting banned members... Unsuccessful!
This query:
INSERT INTO `ps4fun_forum`.smf_ban_groups
(name, ban_time, expire_time, cannot_access, reason, notes)
VALUES ('yabbse_bans', 1215886152, NULL, 1, '', 'Imported from YaBB SE';
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 '' at line 3


What's going wrong and what can I do?
I'm just a simple user.
Please help

SleePy

The attached one should fix that :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Neplug

Quote from: SleePy on July 12, 2008, 04:15:05 PM
The attached one should fix that :)
Thanx this problem are fixed. Do you have more solutions  :)

Now I become this error:

Converting banned members... Successful.
Converting calendar events... Successful.
Converting membergroups... Successful.
Converting basic settings... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `ps4fun_forum`.smf_smileys
ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Neplug

Quote from: SleePy on July 12, 2008, 05:05:53 PM
Common conversion errors.
Thanks, everything was successfully. Now can my wife test the functionality and change the layout.

Thanks very much

pospelov

#128
Hello.
I convert YaBB SE 1.5.5 to SMF 2.0 RC2
File used http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc2_yabbse_converter.zip
I have problem:

Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options...
Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/mydomen/convert.php on line 1295

-////-

Warning: array_keys() [function.array-keys]: The first argument should be an array in  /home/mydomen/convert.php on line 1295

Warning: in_array() [function.in-array]: Wrong datatype for second argument in  /home/mydomen/convert.php on line 2635

Warning: in_array() [function.in-array]: Wrong datatype for second argument in  /home/mydomen/convert.php on line 2635

Warning: in_array() [function.in-array]: Wrong datatype for second argument in  /home/mydomen/convert.php on line 2635

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/mydomen/convert.php on line 2635

Warning: Invalid argument supplied for foreach() in  /home/mydomen/convert.php on line 2647

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in  /home/mydomen/Sources/Subs-Db-mysql.php on line 641

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 ')' at line 3

Help me, please!


Norv

Please, try using the attached file, instead.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

mikemotors

Any idea why this does not work?
Thank You in advance.

Problem below:


Warning: set_time_limit() has been disabled for security reasons in /usr/local/www/data/d/7889/html/forum/convert.php on line 29
YaBB SE 1.5.x to SMF Converter
Converting...
Converting members... Unsuccessful!
This query:

    SELECT
    hxxp:mem.id [nonactive]_MEMBER, SUBSTRING(mem.memberName, 1, 80) AS memberName,
    mem.dateRegistered, mem.posts, SUBSTRING(mem.passwd, 1, 64) AS passwd,
    SUBSTRING(mem.websiteTitle, 1, 255) AS websiteTitle,
    SUBSTRING(mem.websiteUrl, 1, 255) AS websiteUrl, mem.lastLogin,
    mem.birthdate, SUBSTRING(mem.ICQ, 1, 255) AS ICQ,
    SUBSTRING(IFNULL(mem.realName, mem.memberName), 1, 255) AS realName,
    mem.notifyOnce, REPLACE(mem.lngfile, '.lng', '') AS lngfile,
    SUBSTRING(mem.emailAddress, 1, 255) AS emailAddress,
    SUBSTRING(mem.AIM, 1, 16) AS AIM,
    SUBSTRING(mem.personalText, 1, 255) AS personalText,
    SUBSTRING(mem.timeFormat, 1, 80) AS timeFormat,
    mem.hideEmail, SUBSTRING(mem.memberIP, 1, 255) AS memberIP,
    SUBSTRING(mem.memberIP, 1, 255) AS memberIP2,
    SUBSTRING(mem.YIM, 1, 32) AS YIM,
    IF(IFNULL(mem.gender, '') = '', 0, IF(mem.gender = 'Male', 1, 2)) AS gender,
    SUBSTRING(mem.MSN, 1, 255) AS MSN,
    SUBSTRING(REPLACE(mem.signature, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(mem.location, 1, 255) AS location, mem.timeOffset,
    SUBSTRING(mem.avatar, 1, 255) AS avatar,
    SUBSTRING(mem.usertitle, 1, 255) AS usertitle,
    hxxp:mem.im [nonactive]_email_notify AS pm_email_notify, mem.karmaBad, mem.karmaGood,
    mem.notifyAnnouncements,
    SUBSTRING(mem.secretQuestion, 1, 255) AS secretQuestion,
    IF(mem.secretAnswer = '', '', MD5(mem.secretAnswer)) AS secretAnswer,
    CASE
    WHEN mem.memberGroup = 'Administrator' THEN 1
    WHEN mem.memberGroup = 'Global Moderator' THEN 2
    WHEN hxxp:mg.id [nonactive]_GROUP = 8 THEN 2
    WHEN hxxp:mg.id [nonactive]_GROUP = 1 THEN 1
    WHEN hxxp:mg.id [nonactive]_GROUP > 8 THEN hxxp:mg.id [nonactive]_GROUP
    ELSE 0
    END AS ID_GROUP, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS messageLabels, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet, '' AS passwordSalt
    FROM `db7889`.members AS mem
    LEFT JOIN `db7889`.membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

    Unknown column 'mem.im_email_notify' in 'field list'

console65

Hi,

I am trying to convert a board, each time it fails at different stages with 500 "Internal Server Error".

In PHP error log are the following lines repeated 1000s of times:

[21-Mar-2010 22:13:35] PHP Warning:  fread() expects parameter 1 to be resource, boolean given in I:\emsu\convert.php(1109) : eval()'d code on line 21
[21-Mar-2010 22:13:35] PHP Warning:  feof() expects parameter 1 to be resource, boolean given in I:\emsu\convert.php(1109) : eval()'d code on line 20

Followed by a timeout error which creates the Server Error.

Any idea how I can fix this?

Thanks.

trilogi

Is there a converter for YaBB SE 1.5.5 to SMF 2.0/SMF 2.1?

I have an old forum YaBB SE 1.5.5 that I want to upgrade to SMF.

I have installed the SMF 2.0 successfully. YaBB SE is also installed on the same server. I make sure that both the SMF and YaBB SE share the same database user so that the converter at public_html/smf/convert.php is able to access both the SMF and YaBB databases.

I downloaded the converter from this link:

https://download.simplemachines.org/?converters;software=yabbse

It did not state which version of YaBB SE it is designed to convert.  I tried it anyway but was unsuccessful.  I tested with PHP 5.2 ( YaBB SE 1.5.5 only works with this PHP version ), 5.3 (YaBB SE starts to fail), 5.4, 5.5, 5.6 and 7.0. 

It appears that SMF 2.0 requires >= PHP 5.4 but YaBB SE can only runs on PHP <= 5.2

When I ran the convert.php on PHP 7.0 I got the following errors:

Converting...
Converting members...
------------------------------------------------------
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/xxxxxx/public_html/smf/convert.php on line 2499
Fatal error: Uncaught Error: Call to undefined function mysql_errno() in /home/xxxxxx/public_html/smf/convert.php:2500 Stack trace: #0 /home/xxxxxx/public_html/smf/convert.php(1248): convert_query('SELECT\n\tmem.id_...') #1 /home/xxxxxx/public_html/smf/convert.php(51): doStep1() #2 {main} thrown in /home/xxxxxx/public_html/smf/convert.php on line 2500


When I ran the convert.php on PHP 5.2 convert.php shows the following errors:

Parse error: syntax error, unexpected T_FUNCTION in /home/xxxxxx/public_html/smf/Sources/Subs.php on line 1271

On PHP 5.3 it shows a blank screen with no message.  On PHP 5.4, 5.5 & 5.6 it throws the following errors:

Converting...
Converting members...
Warning: mysqli_error(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/xxxxxx/public_html/smf/convert.php on line 2499

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/xxxxxx/public_html/smf/convert.php on line 2499
Unsuccessful!
This query:

    SELECT
    mem.id [nofollow]_member, SUBSTRING(mem.member_name, 1, 80) AS member_name,
    mem.date [nofollow]_registered, mem.posts, SUBSTRING(mem.passwd, 1, 64) AS passwd,
    SUBSTRING(mem.website_title, 1, 255) AS website_title,
    SUBSTRING(mem.website_url, 1, 255) AS website_url, mem.last_login,
    mem.birthdate, SUBSTRING(mem.icq, 1, 255) AS icq,
    SUBSTRING(IFNULL(mem.real_name, mem.member_name), 1, 255) AS real_name,
    mem.notify_once AS notify_once, REPLACE(mem.lngfile, '.lng', '') AS lngfile,
    SUBSTRING(mem.email_address, 1, 255) AS email_address,
    SUBSTRING(mem.aim, 1, 16) AS aim,
    SUBSTRING(mem.personal_text, 1, 255) AS personal_text,
    SUBSTRING(mem.time_format, 1, 80) AS time_format,
    mem.hide_email, SUBSTRING(mem.member_ip, 1, 255) AS member_ip,
    SUBSTRING(mem.member_ip, 1, 255) AS member_ip2,
    SUBSTRING(mem.yim, 1, 32) AS yim,
    IF(IFNULL(mem.gender, '') = '', 0, IF(mem.gender = 'Male', 1, 2)) AS gender,
    SUBSTRING(mem.msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(mem.signature, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(mem.location, 1, 255) AS location, mem.time_offset,
    SUBSTRING(mem.avatar, 1, 255) AS avatar,
    SUBSTRING(mem.usertitle, 1, 255) AS usertitle,
    mem.im [nofollow]_email_notify AS pm_email_notify, mem.karma_bad, mem.karma_good,
    mem.notify_announcements,
    SUBSTRING(mem.secret_question, 1, 255) AS secret_question,
    IF(mem.secret_answer = '', '', MD5(mem.secret_answer)) AS secret_answer,
    CASE
    WHEN mem.memberGroup = 'Administrator' THEN 1
    WHEN mem.memberGroup = 'Global Moderator' THEN 2
    WHEN mg.id [nofollow]_group = 8 THEN 2
    WHEN mg.id [nofollow]_group = 1 THEN 1
    WHEN mg.id [nofollow]_group > 8 THEN mg.id [nofollow]_group
    ELSE 0
    END AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, '' AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `xxxxxx_yabbse`.yabbse_members AS mem
    LEFT JOIN `xxxxxx_yabbse`.yabbse_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:


It seems like I have not been able to move beyond the Member conversion. Anyone has an answer?

P/S. We would be happy to pay for help if need be for someone to help convert our YaBB SE 1.5.5 forum to SMF 2.0 or 2.1.

Thanks!

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

trilogi

#134
Thanks for the quick reply on a Sunday! (I wasn't too hopeful given that the last post was a long time ago).

I have downloaded the "convert.php" and "yabbse_to_smf.sql" from the given link. I got essentially the same error message after trying on PHP 5,4, 5.6 and 7.0:

Converting...
Converting members... Unsuccessful!
This query:

    SELECT
    mem.id [nofollow]_member, SUBSTRING(mem.member_name, 1, 80) AS member_name,
    mem.date [nofollow]_registered, mem.posts, SUBSTRING(mem.passwd, 1, 64) AS passwd,
    SUBSTRING(mem.website_title, 1, 255) AS website_title,
    SUBSTRING(mem.website_url, 1, 255) AS website_url, mem.last_login,
    mem.birthdate, SUBSTRING(mem.icq, 1, 255) AS icq,
    SUBSTRING(IFNULL(mem.real_name, mem.member_name), 1, 255) AS real_name,
    mem.notify_once AS notify_once, REPLACE(mem.lngfile, '.lng', '') AS lngfile,
    SUBSTRING(mem.email_address, 1, 255) AS email_address,
    SUBSTRING(mem.aim, 1, 16) AS aim,
    SUBSTRING(mem.personal_text, 1, 255) AS personal_text,
    SUBSTRING(mem.time_format, 1, 80) AS time_format,
    mem.hide_email, SUBSTRING(mem.member_ip, 1, 255) AS member_ip,
    SUBSTRING(mem.member_ip, 1, 255) AS member_ip2,
    SUBSTRING(mem.yim, 1, 32) AS yim,
    IF(IFNULL(mem.gender, '') = '', 0, IF(mem.gender = 'Male', 1, 2)) AS gender,
    SUBSTRING(mem.msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(mem.signature, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(mem.location, 1, 255) AS location, mem.time_offset,
    SUBSTRING(mem.avatar, 1, 255) AS avatar,
    SUBSTRING(mem.usertitle, 1, 255) AS usertitle,
    mem.im [nofollow]_email_notify AS pm_email_notify, mem.karma_bad, mem.karma_good,
    mem.notify_announcements,
    SUBSTRING(mem.secret_question, 1, 255) AS secret_question,
    IF(mem.secret_answer = '', '', MD5(mem.secret_answer)) AS secret_answer,
    CASE
    WHEN mem.memberGroup = 'Administrator' THEN 1
    WHEN mem.memberGroup = 'Global Moderator' THEN 2
    WHEN mg.id [nofollow]_group = 8 THEN 2
    WHEN mg.id [nofollow]_group = 1 THEN 1
    WHEN mg.id [nofollow]_group > 8 THEN mg.id [nofollow]_group
    ELSE 0
    END AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, '' AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `xxxxxx_yabbse`.yabbse_members AS mem
    LEFT JOIN `xxxxxx_yabbse`.yabbse_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

    Unknown column 'mem.member_name' in 'field list'


Except that this time it did report the cause of error which is 'mem.member_name' in 'field list' being unknown.  There are member_name field in both YaBB SE and SMF databases but why is there a prefix of "mem." which caused the issue?

Thanks again!

vbgamer45

can you do a sql command
describe yabbse_members;

On your yabbse members table or do show create table  tablenamehere;
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

trilogi

Attached is the screen shot after running the SQL command "describe yabbse_members;"

Thanks.

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

trilogi

Thanks again.

This time it seems to proceed to try to copy members from YaBBSE to SMF but failed again. The whole error message is too long to list and contains some user data which I list only as **************


Converting...
Converting members... Unsuccessful!
This query:

    INSERT INTO `xxxxxx_smf`.smf_members
    (ID_MEMBER, memberName, dateRegistered, posts, passwd, websiteTitle, websiteUrl, lastLogin, birthdate, ICQ, realName, notifyOnce, lngfile, emailAddress, AIM, personalText, timeFormat, hideEmail, memberIP, memberIP2, YIM, gender, MSN, signature, location, timeOffset, avatar, usertitle, pm_email_notify, karmaBad, karmaGood, notifyAnnouncements, secretQuestion, secretAnswer, ID_GROUP, buddy_list, pm_ignore_list, messageLabels, validation_code, additionalGroups, smileySet, passwordSalt)

**************
**************
Caused the error:

    Unknown column 'memberName' in 'field list'


I then ran the SQL command "describe smf_members;" and got the attached screen shot. So it seems like this "convert.php" file is trying to specify the "member_name" on the smf as "memberName" which is what it got for the YaBB SE.  Essentialy the error appears to be that YaBB SE 1.55 is using different field name than the SMF in the database?

vbgamer45

Ok yeah looks like major changes need to be made to the sql to get it to work properly...will have time tomorrow to look into it.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: