YaBB 1 Gold SP1 -> SMF 1.0.6 Conversion Error

[marinig]

Hello,
I don't know why I'm getting this error converting my old Yabb board: the convertor says everything was successfull but when I open smf I only find the boards but the users and all the topics are missing! The forum statistics too says "0 Posts in 5262 Topics by 0 Members". Why?

I must specify that during the installation of smf 1.0.6 I get a strange error:

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #1076: Out of range value adjusted for column 'ID_POLL' at row 1

I'm using MySQL 5.0.18 for win32 that is the latest stable version (not beta or rc).

Then if I press the "Try again" link everything ends all right and I can open the just installed smf. It seems to work except for the fact that there is no topic in the board! So I access the Admin Center and fix all the errors and the topic with the welcome post appears.
At this point evereything looks ok to me so I start the convertor and it ends up with all successful operations... But all the topics and members are missing and I can't login because it says that my username doesn't exist! The only thing I can do is delete the entire database and try again!

I also tried installing smf 1.1 rc2 and the install process ends up all right but the convertor can't finish its work! It is impossible to convert members... (I get this error: "Field 'lngfile' doesn't have a default value" - what does that mean??)

Can someone help me?
Thanks

[marinig]

Please, I'm sure you can help me!

I'm trying again and again but I still get the same errors everytime!

[Oldiesmann]

Apparently your host has MySQL running in STRICT mode, which makes it extremely picky about what you can and cannot do. The "out of range" errors indicate that there's probably a problem with the converter.

The other error about the lngfile field is also related to strict mode, but appears to be a bug in MySQL - strict mode doesn't let you create columns without a default value, but lngfile is a TEXT column and the MySQL manual clearly states that TEXT columns can't have a default value...

My only suggestion would be to tell the server admin to turn off strict mode. You may also want to try MySQL 5.0.19, which was released earlier this month.

[marinig]

Ok, Thanks! 

I just installed Mysql 5.0.19. Now, can you tell me how to turn off strict mode?

Many thanks

[marinig]

Ok, I changed mysql mode with this command:

SET GLOBAL sql_mode='TRADITIONAL';

I set the mysql mode to traditional: is that ok?

I don't know why but I still get the same error: "Field 'lngfile' doesn't have a default value"!!

What can I do?? I never had so many problems installing a forum...

[marinig]

Help! 

[ms_ukyankee]

I have to ask, did you download and use the converter for the 1.1 version of SMF, because I'm not seeing a field 'lngfile' in it at all?

[marinig]

I downloaded and used the converter I found here:
convert.php from http://www.simplemachines.org/community/index.php?topic=38966.0
yabb_to_smf.php from http://www.simplemachines.org/community/index.php?topic=65677.0

Is it right?

Thanks

[Fizzy]

That one is for SMF RC1.1

As you are using SMF 1.0.6 please use This One and see if it corrects the problem

[ms_ukyankee]

He's tried both I think.

I don't know, I've converted 4 yabb forums (on linux servers) and not seen that error before. Are you on a windows server by any chance?

[Fizzy]

OK, thanks Leah

Marinig, The lngfile field in the database does not require a default setting and is usually blank. Have you set a default language in your SMF install?

The smf_members table structure shoudl read as

Type = MyISAM
Field = lngfile
Type = Tinytext
Attributes = Blank
Null = No
Default = Blank
Extra = Blank

Can you please compare yours.

[marinig]

Thanks for your answers.

I tried both the 1.0.6 and 1.1rc2 versions with the corresponding converter (I think). Now you tell me that that converter is for rc1 only... So I may have downloaded the wrong converter so, please, can you tell me where to find the latest converter for smf 1.1 rc2 (convert from yabb 1 gold sp1 and from yabb2) ?

I'm just doing some tests and so I'm not on a real webserver. Well, it is a real webserver actually (Apache 2, PHP 5 and Mysql 5) but everything is on my pc (windows XP Pro SP2). I'd like to convert the old yabb database to mysql on my pc just because it's very very big (more than 100MB of files) and I don't want to crash the online server (I have a simple shared hosting account)!!

Marinig, The lngfile field in the database does not require a default setting and is usually blank. Have you set a default language in your SMF install?

Everytime I just installed the smf 1.1 rc2 using install.php, then I opened the forum (to see if it worked) and finally I started the converter using convert.php... Not even accessed the admin center! So I don't think I changed some functional parameter.

Type = MyISAM
Field = lngfile
Type = Tinytext
Attributes = Blank
Null = No
Default = Blank
Extra = Blank

Where should I go to see the smf_members table structure?
I used phpmyadmin but I got something longer and different so I'm not sure it is the same thing. Here it is:

Code Select Expand

Field Type Null Predefined
ID_MEMBER mediumint(8) Yes NULL
memberName varchar(80) Yes
dateRegistered int(10) Yes 0
posts mediumint(8) Yes 0
ID_GROUP smallint(5) Yes 0
lngfile tinytext Yes
lastLogin int(10) Yes 0
realName tinytext Yes
instantMessages smallint(5) Yes 0
unreadMessages smallint(5) Yes 0
buddy_list tinytext Yes
pm_ignore_list tinytext Yes
messageLabels text Yes
passwd varchar(64) Yes
emailAddress tinytext Yes
personalText tinytext Yes
gender tinyint(4) Yes 0
birthdate date Yes 0001-01-01
websiteTitle tinytext Yes
websiteUrl tinytext Yes
location tinytext Yes
ICQ tinytext Yes
AIM varchar(16) Yes
YIM varchar(32) Yes
MSN tinytext Yes
hideEmail tinyint(4) Yes 0
showOnline tinyint(4) Yes 1
timeFormat varchar(80) Yes
signature text Yes
timeOffset float Yes 0
avatar tinytext Yes
pm_email_notify tinyint(4) Yes 0
karmaBad smallint(5) Yes 0
karmaGood smallint(5) Yes 0
usertitle tinytext Yes
notifyAnnouncements tinyint(4) Yes 1
notifyOnce tinyint(4) Yes 1
notifySendBody tinyint(4) Yes 0
notifyTypes tinyint(4) Yes 2
memberIP tinytext Yes
secretQuestion tinytext Yes
secretAnswer varchar(64) Yes
ID_THEME tinyint(4) Yes 0
is_activated tinyint(3) Yes 1
validation_code varchar(10) Yes
ID_MSG_LAST_VISIT int(10) Yes 0
additionalGroups tinytext Yes
smileySet varchar(48) Yes
ID_POST_GROUP smallint(5) Yes 0
totalTimeLoggedIn int(10) Yes 0
passwordSalt varchar(5) Yes



Thanks

[Fizzy]

Hi again,

lngfile   tinytext   Yes   

That's the one you want. Can you try changing the "Yes" to a "No" please by using the Edit function which should be on the right hand side of the field in the table.

[marinig]

Hello again!
I'm sorry but I still have problems while converting from yabb 1 gold to smf 1.1 rc2!
Here is what I get now:

Code Select Expand


Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:

    INSERT INTO `tpsmf`.smf_log_mark_read
    (logTime, ID_MEMBER, ID_BOARD)
    VALUES ('1142507340', '1', '29'),
    ('1142507340', '1', '32'),
    ('1142507340', '1', '20'),
    ('1142507340', '1', '25'),
    ('1142507340', '1', '33'),
    ('1142507340', '1', '40'),
    ('1142507340', '1', '10'),
    ('1142507340', '1', '46'),
    ('1142507340', '1', '30'),
    ('1142507340', '1', '23'),
    ('1142507340', '1', '50'),
    ('1142507340', '1', '15'),
    ('1142507340', '1', '22'),
    ('1142507340', '1', '36'),
    ('1142507340', '1', '4'),
    ('1142507340', '1', '43'),
    ('1142507340', '1', '6'),
    ('1142507340', '1', '14'),
    ('1142507340', '1', '38'),
    ('1142507340', '1', '26'),
    ('1142507340', '1', '18'),
    ('1142507340', '1', '49'),
    ('1142507340', '1', '2'),
    ('1142507340', '1', '35'),
    ('1142507340', '1', '11'),
    ('1142507340', '1', '28'),
    ('1142507340', '1', '39'),
    ('1142507340', '1', '1'),
    ('1142507340', '1', '9'),
    ('1142507340', '1', '34'),
    ('1142507340', '1', '21'),
    ('1142507340', '1', '47'),
    ('1142507340', '1', '8'),
    ('1142507340', '1', '48'),
    ('1142507340', '1', '41'),
    ('1142507340', '1', '12'),
    ('1142507340', '1', '17'),
    ('1142507340', '1', '27'),
    ('1142507340', '1', '19'),
    ('1142507340', '1', '16'),
    ('1142507340', '1', '37'),
    ('1142507340', '1', '42'),
    ('1142507340', '1', '51'),
    ('1142507340', '1', '3'),
    ('1142507340', '1', '7'),
    ('1142507340', '1', '24'),
    ('1142507340', '1', '5'),
    ('1142507340', '1', '45'),
    ('1142507340', '1', '52'),
    ('1142507340', '1', '13'),
    ('1142507340', '1', '31'),
    ('1142507340', '1', '44');

Caused the error:

    Unknown column 'logTime' in 'field list'


What is it now?
Thanks

P.S. If I click on the "Try Aganin" button I get

Code Select Expand


This query:

    ALTER TABLE `tpsmf`.smf_log_topics
    ADD tempID int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY;

Caused the error:

    Can't DROP 'PRIMARY'; check that column/key exists


[marinig]

Please, what should I do?
This conversion is very very difficoult!

[ms_ukyankee]

When I got errors on conversion, I edited the converter and commented out or removed the code that caused errors, and then ran it again, as many times as it took until I got through to the end. So in that case, I'd remove that DROP PRIMARY KEY from that code block in the converter.

Hats off to your perseverance.

[marinig]

I did it! Finally I converted successfully my old yabb 1 gold to smf 1.0.6! It's fantastic! 

Thanks to everybody for the support! 

P.S. I had to install again Apache, PHP and MySQL to make the converter work!!