Coppermine and SQL error

Nuke Soldier Joined: Feb 03, 2006 Posts: 26

Ok I have nuke 7.7 installed. I have the donate o meter installed. When I install coppermine gallery on a test site that I use before installing moduels and blocks coppermine works fine.
When I go to isntall it on the main site I get an error.

Code:

While executing query "SELECT aid, title, pos, description, thumb FROM nuke_cpg_albums WHERE category = 0 ORDER BY pos ASC" on 0

mySQL error: Table 'stclouds_donate.nuke_cpg_albums' doesn't exist

The tables get isntalled into the propper data base. But for some reason coppermine is trying to grab the tables from the donate o meter data base. Or it seems anyway.

Any help on that.
Thanks

Captain Joined: Dec 19, 2004 Posts: 663 Location: Canada

Did you change your default nuke perfix(which is suppose to be nuke_ )?

Code:

stclouds_donate.nuke_cpg_albums

If the answer is yes, you have to edit coppermine sql installation file for nuke default perfix. Smile

Nuke Soldier Joined: Feb 03, 2006 Posts: 26

well nuke did install to www.stcloudscoots/nuke but I did not want it that way. I was not able to just install to www.stcloudscoots.com So I just dragged all the files into the publick html folder instead of a directory.

When I go to phpmyadmin. My data bases are listed under stclouds. Then I have
Stclouds
_donate (donate o meter)
_nuke1 (stcloudscoots.com)
_nuke2 (guildtastic.com My other site that I have sharing the host)
_nuke3 (test site)

As to the coppermine spl install file. Is that just the install.php file that you point the browser to?

What might I be looking for? Would you happen to knwo the answer to that. I have been searching for a couple days for that. Not really sure what to be looking for.

thanks

Nuke Soldier Joined: Feb 03, 2006 Posts: 26

I have been messing around with this line
$dirname = nuke(dirname(__FILE__));

Just changing the nuke part. Not really sure what to stick in there.

In my nuke config.php the prefix is "nuke"