Return Authorization Module (RMA)

[clydejones]

Hi Clyde,

After going over it and over it and over it again I finally found the problem for real this time. I'm a little slow but at least I know where my issue is, fixing it is another story, am hoping you can shed some advice on it.

I finally re-ran the SQL query, and to my surprise it did not give me an error, so of course I felt silly at first, thinking I must have forgotten to run it the first time - but that didn't fix the problem. Then something told me to look at the dB thru MySQL, and I could not find any rows with the word "return" in them. So, I ran the query directly in the phpAdmin screen and got a #1146 Error - - Table 'scrapcha_zencart.configuration_group' doesn't exist. I will paste the exact error below, along with a copy of the query below. I think the only thing that I need to do is change the name from configuration_group_id to just configuration_group, but not being very familiar with My SQL, I am afraid to make any kind of change to it on my own. Also, we have a configuration_group but no configuration_group_title.

Can you tell? Please?

Thank you so much for your help!!

Open admin -> tools -> install sql patches
copy and paste the following sql statement into the text area and then press send.

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group VALUES (NULL, 'Return Authorization', 'Return Authorization Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO `configuration` VALUES (NULL, 'Phone Number', 'RETURN_PHONE', 'true', 'Display phone number field', @configuration_group_id, 1, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Total Value', 'RETURN_VALUE', 'true', 'Display Total Value', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Item Number', 'RETURN_ITEM_NUMBER', 'true', 'Display Item Number field', @configuration_group_id, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

INSERT INTO `configuration` VALUES (NULL, 'Only registered customers may submit a return request', 'REGISTERED_RETURN', 'false', 'Only registered customers may submit a return request', @configuration_group_id, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Set "Return Action" Dropdown List', 'RETURN_ACTION_LIST', 'Refund, Replacement, Repair', 'On the "Return Authorization" Page, set the list of actions , in this format: Action 1,  Action 2', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_textarea(');

INSERT INTO `configuration` VALUES (NULL, 'Define Return Authorization', 'DEFINE_RETURNS_STATUS', '1', 'Enable the Defined Return Authorization Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');