Advertisement:

Author Topic: [SMF Converter] phpBB - 2.0.19+  (Read 509168 times)

Offline Yorkel

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #640 on: September 05, 2009, 05:52:38 AM »
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

  • Guest
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #641 on: September 05, 2009, 07:27:40 AM »
You can ignore this error (minor bug in convert.php)... the conversion has already finished:
Quote
Recalculating forum statistics... Successful.

Offline tsteele

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #642 on: September 11, 2009, 12:22:23 AM »
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

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #643 on: September 11, 2009, 11:27:45 AM »
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

Offline Sprockette

  • Semi-Newbie
  • *
  • Posts: 44
    • Fsuon Project
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #644 on: October 04, 2009, 11:22:48 AM »
how can i convert a mod in PHPBB2 to SMF?

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #645 on: October 04, 2009, 12:53:17 PM »
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

Offline Logicbloke

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #646 on: March 01, 2010, 01:51:39 PM »
Will this converter work for phpBB 1.4.4 ? Thanks

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #647 on: March 01, 2010, 07:07:51 PM »
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

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,868
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • https://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #648 on: March 03, 2010, 03:27:03 PM »
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
Cincy Space - now open!

Offline MariusMax

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #649 on: April 20, 2010, 04:43:58 AM »
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

Offline Adrien

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #650 on: April 23, 2010, 03:18:23 PM »
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

  • Guest
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #651 on: April 24, 2010, 03:09:19 AM »
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.

Offline greddy

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #652 on: May 13, 2010, 07:50:49 AM »

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

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #653 on: May 13, 2010, 08:27:49 AM »
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

Offline greddy

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #654 on: May 13, 2010, 11:54:13 AM »

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 ;


Offline greddy

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #655 on: May 17, 2010, 05:41:00 PM »

no chance ?

bye, Peter

Offline greddy

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #656 on: August 03, 2010, 06:25:35 PM »
no help for my problem ?

Peter

Offline LaurentGom

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #657 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:

Quote
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)

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?

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,115
  • Gender: Male
  • I don't speak German.
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #658 on: May 05, 2011, 11:41:55 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:

Quote
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)

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
Coding Guidelines       

Offline Dchidell

  • Semi-Newbie
  • *
  • Posts: 27
  • SMF 2.0
Re: [SMF Converter] phpBB - 2.0.19+
« Reply #659 on: July 02, 2011, 12:33:18 PM »
I have kinda same error... Don't know how to fix it to be honest

Code: [Select]
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?