Software: YaBB SE
Version: 1.5.4
This is the official support topic for YaBB SE 1.5.4 converter. Use this topic to ask for support for this converter.
Changelog
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
My Problem:
Converting posts (this may take some time)... Successful.
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... Unsuccessful!
This query:
SELECT m.ID_MEMBER, lt.ID_TOPIC, lt.notificationSent AS sent
FROM (`spocrati_ht4uforum`.yabbse_log_topics AS lt, `spocrati_ht4uforum`.yabbse_members AS m)
WHERE notificationSent != 0
AND lt.memberName = m.memberName
LIMIT 0, 500;
Caused the error:
Unknown column 'lt.memberName' in 'where clause'
I have no any idea what I can do... My solution was create a new field memberName in yabbse_log_topics. After them, the script works but for ever on the same step
Try the one attached in the first post.
Thanks for your help ;)
With your new file, I have no error messages, but the script works for ever:
Converting...
Converting topic notifications... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.
in the last 24 hour it works on the same step. Have you an another soloution?
Try this file.
:D :D Now it works wonderfull, thanks for your support :-*
Quote
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Hi, I have been trying to convert my yabbse forum to SMF using the files in this thread. It works fine until after it converts the post and then it gets an Internal Sever Error.
Any ideas?
Thanks.
I don't know why but after using this converter random members have an ID_GROUP setting of 11... even though that group does not exist. This caused me alot of headaches since the members with that group id could not see anything. It was funny that when they logged in the boards where gone, but when they logged back out they came back. ;D
I already fixed it in my conversion since it was just a matter of running an update query, but thought I would report it for you to look into.
Quote from: Chuck on February 14, 2007, 12:52:59 AM
Hi, I have been trying to convert my yabbse forum to SMF using the files in this thread. It works fine until after it converts the post and then it gets an Internal Sever Error.
Any ideas?
Thanks.
Does the post conversion make any process at all or once it gets there it gets the error?
Quote from: Chris Cromer on February 15, 2007, 06:44:37 AM
I don't know why but after using this converter random members have an ID_GROUP setting of 11... even though that group does not exist. This caused me alot of headaches since the members with that group id could not see anything. It was funny that when they logged in the boards where gone, but when they logged back out they came back. ;D
I already fixed it in my conversion since it was just a matter of running an update query, but thought I would report it for you to look into.
Chris that is weird. Was it a primary or secondary group? If you look at this part it shows you that it gets the correct group.
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
Yes, all the post are converted successfully.. When it says converting priveat messages, or after that, I get the internal sever error. When I look in the datatbase it appears that the pm's have been converted-at least there is the same amount in the new table.
The last message that I get before the internal sever error is
Converting private messages step 2 incomplete..
I got this from the server error log, it seems to have somethng to do with it
Allowed memory size of 8388608 bytes exhausted (tried to allocate 10240 bytes)
[Thu Feb 15 19:48:44 2007] [error] [client 65.24.102.63] Premature end of script headers:..........
That's just it, there is no group 11 in either the YaBBSE forum or in the SMF forum. Infact the groups in the YaBBSE are unaltered, there are no new groups.
Oh and just to let you know, attachments where an issue as well for me. The directory is missing alot of attachment files and I had to do some pruning on the attachments from the admin center to get it to convert. If I didn't do it the script would die and all you see is a white screen. My error log shows it trying to access files that don't exist and having trouble and failing.
Umm I'll have to look more into this. I still don't understand how the ID_GROUP was set to 11.
Quote from: Chuck on February 15, 2007, 02:40:19 PM
The last message that I get before the internal sever error is
Converting private messages step 2 incomplete..
I had the same error. The way I solved it was by using the yabbse_to_smf.sql file in the 4th post rather than the file in the 1st post. After that it worked well for me.
Hey, thanks for the reply. That is the file that I use and I still get the error.
Post your phpinfo.php file.
What is phpinfo.php? (http://www.simplemachines.org/community/index.php?topic=18250.0)
I don't know if this is because the forum I converted was converted from YaBB to YaBBSE to SMF. But I noticed in the database in the members table, old members that didn't set their birthday are set to 0000-00-00, where as members who signed up after the conversion to SMF have 0001-01-01.
I doubt it affects anything, but I thought I would report it since I didn't know if it's something specific to the forum I converted or a bug that happens for all conversions.
I'll look into it. If I'm correct the correct format is 0001-01-01 cause of MySQL running in strict mode.
Yeah, I updated all the rows to the 0001 setting. I just wanted to report it incase it might be a issue with the converter.
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+.
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.
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.
This is really weird. I'll have to check YaBB SE and see what's up with the converter.
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
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?
Are you using the .sql file from this topic? The one in the downloads page is different from the one on this topic.
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...
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?
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?
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.
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 :)
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? ;)
is it too late to convert 1.5.5 to SMF?
thanks JayBachatero for the updated SQL file
enduris and cspeech so you still need help?
Quoteenduris and cspeech so you still need help?
Hi Jay,
Yes, I still need some assistance please, thanks.
Can you post the structure of the members table?
OK, I have attached a PDF printout from phpMyAdmin.
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.
QuoteCan you check in your Settings.php file for YaBB SE for the $db_prefix.
Well I can tell you without looking that the prefix for all of the tables that I exported (including members) is "forum_"
Ok but what is the setting in the Settings.php file?
QuoteOk but what is the setting in the Settings.php file?
You are referring to the YaBB SE Settings.php file, correct?
This is actually an export from a multi-board version of YaBB SE, so $db_prefix is a variable that is set dynamically.
One question I have though: How does the converter know which db to find the YaBB SE tables in? I know that the db has to exist on the same MySQL server as the SMF installation, but our server has many db's on it.
The first error I actually receive when running the converter is this:
Quote
Caused the error:
Unknown column 'mem.im_email_notify' in 'field list'
So now, I am wondering if we have extra columns in the YaBB SE members table that is causing the converter to error out?
Try running upgrade.php instead. SMF is able to upgrade certain versions of YaBB SE. Download the upgrade package. Change the prefix in the SMF Settings.php file to the yabb se prefix and upgrade. Do a backup first though.
QuoteTry running upgrade.php instead. SMF is able to upgrade certain versions of YaBB SE. Download the upgrade package. Change the prefix in the SMF Settings.php file to the yabb se prefix and upgrade. Do a backup first though.
Hi Jay,
I ran across this old post (http://www.simplemachines.org/community/index.php?topic=41128.0), and this looks like the exact problem we are experiencing.
I have been trying to convert our YaBB SE data directly into SMF 1.1.3. Instead, is this the process I should follow:
- Install SMF 1.0.5
- Run the YaBB SE converter
- Run upgrade.php
OK, problem solved!
Convert.php worked with the .sql file found in this topic (the second posting), but only after I hardcoded in the "from" (or source) database in convert.php. The problem was that the script was not detecting the database where my YaBB SE tables were.
The only problem I have noticed so far is that membergroups did not all get converted. This particular YaBB SE board had several custom member groups, and the custom groups did not make the transition.
But other than that, members, boards and posts look great, converted straight into SMF 1.1.3 :)
Since you just had a backup the Settings.php from YaBB SE was not found.
QuoteSince you just had a backup the Settings.php from YaBB SE was not found.
Yes, that makes sense.
There was another issue I should note here: When non-Admin members logged in to the new SMF forum, they did not have access to any of the boards (basically they saw news items and stats, that's about it). The forum Admin had to reset all of their passwords to something new, and when they logged back in, they had full access.
I am not sure, but this might be related to the fact that the YaBB SE membergroups did not get converted?
QuoteConvert.php worked with the .sql file found in this topic (the second posting), but only after I hardcoded in the "from" (or source) database in convert.php. The problem was that the script was not detecting the database where my YaBB SE tables were.
can someone please point exactly where the "from" or source in convert.php file as there are many instances of this word in the convert.php file.
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";'); is what you are looking for.
Thanks for the reply Jay! but i'm still encountering errors and installation is unsuccessful. i got these errors
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of YaBB SE 1.5.x. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: No database selected
Notice: Undefined index: don_bosco.sql in /home/donbosco/public_html/convert.php on line 343
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
all i have is a backup of my database. and what i did is change 'from_prefix' to 'don_bosco.sql'. is this correct? that's the filename of my backup exported from a yabbse remote hosting forum.
just a newbie here, so a step by step solution is needed ;D
Actually no that's not correct. You need to import the backup back to the database and then run the converter.
just did that Jay, imported the backup and run the converter. the error was
Unknown column 'mem.im_email_notify' in 'field list'
how do i edit this line based on endurics post?
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
That's a different issue. What version of YaBB SE do you have?
no idea, i'm assuming it's 1.5.5 :D i've got my backup database from Boardnation, a remote forum hosting, now owned by endurics. and from his post here, he said he managed to convert a backup of yabbse to smf. the instructions he emailed me was
"I had to edit convert.php and put in the source database name. So, just open up convert.php and edit the line that says "source" or "from" with your database name." which is basically what he posted here. but i don't know what part of the convert.php to edit and what to put in that part of code..
help please :(
If the backup is not too big send me an email with it and I'll take a look into it.
it's 3MB. is it ok? pls pm me your email add..
Thanks again, Jay
database sent, it's actually a 3Mb archived..
Ok just looked at the backup and the column is there in the backup. Check in phpMyAdmin if you see the im_email_notify column is there.
Hi Jay,
there is no im_email_notify column, or i might not be searching hard enough. or i don't know where to look at :(
i've posted the screenshot of phpmyadmin,..
http://www.donboscoforum.com/ScreenHunter_01%20Nov.%2015%2012.28.jpg (http://www.donboscoforum.com/ScreenHunter_01%20Nov.%2015%2012.28.jpg)
http://www.donboscoforum.com/ScreenHunter_02%20Nov.%2015%2012.28.jpg (http://www.donboscoforum.com/ScreenHunter_02%20Nov.%2015%2012.28.jpg)
thanks
Image links are broken.
opppsss.. fixed.. pls check them again..
It's inside the members table.
found it! there's im_email_notify
http://www.donboscoforum.com/ScreenHunter_03 Nov. 15 15.46.jpg (http://www.donboscoforum.com/ScreenHunter_03%20Nov.%2015%2015.46.jpg)
Ok I don't get why it's giving that error. Can you try it again?
even endurics got that error but he managed to fixed it. i'll give it another try.. do i have to do a fresh reinstall of smf and reupload my yabbse database?
i just tried converting it again but same error
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 `donbosco_smf`.smf_members AS mem
LEFT JOIN `donbosco_smf`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
LIMIT 0, 500;
Caused the error:
Unknown column 'mem.im_email_notify' in 'field list'
Ok I see the issue. What is the prefix of the SMF tables? The prefix seems to be the issue. Needs to be forum not smf.
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Should be.
$from_prefix = eval('`donbosco_smf`.forum_');
got this error
Parse error: syntax error, unexpected $end in /home/donbosco/public_html/convert.php(343) : eval()'d code on line 1
Must have replaces something else while doing this. Redownload the file.
Quote from: JayBachatero on November 14, 2007, 11:05:33 PM
Ok I see the issue. What is the prefix of the SMF tables? The prefix seems to be the issue. Needs to be forum not smf.
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Should be.
$from_prefix = eval('`donbosco_smf`.forum_');
if i use forum as prefix of the smf tables, i then get an error.
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 12, 2007 at 12:12 AM
-- Server version: 4.1.20
-- PHP Version: 4.3.9
--
-- Database: `db_dumps`
--
-- --------------------------------------------------------
--
-- Table structure for table `forum_banned`
--
CREATE TABLE `forum_banned` (
`type` tinytext NOT NULL ,
`value` tinytext NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
MySQL said: Documentation
#1050 - Table 'forum_banned' already exists
i just did another reinstall. fyi, database name is donbosco_smf and prefix is smf_
is this line still ok to use?
$from_prefix = eval('`donbosco_smf`.forum_');
thanks for your efforts, man.. it's just getting frustrating on my part... >:(
Where do you have smf installed and yabb se? In the same database?
If you want pm me ftp info and accedd to phpmyadmin.
Hi!
I have them on the same database. check your messages..
thanks heaps, mate!
I'll look at it when I get home tonight :).
thanks, mate! :D
Ok I imported the backup again. Upload the convert.php and use
$from_prefix = '`donbosco_smf`.forum_'; as the prefix.
can you please do the conversion so that you could see the errors being generated.
Upload the convert.php and I'll do it.
uploaded convert.php and yabbse_to_smf.sql
thanks!
Alright I'm the the train on my way home so I'll do it in a bit.
All set and done.
wow!!!!! cheers, man! thank you so much! how did you do it? i know i've been doing some crazy things with it.. i just can't follow directions.
thanks once again!
You didn't import the backup and I changed the prefix also.
Converting boards... Unsuccessful!
This query:
UPDATE `chapeau_discussion`.discussion_boards
SET memberGroups = '-1,0,2', lastUpdated = 1197215410
WHERE ID_CAT = 4;
Caused the error:
Unknown column 'lastUpdated' in 'field list'
What does this mean???
Use the convert.php from here. http://www.simplemachines.org/community/index.php?topic=140741.0 and the yabb21_to_smf.php file from this topic.
I'm upgrading to SMF from YABB SE, i have used the sql & convert.php from this topic. Then I get the next errors. Can you tell me what the problem is? Thanks.
Converting posts (this may take some time)... Successful.
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...
Warning: feof(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 20
Warning: fread(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 21
Warning: feof(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 20
Warning: fread(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 21
Is the attachments folder in yabbse readable/writeable by php?
If I remember right, You should be able to upgrade to SMF from yabb SE if you are using the last version that was released and just upload the large upgrade package.
Quote from: SleePy on December 29, 2007, 01:05:30 AM
Is the attachments folder in yabbse readable/writeable by php?
If I remember right, You should be able to upgrade to SMF from yabb SE if you are using the last version that was released and just upload the large upgrade package.
Both folder old and new are readable/writeable by PHP, with CHMOD 777.
Quote
Your YaBB SE install (v. YaBB SE 1.5.3) is not the most recent (v. YaBB SE 1.5.5).
Your language file version is the most recent.
The most recent version of index.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.3.
Your version of Admin is the most recent.
Your version of BoardIndex is the most recent.
Your version of Calendar is the most recent.
The most recent version of Display.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
Your version of Errors is the most recent.
Your version of ICQPager is the most recent.
The most recent version of InstantMessage.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.3.
Your version of Karma is the most recent.
The most recent version of Load.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
Your version of LockThread is the most recent.
The most recent version of LogInOut.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.1.
Your version of Maintenance is the most recent.
Your version of ManageAttachments is the most recent.
Your version of ManageBoards is the most recent.
Your version of ManageCats is the most recent.
Your version of Memberlist is the most recent.
Your version of MergeThreads is the most recent.
Your version of MessageIndex is the most recent.
The most recent version of ModifyMessage.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.2.
Your version of ModSettings is the most recent.
Your version of MoveThread is the most recent.
Your version of Notify is the most recent.
Your version of Poll is the most recent.
The most recent version of Post.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.2.
The most recent version of Profile.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.2.
Your version of Recent is the most recent.
Your version of Register is the most recent.
Your version of RemoveOldThreads is the most recent.
The most recent version of RemoveThread.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
Your version of RepairBoards is the most recent.
Your version of Search is the most recent.
Your version of Security is the most recent.
Your version of SendTopic is the most recent.
Your version of SplitThreads is the most recent.
The most recent version of Subs.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
This is informatie about my forum, maybe a problem with the version, if this the problem what can I do to solve the problem?
The forum is upgraded to 1.5.5, the upgrade to SMF gives same errors as post before.
Well you could manually edit the Yabbse files to fake the version and hope the upgrade goes well.
Was that output from the upgrade or converter script?
I have tried this a number of times and I keep getting errors. This seems to be the error that is stopping the whole progress:
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 `jbmaudio_smf1`.smf_members AS mem
LEFT JOIN `jbmaudio_smf1`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
LIMIT 0, 500;
Caused the error:
Unknown column 'mem.im_email_notify' in 'field list'
A little help?
can anyone help me????
Can any one help me?
The error is related to your prefix. Right now it's loading the SMF prefix. I posted a way to by pass this a few posts back.
My prefix for my SMF forums is 'smf_' I guess I am not sure what you are saying. I found the fix you were talk about
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Should be.
$from_prefix = eval('`donbosco_smf`.forum_');
but i am not sure what prefix you are talking about...
Ok I nuked everything and started over. I am getting this error now:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
UPDATE `jbmaudio_smf1`.smf_boards
SET memberGroups = '-1,0,2', lastUpdated = 1200585572
WHERE ID_CAT = 1;
Caused the error:
Unknown column 'lastUpdated' in 'field list'
I have tried pretty much everything in this post and can't get it to work....
QuoteUse the convert.php from here. http://www.simplemachines.org/community/index.php?topic=140741.0 and the yabb21_to_smf.php file from this topic.
this is the error i am getting:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
UPDATE `jbmaudio_smf1`.smf_boards
SET memberGroups = '-1,0,2', lastUpdated = 1200586738
WHERE ID_CAT = 1;
Caused the error:
Unknown column 'lastUpdated' in 'field list'
When I use the sql file from this post i get,
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
when i use the files from the down load section, i get the error in the previous post
Hello? This is a support forum right? Anyone out there?
It's still picking up the old prefix. What is the prefix for your YaBB SE install? Also check the file permissions for the file. That could be the reason for the Internal Server Error.
The supermod database is named:
jbmaudio.yabbse
The prefix for supermod tables is:
yabbsm
The Simple Machines database is named:
jbmaudio.smf1
the prefix for my simple machines tables are:
smf
I hope this helps
Ok do this.
Find
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Replace with
$from_prefix = '`yabbse`.yabbsm_';
QuoteOk do this.
Find
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Replace with
$from_prefix = '`yabbse`.yabbsm_';
Ok I made that change and now I get the following error :
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of YaBB SE 1.5.x. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'jbmaudio_smf1'@'localhost' for table 'yabbsm_members'
I went back to the orginal convert.php and got this error:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
UPDATE `jbmaudio_smf1`.smf_boards
SET memberGroups = '-1,0,2', lastUpdated = 1201121972
WHERE ID_CAT = 1;
Caused the error:
Unknown column 'lastUpdated' in 'field list'
Any suggestions
Keep the change and look at Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
I did this, i have added the user to both databases. it can access it the data base when i use the original covert.php. why can't it access it with the modified one? The SMF user has all privileges for my supermod database so why would i be getting this error?
(http://www.jbmaudio.com/Assets/users.JPG)
as you can see my smf user is on all of my databases. Unless I am not understanding what you are saying.
Just incase you can't see the image
Click here (http://www.jbmaudio.com/Assets/users.JPG) for a bigger copy
What permissions did you give to that user on that database though?
all privileges. the user should have total access
Is it possible for you to PM me access to your site or can you contact me on IM?
sent you an IM
Jay you out there?
I'm here now. Just got your IM.
Hello! We're trying to convert our YaBB SE 1.5.5 installation to SMF. With the converter on the site we couldn't do it. There were some errors. After we tried yabbse_to_smf.sql which one can get in this topic it worked! But all our messages on the new SMF are like "???????? ?????". Obviously we are experiencing problems with the encoding. Actually the encoding on the YaBB SE is windows-1251 (cp1251) and database encoding and collation is latin1. Any ideas on how can we convert messages so they stay like normal messages and not question marks?
Appreciate your help!
Are you using the convert.php script linked in the first post of this topic?
That one has a convert.php that lets you choose your SMF encoding. Choose UTF-8 for it and it should hopefully convert things correctly.
Thank you for your reply, but i don't see convert.php in the first post.
I found convert.php in the neighbour-topic "[SMF Converter] Yabb - 2.1", but it didn't help with my problem :(
Ohh, sorry thank you. I fixed it
Quote
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Looks like it worked! Thank you very much for such a wonderful support, SleePy!
The convert.php link links to http://www.simplemachines.org/community/index.php?topic=140741.0 which links back to here.... circular... Where can I get this convert.php file?
W.
Scratch that, a little confusing, but the file was actually attached at the end of that linked thread, but not visible at all if you aren't logged in.
I get the error:
Fatal error: Cannot redeclare ip2range() (previously declared in /home/nwrsuser/public_html/convert.php(910) : eval()'d code:1) in /home/nwrsuser/public_html/convert.php(913) : eval()'d code on line 20
Suggestions?
W.
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.
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.
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.
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
The attached one should fix that :)
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
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Quote from: SleePy on July 12, 2008, 05:05:53 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Thanks, everything was successfully. Now can my wife test the functionality and change the layout.
Thanks very much
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!
Please, try using the attached file, instead.
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'
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.
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_member, SUBSTRING(mem.member_name, 1, 80) AS member_name,
mem.date_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_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_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 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!
Try this one for new versions of PHP
https://github.com/SimpleMachines/converters/tree/master/SMF2.0/Yabbse/1.5
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_member, SUBSTRING(mem.member_name, 1, 80) AS member_name,
mem.date_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_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_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 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!
can you do a sql command
describe yabbse_members;
On your yabbse members table or do show create table tablenamehere;
Attached is the screen shot after running the SQL command "describe yabbse_members;"
Thanks.
Try using this sql file in this post instead
https://www.simplemachines.org/community/index.php?topic=140776.msg905770#msg905770
Use with the new convert.php
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?
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.
Thanks again for your advise. Based on what you described I am beginning to understand what caused the conversion problem:
Basically the convert.php and the yabbse_to_smf.sql for the YaBBSE 1.5.x can only be converted to SMF version 1.1 and not to version 2.x because for some reason SMF decided to change the database field names such as "memberName" in version 1.1 to "member_name" in version 2.x and the converter could not handle the change.
I decided to install SMF version 1.1 and activated PHP version 5.4. I then use the convert.php and the yabbse_to_smf.sql in this link you provided:
https://www.simplemachines.org/community/index.php?topic=140776.msg905770#msg905770
I did have to comment out a section of the convert.php that references 'SQL_MAX_JOIN_SIZE' as described in this post: http://www.simplemachines.org/community/index.php?topic=528263.0 in order for the conversion to work.
In the end I managed to convert the YaBB SE 1.5.5 forum to SMF 1.1 using the above steps. That is great!
I next have to figure out how to upgrade SMF 1.1 to SMF 2.0 because SMF 1.1. would not run on PHP 7.0. I hope it won't give me as much problem.
Once again thanks for the great help. Good night.
Glad you figured it out. Yes it was the case of SMF changing some variables adding a _ to make a space to the names. Going to SMF 2.0.x is easy though.
Just noticed that although all messages and members were posted correctly from YaBBSE 1.5.5 to SMF 1.1, all the attachments in the messages in YaBBSE posts were lost.
I tried to re-do the conversion again by re-installing the SMF 1.1 database and ensure that all attachment are allowed from admin. The conversion was completely successful but the attachment were still lost. The conversion message is shown below in brown.
I have used the attached convert.php and yabbse_to_smf.sql to do the conversion. I found that there was mention of the attachment conversions inside the yabbse_to_smf.sql file but there was still no attachment.
Is this expected or is there something else that need to be done to convert the attachment as well? Many of these attachments are quite valuable and since there are more than 8000 messages in the old forum it is not quite practical to manually restore them.
Thanks for any advise.
YaBB SE 1.5.x to SMF Converter
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
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.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the YaBB SE 1.5.x installation.
We hope you had a smooth transition!
Do you see the attachments in your smf's attachments folder
No the only file in the SMF attachments folder is "index.php" and there is no other files.
I noticed that in YaBBSE the attachments are captured by the "attachmentFilename" field in the yabbse_messages table . But on SMF 1.1, the table "smf_messages" there isn't such a field. How is an attachment info linked to a message in SMF 1.1?
is your smf_attachments table filled with entries.
If so copy your attachments from yabbse to your smf attachments folder.
No. Strangely the smf_attachments table is completely empty. I have attached the screen shot.
Thanks.
For some reason the screen shot was not attached in the last post. Here it is.
I tried to create a post in my new SMF 1.1 forum with an attachment and sure enough the entry showed up in the smf_attachments table with all the relevant fields. I then ran the convert.php again to re-do the conversion. After conversion the smt_attachments table again showed blank. So the conversion process wiped out the new post that I created with the attachment. I guess the convert.php somehow did not manage to convert the attachment in YaBBSE.
See if this attached file does anything...
I saw the conversion stopped at Converting topic notifications... Successful.
And didn't do any steps after from your log
It just does the steps after the first one
Tried that and got the following errors:
Converting...
Converting attachments...
Warning: Unknown: 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/automa11/public_html/smf/convert.php(1109) : eval()'d code on line 13
Fatal error: Call to undefined function getAttachmentFilename() in /home/automa11/public_html/smf/convert.php(1109) : eval()'d code on line 13
Anyway we have decided to manually transfer the attachment info (attachmentFilenaame, attachmentSize, ID_MSG and and ID_MEMBER) from yabbse_massages table to the smf_attachments. Fortunately only several hundreds of the posts have attachment and it took a few hours of manual labor to do that. But now we got a converted SMF 1.1. forum that is more or less complete and will next try to convert from 1.1 to 2.0.
I wonder if the large upgrade installer posted at: https://download.simplemachines.org/ is meant for upgrading from 1.1 to 2.0.15? Or is it meant for an upgrade from one version of 2.0.xx to 2.0.15? Since the conversion from YaBBSE to SMF 1.1 was quite a struggle we are hoping not to encounter similar difficulties when upgrading from 1.1. to 2.0.15.
Thanks.
yes it is meant to go from 1.1 to 2.0.x
Thanks for the confirmation. We will work on it.
We have upgraded from 1.1. to 2.0. We are glad to report that the upgrade proceeded smoothly without any hiccup. The upgraded SMF 2.0 has all the topics and posts.
However, the attachment issue came back up again. Although the posts show the attachment file name and file type but when I click on the attachment it returns a "404 - Attachment Not Found". The same attachment was available when in SMF 1.1. I check that there are still lots of files in the public_html/smf/attachments folder but the forum is unable to locate it.
Comparing the smf_attachments table between 1.1 and 2.0 (see attached) show that aside from the column heading changes SMF 2.0 added more columns in the table. e.g. There was no fileext column in 1.1 but now there is in 2.0. There is no file_hash in those entries because it was manual input (when upgrading from YaBBSE to SMF 1.1). It did work in 1.1.
I tried to remove the extension from the file name itself (e.g. I renamed "numerical_code_tube1.png" in the "filename" column to "numerical_code_tube1" thinking that maybe SMF2.0 would append the file extension to the actual filename but that did not help either.
In the end I examined the files in the public_html/smf/attachments on the server and realized that a number of files that were in that folder were deleted by the SMF upgrader during the upgrade from 1.1 to 2.0. The attachment that I clicked on happened to be the one that was deleted.
I then copied the original files from my yabbse/attachments folder to the smf/attachments and now the forum is able to serve up those files.
In other words for some reasons SMF upgrade.php decided that some of those files in the smf/attachments should be deleted during the upgrade. However there was no report of this actions and it is fortunate that we notice it during the testing.
Was that a know deliberate action by the upgrader or is that a bug?
Thanks.
I just realized that the attachments only showed up when I logged in as the forum administrator. When I logged in as a regular user (even at the highest level as a moderator but is not Admin) the message board still does not show the attachments.
[Edit] Just found out that this need to be enabled by Admin and set the permission to view the attachment.