News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

[SMF Converter] YaBB SE 1.5.4

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

Previous topic - Next topic

Chuck

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+.

Chris Cromer

Quote from: Chuck 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+.
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.

Chuck

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.

JayBachatero

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

mefistofeles

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

 

Marcosms

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?

JayBachatero

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

Marcosms

#27
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... 

Marcosms

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?

JayBachatero

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

Marcosms

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.



endurics

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:


     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

endurics

Quote from: endurics 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:


     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

cspeech19

is it too late to convert 1.5.5 to SMF?

mysiar1

thanks JayBachatero for the updated SQL file

JayBachatero

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

endurics

Quoteenduris 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

JayBachatero

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

endurics

OK, I have attached a PDF printout from phpMyAdmin.
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

JayBachatero

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

Advertisement: