Advertisement:

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

Offline Chuck

  • Semi-Newbie
  • *
  • Posts: 29
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #20 on: March 13, 2007, 05:34:07 PM »
I got my board to convert but.....

Some members are able to log in, but apparently do not have the proper permission to post or do other things.

Also, when I view permissions on the admin center it only shows that there are 1419 regualr members-I have 2300+.

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #21 on: March 13, 2007, 10:06:23 PM »
I got my board to convert but.....

Some members are able to log in, but apparently do not have the proper permission to post or do other things.

Also, when I view permissions on the admin center it only shows that there are 1419 regualr members-I have 2300+.
Sounds like you have the same problem I had on the last page. That group id of 11 thing. It caused me permission problems and them to not be listed on the permissions page as members.

Open up members table and see if you notice any members with odd group numbers. If you see alot of people, post that group id number and I can write you a query that will fix it.
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline Chuck

  • Semi-Newbie
  • *
  • Posts: 29
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #22 on: March 13, 2007, 11:07:01 PM »
Thanks, I figured it out after reading your post.  Some of the users group id's were set to 22??  I was able to fix it using a mysql query.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #23 on: March 19, 2007, 10:21:40 AM »
This is really weird.  I'll have to check YaBB SE and see what's up with the converter.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline mefistofeles

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #24 on: April 05, 2007, 05:06:22 PM »
I have tryed to convert Yabb SE 1.5.5 to SMF 1.1.2 but get this error:


Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
UPDATE `300power_com`.smf_boards
SET memberGroups = '-1,0,2', lastUpdated = 1175806904
WHERE ID_CAT = 2;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


I hope that its ok to ask about this Yabb SE version in this post?!  :)

//David

 

Offline Marcosms

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #25 on: April 11, 2007, 04:20:51 PM »
I found a few topics about problems converting attachments but no answer to my questions.
I'm unable to import the attachments and the converter produce long error logs as said at
http://www.simplemachines.org/community/index.php?topic=162750.0
I had success converting everything else excepting attachments (JPGs).
Any suggestion?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #26 on: April 16, 2007, 04:11:46 PM »
Are you using the .sql file from this topic?  The one in the downloads page is different from the one on this topic.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Marcosms

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #27 on: April 16, 2007, 06:07:08 PM »
I used it but had no results at first. Now with more tries I'm able to have the files linked in the messages but not showing. I'll work on this more... 
« Last Edit: April 16, 2007, 07:03:10 PM by Marcosms »

Offline Marcosms

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #28 on: April 19, 2007, 11:19:00 AM »
I understand that files needs width and lenght to show under the messages and the size is generated by the -getimagesize- function. After converting, the attachments in the mysql table have width and eight at 0. Seems like the getimagesize doesn't work but I can't understand why and how to fix it.

At first the converter produced a very large error log that indicated a problem with lines 826 and 827 of convert.php

I escluded the lines:

//if ($special_code !== null)
//   eval($special_code);

Then the conversion worked giving an error at step=1&substep=39 for converting banned members. Going directly at step=1&substep=40 the conversion ended succefully.
The attachments files copied in the smf attachments dir were cancelled by the converter. I copied them back in the same dir and recalculated the kb sizes from the admin page. Now the attachmet are linked and download correctly when clicked but don't show under the message. The width and eight are at 0 in the mysql table so apparently getimagesize function doesn't work and I can't find what's disturbing the process.

At first I had 6 files left in the attachments dir after conversion. They had two or more dots inside their names. I supposed they to cause the problem so I cancelled them from the yabbse messages and attachments dir and converted again.
The result don't changed at all: error log from lines 826 and 827 or no size to have images showing under the messages. I still have the doubt that other attachments files have something bad in their nemes for the converter to work correctly.

I suppose getimagesize can work as a standalone query but I'm not able to do such things with php.

Any tips to have everything (including getimagesize) working while converting and to have attachments showed under the messages?
 

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #29 on: April 21, 2007, 02:26:24 AM »
The error you got was an error with the .sql file and not the convert.php file.  With you commenting out those lines it diables the converter from running the PHP snippets inside the .sql file.  What convert.php and .sql are you using?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Marcosms

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #30 on: April 21, 2007, 06:23:08 PM »
The second .sql of this topic and the converter of the downloads.
You mean there is a malfunction danger due to the exclusion of the two lines?
What kind of malfunction?

In the meantime I managed to have everything working another way. Not so many attachments so I copied manually widhts and lenghts in the mysql table. Now everything is working right and I'm happy with smf. Hard work for me to convert but for sure it's my fault.



Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #31 on: June 12, 2007, 09:37:34 PM »
Greetings,

I'm using convert.php from the downloads area, and the .sql script from this topic (the 2nd follow-up attachment).

Here is the code and error I am receiving:

Code: [Select]
     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 `my_forums`.smf_members AS mem
    LEFT JOIN `my_forums`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

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

There is a memberGroup column defined in the members table of the yabb SE db.

Any insight on this would be greatly appreciated  :)
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #32 on: June 20, 2007, 04:30:40 AM »
Greetings,

I'm using convert.php from the downloads area, and the .sql script from this topic (the 2nd follow-up attachment).

Here is the code and error I am receiving:

Code: [Select]
     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 `my_forums`.smf_members AS mem
    LEFT JOIN `my_forums`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

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

There is a memberGroup column defined in the members table of the yabb SE db.

Any insight on this would be greatly appreciated  :)


OK, I believe the moderator is away for the time being, is there anyone else that can assist?  It has now become a situation of moderate desperation !

Would it help to state publicly that there is no bigger SMF fan on the planet than myself?  ;)
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline cspeech19

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #33 on: July 21, 2007, 04:27:51 AM »
is it too late to convert 1.5.5 to SMF?

Offline mysiar1

  • Newbie
  • *
  • Posts: 4
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #34 on: August 04, 2007, 11:23:46 AM »
thanks JayBachatero for the updated SQL file

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #35 on: August 11, 2007, 01:36:52 PM »
enduris and cspeech so you still need help?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #36 on: August 15, 2007, 10:00:47 PM »
Quote
enduris and cspeech so you still need help?

Hi Jay,

Yes, I still need some assistance please, thanks.
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #37 on: August 15, 2007, 10:07:32 PM »
Can you post the structure of the members table?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #38 on: August 15, 2007, 11:22:15 PM »
OK, I have attached a PDF printout from phpMyAdmin.
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #39 on: August 16, 2007, 12:13:51 AM »
After taking a second look I noticed that the prefix is being set to smf_.  Can you check in your Settings.php file for YaBB SE for the $db_prefix.  Tell me what is it.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert