Advertisement:

Author Topic: [SMF Converter] YaBB SE 1.5.4  (Read 175852 times)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #120 on: June 18, 2008, 03:29:14 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline TheRealWaldo

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #121 on: June 18, 2008, 04:56:01 PM »
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.

Offline TheRealWaldo

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #122 on: June 18, 2008, 05:04:00 PM »
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.

Offline Neplug

  • Semi-Newbie
  • *
  • Posts: 15
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #123 on: July 12, 2008, 01:55:57 PM »
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
« Last Edit: July 12, 2008, 02:22:04 PM by Neplug »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #124 on: July 12, 2008, 04:15:05 PM »
The attached one should fix that :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Neplug

  • Semi-Newbie
  • *
  • Posts: 15
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #125 on: July 12, 2008, 04:39:11 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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #126 on: July 12, 2008, 05:05:53 PM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Neplug

  • Semi-Newbie
  • *
  • Posts: 15
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #127 on: July 13, 2008, 03:03:36 AM »
Common conversion errors.
Thanks, everything was successfully. Now can my wife test the functionality and change the layout.

Thanks very much

Offline pospelov

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #128 on: December 04, 2009, 02:14:56 AM »
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!

« Last Edit: December 04, 2009, 02:19:16 AM by pospelov »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #129 on: December 04, 2009, 11:52:43 AM »
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

Offline mikemotors

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #130 on: January 01, 2010, 08:53:31 AM »
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
    mem.ID_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,
    mem.im_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 mg.ID_GROUP = 8 THEN 2
    WHEN mg.ID_GROUP = 1 THEN 1
    WHEN mg.ID_GROUP > 8 THEN mg.ID_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'

Offline console65

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #131 on: March 21, 2010, 06:18:13 PM »
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.