[SMF Converter] phpBB - 2.0.19+

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

Previous topic - Next topic

Yorkel

Hello!
Got a problem with conversion:

Quote
Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting avatar gallery images... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1252143697),
    ("conversion_from", "phpbb2_to_smf.sql");

Caused the error:

    Something is wrong in your syntax obok '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1252143697)' w linii 1


It would be realy great if someone could help me out here.
Im a new user of smf...

ThorstenE

You can ignore this error (minor bug in convert.php)... the conversion has already finished:
QuoteRecalculating forum statistics... Successful.

tsteele

I see the same when converting from phpbb2 to smf1.10 as well.  Good to know it's minor.  I didn't see this before in 1.1.8

Norv

I doubt it was related to SMF versions, rather to converter versions. :)
There may be a new feature added in the converter that is still in the works.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sprockette

how can i convert a mod in PHPBB2 to SMF?

Norv

As said in your other thread, there is no converter for code.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Logicbloke

Will this converter work for phpBB 1.4.4 ? Thanks

Norv

I have no idea if it was ever tested, and I have doubts it would work. It is an extremely old one, and a major version, too... if you're sure you wrote the right version! :)

You can always try, make a backup of your phpbb database and give it a shot. Normally nothing wrong should happen to your database, the converter only tries to read from it, and if it results in an error, then it simply stops. (but make a backup in any case).
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Oldiesmann

Your best bet would be to follow these instructions to upgrade to a newer version of phpBB first. You can then convert to SMF from there.
Michael Eshom
Christian Metal Fans

MariusMax

Hi,

Im trying to convert our phpbb 2.0.23 forum to SMF 2.0 RC3 but im getting the following error

Converting...
Converting members...
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

I have tried searching the forums, but without any luck. Any clue?

-Marius

Adrien

I'm experiencing the same problem as MariusMax. It seems that it has been solved for other converters, but I couldn't find out what was the fix...

I have another question, is there a way to speed up things ? I took a look in the source code and I figured out that convert['block_size'] was never defined and a value of 500 or 200 was used instead, should I define convert['block_size'] at the beginning of the file to, let's say, 2000 ? (I work in local)

Thanks in advance for your help !

ThorstenE

This error isn't related to the block size, the error is related to an empty value (id_member_updated).. the SMF 2 insert function doesn't accept empty values for database fields.

A possible solution: convert your phpBB3 to SMF 1.1.x, then ugrade your board to SMF 2.0 RC3.

greddy


Hello,

i have a modded phpbb2 Forum with php-Nuke as portal ... the database-settings are right and when i start the converter this shows:

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 member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, IFNULL(mg.id_group, 0)) AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
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 website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_viewemail = 1, 0, 1) AS hide_email, 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 message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
'' AS member_ip, '' AS member_ip2
FROM `z32`.nuke_users AS u
LEFT JOIN `z32`.nuke_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `z32club`.smf_membergroups AS mg ON (mg.group_name = 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_id' in 'field list'


what can i do ?

cheers

Norv

That's an odd error... What version of phpbb2/php_nuke do you have? If it's very outdated, by any chance, would it be possible to update it? Or, on the contrary is it new?

Alternatively, could you please login in phpMyAdmin, select your phpbb2 database (z32), and the table nuke_users, and go to the Export tab, exporting the table into a file, structure only (please see the checkboxes: only structure should be checked, data should not be checked, the rest can remain as whatever defaults you may have), and attach here that file.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

greddy


Hello,

yes, very old, i don't know which version the phpbb and nuke are. Over 6 years i have not changed anything :)

hier the structur ...  hope this helps.

-- Server Version: 5.0.67
-- PHP-Version: 5.2.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `z32`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nuke_users`
--

CREATE TABLE IF NOT EXISTS `nuke_users` (
  `uid` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `uname` varchar(25) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `femail` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `user_avatar` text,
  `user_regdate` varchar(20) NOT NULL default '',
  `user_icq` varchar(15) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_from_flag` varchar(25) default NULL,
  `user_intrest` varchar(150) default NULL,
  `user_sig` varchar(255) default NULL,
  `user_viewemail` tinyint(2) default NULL,
  `user_theme` int(3) default NULL,
  `user_aim` varchar(18) default NULL,
  `user_yim` text,
  `user_msnm` varchar(25) default NULL,
  `pass` varchar(40) default NULL,
  `storynum` tinyint(4) NOT NULL default '10',
  `umode` varchar(10) NOT NULL default '',
  `uorder` tinyint(1) NOT NULL default '0',
  `thold` tinyint(1) NOT NULL default '0',
  `noscore` tinyint(1) NOT NULL default '0',
  `bio` tinytext NOT NULL,
  `ublockon` tinyint(1) NOT NULL default '0',
  `ublock` tinytext NOT NULL,
  `theme` varchar(255) NOT NULL default '',
  `commentmax` int(11) NOT NULL default '4096',
  `counter` int(11) NOT NULL default '0',
  `newsletter` int(1) NOT NULL default '0',
  `user_posts` int(10) NOT NULL default '0',
  `user_attachsig` int(2) NOT NULL default '0',
  `user_rank` int(10) NOT NULL default '0',
  `user_level` int(10) NOT NULL default '1',
  `user_active` tinyint(1) default '1',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_timezone` tinyint(4) NOT NULL default '10',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) NOT NULL default 'english',
  `user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '1',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_avatar_type` tinyint(4) NOT NULL default '3',
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  `user_group_cp` int(11) NOT NULL default '2',
  `user_active_cp` enum('YES','NO') NOT NULL default 'YES',
  `user_lastvisit_cp` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_regdate_cp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`uid`),
  KEY `user_session_time` (`user_session_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7733 ;


greddy


greddy


LaurentGom

Hi

I'm experiencing the same problem as MariusMax and Adrien while trying to convert my phpBB 2.0.22 to SMF2.0 RC5:

QuoteConverting...
Converting members...
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

The weird thing is that it works perfectly on my local installation of the website, with exactly the same configuration (but a much smaller database).

Any chance to fix this by hacking into the conversion script? Or is the only solution to install SMF 1.1, convert and then upgrade to 2.0?

IchBin™

Quote from: LaurentGom on April 20, 2011, 02:08:58 AM
Hi

I'm experiencing the same problem as MariusMax and Adrien while trying to convert my phpBB 2.0.22 to SMF2.0 RC5:

QuoteConverting...
Converting members...
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

Any chance to fix this by hacking into the conversion script? Or is the only solution to install SMF 1.1, convert and then upgrade to 2.0?

That is the way I would do it. I don't know much about the conversion process, but I do know about upgrading SMF. Its a very easy process and would be worth the bit of extra work to get there.
IchBin™        TinyPortal

Dchidell

I have kinda same error... Don't know how to fix it to be honest

Converting members...
Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, IFNULL(mg.id_group, 0)) AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
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 website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_viewemail = 1, 0, 1) AS hide_email, 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 message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
'' AS member_ip, '' AS member_ip2
FROM `staragwa_staragwardia`.phpbb_users AS u
LEFT JOIN `staragwa_staragwardia`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `staragwa_smf`.smf_membergroups AS mg ON (mg.group_name = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='


Any ideas if it is possible to fix it?

Advertisement: