MySQl table errors on SMF integration

[pbdoggie]

I am trying to bridge/integrate SMF 1.0.5 and CPG 1.3.5 and followed the tutorial.  However I get the following errors when installing CPG:

Code Select Expand

The following errors were encountered and need to be corrected first:

mySQL Error: Table 'smf_categories' already existson query ' CREATE TABLE smf_categories ( cid int(11) NOT NULL auto_increment, owner_id int(11) NOT NULL default '0', name varchar(255) NOT NULL default '', description text NOT NULL, pos int(11) NOT NULL default '0', parent int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', subcat_count int(11) NOT NULL default '0', alb_count int(11) NOT NULL default '0', pic_count int(11) NOT NULL default '0', stat_uptodate enum('YES','NO') NOT NULL default 'NO', PRIMARY KEY (cid), KEY cat_parent (parent), KEY cat_pos (pos), KEY cat_owner_id (owner_id) ) TYPE=MyISAM'

I tried deleting the tables via phpmyadmin and another table would give me the problem.
Fresh Fantastico install of SMF.  I uploaded CPG via ftp.  Changed the files for CPG per tutorial.  Using the same database info as SMF.

[kegobeer]

It looks like you are:

1.  Trying to install Coppermine with a bridge already enabled.  Bridge only after Coppermine is installed and working.
2.  Using the same table prefix for SMF and Coppermine.  They must be in the same database, but the table prefixes must be different, ie: smf10_ and cpg135_

Here's what you need to do:  Install SMF and get it working.  Install Coppermine and get it working.  After you complete those steps, then bridge Coppermine with SMF.

[pbdoggie]

2.  Using the same table prefix for SMF and Coppermine.  They must be in the same database, but the table prefixes must be different, ie: smf10_ and cpg135_

That's what I was doing wrong.

Thanks for the quick reply.

[MIRROR]

Just want to echo that i have followed this short discussion with interest and it will useful for my own integration with either SMF or phpBB. Thanks for the topic.