looking for help converting newbb(in xoops) to smf please

[patchster]

hi ,iam using a XOOPS 2.0.9.2 based site and currently NewBB 2.0 version 2.02 as the foum
after installing the SMF 1.1.rc2 , and then using the 1.1 converter ..it didnt quite go so well , i got the members info  over but none of the topics/catagories/boards/posts etc etc
after having read throught the 25 pages of requests and replies , i came the the conclusion it would be easier for me (and maybe more successful ) if i installed the SMF 1.1.rc1 then converted it,then updgrade to SMF 1.1.rc2 but the only snag in this is i just cannot find the SMF 1.1.rc1 download 
has anyone got a link to it please  failing that  can anyone tell me what the answer to my problem is and save me a lot of messing about

EDIT: found the rc1 version installed it etc , identical result so its not that  so iam stumped

Code Select Expand

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
SELECT
forum_id AS ID_BOARD, cat_id AS ID_CAT, forum_name AS name,
forum_desc AS description, forum_topics AS numTopics,
IF(forum_access = 1, '0,2', IF(forum_access = 3, '', '0,-1,2')) AS memberGroups,
forum_posts AS numPosts
FROM `gamehacking`.xoops_bb_forums
LIMIT 0, 500;
Caused the error:

Unknown column 'forum_access' in 'field list'

any help towards the link or advice regards the unsuccessful part of the conversion would be great
many thanks
patch

[Oldiesmann]

It looks like the database structure for newbb has changed since that converter was written. Give me a few minutes to look at it and I'll see what I can do for you.

[patchster]

  it would be well cool  if you could fix it ..Here's hoping and fingers crossed

[Oldiesmann]

This is going to take me longer than expected due to the use of the group_permissions table in XOOPS. I haven't had enough time to figure out the difference between "global_forum_access" and "forum_can_view" in the permissions table (gperm_name), and I have a class at 2, so I will try to work on this later.

[patchster]

This is going to take me longer than expected due to the use of the group_permissions table in XOOPS. I haven't had enough time to figure out the difference between "global_forum_access" and "forum_can_view" in the permissions table (gperm_name), and I have a class at 2, so I will try to work on this later.

ok thanks for checking,
i look forward to the  fix
regards

[Oldiesmann]

Ok... Try this one.

[patchster]

hi again
thx for the file,but  i got the exact same reply

==========================================================

Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
SELECT
forum_id AS ID_BOARD, cat_id AS ID_CAT, forum_name AS name,
forum_desc AS description, forum_topics AS numTopics,
IF(forum_access = 1, '0,2', IF(forum_access = 3, '', '0,-1,2')) AS memberGroups,
forum_posts AS numPosts
FROM `gamehacking`.xoops_bb_forums
LIMIT 0, 500;
Caused the error:

Unknown column 'forum_access' in 'field list'

==========================================================

is there a newer convert.php too? or do u think thats fine?

[Oldiesmann]

Whoopsies! Forgot to remove that part... Sorry about that

Try this one

[patchster]

well,
we are getting somewhere , i didnt get the same error , but i got this error
===================================================================================
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting board access... Unsuccessful!
This query:
UPDATE `gamehacking`.smf1_boards SET memberGroups = WHERE ID_BOARD = '1';
Caused the 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 'WHERE ID_BOARD = '1'' at line 1
===================================================================================

the forum now says the board / catagory titles and how many posts etc , so we have move on a little

any idea what that error  means ?
many thanks

[patchster]

hi again,
just wondering if you have had any time to have another look at the above error at all?
sorry to repost , just i cant get it past that point

[Oldiesmann]

Sorry about that. Stupid mistake on my part.

[patchster]

Oldiesmann, i really appreciate the time u have taken to help me out here ,
Its got another error though  ..
========================================================
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting board access... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:
SELECT
p.post_id AS ID_MSG, p.topic_id AS ID_TOPIC, p.post [nofollow]_time AS posterTime,
p.uid AS ID_MEMBER, p.subject AS subject, u.email [nofollow] AS posterEmail,
IFNULL(u.name, 'Guest') AS posterName, p.poster_ip AS posterIP,
IF(p.nosmiley, 0, 1) AS smileysEnabled, p.forum [nofollow]_id AS ID_BOARD,
REPLACE(pt.post_text, '<br>', '<br />') AS body
FROM (`gamehacking`.xoops_bb_posts AS p, `gamehacking`.xoops_bb_posts_text AS pt)
LEFT JOIN `gamehacking`.xoops_users AS u ON (u.uid = p.uid)
WHERE pt.post [nofollow]_id = p.post [nofollow]_id
LIMIT 0, 200;
Caused the error:

Unknown column 'p.nosmiley' in 'field list'
========================================================

would you be so kind as to have another look at it for me ?

many thanks once again

[patchster]

hi again tis only me..[groan]
ok i had a look and i took out the 'p.nosmiley' from the sql (i can live without it not conerting the smileys ..soooo i got all the posts /users/topics across, cool huh
iam on the last leg now and have 1 more error ,


==============================
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting board access... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Clearing unused tables... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting moderators... Unsuccessful!
This query:
SELECT user_id AS ID_MEMBER, forum_id AS ID_BOARD
FROM `gamehacking`.xoops_bb_forum_mods
LIMIT 0, 500;
Caused the error:

Table 'gamehacking.xoops_bb_forum_mods' doesn't exist
==============================

any ideas?

[Oldiesmann]

Fixed both problems.

The "nosmiley" column is now called "dosmiley" and moderator info is stored in the "forum_moderator" column in the bb_forums table as a space-seperated list of member IDs.

[patchster]

i really respect your patience in dealing with this for me
but i have just 1 error
======================================
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting board access... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Clearing unused tables... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting moderators... Unsuccessful!
This query:
INSERT INTO `gamehacking`.smf_moderators VALUES (, '1');
Caused the 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 ' '1')' at line 1
=========================================

sorry about this

[Oldiesmann]

Sorry. Another typo.

[patchster]

hiya real sorry for the delay in replying

well i think we are almost there now
just this last error to fix and i think we will have sucess !
===============================================
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting board access... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Clearing unused tables... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting moderators... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `gamehacking`.smf_boards
SET ID_LAST_MSG = 708, lastUpdated = 1140346857
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'
=======================================

what do you think?

cheers

[modcase]

I wanted to thank you Oldiesmann as well for looking into this. You have gotten me a few more steps down the line. I will be watching the progress of the thread with hope.

[Oldiesmann]

I believe that's a bug with convert.php itself. At that point you're at the end of the conversion anyway. Login to your SMF board, go to Admin -> Forum Maintenance and click on "Recount all totals and statistics". That will update the statistics.

[ideiafacil]

Hello thanks for your work.. 

Any user have make a test with CBB ?