News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Convert bbPress 1.0.2 to SMF 1.1.11?

Started by cabezon, March 10, 2010, 05:10:25 PM

Previous topic - Next topic

Norv

In fact, the converters are usually written such that it should work, no matter from where, even outside both.

But there can be cases (bugs perhaps) when it can lead to surprises, therefore when it doesn't seem to find something, it's better to be sure.

In any case, could you please eventually try with the attached file...? (for SMF 1.1.11)
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

Tomcraft

Thx! Which converter.php should I use?

Norv

The one above in this topic should work just fine. That one changes rarely. :)
However I attach it just in 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

Tomcraft

Excellent, THX!

I'lll give it a try this weekend!

Tomcraft

Sorry for the delay, the new skript worked excellent for bbPress 1.02!

Is there a way to also import the attachments from "bb-attachments" plugin and the PMs from "bbpm" plugin?

Best regards

Tom

Tomcraft

Is it possible to upgrade the script for SMF 2.0 RC4?

Best regards

Tom

ThorstenE

there should be a 2.0RC4 version on the downloads page (I personally never tested these files)..
btw, is your other issue (attachments, pms) solved?

Tomcraft

lol... sorry... you're right, found the new converter for 2.0 RC4. I should have looked there before, sorry.

We wrote a converter for the attachments which works great. After the migration we will release this to the SMF community.

PM migration is still in progress, but we already mentioned to simply drop them. :-P

Best regards

Tom

Tomcraft

I have the same problems with the 2.0RC4 conversion script like in this thread:
Unable to find the settings for bbPress 0.6.3. Please double check the path and try again.
I think this needs to be fixed again. ;-)

The conversion script to SMF 1.x works great!

Best regards

Tom

ThorstenE

huh, would you please try the attached version? please delete the old bbpress_to_smf.sql before..


Tomcraft

Great, no it starts the conversion but stops at:
Converting posts...
Successful.
Recalculating forum statistics... Duplicate key name 'ip_index'

Any ideas?

Best regards

Tom


Tomcraft

Thx! I'll try this later. Why don't you update the converter package in downloads-section when you fixed a bug? *g*

Why are topic-views not converted?

Best regards

Tom

ThorstenE

Quote from: Tomcraft on December 19, 2010, 01:41:07 PM
Thx! I'll try this later. Why don't you update the converter package in downloads-section when you fixed a bug? *g*
Don't know why the files haven't been fixed yet, that's no longer my business ..
can you please check the bbpress database (table topics)? What is the name of the related column for the topic views?

Tomcraft

#34
Views are stored in bb_meta like:
INSERT INTO `bb_meta` (`meta_id`, `object_type`, `object_id`, `meta_key`, `meta_value`) VALUES(109432, 'bb_topic', 495, 'views', '2');
where object_id is the topic_id.

P.S.: The fix work great!

Best regards

Tom

ThorstenE

ok, would you please test?
find in bbpress1.0_to_smf.sql:
/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics 20
SELECT
t.topic_id AS id_topic, t.topic_sticky AS is_sticky, t.forum_id AS id_board,
IFNULL(MIN(p.post_id), 0) AS id_first_msg, IFNULL(MAX(p.post_id), 0) AS id_last_msg,
t.topic_poster AS id_member_started, t.topic_last_poster AS id_member_updated,
t.topic_posts AS num_replies, CASE t.topic_open WHEN 1 THEN 0 ELSE 1 END AS locked
FROM {$from_prefix}topics AS t
LEFT JOIN {$from_prefix}posts AS p ON (p.topic_id = t.topic_id)
GROUP BY p.topic_id;
---*


replace it with:

/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics 20
SELECT
t.topic_id AS id_topic, t.topic_sticky AS is_sticky, t.forum_id AS id_board,
IFNULL(MIN(p.post_id), 0) AS id_first_msg, IFNULL(MAX(p.post_id), 0) AS id_last_msg,
t.topic_poster AS id_member_started, t.topic_last_poster AS id_member_updated,
meta.views AS num_views,
t.topic_posts AS num_replies, CASE t.topic_open WHEN 1 THEN 0 ELSE 1 END AS locked
FROM {$from_prefix}topics AS t
LEFT JOIN {$from_prefix}posts AS p ON (p.topic_id = t.topic_id)
INNER JOIN {$from_prefix}meta AS meta ON (t.topic_id = meta.object_id)
GROUP BY p.topic_id;
---*

Tomcraft

Thx for your help! I get this error:
Unknown column 'meta.views' in 'field list'
I think it needs to be:
/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics 20
SELECT
   t.topic_id AS id_topic, t.topic_sticky AS is_sticky, t.forum_id AS id_board,
   IFNULL(MIN(p.post_id), 0) AS id_first_msg, IFNULL(MAX(p.post_id), 0) AS id_last_msg,
   t.topic_poster AS id_member_started, t.topic_last_poster AS id_member_updated,
   meta.meta_value AS num_views,
   t.topic_posts AS num_replies, CASE t.topic_open WHEN 1 THEN 0 ELSE 1 END AS locked
FROM {$from_prefix}topics AS t
   LEFT JOIN {$from_prefix}posts AS p ON (p.topic_id = t.topic_id)
   INNER JOIN {$from_prefix}meta AS meta ON (t.topic_id = meta.object_id)
GROUP BY p.topic_id;
---*

But then I get this:
Wrong value type sent to the database. Integer expected. (num_views)
Best regards

Tom

saurabhstar

Is there any converter for bbpress to smf ? I have a simple bbpress forum and I would love to convert into smf..

Tomcraft

hmmm? Could you please mind the topic and start reading the posts? *g*

-> http://download.simplemachines.org/?converters;software=bbpress

Best regards

Tom

ThorstenE

Tomcraft,
please try the attached version ..

Advertisement: