(As posted on the pnCPG website)
Hi there,
I've just spent 30 mins going through pnCPG 2.4 and fixed the problem with importing PostNuke users and the error "Query0 failed : Table '*insert DB name here*.cpg11d_users' doesn't exist"
First up, the failing to import users:
Open up pnadmin.php in a text editor and go to line 417, it should be
while ($teller < usr_num ){
Change this to
while ($teller < $usr_num ){
now go to line 424, it should look like this:
$results1 = mysql_query( "SELECT * FROM $_cpg_prf WHERE user_name='$username' " );
change it to
$results1 = mysql_query( "SELECT * FROM $_cpg_prf WHERE user_name=$username" );
Now upload that modified file and run the import again, you should now find your Coppermine userbase filled with your Postnuke users :)
Now for the problem with the 'random' block that is causing the 'cpg11d_users' doesn't exist" error
Open up pncpg-random.php, it's in the pnblocks folder/directory.
Go to line 28, it should look like this:
$url[1] = "cpg11d";
change the cpg11d to whatever your Coppermine database table prefix is, often it will be cpg132 or similar (seems to depend on the version number of Coppermine you installed)
That should sort out the two biggest bugs in this release whilst waiting for 2.5 :)
The first reported bug is acknowledged and fixed in 2.5; the second issue is a question of filling in the block details correctly.
In the next version have updated this setting but it is always necessary to verify these settings.
Cas