Print

[scifirocket21]

I have my Coppermine photo gallery bridged with PHPBB2.  When I try to install plug-ins, I usually ends up in a database error.  I tried the same files on a non bridged gallery and it worked fine.  What do I do?

[Joachim Müller]

Posting a link to your page and the actualy mySQL error you get (note: do not post debug_ouput, but only the error message) might help.

[scifirocket21]

Error Message:
Critical error
There was an error while processing a database query

URL: http://www.mydpnet.com/videos/index.php

[Joachim Müller]

Turn debug mode on, leave notices turned off, post the actual error message.

[scifirocket21]

Here is what I get now:

While executing query "SELECT * FROM cpg_mark_users WHERE user_id = 2" on 0

mySQL error:

[Joachim Müller]

What's the actual error message? What's your coppermine database table prefix? Does the table actually exist that the error message complains about?

[scifirocket21]

It would probably be best if you looked here: http://www.mydpnet.com/videos/index.php.

The debug mode is on, so you should find what you are looking for.

[Joachim Müller]

Does the table actually exist that the error message complains about?

[scifirocket21]

cpg_mark_users does not exist apprently.  I think that this table is removed or changed when I bridged coppermine with phpbb because coppermine's user thing (i dont know what to call it) reads off of the phpbb user thing.

(Sorry I'm vauge)

[Sami]

The cpg_mark_user is the custom (plugin) made table for CPGMark plugin , if it's not there then try to removing cpgmark from your cpg_plugins table manualy by phpmyadmin then try to install the plugin again

[Jale Crni]

where to download bridge between SMF  and Coppermine?    please help me

[Sami]

- Next time Please do not post to unrelated thread , create you own new thread ...
- Read the documentation & search board before post an issue
- SMF bridge is already under standard installation package , you don't need to download it if you already have installation package of CPG 1.4.8 you need to enable it under bridge manager

[Jale Crni]

- Next time Please do not post to unrelated thread , create you own new thread ...
- Read the documentation & search board before post an issue
- SMF bridge is already under standard installation package , you don't need to download it if you already have installation package of CPG 1.4.8 you need to enable it under bridge manager

Ok, sorry.  I asked administrator (before posting in this thread) for help becouse i know that i'm asking noob  questions, but he didin't answer.

[scifirocket21]

The cpg_mark_user is the custom (plugin) made table for CPGMark plugin , if it's not there then try to removing cpgmark from your cpg_plugins table manualy by phpmyadmin then try to install the plugin again

It didn't work.  I still get error messages which can be seen at www.mydpnet.com/videos.  It appears that bridging CPG with another application removes any "users" tables from the CPG database, and reads all the user information from whatever you bridge CPG to.  I guess that's why it says this:

Code: [Select]

While executing query "SELECT * FROM cpg_mark_users WHERE user_id = 2" on 0

mySQL error:

The plug in works fine when CPG is not bridged.  So I know that something has to be wrong on CPG side, and it most likely has something to do with how CPG and PHPBB (the forum I'm using) share user information.  Other than that, I know nothing.  I tried re-installing CPG, but the same exact errors occured.

Sorry for rambling, I guess I'm trying to talk myself into solving the problem.  lol.

Any ideas?  (Thank you for your help so far.)

[Nibbler]

Bridging doesn't remove anything. If the table is not there then why don't you just create it and see what happens?

Code: [Select]

CREATE TABLE `cpg_mark_users` (
  `user_id` int(11) NOT NULL default '0',
  `use_watermark_img` tinyint(4) NOT NULL default '0',
  `img_vpos` varchar(10) NOT NULL default '',
  `img_hpos` varchar(10) NOT NULL default '',
  `use_watermark_txt` tinyint(4) NOT NULL default '0',
  `watermark_text` varchar(255) NOT NULL default '',
  `watermark_text_size` tinyint(4) NOT NULL default '0',
  `large_watermark_text_size` tinyint(4) NOT NULL default '0',
  `watermark_text_color` varchar(6) NOT NULL default '',
  `txt_vpos` varchar(10) NOT NULL default '',
  `txt_hpos` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;


[scifirocket21]

That error is gone, but now I need to creat table cpg_mark_config?  I must have installed the plug-in incorrectly, otherwise these tables would be where they were supposed to be.  I FTP the plug-in folder to the plug-ins folder on CPG.  Did I do somthing wrong, or am I skipping some step?

[Nibbler]

You should upload and then install the plugin using the plugin manager interface. Make sure your mysql user actually has permission to create new tables.

[scifirocket21]

I'm about to go insane.
I re-uploaded the whole CPG gallery again, and then bridged it with my PHPBB forum.  I then uploaded and installed the plug-in using the Plug-in manager (I had to change the CHMOD of the plug-ins folder to 777, I assume you have to do that to upload the plug-ins (it worked)).  And i still get the same error messages.  I checked to make sure that the user can create tables.  It said that the user had all privileges. 

What confuses me is the message I get after I install the plug-in.  I shouldn't get the the following message with a clean installation of CPG, should I?

Performing Database Updates
CREATE TABLE `cpg_mark_watermark` ( `pid` INT NOT NULL, `watermarked` TINYINT NOT NULL, PRIMARY KEY (`pid`) ) TYPE=MyISAM Already Done
CREATE TABLE `cpg_mark_users` ( `user_id` int(11) NOT NULL default '0', `use_watermark_img` tinyint(4) NOT NULL default '0', `img_vpos` varchar(10) NOT NULL default '', `img_hpos` varchar(10) NOT NULL default '', `use_watermark_txt` tinyint(4) NOT NULL default '0', `watermark_text` varchar(255) NOT NULL default '', `watermark_text_size` tinyint(4) NOT NULL default '0', `large_watermark_text_size` tinyint(4) NOT NULL default '0', `watermark_text_color` varchar(6) NOT NULL default '', `txt_vpos` varchar(10) NOT NULL default '', `txt_hpos` varchar(10) NOT NULL default '', PRIMARY KEY (`user_id`) ) TYPE=MyISAM Already Done
CREATE TABLE `cpg_mark_config` ( `name` varchar(40) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM Already Done
INSERT INTO `cpg_mark_config` VALUES ('watermark_path', 'watermarks/') Already Done
INSERT INTO `cpg_mark_config` VALUES ('small_watermark_image', 'watermark.png') Already Done
INSERT INTO `cpg_mark_config` VALUES ('large_watermark_image', 'watermark_large.png') Already Done
INSERT INTO `cpg_mark_config` VALUES ('display_image_mark', '0') Already Done
INSERT INTO `cpg_mark_config` VALUES ('upload_mark', '1') Already Done
INSERT INTO `cpg_mark_config` VALUES ('user_watermark', '0') Already Don

And then after I click next, it takes me to this error message (which we have already seen):

Code: [Select]

While executing query "SELECT * FROM cpg_mark_users WHERE user_id = 2" on 0

mySQL error:


I noticed that it creaded the CPG Mark row in the plug-ins table of the database, but it won't create any other tables even if the user has all privileges.

Any more ideas?

[Nibbler]

Stop re-installing; Coppermine is not windows. Looks to me like the user does not have the CREATE TABLE privilege. Running the queries manually appears to solve your issues, so I would suggest running the rest of the create table statements via phpmyadmin or whatever you use.

[scifirocket21]

The only reason I re-installed the script was because I thought I might have done some damage to the database after playing with it.  I'll try manually creating the tables again and see what happens.