WordPress MU

On top of all admin pages i get this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dittnett/public_html/wp-content/plugins/super-capcha/super-captcha.php on line 196

at plugin page i get this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dittnett/public_html/wp-content/plugins/super-capcha/super-captcha.php on line 220

WPMU 2.9.1.1
BP 1.2

http://wordpress.org/extend/plugins/super-capcha/

Hi leisegang,

This is an issue I've come across on some installations, for some reason the SQL queries aren't executing; this happens with other plugins as well.

Here is some SQL code that you'll need to run, or you may need to uninstall the plugin and reinstall.

CREATE TABLE YOURTABLEPREFIXHERE_scaptcha (
log_id mediumint(9) NOT NULL AUTO_INCREMENT,
log_user VARCHAR(255),
log_ip VARCHAR(255),
log_time INT(30),
log_host TEXT,
log_browser TEXT,
log_form TEXT,
UNIQUE KEY log_id (log_id)
);

Now you can either insert the following manually, or restore defaults option in the control panel for sCAPTCHA:

INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('display::login', 'false');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('display::sgup', 'false');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('demensions::width', '200');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('demensions::height', '75');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('type::word', '1');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('font::type', 'ttf');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('font::path', './includes/elephant.ttf');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('format::size', '30');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('format::spacing', '30');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('format::angle', '50');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('color::background', '#e3daed');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('color::text', '#0a68dd,#f65c47,#8d32fd');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('color::transparent', '40');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('color::lines', '#80BFFF');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('color::arc', '#8080ff');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('bots::signup', '0');
INSERT INTO YOURTABLEPREFIXHERE_scaptcha (conf_key, conf_val) VALUES ('bots::login', '0');

*NOTE: BE SURE TO REPLACE ALL "YOURTABLEPREFIXHERE"s with your WordPress table prefix or it will not work*