PHPBB2 - problem with MySQL

[stockkarts]

but when I try it again I get the same message I got in the other posts...
it acts like it's bringing across the posts and threads, but doesn't link them up so leaves them...

is it worth looking at uninstalling all our mods etc?

[J. Williams]

A mod of phpBB which changes the structure like CH is likely needed to be removed

[stockkarts]

A mod of phpBB which changes the structure like CH is likely needed to be removed

daft question

"Changes the structure like CH"

?

[J. Williams]

Category Hierarchy, I do know some mods have an uninstall option; now I don't recommend this but if you have easy mod, revert to the backups of your first ever modification installed

[stockkarts]

um so things like attachment mod etc would do it then...  but do we just need to change the database don't we not the files....

[J. Williams]

Well actually no, your problem is a MYSQL related problem; did you make sure the SMF DB User can access your old phpbb's database?

[stockkarts]

how do you do that?

[stockkarts]

ok

I uninstall this database and then reinstalled the software (new forum) and than ran the convertor and it worked

thank you

[panacea]

I am converting from phpbb 2021 to smf 1.1 rc3
All iam concerned is about posts, so when i got error in converting the user i deleted all the users.

Then i got this error in converting posts


Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `smfpaper2`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD, modifiedName, icon)
VALUES ('2', '2', '1123433567', '2', '', 'Paper 1', '', '1', '0', '128.107.253.41', 'blah blah title
<br />
<br />
<br />1) What is a smith chart used for
<br />
<br />2) How is impedance matching done and why do we need it (basically can talk about ideal power supply needing a low internal resistance and high load to function properly. so one stage of transistor amplifier has to have low o/p resistance and high i/p resistance for next stage- do look up all basic electronics) ( also about sinking high currents without damage)
<br />
<br />3) Name all flipflops u know and working esp. master slave.
<br />
<br />4) C programming - program to find how many 1\'s are present in an integer variable using bitwise operators. something about dynamic allocation, static functions, macros
<br />
<br />5) c++ virtual functions
<br />
<br />6) what types of control r there
', '1', '', 'xx'),

[Person]

Ok, I'm back ... and I'm going to apply all modifications into my version of converters ...

[okbluejays]

Converting a forum  and getting the following when it unsuccessfully converts users. Its all greek to me


    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 `hockey_hhhockeyforum`.phpbb_users AS u
    LEFT JOIN `hockey_hhhockeyforum`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `hockey_hhhockeyforum`.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

[Ferny]

Use this: phpbb2_to_smf_2006_09_02.zip

[bebe]

Never mind, problems solved.
I got the status changed from "Awaiting Activation" to "Awaiting Approval" using the following query in MyPhpAdmin:-
UPDATE smf_members SET is_activated=REPLACE(is_activated, '0', '3')

Hi,

I used the above converter to convert phpBB 2.0.21 to SMF 1.1 RC3 without any problems. Thanks Ferny.

Now i have a small problem.

I have been using "enable account activation by Admin" (which should be the registration method of "Member Approval" in SMF) with my existing forum and i have a lot of members have not been activated (i managed to leave the records there without showing to others except the admin with a mod).
After converting to SMF, i discovered that those members not activated by Admin, which i reckon should be similar to the case of "members not yet approved by the admin" in SMF, are showing in "Awaiting Activation" list instead of "Awaiting Approval" list. (If the forum has been using "enable account activation by Users" in phoBB, which should be the same as registration method of "Members Activation" in SMF, then those who has not yet activated their account should be showing in "Awaiting Activation" list.)

May i know what can i do (changing of scripts?) to have those members' to be listed under "Awaiting Approval" instead of "Awaiting Activation" once the database being converted from phpBB to SMF?

Would love to have your help asap. Thanks.

[limpbrains]

I'm trying to convert phpbb 2.0.21 to SMF 1.1 RC3
when using usual converter a have this error

Code Select Expand


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 `forum`.phpbb_users AS u
    LEFT JOIN `forum`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `site`.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


when trying

hxxp:acentermedia.net/Person/SMF/phpbb2_to_smf_2006_08_26-3.zip [nonactive]
or
hxxp:person.acentermedia.net/SMF/phpbb2_to_smf_2006_08_26-3-utf8.zip [nonactive]

there is no errors but script ends unexpectly

Code Select Expand


Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys...

[limpbrains]

sorry, a little mistace.
I have tried

phpbb2_to_smf_2006_08_26-3.zip
and
phpbb2_to_smf_2006_09_02.zip

not
phpbb2_to_smf_2006_08_26-3.zip
and
phpbb2_to_smf_2006_08_26-3-utf8.zip

and phpbb2_to_smf_2006_09_02.zip gives the same error

[bebe]

Well, i just found out another problem even though i got no errors in the process of converting.

The Approved Member's count and list is correct, the Awaiting Approval's count and list is correct too. The problem lies with the "View All Members" list, it only shows 3 pages... why


I found out that the problem is not caused by the converter, hence, i'll continue in search of the solutions here.

[Person]

I have repacked version phpbb2_to_smf_2006_09_02.zip:

This is only difference between default and UTF8 version:

Code ("Default charset for MySQL") Select Expand

// Persist?
if (empty($db_persist))
mysql_connect($db_server, $db_user, $db_passwd);
else
mysql_pconnect($db_server, $db_user, $db_passwd);

Code ("UTF8 charset for MySQL") Select Expand

// Persist?
if (empty($db_persist))
mysql_connect($db_server, $db_user, $db_passwd);
else
mysql_pconnect($db_server, $db_user, $db_passwd);

// UTF8
mysql_query("SET NAMES UTF8");

New files:
phpbb2_to_smf_2006_09_21.zip
phpbb2_to_smf_2006_09_21-utf8.zip

And other old files:
smf.person-lab.net

By

[limpbrains]

To slove my problem with smileys

I've just deleted this section from phpbb2_to_smf.sql 

But now Im have the folowing error

Code Select Expand


Converting topics... Unsuccessful!
This query:

    INSERT INTO `site`.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 ('3', '0', '6', '6', '4', '4', '7', '0', '1', '0', '460'),
    ('4', '0', '15', '4212', '4', '4', '7', '0', '1', '2', '2770'),
    ('5', '0', '20', '20', '4', '4', '7', '0', '1', '0', '467'),
    ('6', '0', '21', '21', '4', '4', '2', '0', '1', '0', '539'),
    ('7', '0', '22', '1486', '6', '16', '6', '0', '0', '21', '1037'),
    ('8', '0', '23', '697', '6', '109', '5', '0', '0', '17', '956'),
    ('10', '0', '29', '29', '4', '4', '9', '0', '1', '0', '304'),
    ('11', '0', '32', '6598', '9', '166', '6', '0', '0', '31', '1559'),
    ('12', '0', '34', '34', '4', '4', '4', '0', '1', '0', '392'),
    ('13', '0', '38', '38', '2', '2', '2', '0', '1', '0', '3109'),
    ('14', '0', '43', '308', '8', '36', '3', '0', '0', '19', '892'),
    ('16', '0', '47', '49', '8', '8', '5', '0', '0', '2', '314'),
    ('17', '0', '64', '3668', '8', '93', '5', '0', '0', '41', '2599'),
    ('19', '0', '99', '99', '6', '6', '3', '0', '0', '0', '225'),
    ('20', '0', '101', '109', '6', '6', '3', '0', '0', '5', '343'),
    ('21', '0', '103', '105', '16', '2', '5', '0', '1', '1', '313'),
    ('22', '0', '108', '6091', '4', '93', '12', '0', '1', '9', '441'),
    ('23', '0', '110', '407', '6', '6', '8', '0', '0', '9', '66'),
    ('24', '0', '111', '111', '6', '6', '3', '0', '0', '0', '197'),
    ('25', '0', '113', '113', '6', '6', '3', '0', '0', '0', '201'),
    ('26', '0', '119', '349', '6', '7', '3', '0', '0', '4', '299'),
...
    ('564', '0', '4518', '4524', '166', '193', '3', '0', '0', '3', '100'),
    ('565', '0', '4522', '4598', '93', '166', '8', '0', '0', '5', '40'),
    ('566', '0', '4554', '4566', '166', '193', '3', '0', '0', '1', '78'),
    ('567', '0', '4556', '4561', '280', '105', '9', '0', '0', '2', '101'),
    ('568', '0', '4557', '4567', '280', '154', '3', '0', '0', '3', '107');

Code Select Expand

Caused the error:

    Duplicate entry '833-5' for key 3



[bebe]

Hi Person,
I used "phpbb2_to_smf_2006_09_21-utf8.zip" and successfully in converting phpBB 2.0.21 to SMF 1.1 RC3 (without any error or problems).

[Person]

Cool ... I have made this simple utf8 mod to convert phpBB2 forum which is in Slovenian language (special characters [ščćžđ ŠČĆŽĐ]).
The original version don't convert this characters.