coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 pnCPG (Coppermine for postNuke/Zikula) => Topic started by: msbr on April 16, 2007, 12:57:28 AM

Title: pnCPG Block Errors (table does not exist)
Post by: msbr on April 16, 2007, 12:57:28 AM
Hi,

We have the Coppermine start page set to 'pnCPG'.  This has always worked great for our homepage...

When I try to add a pnCPG block (such as 'pnCPG/Show last added Albums') it crashes the whole site and displays this error: Query1 failed : Table 'my_postnukedb.cpg__albums' doesn't exist

It also does that for all other pnCPG block types.  It seems that it is adding an extra underscore to the table name.  I have the pnCPG configuration set to use the prefix 'cpg_' which should be correct because the homepage works.

To get the site back up, I have to rename the pnCPG directory (to re-enable access to Coppermine), then deactivate the new pnCPG block, then rename the pnCPG directory back to the original name (to re-enable pnCPG/Coppermine).

We are using pnCPG 3.5 and Coppermine 0.7.6.2.

Does anybody know what we may be doing wrong?  Thank you for the help.
Title: Re: pnCPG Block Errors (table does not exist)
Post by: Kenshino on April 19, 2007, 07:38:10 PM
The prefix should not have an underscore. So set it at cpg if it is cpg only.

As for why your page works correct, the reason is because pnCPG doesn't use the table information till you use the blocks.
Title: Re: pnCPG Block Errors (table does not exist) SOLVED
Post by: msbr on April 19, 2007, 09:06:41 PM
That fixed it... Thanks!