Phpbb 2 problem on line 2656 (Converting)

[TaX]

Hii people i have a Phpbb 2 forum (2.0.23) "the last 2 version  " and well i want migrate them to SMF and well i finish to install the forum (SMF) and when i try to run "convert.php" they give the next error:

Parse error: syntax error, unexpected ';', expecting ')' in /home/forofueg/public_html/foro/convert.php on line 2656

ouch!!! So i'm stacking in that step
Please if someone can help me!? I reall apreciated that!!!
Thanx's very much in advance

[Aakku]

Parse error: syntax error, unexpected ';', expecting ')' in /home/forofueg/public_html/foro/convert.php on line 2656

ouch!!! So i'm stacking in that step
Please if someone can help me!? I reall apreciated that!!!
Thanx's very much in advance

Ouch too  I have phpbb 2.0.21. and i had same parse error when i tried to convert ... SMF was installed today on same server with finnish language support - don't know what to do ... waiting.

[Lansu]

And the same thing in here as well. But I have phpbb 3.

[ThorstenE]

uhhh, the convert.php in the download-packages seems to be wrong?!?
please download the version from this Topic:
http://www.simplemachines.org/community/index.php?topic=140741.0
(attached, scroll down)

[Aakku]

uhhh, the convert.php in the download-packages seems to be wrong?!?
please download the version from this Topic:
http://www.simplemachines.org/community/index.php?topic=140741.0
(attached, scroll down)

Thanks !

I almost succeeded  --> convert.php gives now this message :

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_level = 1, 1, hxxp:mg.id [nonactive]_GROUP) 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_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, u.user_active AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
    u.user_registered_ip AS memberIP, u.user_registered_ip AS memberIP2
    FROM `outomaa_phpbb2`.phpbb_users AS u
    LEFT JOIN `outomaa_phpbb2`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `outomaa_smf`.smf_membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != -1
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the error:

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

Any idea, where that 'field list' might be ?  Bold font by me ...

[ThorstenE]

looks like the updated version contains some parts only working for "modded" phpBB-Versions.. 

edit the phpbb2_to_smf.sql
find

Code Select Expand

, u.user_registered_ip AS memberIP, u.user_registered_ip AS memberIP2
and remove this

[Aakku]

looks like the updated version contains some parts only working for "modded" phpBB-Versions.. 

edit the phpbb2_to_smf.sql
find

Code Select Expand

, u.user_registered_ip AS memberIP, u.user_registered_ip AS memberIP2
and remove this

Jes ! Yippe 

It works perfectly - no losses of data and memberlist is original ... Thank You very, very much.

Still i have a little question - what is the name of file, where this "posting box" is defined --> i'd like to make it a bit larger. In phpBB2 we used a lot larger box - it's easy to write longer texts too.

[ThorstenE]

the size of the postbox can modified by editting the Sources/Subs-Post.php

find:

Code Select Expand

// Allow for things to be overridden.
if (!isset($context['post_box_columns']))
$context['post_box_columns'] = 60;
if (!isset($context['post_box_rows']))
$context['post_box_rows'] = 12;

change 60  to a higher value for the colums, 12 for the rows..

[SleePy]

That line should be fixed with using:

Code Select Expand

    IFNULL(u.user_registered_ip, '') AS memberIP, IFNULL(u.user_registered_ip, '') AS memberIP2

as well

[Aakku]

the size of the postbox can modified by editting the Sources/Subs-Post.php

Thanks again - now system seems to be ready 

[imranbaig]

Hi thanks for the Converter but m getting the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `anime35_bb`.phpbb_users AS u
LEFT JOIN `anime35_bb`.phpbb_ranks AS r ON ' at line 26

[SleePy]

Try the attached file.

[imranbaig]

Thanks I have the same error. If I use the file you have attached then it gives this error -     Unknown column 'u.user_registered_ip' in 'field list'

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_level = 1, 1, hxxp:mg.id [nonactive]_GROUP) 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_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, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
IFNULL(u.user_registered_ip, '') AS memberIP, IFNULL(u.user_registered_ip, '') AS memberIP2

[SleePy]

Try the following file then.

[imranbaig]

Thanks every thing went smooth until this point:

Recalculating forum statistics... Unsuccessful!

This query:

    UPDATE `@@@@@`.smf_topics
    SET ID_FIRST_MSG = '',
    ID_MEMBER_STARTED = '0', ID_LAST_MSG = '',
    ID_MEMBER_UPDATED = '0', numReplies = '-1'
    WHERE ID_TOPIC = 1020
    LIMIT 1;

Caused the error:

    Duplicate entry '0-1' for key 2

[SleePy]

Odd,

There is a topic in the topics table that doesn't have a starting or ending message. The converter script looks like it was supposed to prevent that.

We could manually go into phpMyAdmin and delete that topics id. I don't think you would lose any messages. It hopefully should be able to continue from then on.

[imranbaig]

I dont know which TOPIC ID I deleted few which had no start and end message id. The error still exists.

[SleePy]

Is it the same exact error as above? If you did that topic still exists in the SMF database (as well as phpbb 2 database if you are starting the converter over from the start).

[imranbaig]

Yes it is the exact same error, showing the error with different topic errors. I'm restarting the converter from same place from where it had stopped.

[SleePy]

Tell me, in phpbb. Are these moved topics that we are dealing with?