I have installed the coppermine photo gallery just fine, it's great.
I am using wordpress for my website and there is a plugin used on Wordpress called "CoppermineSC" which needs information to read the albums to display thumbnails on blog posts. The set up code requires that I add a CPGSC_TABLE_PREFIX'.
I am using the latest version of Coppermine, 1.5.22. And, I have one site that works fine. On that site (that works fine, but is on a completely different web host), I used the CPGSC_TABLE_PREFIX' as 'cpg15x_'. However, on the this new site where I just installed Coppermine, that coding doesn't work and I get the following errors:
CoppermineSC database error: [table 'classicmoviephotodb.cpg15x_config' doesn't exist]
SELECT value FROM cpg15x_config WHERE name="ecards_more_pic_target" OR name="fullpath"
CoppermineSC database error: [table 'classicmoviephotodb.cpg15x_pictures' doesn't exist]
SELECT filepath, filename, title, pid FROM cpg15x_pictures WHERE aid=1 ORDER BY RAND( ) LIMIT 3
classicmoviephotodb is the name of the database.
Can you tell me how to find the CPGSC_TABLE_PREFIX for my current photo gallery? Where do I look for it?
Thanks!
Simply use phpmyadmin to check your coppermine database. It will all be clearly written in there
Having said that, are you sure this plugin supports CPG1.5.x? A very quick look at the plugin page does not show what versions it supports and the last comment was from 2010.
Thanks for the reply, and sorry if I should know this, but where do I find phpmyadmin and what is it?
Quote from: Phill Luckhurst on May 17, 2013, 06:21:25 PM
Having said that, are you sure this plugin supports CPG1.5.x? A very quick look at the plugin page does not show what versions it supports and the last comment was from 2010.
Yes, I said in my first post that I have it successfully running on another site using that code, which was just installed last month. Yes, the plugin is old and not supported, but I also have it running on several other sites and it works fine once it's set up correctly. I just don't seem to have the right info in the plugin setup.
You can also find out the table prefix by having a look at the file include/config.inc.php.
OMG, thank you so much. The information in the config.inc.php is completely different than what I have for everything, user,pass, etc.. I used that info and it now works find.
THANK YOU SO MUCH! YOU MADE MY DAY, NOW I CAN REALLY START PRODUCTION!
MUCH APPRECIATED. :)
Please
Quote from: Joachim Müller on September 28, 2008, 12:46:26 PM
tag your thread as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.