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): 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?