• Welcome to Simple Machines Community Forum. Please login or sign up.
November 30, 2021, 11:46:24 PM

News:

Follow SMF on Twitter.


[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

SleePy

Open convert.php

Find and remove:

convert_query("
ALTER TABLE {$to_prefix}smileys
ORDER BY LENGTH(code) DESC");
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

woofmang

i can't get past step 1 with this convertor script; the error message i'm getting is:

QuoteConverting members... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_members
    (ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
    VALUES ('885', 'username', 'username_again', 'user's_hashed_password', 'user_last_visit', 'user_reg_date', 'user_from', 'user_posts', '', '0', 'user_email@domain.com', '0', '', '', '', '', '', '', '1', '0', '1', '', 'user_sig', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
<snip>several hundred more members' info</snip>
Caused the error:

    Incorrect integer value: '' for column 'ID_GROUP' at row 1

the board i'm trying to convert from is phpbb 2.0.22, and has a fair number of mods; any suggestions?

thanks.

SleePy

Well that shouldn't be happening but it appears some reason that the converter can't find its group thus returning null

Find:
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,

Replace:
u.user_posts AS posts, IF(u.user_level = 1, 1, if(NULL, 0, mg.ID_GROUP)) AS ID_GROUP,

That should fix it hopefully.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

woofmang

thanks, SleePy!

your fix didn't work as posted, but it pointed me in the right direction; since i'm the only admin or moderator on the board i'm trying to convert, i just changed that line to:

u.user_posts AS posts, IF(u.user_level = 1, 1, 0) AS ID_GROUP,

and the rest worked fine until i ran into the same error as mainedan a couple of posts above; i removed the convert_query() call you mentioned, and the rest of it went smooth as silk.

i appreciate the help; my board isn't that big, but with ~700 members and ~90,000 posts, i wouldn't have even tried to convert it manually.

thanks again! :)

JayBachatero

Quote from: SleePy on July 31, 2007, 11:56:14 PM
Open convert.php

Find and remove:

convert_query("
ALTER TABLE {$to_prefix}smileys
ORDER BY LENGTH(code) DESC");


That is not a fix.  That's there for a reason.

To fix the issue just change ORDER BY LENGTH(code) DESC to ORDER BY code DESC
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

SleePy

Thanks for the info Jay, I will remember next time to just remove length() from the query.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

thydarkgift

August 07, 2007, 02:46:05 PM #246 Last Edit: August 07, 2007, 08:58:37 PM by thydarkgift
I'm trying to convert my phpbb 2.0.19 from one site, to SMF which I've just created on another site.  What files do I need to move over to the new site?  I've uploaded the backup of my old phpbb (phpbb_db_backup.sql) as well as the convert.php and phpbb2_to_smf.sql and I get an error when I run the convert.php saying "Unable to find the settings for phpBB2. Please double check the path and try again."

I then copied all my phpBB files to a phpBB directory on my new domain/server and when I try to run the convert.php I get the following error, "Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'qwbjauvy_smf1'@'localhost' for table 'phpbb_users'"

What can I be doing wrong.  First time at this, so if someone can give a somewhat detailed explanation, it would be greatly appreciated.

Shawn

SleePy

Did you import the database backup into the database?

The error you gave you should ask your host. This error comes from the mysql user you are using not having access to the other database.
They can point you in the right direction to get this fixed so your mysql user can access both databases.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

TheCoolGamer

August 09, 2007, 11:21:02 AM #249 Last Edit: August 09, 2007, 11:22:49 AM by TheCoolGamer
I think I found a bug in the converter. [size bbcode in the signature isn't properly converted.
This in the converter:
Line 147

$row['signature'] = preg_replace('~\[size=([789]|[012]\d)\]~i', '[size=$1px]', $row['signature']);
if ($row['signature_uid'] != '')
$row['signature'] = preg_replace('~(:u:|:1:|:)' . preg_quote($row['signature_uid'], '~') . '~i', '', $row['signature']);

But it should be:
if ($row['signature_uid'] != '')
$row['signature'] = preg_replace('~(:u:|:1:|:)' . preg_quote($row['signature_uid'], '~') . '~i', '', $row['signature']);
$row['signature'] = preg_replace('~\[size=([789]|[012]\d)\]~i', '[size=$1px]', $row['signature']);


SleePy

Thanks for letting us know,
I have added it to the bug tracker so it can be fixed when Jay has time to fix the converter.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

LittleDude-

August 17, 2007, 03:35:36 PM #251 Last Edit: August 17, 2007, 03:44:31 PM by LittleDude-
hi i dont get how i convert it from phpbb to smf can anyone help me ive got converter.php and phpbb2_to_smf but i dont get what im doing any help would be nice LittleDude-

LittleDude-

August 17, 2007, 03:59:57 PM #252 Last Edit: August 17, 2007, 04:02:42 PM by LittleDude-
do the smf files and ure phpbb forum afto be in the same folder or install them sperate?

do you put the convert in smf or phpbb setup?

SleePy

the convert files go in the SMF folder.
The SMF and phpbb files can be in different folders.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

LittleDude-


LittleDude-

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user '*********@smf1'@'localhost' for table 'phpbb_users'

whys it not letting me?

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

Quote from: TheCoolGamer on August 09, 2007, 11:21:02 AM
I think I found a bug in the converter. [size bbcode in the signature isn't properly converted.
This in the converter:
Line 147

$row['signature'] = preg_replace('~\[size=([789]|[012]\d)\]~i', '[size=$1px]', $row['signature']);
if ($row['signature_uid'] != '')
$row['signature'] = preg_replace('~(:u:|:1:|:)' . preg_quote($row['signature_uid'], '~') . '~i', '', $row['signature']);

But it should be:
if ($row['signature_uid'] != '')
$row['signature'] = preg_replace('~(:u:|:1:|:)' . preg_quote($row['signature_uid'], '~') . '~i', '', $row['signature']);
$row['signature'] = preg_replace('~\[size=([789]|[012]\d)\]~i', '[size=$1px]', $row['signature']);


Fixed.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

adambrown

I run the converter, and i receive this problem : The error MySQL gave was: SELECT command denied to user 'smf_jos'@'10.1.21.4' for table 'phpbb_users' any ideas?

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: