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:
QuoteParse 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 :)
Quote from: TaX on September 09, 2008, 04:42:16 AMQuoteParse 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.
And the same thing in here as well. But I have phpbb 3.
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)
Quote from: TE on September 09, 2008, 11:16:32 AM
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 :o --> convert.php gives now this message :
QuoteConverting 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, 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 ...
looks like the updated version contains some parts only working for "modded" phpBB-Versions.. :o
edit the phpbb2_to_smf.sql
find
, u.user_registered_ip AS memberIP, u.user_registered_ip AS memberIP2
and remove this
Quote from: TE on September 09, 2008, 12:10:16 PM
looks like the updated version contains some parts only working for "modded" phpBB-Versions.. :o
edit the phpbb2_to_smf.sql
find
, u.user_registered_ip AS memberIP, u.user_registered_ip AS memberIP2
and remove this
Jes ! Yippe :D
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.
the size of the postbox can modified by editting the Sources/Subs-Post.php
find:
// 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..
That line should be fixed with using:
IFNULL(u.user_registered_ip, '') AS memberIP, IFNULL(u.user_registered_ip, '') AS memberIP2
as well
Quote from: TE on September 09, 2008, 01:20:37 PM
the size of the postbox can modified by editting the Sources/Subs-Post.php
Thanks again - now system seems to be ready ;D
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
Try the attached file.
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'
QuoteSELECT
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, 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
Try the following file then.
Thanks every thing went smooth until this point:
Recalculating forum statistics... Unsuccessful!
QuoteThis 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
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.
I dont know which TOPIC ID I deleted few which had no start and end message id. The error still exists.
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).
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.
Tell me, in phpbb. Are these moved topics that we are dealing with?
hmmm moved these topics from phpbb to smf, hence I removed them from smf topics table, not phpbb, do I have to remove them from phpbb?
Well it would be almost the same way but using the phpbb topics table.
I was referring to if they where a topic that linked to another topic because that topic was moved.
I'm not sure if they were moved, I'm only converting the forum, I'm not an admin/mod/owner of the site.
Is there anything else that needs to be converted after topics?
A few things such as posts and polls I believe.
We can try this. It may or may not work.
Open the phpbb2_to_smf.sql
Find:
/* // !!! WHERE t.topic_moved_id = 0 */
Replace:
WHERE t.topic_moved_id = 0
I wonder if that will prevent moved topic notices from being converted.
hmmm no it did not work...
Am I able to have a copy of the phpbb database to see what is going on here?