from YaPP to SMF

[Poasters]

Hello, our forum http://www.poasters.com/forum/index.php?op=forum is running YaPP by Eric M., which is based on YaBBSE 1.5.1. If we want to convert to SMF, can we use the YaBBSE to SMF converter on your downloads page?

We have an error which appears to be related to the database. Is that likely to affect the conversion?

[H]

What is the error?

[Poasters]

2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
(/big/dom/xpoasters/www/forum/Sources/SAdmin.php ln 57)

It prevents login to the admin panel. Not good.

[H]

That shouldn't affect the converter .

If the converter fails then it won't matter too much as your data is not deleted

[Poasters]

OK, good. Thanks, I'll let you know how it goes.

[Poasters]

OK, I finally attempted a conversion on a backup of our YaBBSE database. It is just the database, and not the YaPP files. The conversion was unsuccessful, giving the following 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 `xpoaster_steve2`.smf_members AS mem
    LEFT JOIN `xpoaster_steve2`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

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

[Oldiesmann]

What version of YaBB SE are you using? If I remember correctly, YaPP was an early predecessor to LSP Enigma.

[Poasters]

YaPP (yet another php portal) was an independent project by Eric M.

Our installation appears to be based on YaBBSE 1.5.0.

[JayBachatero]

Which converter are you using?

[Poasters]

This one from the downloads page:
http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-rc3_yabbse_converter.zip

[JayBachatero]

Try this one.

[Poasters]

It results in the same error.

[JayBachatero]

Go into the YaPP database and run this query.  You need to replace {$db_prefix} with the correct database prefix.  After you run it paste the output here.

Code Select Expand

SHOW COLUMNS
FROM {$db_prefix}members

[Poasters]

SQL result

Host: localhost
Database: xpoaster_steve2
Generation Time: Nov 22, 2006 at 06:41 PM
Generated by: phpMyAdmin 2.8.0.2 / MySQL 4.1.21-standard
SQL query: SHOW COLUMNS FROM yabbse_members;
Rows: 44
Field    Type    Null    Key    Default    Extra
ID_MEMBER    int(10) unsigned         PRI    NULL    auto_increment
memberName    varchar(80)         MUL         
realName    tinytext    YES         NULL    
passwd    tinytext                   
emailAddress    tinytext    YES         NULL    
dateRegistered    bigint(20)    YES         NULL    
personalText    tinytext    YES         NULL    
memberGroup    tinytext    YES         NULL    
gender    tinytext    YES         NULL    
birthdate    date              0000-00-00    
websiteTitle    tinytext    YES         NULL    
websiteUrl    tinytext    YES         NULL    
location    tinytext    YES         NULL    
ICQ    tinytext    YES         NULL    
AIM    tinytext    YES         NULL    
YIM    tinytext    YES         NULL    
hideEmail    tinyint(4)    YES         NULL    
timeFormat    tinytext    YES         NULL    
signature    text    YES         NULL    
posts    int(11)    YES         NULL    
timeOffset    float    YES         NULL    
avatar    tinytext    YES         NULL    
im_ignore_list    text    YES         NULL    
im_email_notify    tinyint(4)              0    
lastLogin    bigint(20)    YES         NULL    
karmaBad    tinyint(4)              0    
karmaGood    tinyint(4)              0    
usertitle    tinytext    YES         NULL    
lngfile    tinytext    YES         NULL    
notifyAnnouncements    tinyint(4)              1    
notifyOnce    tinyint(4)              1    
MSN    tinytext    YES         NULL    
memberIP    tinytext    YES         NULL    
secretQuestion    tinytext                   
secretAnswer    tinytext                   
astatus    text                   
bio    text                   
muteduser    tinyint(4)              0    
mood    varchar(75)                   
mood_filename    varchar(200)                   
theme    text                   
showAvatars    tinyint(1)              1    
showSigs    tinyint(1)              1    
showLocked    tinyint(1)              1    

[JayBachatero]

Ummm that column that it's giving the error on exists.  Not sure what's the problem.

[Poasters]

Is it possible that there is another hidden error?

What steps can we take to convert our forum?

[JayBachatero]

You just have one YaPP installation right?

[Poasters]

We have our main live site with a complete YaPP installation.
http://www.poasters.com/forum?op=forum

We also have a test site with a clean SMF install and a mysql database that includes both the yabbse_ tables from a backup of the live site and smf_ tables from the new install.
http://steve2.xpoasters.com/smf/

I created this particular forum to test whether the yabbse converter would work for us.

[JayBachatero]

Umm can you check both databases and see if the columns for the members table matches?

[Poasters]

I can try that in about 1.5 hours when I get home.

You are referring to the table structures at both sites, right? The new install only has one user.