Problems with a sql query perhaps?

[redbone]

Hi all,

 

Don't know too much about sql, but I installed the Anti-Robot Registration 2.5 contribution and all was fine and working great. Afterwards, I installed the Order Editor 3.01 Contribution and that was working great. However, a couple days later (after I had created about 50 additional products in the store) I find that the Anti-Robot Registration isn't working. The box comes up, but there aren't any characters in it. I went back thru my saved databases and it seems to have stopped working after I installed the Order Editor contribution.

 

I believe somehow the sql query from the Order Editor contribution messes with the Anti-Robot one. I'm not too knowledgeable about sql queries so i'm posting in the hopes that somebody out there can spot something that's conflicting between the two queries and how can I go about fixing it.

 

BTW, the Order Editor contrib still works.

 

Here's the query that's run with the Anti-Robot Registration Contrib:

 

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('736', 'Anti Robot Reg', 'Anti Robot Registration', 300, 1);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate the Anti Robot Registration?', 'ACCOUNT_VALIDATION', 'true', 'This forces the user to enter a visual code, preventing bots from automatically registering.', 736, 10, '2004-08-08 17:00:00', '2004-08-08 17:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate for New Users? ', 'ACCOUNT_CREATE_VALIDATION', 'true', 'Force the user to enter a visual code when creating a new account. (OPTIONAL)', 736, 20, '2004-08-08 17:00:00', '2004-08-08 17:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate for Editing of User Account? ', 'ACCOUNT_EDIT_VALIDATION', 'true', 'Force the user to enter a visual code when editing an existing user account. (OPTIONAL)', 736, 21, '2004-08-08 17:00:00', '2004-08-08 17:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate for Changing Passwords? ', 'ACCOUNT_EDIT_PASSWORD_VALIDATION', 'true', 'Force the user to enter a visual code when changing the password for thier account. (OPTIONAL)', 736, 23, '2004-08-08 17:00:00', '2004-08-08 17:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate for Contact us? ', 'CONTACT_US_VALIDATION', 'true', 'Force the user to enter a visual code when using contact us form. (OPTIONAL)', 736, 24, '2004-08-08 17:00:00', '2004-08-08 17:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Length of Validation Code.', 'ENTRY_VALIDATION_LENGTH', '5', 'Default Length= 5  Max= 10', 736, 50, '2004-08-08 17:00:00', '2004-08-08 17:00:00', NULL, NULL);

CREATE TABLE anti_robotreg (

session_id char(32) DEFAULT '' NOT NULL,

reg_key char(10) NOT NULL,

timestamp int(11) unsigned NOT NULL,

PRIMARY KEY (session_id))

 

Here's the sql query for the Order Editor contrib:

 

ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '0.000' NOT NULL;

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Order Editor- Display Payment Method dropdown?', 'ORDER_EDITOR_PAYMENT_DROPDOWN', 'true', 'Based on this selection Order Editor will display the payment method as a dropdown menu (true) or as an input field (false).', '1', '95', now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Order Editor- Display Shipping Method dropdown?', 'ORDER_EDITOR_SHIPPING_DROPDOWN', 'true', 'Based on this selection Order Editor will display the shipping method as a dropdown menu (true) or as an input field (false).', '1', '96', now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Order Editor- use Separate Pricing Per Customer?', 'ORDER_EDITOR_USE_SPPC', 'false', 'This should be set to true only if SPPC is installed.', '1', '97', now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Order Editor- select a tax class for shipping fees', 'ORDER_EDITOR_DEFAULT_TAX_CLASS', '0', 'Order Editor will assess tax on shipping as being a part of this tax class.', '1', '98', now(), now(), 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Order Editor- select your credit card payment method', 'ORDER_EDITOR_CREDIT_CARD', 'Credit Card', 'Order Editor will display the credit card fields when this payment method is selected.', '1', '99', now(), now(), NULL, 'tep_cfg_pull_down_payment_methods(');

 

I truly appreciate anybody's help on this!