Hi,
i have a problem with this plugin. i have installed pms as in instructions. now my whole gallery crashes saying "critical error: There was an error while processing a database query" and nothing works, just a blank white page with the error message. if i remove the plugin files my gallery works fine again.
can anyone help me with this problem?
thanks!
Ok i solved this. Had to manually add table in mysql cos the basic.sql had wrong parametres.
In basic.sql file was:
CREATE TABLE CPG_pms (
id INT(10) NOT NULL AUTO_INCREMENT,
owner int(10) NOT NULL DEFAULT '0',
subject VARCHAR(120) NOT NULL DEFAULT '',
message TEXT,
sender VARCHAR(120) NOT NULL DEFAULT '',
sender_id int(10) NOT NULL DEFAULT '0',
posted INT(10) NOT NULL DEFAULT '0',
sender_ip VARCHAR(120),
smileys TINYINT DEFAULT '1',
status TINYINT DEFAULT '0',
showed TINYINT DEFAULT '0',
replied TINYINT DEFAULT '0',
PRIMARY KEY (id)
) TYPE=myISAM;
i used this:
CREATE TABLE cpg15x_pms (
id INT(10) NOT NULL AUTO_INCREMENT,
owner int(10) NOT NULL DEFAULT '0',
subject VARCHAR(120) NOT NULL DEFAULT '',
message TEXT,
sender VARCHAR(120) NOT NULL DEFAULT '',
sender_id int(10) NOT NULL DEFAULT '0',
posted INT(10) NOT NULL DEFAULT '0',
sender_ip VARCHAR(120),
smileys TINYINT DEFAULT '1',
status TINYINT DEFAULT '0',
showed TINYINT DEFAULT '0',
replied TINYINT DEFAULT '0',
PRIMARY KEY (id)
);
hope this helps if someone else has this problem