forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 pnCPG (Coppermine for postNuke/Zikula) => Topic started by: erinmac on December 05, 2007, 04:43:00 pm

Title: Help - Added a postnuke block from pnCPG and killed site!
Post by: erinmac on December 05, 2007, 04:43:00 pm

Query0 failed : Table 'CopperGBO.cpg141_users' doesn't exist

I've searched and can't find this error just yet - all I did was try to add a random block to my site and it crashed everything.  Guess that's not working eh?

Title: Re: Help - Added a postnuke block from pnCPG and killed site!
Post by: erinmac on December 05, 2007, 04:53:31 pm

I used the psak.php (postnuke swiss army knife) and switched the theme back to the default basic theme - was able to get in admin and remove the block and reset my themes.

That sucked.

Title: Re: Help - Added a postnuke block from pnCPG and killed site!
Post by: casNuy on December 08, 2007, 10:33:41 am

You are becoming an expert. I have already mentioned here on the forum that you always should start with defining a new block on the right side within Postnuke. This way you can always access the admin page and remove a block if it gives problems.
You most likely did not enter proper info when setting up the block.
Have you fixed this too by now ?

Cas

Title: Re: Help - Added a postnuke block from pnCPG and killed site!
Post by: mikeymx5 on March 03, 2008, 02:29:40 pm

OK I mess with this for a while before I found a FIX,
First to get back into Post nuke simply rename the PNCPG module folder to something else, I named mine to "PNCPG1"
Go in to postnule and disable the PNCPG block and then name the folder back.

Now you are in Postnuke again! Sucks that one block can kill postnuke but what ever?

Now to fix the real problem, for me is was a mis labled data field!
Coppermine Table Prefix ---- I had "CPG14x_" it should be just "CPG14x" yours may be a little different (this setting was the problem child for the query errors!!)
User table for Postnuke   ---- Mine is "nuke_users" adjust for you
User table for Coppermine --Mine is "cpg14x_users" again adjust this for your settings

Good luck to all!

Title: Re: Help - Added a postnuke block from pnCPG and killed site!
Post by: mikeymx5 on March 03, 2008, 02:34:47 pm

Just a side note i think that this fix needs to be stuck to the top of the forum as many people like my self have had it, and no one has posted a fix for it until now!

Considering that it can take down a site it is an important fix!

Title: Re: Help - Added a postnuke block from pnCPG and killed site!
Post by: casNuy on March 03, 2008, 08:37:04 pm

Thanks for pointing this out but if someone  is adding ablock to Postnuke, it should be configured first on the rights side so you still can access the admin section in order to disable the block. The solution has been stated several times here on the forum.

Cas