[SMF Converter] YaBB SE 1.5.4

[ajg]

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_02%20Nov.%2015%2012.28.jpg

thanks

[JayBachatero]

Image links are broken.

[ajg]

opppsss.. fixed.. pls check them again.. 

[JayBachatero]

It's inside the members table.

[ajg]

found it!  there's im_email_notify

http://www.donboscoforum.com/ScreenHunter_03 Nov. 15 15.46.jpg

[JayBachatero]

Ok I don't get why it's giving that error.  Can you try it again?

[ajg]

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

Code Select Expand

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'

[JayBachatero]

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_');

[ajg]

got this error

Parse error: syntax error, unexpected $end in /home/donbosco/public_html/convert.php(343) : eval()'d code on line 1

[JayBachatero]

Must have replaces something else while doing this.  Redownload the file.

[ajg]

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

[JayBachatero]

Where do you have smf installed and yabb se?  In the same database?

If you want pm me ftp info and accedd to phpmyadmin.

[ajg]

Hi!

I have them on the same database.  check your messages..

thanks heaps, mate!

[JayBachatero]

I'll look at it when I get home tonight .

[ajg]

thanks, mate!   

[JayBachatero]

Ok I imported the backup again.  Upload the convert.php and use
$from_prefix = '`donbosco_smf`.forum_'; as the prefix.

[ajg]

can you please do the conversion so that you could see the errors being generated.

[JayBachatero]

Upload the convert.php and I'll do it.

[ajg]

uploaded convert.php and yabbse_to_smf.sql

thanks!

[JayBachatero]

Alright I'm the the train on my way home so I'll do it in a bit.