toemik

Grateful for any advice on transferring my mambo 4.014 mambo minibb1.5 to my new site running 0.7 and simpleboard. I know that there is a conversion program to run but it requires that minibb is already installed with the table and so is simpleboard. Minibb wont go on 4.5 and simpleboard doesn't go with 4.014. I have tried exporting the minibb tables and running the script but it just coughs and splutters and fails.

Any advise on the conversion appreciated.

Thanks

Riba

toemik - I'm maintaining that script...what is the error?
There is no need to export the miniBB tables - when you upgrade your site to 4.5 you run the upgrade sql script which will upgrade your Mambo database from 4.0.14 to 4.5. The miniBB tables should be left intact in the new database. Then install SimpleBoard, and just run the miniBB to simpleboard upgrade script.
Let me know if you still have problems.

toemik

Thanks for the reply, the problem I have is that the conversion program fails because I do not satisfy it requirements mysql is at 4.018. I thought originally it was catch22 issue.

I have a site using mambo 4.0 and minibb 1.5, the upgrade is to build a new 4.5.07 base, move the minibb tables over then convert. Nothing going quite so easy as it could.

I have built a new linux server up which I can upgrade the mysql on, my next move is to transfer over the site to my test system, run the conversion then re-upload the tables (easy ?? yep should be when mysql wants to work on the local host and not complain about /var/lib.... and my.cnf issues but that is another story ).

Riba

It should work at least with mysql 4.0.14, that's the one I used to test the script. I'm also running Mambo 4.0.x and planning the upgrade just they way you do, what I did is to upload the old database, upgrade to 4.5 db, install simpleboard, and run the minibb to simpleboard script. I'm pretty much sure that minibb tables were left intact in the database after the 4.0>4.5 database upgrade.
Yell if you still have problems with the script.

toemik

Hi Riba,
Thanks for the reply. I completely emptied the simpleboard tables and re-downloaded the conversion program. The result was a little dramatic, the program seemed to hang and after about 10 minutes (time to get a coffee) I thought I better investigate. Logged into my shell and ran top - aghh 0.1% idle cpu, top process mysql at 90%+. killed of the process, but the conversion had been working, its just that it is a large board I am converting, so I shall setup a local server and mimic my ISP setup / mambo installation to complete the conversion and upload the new tables.

Riba

Yes, it can take a while for a large amount of data. I'm sure it will work out just fine, I often suggested people who have problems with the hosting DB to do the conversion locally and then just upload the tables.

toemik

Thanks for the info -and apologies for the delay in replying.

I trimmed down my database, and performed the conversion locally, repopulataed my dB and all is well.

Original dB = 16M now 4Mb

Heidi

Hi,

I'm having problems with this converter:

Currently I'm running a miniBB forum and like to convert to SMF. But while running the converter I receive an error message:

"
Notice: Undefined variable: dbUserSheme in /home/www/htdocs/<mydomain>/forum/setup_options.php on line 47
Converting members... Unsuccessful!
This query:

SELECT
user_id AS ID_MEMBER, SUBSTRING(username, 1, 80) AS memberName,
SUBSTRING(username, 1, 255) AS realName,
UNIX_TIMESTAMP(user_regdate) AS dateRegistered,
SUBSTRING(user_email, 1, 255) AS emailAddress,
UNIX_TIMESTAMP(user_regdate) AS lastLogin,
SUBSTRING(user_from, 1, 255) AS location,
SUBSTRING(user_password, 1, 64) AS passwd,
SUBSTRING(user_icq, 1, 255) AS ICQ,
SUBSTRING(user_website, 1, 255) AS websiteTitle,
SUBSTRING(user_website, 1, 255) AS websiteUrl,
IF(user_viewemail = 1, 0, 1) AS hideEmail, num_posts AS posts,
IF('admin' = username, 1, 0) AS ID_GROUP, '' AS lngfile,
'' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS AIM, '' AS YIM, '' AS MSN, '' AS timeFormat,
'' AS signature, '' AS avatar, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM `<databasename>`.minibb_users
LIMIT 0, 500;

Caused the error:

Unknown column 'num_posts' in 'field list'
"

and in setup_options.php line 47 is

$protectWholeForum=0;
$protectWholeForumPwd='pwd';
$userInfoInPosts=array($dbUserSheme['user_custom2'][1]); // <<<<< This is line 47

$postRange=60;



Does anybody here has an idea how I could solve this? I'd realy like to use SMF.

Thanks in advance
Heidi