Bridge Wizard fails bridging with SMF

[JimK]

When I used the bridging wizard, I get the following error message after I select "Finsh".

"There was an error while processing a database query"

Set up was easy for SMF bridging, so I don't know what could have went wrong.  Do CPG and SMF have to be in the same mySQL database?  I setup two separate databases for them and I didn't see anything in the documentation specifying that they must be the same db.

Any help would be appreciated.

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=24032.0

[JimK]

I have the following issue when trying to bridge coppermine and SMF:

When I used the bridging wizard, I get the following error message after I select "Finsh".

"There was an error while processing a database query"

Set up was easy for SMF bridging, so I don't know what could have went wrong.  Do CPG and SMF have to be in the same mySQL database?  I setup two separate databases for them and I didn't see anything in the documentation specifying that they must be the same db.

Any help would be appreciated.

Note:  forum and gallery are .htaccess protected.  Use same username and password below.

Coppermine install: http://www.coznect.com/genealogy/cpg140/
Forum install: http://www.coznect.com/genealogy/forum/
Coppermine version: cpg1.4.9
Forum version: SMF 1.0.8
Test user account: guest / edwin1868

BridgeManager settings:
Forum URL:  http://www.coznect.com/genealogy/forum
Relative path to your BBS's config file:  ../forum/
Use post-based groups?:  0

[Nibbler]

Enable debug mode and attempt the bridge again. Post the mysql error message you get (not the entire debug output).

[JimK]

mySQL error: Table 'mktrisk2_smf.cpg149_usergroups' doesn't exist

[Nibbler]

OK, see http://forum.coppermine-gallery.net/index.php?topic=24842.msg114300#msg114300

[JimK]

Thanks Nibbler!  Everything now works great!