News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

JayBachatero

If you PM me FTP info I can take a look at it for you :).
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

dratte


dratte

To all of those who will post here. I must say that I had a lot of problem with the transfer of my files. but Jay is a real GENIOUS. HE was able to fix the problem no time. My mistake was simply because I had used the wrong file.

So again thanks JAY THE MAN!!!

darky2106

Quote
Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_members
    (ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
    VALUES ('503', 'FousaSandFase', ................................. and etc.....

Caused the error:

    Incorrect integer value: '' for column 'ID_GROUP' at row 1
Im using this sql file(from the topic) and the converter from the topic --> http://www.simplemachines.org/community/index.php?topic=140741.0

I need help fast please im very confused :(

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

darky2106

yes i am using the file from this topic and it dose not work...

JayBachatero

What version of phpBB are you running?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

darky2106

PHPBB:2.0.22
SMF:1.1.2

Those are the versions of both installed forums.. i have many installations of different versions if its needed...

JayBachatero

Ok it should work.  You need to upgrade to 1.1.4 BTW.  Give the converter a shot again.  I remember seeing something similar so I'll look into it more and see what's up.  Do a search 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

darky2106

I found out on another topic why it happens like that:
Quote
EDIT ---
I was able to fix this error and a few other ones that had poped up. It seams that there is a bug in mysql 5.X
and so sence i had access to the my.ini file i changed this line
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to this line
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
and it fixed all error and inserted every thing just fine.

But i have problem whit smileys now.. i saw an sql script in this topic i will search it again..

NetFlag

I have started a forum based on phpbb3. Now I would like to convert in SMF. Is there a converter in development?

JayBachatero

#391
Yes it's still under development.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

RossEdward

Use this convert.php with the .sql file attached in this topic.

keeps on pointing me back to the same topic :(

i already downloaded the .sql file, tried using the default convert.php provided in the download converter page provided of the site. but i cannot download or get a copy of that converter that mod has posted.

JayBachatero

What do you mean it keeps pointing you back to the same topic?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

RossEdward

#394
Quote from: JayBachatero on January 13, 2007, 02:47:08 AM
Software: phpBB
Version: 2.0.19 and up

This is the official support topic for phpBB converter.  Use this topic to ask for support for this converter.  I merged all the changes that were floating around.  Lets use this topic to get a final working version.

Changelog
! Convert smileys. (phpbb2_to_smf.sql)
! When converting attachments cast width and height as a string. (phpbb2_to_smf.sql)
! Merged all the small changes floating around into one file. (phpbb2_to_smf.sql)
! When converting attachments set the width and height for images (phpbb2_to_smf.sql)
! Bug in signature conversion. (phpbb2_to_smf.sql)

convert.php
Use this convert.php with the .sql file attached in this topic.

http://www.simplemachines.org/community/index.php?topic=140741.0 <-- convert.php

are you referring to another version of convert.php or the .sql on this one? coz i was able to download the .sql but when i click on the convert.php i just keeps on jumping back to this thread.

Eddy Matthews

After having loads of problems with the converter failing to convert my phpbb posts (see http://www.simplemachines.org/community/index.php?topic=216789.0 ), I eventually found a new version of the converter sql file and tried that....

It got past the previous problems, but it now generates a new error:

Converting...
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 board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images...
Fatal error: Call to undefined function: copy_dir() in /home/fhlinux208/p/paddleducks.co.uk/user/htdocs/smf/convert.php(665) : eval()'d code on line 20

Can anypne help with that one please?

Regards
Eddy

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Eddy Matthews

Quote from: JayBachatero on January 15, 2008, 01:36:15 PM
Did you try the convert.php here?  http://www.simplemachines.org/community/index.php?topic=140741.0

I've tried every version I could find Jay - I eventually got it to work by removing the stuff for converting the avatar files/directory from the converters sql file - Then it completed without problems. The avatars aren't a big deal for me, as long as I have the userbase and the messages etc transferred across....

Regards
Eddy

JayBachatero

Using those two files there shouldn't be a problem with them.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

iatros

This attachment seems to be not working. Am I the only one having access problems?
Come visit at hxxp:ppc-central.com [nonactive]

Advertisement: