Error Message and Site down-Help would be appreciated.

[kagan]

I had my host load coppermine yesterday 1.4.3  Fresh load on a new site(Postnuke 761).  That seemed fine.  Then had them load PNCPG 3.2
on the site.  I went to administration and all seemed well.  I went in and createda block on the left for a random image i believe.  Now i get this message anywhere on my site basically:

Query0 failed : Table 'hammonds_pn.cpg__users' doesn't exist

I cant even get to my administration to try and fix it.  Any help would be appreciated.  The host says they installed correctly.(of course hehe, but in all fairness reading the docs it appears they did.) 

[casNuy]

To fix do this :
start phpMydmin and locate the postnuke blocks table (nuke_blocks). Change the prefix according your settings.
Go the last record, this must be the block causing the issue. Delete the block, problem solved.

Why did this happen :
Within the admin settings of pnCPG you have to define the database name of Coppermin AND the correct table prefix for Coppermine.
In addition this module expects that the database user for Postnuke is the same as the database user for Coppermine (or should have at least the same rights)

Good luck,
Cas

[kagan]

Ok they deleted the block out and that let me back in the site with no problem.  Thank you for saving me from a TOO painful learining experience.    Now the host doesnt want to play with it anymore so its just me.  I dont want to do anything premature so I am asking a few more questions.  The name of the database in the module settings was the same as the actual database.  So I have checked  that. 
so according to what you put in Cas I am left with table prefix and the user rights.  I have 2 users total on my site.  I havent opened this one yet and waiting until it all works to move from my previous site home.  So What else should I be looking for?

Table Prefix in settings is:  cpg_


I do see that the table that was being sought was hammonds_pn.cpg_users  So what is my next step? 
I would say as a newbie that i have ruled out database name so its the prefix or the user rights.  But would the user rights cause this problem?  Thanks for taking time from a busy schedule for this!

[kagan]

I have now ventured into my first database exploring with phpmyadmin.   I cant find the Table listed in the error:
'hammonds_pn.cpg__users'   Where should i be looking?   I am looking down the list of cpg tables and i dont see anything lookin like this.  Thoughts?

[casNuy]

Do not worry, it does take some time.
First of all, you need to look for the database related to Coppermine.
You can find that simply within the config of Coppermine, just logon to Coppermine as Admin and check the configuration.
You will probabbly find all information there.
If not, you will find the database-name for oppermine. Go into phpMyAdmin and you will find the database. Check therefix of the tables.
In a fresh install the prefix probably is "cpg143". Your database probably will be something like  hammonds_cpg.

Now the trick here is that pnCPG expects the PostNuke Database user to have full access onto the Coppermine database. These things can be set by yourself by the tools provided by your provider.

Hopefuly this helps you out.  I could set it up for you but would need admin access to Postnuke/Coppermine and your maintenance site (wheer you access phpyAdmin).
Never post it passwords here, send me a Private Message or send it to my home address.

cas

[kagan]

Cas I mailed you all of my info.  I managed to crash my site again.  In all fairness though at least this time I was able to get it back up again!  I cant seem to get it configured to read where it is supposed to be reading.  Thanks again for all of your help.  As I was exploring I did see that the host tech support did put all of the tables inside the pn database...or at least it appears.  I tried changing the configuration to point there, and also to the coppermine database but same result.   Thanks for your time.

[kagan]

Ok Cas a little more success.   I have now got it configured properly(I believe) to read from the postnuke database cpg folders.  Now when I create a Random Image block it no longer crashes but pops right up as it should with lines for stats and the spot for the image.  But its reading nothing.   All the stats and the picture frame are empty.  Im trying to determine if Coppermine is still saving everything to its old database but im reading from my PN one now.  Anyway it is no longer giving me a crash, its just not showing photos.

[casNuy]

all is ok now. See my PM.

You do have a lot of additional files on your site, looks to me some cleaning cannot harm (make a backup first).

Enjoy using Coppermine and pnCPG.

Cas