[SMF Converter] phpBB3

[easyrider77]

Hi there,

After successful convert from phpBB, i can't  access to  avatars or attachments folder when i try to upload image or avatar from my PC.


I convert offline the forum with XAMPP.


I do something wrong..? 

[ThorstenE]

when transfering your forum from offline to online you must modify the pathes to avatars, smileys etc.. repair_settings.php should help you:
What is repair_settings.php?

[easyrider77]

Hi TE, thanks for your reply.

It works..!! 

Reset  all the critical paths to the right position, great tool..!!  thank you.

For avatars work ok, but when i try to upload picture from pc, i get this error..

Any idea  about..?

The file i try upload is 450x90 px 3,53 KB gif..!!

[ThorstenE]

1) make sure the avatars /attachments folder is writeable ( CHMOD 777)
How do I chmod? / what is chmod?
2) go to Admin - Attachments and Avatars - Max attachment folder space:     -->> increase the value to a higher size.

[easyrider77]

Was the max attachment folder space.. i change it to bigger  value and work perfect..! thanks TE..!! 


There is some script  to correct the attachments paths or/and, the bbcode size posts..?

Because after conversion, both attachments not open as fotos or files, and all the words/posts where was in size bbcode, apear in 99px size.. i mean real huge..!! 

[ThorstenE]

I'm not sure about your issue.. can you post a link to an affected post on your forum?

[easyrider77]

Some  off them, from about 11 pages with "99px" key Search Results..

Code Select Expand

http://www.adultforumgr.com/index.php?topic=3069.msg64043#msg64043
http://www.adultforumgr.com/index.php?topic=3025.0
http://www.adultforumgr.com/index.php?topic=2992.0
http://www.adultforumgr.com/index.php?topic=3180.0
http://www.adultforumgr.com/index.php?topic=2951.0
http://www.adultforumgr.com/index.php?topic=3226.0
http://www.adultforumgr.com/index.php?topic=1219.0
http://www.adultforumgr.com/index.php?topic=2817.0
http://www.adultforumgr.com/index.php?topic=2749.0

[easyrider77]

I am not sure what you mean.. would you like to replace your old size tags in the database or only don't know, how to use size tag in SMF?

the size in SMF is used with pt or px as an attribute, the max. size is 99

Code Select Expand

[size=99pt]test[/size]

if you want to replace old BBCODEs in the messages table you can do it with the same solution posted above
example:

Code Select Expand

UPDATE smf_messages SET BODY = replace( BODY, 'size=200', 'size=99pt' )

Hey TE, i just so this post.. ! is possible to use the "same" command in phpmyadmin..?

All the post's with size bbcode looks like those after convert:

Code Select Expand


[size=99px][url]http://www.20q.net/[/url][/size]
[size=99px][b]Τι είναι ο χάκερ (hacker), πως «δουλεύει» [/b][/size]
[size=99px][b]Once Upon A Time In The West [/b][/size]

[ThorstenE]

yes, that's exactly the solution, you must replace the size=99px with a smaller value (in my example 20pt)

Code Select Expand

UPDATE smf_messages SET BODY = replace( BODY, 'size=99px', 'size=20pt' )

Execute the query with phpMyAdmin.

[easyrider77]

A big thank you my fried TE..!   it works fine..!

[cut|throat]

Worked perfect. Thanks allot.

Only thing is, now I need to convert to SMF 2.0....Is the a password fix for the 2.0 rc1?

Thanks.

[ThorstenE]

the password fix is build-in in 2.0 RC1

[Indrit]

I did convert my forum and everything seems fine BUT, I can not LOGIN to my forum. I have read all over SMF forum that there is a issue about password while converting from phpbb3 to smf 1.1.8 and also there is a fix password file. I am not sure where to upload this file and what to do with it.   If I am not mistaken it is a .xml file

Please help?

Regards,
Indrit

[ThorstenE]

th phpBB3_login_fix.tgz is attached to the first post from this topic. You can install it via Package Manager or manually change the Sources/LogInOut.php

[InternetMafia]

I installed the board and the board converted correctly with the exception of one problem.

I no longer have admin rights.

Is there a quick fix for this?

[ThorstenE]

I accidentally deleted my admin account, what do I do?

[Joe N]

Could you convert back to smf?

Joe

[SleePy]

Yes,

Just follow the instructions on the conversion page or the ones found on our doc site

[Pame]

Hi

Could you explain to me what happens ?

My phpBB Version is 3.0 from early 2008 & SMF 1.1.8

I'd installed this latest version from SMF & phpBB3 converter.php (uploaded with phpbb3_to_smf.sql file) but...
My error is...

Code Select Expand


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

    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
    u.user_regdate AS dateRegistered,
    SUBSTRING(u.user_from, 1, 255) AS location,
    u.user_posts AS posts, IF(u.user_rank = 1, 1, IFNULL(mg.ID_GROUP, 0)) AS ID_GROUP,
    u.user_new_privmsg AS instantMessages,
    SUBSTRING(u.user_email, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessages,
    SUBSTRING(u.user_msnm, 1, 255) AS MSN,
    SUBSTRING(u.user_aim, 1, 16) AS AIM,
    SUBSTRING(u.user_icq, 1, 255) AS ICQ,
    SUBSTRING(u.user_yim, 1, 32) AS YIM,
    SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
    SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
    u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
    IF(u.user_allow_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
    REPLACE(u.user_sig, '\n', '<br />') AS signature,
    u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
    u.user_notify_pm AS pm_email_notify,
    CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle, u.user_ip AS memberIP,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
    u.user_ip AS memberIP2
    FROM `***`.phpbb_users AS u
    LEFT JOIN `***`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `***`.smf_membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.group_id NOT IN (1, 6)
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the error:

    Unknown column 'u.user_id' in 'field list'



Sorry for my poor english really !

NB: php 4.4 - MySQL 5.0

[SleePy]

Does a phpbb_users table exist in your phpBB database?
Is there a column in there called user_id?