Import for Infusions

[tonezzz]

Hi,

My old forum system is "Infusions". Does anybody every heard about it? Any possibility to import it? I tried searching on Yahoo but didn't find any useful info. Please help.

Thanks,
Tony.

[feldon23]

I do a Google search for "Infusions forum" and find nothing. Are you sure that is the forum software you are using? Perhaps a link to your forum so we can investigate?

[tonezzz]

I already have 2 contenders, anybody else?
Check the current forum on my (company)'s website here http://www.star-board.com

[feldon23]

After digging and comparing, I am fairly certain that the entire Star-Board.com website is built in PHP-Fusion (http://php-fusion.co.uk/forum/index.php), a Content Management System. Even though all the "branding" and copyrights have been stripped out, I still see direct comparisons. For example the Login box looks IDENTICAL with the exact same spacing for Username, Password, and the Login button. The spacing and layout of the forum looks identical to me.

According to the vBulletin User Manual, in the ImpEx section (http://www.vbulletin.com/docs/html/impex_module_dump), importing the forum data from PHP Fusion is supported. Of course it will be up to you to either try to integrate vBulletin with the rest of the website, or completely rebuild the website in another CMS package and link it with vBulletin. I suppose you could install vBulletin in a separate folder and just link to and from it. Note that it is not a built-in feature of vBulletin to link or integrate with any other script, so this will be up to you to research.

[tonezzz]

Thanks Feldon23, you're correct. All the copyrights and branding things were removed by the implementer we hired last year (perhaps that caused us a lot of bugs for a year, that's why we need to change). Due to my limited knowledge on open source things I didn't realize that until now.

After I know its real name I has downloaded the ImpEx module from VB then config and runt it but it failed to start. Here's the error message:


ImpEx Database errormysql error: Invalid SQL:
INSERT INTO vb_usergroup
(
importusergroupid, title, description,
usertitle, passwordexpires, passwordhistory,
pmquota, pmsendmax,
opentag, closetag, canoverride,
ispublicgroup, forumpermissions, pmpermissions,
calendarpermissions, wolpermissions, adminpermissions,
genericpermissions, genericoptions, attachlimit,
avatarmaxwidth, avatarmaxheight, avatarmaxsize,
profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize,
signaturepermissions, sigpicmaxwidth, sigpicmaxheight,
sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars,
sigmaxrawchars, sigmaxlines
)
VALUES
(
'69',
'Imported Users',
'Usergroup description',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
mysql error number: 1366
Date: Thursday 09th 2007f August 2007 09:10:40 PM
Database: sbvb2
MySQL error:

[feldon23]

Pretty much out of my league as far as knowledge. Are you running MySQL 5 with STRICT mode enabled?

[Jerry]

Set this in ImpExConfig.php :



define('forcesqlmode', true);