PHPBB2 - problem with MySQL

[sayokan]

I used the same file and converted with no problems but what I have is all none English characters are muddled up like "gönüllüsü arkadaþlar".

I have SMF setup in Turkish language. Any ideas would be highly appriciated!!!

[chipset66]

Hi,
I to use this version: phpbb2_to_smf_2006_09_21.
This works, but with a 1 mini problem: Everi group have 5 stars instead 1, 2, 3......8. I fix this from adminpanel for everi group and now is OK.

10x for this updated convert.

[EvilDragon]

I tried it (and many other converter versions...) But I have a similar problem as above:

Code Select Expand


Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `sql740`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('2039', '0', '26421', '26461', '2', '148', '2', '0', '0', '1', '369'),
('2040', '0', '26438', '35943', '512', '674', '4', '0', '0', '6', '538'),
('2041', '0', '26443', '26616', '78', '181', '9', '0', '0', '33', '1196'),
('2042', '0', '26448', '26552', '512', '109', '8', '0', '0', '5', '373'),
('2043', '0', '26487', '26648', '286', '286', '9', '0', '0', '20', '683'),
('2044', '0', '26518', '26613', '35', '79', '2', '0', '0', '5', '527'),
('2045', '0', '26543', '30672', '517', '11', '15', '0', '0', '5', '353'),
('2046', '0', '26549', '26553', '106', '488', '8', '0', '0', '1', '240'),
('2047', '0', '26559', '26857', '526', '447', '5', '0', '0', '17', '757'),
('2048', '0', '26575', '26772', '181', '181', '9', '0', '0', '7', '363'),
('2049', '0', '26576', '26576', '13', '13', '1', '0', '0', '0', '395'),

... some SQL lines deleted...

('2071', '0', '26882', '27070', '445', '200', '10', '0', '0', '4', '343'),
('2072', '0', '26882', '26882', '445', '445', '10', '0', '0', '0', '15'),
('2073', '0', '26890', '26958', '530', '530', '5', '0', '0', '5', '207'),
('2074', '0', '26910', '26914', '62', '4', '6', '0', '0', '2', '254'),
('2075', '0', '26916', '26959', '-1', '181', '18', '0', '0', '11', '466'),
('2076', '0', '26922', '27399', '428', '28', '1', '0', '0', '10', '615'),
('2077', '0', '26936', '26967', '517', '517', '5', '0', '0', '8', '216'),

... some more SQL Lines deleted...

Caused the error:

Duplicate entry '26882-10' for key 3

[/quote]

I checked the Database of php2bb, and there are definately no two entries for 26882...

Any idea?

[sayokan]

frwjd: see my post above yours and download that converter It fixes this error and some others

This worked fine to convert but I am having this error now:

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

It prevents me logging into system and also doesn't show anything.

[kRisTen26]

I feel like a total idiot and I've been at this for hours.  I've finally gotten the converter to actually DO something and wind up with this:

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_level = 1, 1, mg.ID [nofollow]_GROUP) AS ID_GROUP,
    u.user_new_privmsg AS instantMessages,
    SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessages,
    SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
    SUBSTRING(u.user_aim AS 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 memberIP,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
    '' AS memberIP2
    FROM `desti10_forum`.phpbb_users AS u
    LEFT JOIN `desti10_forum`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `desti10_Forum`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != -1
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the 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 'AS emailAddress, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessag' at line 9

What's causing it and HOW can I fix it?! 

I'm going a little out of my mind here...

Kristen

[Person]

Please read this: (some posts above)
http://www.simplemachines.org/community/index.php?topic=107868.msg738192#msg738192

[kRisTen26]

Thanks for the advice.  I've downloaded and run the phpbb2_to_smf_2006_09_21-utf8.zip file, but am now getting this error:

Converting ranks... Successful.
Converting groups... Successful.
Converting smileys...
Fatal error: Call to undefined function: copy_dir() in /home/desti10/public_html/Forum/convert.php(656) : eval()'d code on line 13

I'm still stumped...

[Oldiesmann]

copy_dir is defined in the phpbb2_to_smf.sql file, so I'm not sure why you're getting that error...

[kRisTen26]

Is there anything I can do to fix it?  I have not altered the uploaded files in any way.  I've also tried going from my phpBB board to the 1.0.8 version and just a 500 error when I delete the 1.1 and upload the 1.0.8 files.  The 1.1 board runs, but will not convert.

[Oldiesmann]

Try moving the "function copy_dir" block from phpbb2_to_smf.sql to convert.php - that might make the converter think it's defined (especially if you put the function declaration at the beginning of the file).

[Burke]

I am trying to convert from phpBB2 Plus 1.53a to SMF 1.1 RC3 using these converters:

phpbb2_to_smf_2006_09_02.zip
phpbb2_to_smf_2006_09_21.zip
phpbb2_to_smf_2006_09_21-utf8.zip
smf_1-1-rc3_phpbb2_converter.zip

I know that the converters are supposed to convert only clean phpBB2 boards, but the Plus version is based on phpBB2 and should work I guess. I would appreciate any help. Thanks.

The error message:

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_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
SUBSTRING(u.user_aim AS 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 memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM `database1`.phpbb_users AS u
LEFT JOIN `database1`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `database2`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the 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 'AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privms

[Ferny]

This error should be fixed in: phpbb2_to_smf_2006_09_02.zip phpbb2_to_smf_2006_09_21.zip and phpbb2_to_smf_2006_09_21-utf8.zip

Delete current convert.php and phpbb2_to_smf.sql, unzip phpbb2_to_smf_2006_09_21.zip and use the files from them (it's the latest update).

[kRisTen26]

At the risk of sounding dumb, you only need to use one converter, right?  I've been trying to use the    phpbb2_to_smf_2006_09_21-utf8.zip version and have not been successful.  I'm still coming up with "Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys...
Fatal error: Call to undefined function: copy_dir() in /home/desti10/public_html/smf/convert.php(656) : eval()'d code on line 13"

Do I need to use another converter as well? 

[Burke]

Thanks, I did that. I tried all the convertion scripts. Using the latest update, this happens:

I still get errorr. It shows that error occurs with images, and with smileys. It is impossbile for me to get the log, as everything flows fast accros the screen, and then finally shows as the convertion was successful. While the Convert.php is running, it shows a lot of errors regarding at least images and smileys, but at the end it says that the convertion was successful. This is kind of a contradict I think. Can anyone tell me why I get this error, and perhpas tell me if the convertion was indeed succesful or not as the convert.php ends up reporting. Thanks.

[Ferny]

Thanks, I did that. I tried all the convertion scripts. Using the latest update, this happens:

I still get errorr. It shows that error occurs with images, and with smileys. It is impossbile for me to get the log, as everything flows fast accros the screen, and then finally shows as the convertion was successful. While the Convert.php is running, it shows a lot of errors regarding at least images and smileys, but at the end it says that the convertion was successful. This is kind of a contradict I think. Can anyone tell me why I get this error, and perhpas tell me if the convertion was indeed succesful or not as the convert.php ends up reporting. Thanks.

I think those errors occur because the script can't copy files from one directory to other (an example, if your directory doesn't have writing permission). You can copy them by hand

[Oldiesmann]

Ok... Try these files. I moved the copy_dir function from phpbb2_to_smf.sql to convert.php.

[Resourcez]

The issue is probably that the file permissions in the 'copy to' directory are incorrect e.g. they may be 755 instead of 644.

[Burke]

Thanks for the suggestions. I now get these 3 errors:

Converting attachment mod (if installed)... Incomplete

Copying smileys
Warning: copy(/hsphere/local/home/xxx/domain.tld/smf/Smileys/default/icon_arrow.gif): failed to open stream: Permission denied in /hsphere/local/home/xxx/domain.tld/smf/convert.php(653) : eval()'d code on line 16

Copying Avatars (including the images in the /avatars/gallery folder of phpBB2)
Warning: copy(/hsphere/local/home/xxx/domain.tld/smf/avatars/gallery/World_of_Warcraft/004.gif): failed to open stream: No such file or directory in /hsphere/local/home/xxx/domain.tld/smf/convert.php(653) : eval()'d code on line 16

What might be wrong? I checked the CHMOD, the avatars folder etc. are all 777 so should not be because of the permissions. And actually ALL files (attachments and avatars) are copied to the /smf/attachments folder. I thought that avartars images should be copied to the /smf/avatars images folder? Anyway, despite the copying of files, I still get the above errors. Thanks.

[jacky]

hi, im french and i have a error with the script.

Code Select Expand

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    p.post_id AS ID_MSG, p.topic_id AS ID_TOPIC, p.post_time AS posterTime,
    p.poster_id AS ID_MEMBER,
    SUBSTRING(IFNULL(u.user_email, ''), 1, 255) AS posterEmail,
    SUBSTRING(IF(IFNULL(pt.post_subject, '') = '', t.topic_title, pt.post_subject), 1, 255) AS subject,
    SUBSTRING(IF(IFNULL(p.post_username, '') = '', u.username, p.post_username), 1, 255) AS posterName,
    p.enable_smilies AS smileysEnabled, IF(p.post_edit_time > 0, p.post_edit_time, 0) AS modifiedTime,
    CONCAT_WS('.', CONV(SUBSTRING(p.poster_ip, 1, 2), 16, 10), CONV(SUBSTRING(p.poster_ip, 3, 2), 16, 10), CONV(SUBSTRING(p.poster_ip, 5, 2), 16, 10), CONV(SUBSTRING(p.poster_ip, 7, 2), 16, 10)) AS posterIP,
    SUBSTRING(REPLACE(REPLACE(IF(pt.bbcode_uid = '', pt.post_text, REPLACE(REPLACE(REPLACE(pt.post_text, CONCAT(':u:', pt.bbcode_uid), ''), CONCAT(':1:', pt.bbcode_uid), ''), CONCAT(':', pt.bbcode_uid), '')), '\n', '<br />'), '"', '"'), 1, 65534) AS body,
    p.forum_id AS ID_BOARD, '' AS modifiedName, 'xx' AS icon
    FROM (`forum`.phpbb_posts AS p, `forum`.phpbb_posts_text AS pt, `forum`.phpbb_topics AS t)
    LEFT JOIN `forum`.phpbb_users AS u ON (u.user_id = p.poster_id)
    WHERE pt.post_id = p.post_id
    AND t.topic_id = p.topic_id
    LIMIT 0, 200;

Caused the error:

    Champ 'pt.post_subject' inconnu dans field list

What is the problem?
I already used other corrected scripts
thanks

[Oldiesmann]

It's saying that the post_subject column doesn't exist in the phpbb_posts_text table. Try this SQL file (upload it to your forum directory, overwriting the existing one).