Return Authorization Module (RMA)

[pdxdoug]

Installed this mod on a 1.3.9h site. Configuration page shows and works in admin. The returns page appears to collect all the data but the email lacks all the data collected on the Returns page. It's as though the $EXTRA_INFO field doesn't make it to the email.

Other install mods are FEC.

Thanks in advance to an insight as to solving this.

[marcopolo]

Just tried to install RMA mod on a new 1.5.4 install and getting the following error: Column count doesn't match value count at row 1

After a little research it seems if the installer for this module shortcuts explicitly naming the columns it will spit out the column count error when run.. Is there a updated install script that I can try?

[DrByte]

Just tried to install RMA mod on a new 1.5.4 install and getting the following error: Column count doesn't match value count at row 1

After a little research it seems if the installer for this module shortcuts explicitly naming the columns it will spit out the column count error when run.. Is there a updated install script that I can try?

Which specific RMA mod are you trying to install?
What other mods do you have installed? Specifically anything by Numinix? Many numinix mods break other mods' install logic because of the changes Numinix made to database tables. To work around that you may need to alter your install scripts to specifically list all the column names for which it is inserting data.

ie: change the install.sql from

INSERT INTO `configuration` VALUES .....

to

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 .....

[marcopolo]

Hello DrByte, thanks for responding to my issue. Yes I have a few Numinix modules installed and figured it was because of them. It's the regular RMA module not the flexible one. I will try your solution later this evening when I'm able to work on the site and report back.

[marcopolo]

Ok it worked!

Here is the original code:

#Return Authorization SQL Install
# For Zen-Cart 1.3.9
# Last Updated: 4/13/2010

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';

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

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization';

INSERT INTO `configuration` VALUES (NULL, 'Phone Number', 'RETURN_PHONE', 'true', 'Display phone number field', @t4, 1, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Item Name', 'RETURN_ITEM_NAME', 'true', 'Display Item Name field', @t4, 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', @t4, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Total Value', 'RETURN_VALUE', 'true', 'Display Total Value', @t4, 4, 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', @t4, 5, 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', @t4, 6, NULL, now(), NULL, 'zen_cfg_textarea(');
INSERT INTO `configuration` VALUES (NULL, 'Return - Show Store Name and Address', 'RETURN_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 7, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
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', @t4, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO `configuration` VALUES (NULL, 'Return Authorization Version', 'RA_VERSION', '2.3.3', 'Return Authorization version', @t4, 9, NULL, now(), NULL, NULL);

Here is what I changed it to:

#Return Authorization SQL Install
# For Zen-Cart 1.3.9
# Last Updated: 4/13/2010

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';

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

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization';

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 (NULL, 'Phone Number', 'RETURN_PHONE', 'true', 'Display phone number field', @t4, 1, NULL, now(), NULL, 'zen_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 (NULL, 'Item Name', 'RETURN_ITEM_NAME', 'true', 'Display Item Name field', @t4, 2, NULL, now(), NULL, 'zen_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 (NULL, 'Item Number', 'RETURN_ITEM_NUMBER', 'true', 'Display Item Number field', @t4, 3, NULL, now(), NULL, 'zen_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 (NULL, 'Total Value', 'RETURN_VALUE', 'true', 'Display Total Value', @t4, 4, NULL, now(), NULL, 'zen_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 (NULL, 'Only registered customers may submit a return request', 'REGISTERED_RETURN', 'false', 'Only registered customers may submit a return request', @t4, 5, NULL, now(), NULL, 'zen_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 (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', @t4, 6, NULL, now(), NULL, 'zen_cfg_textarea(');
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 (NULL, 'Return - Show Store Name and Address', 'RETURN_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 7, NULL, now(), NULL, 'zen_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 (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', @t4, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
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 (NULL, 'Return Authorization Version', 'RA_VERSION', '2.3.3', 'Return Authorization version', @t4, 9, NULL, now(), NULL, NULL);

[lat9]

Just a small change to your installation SQL, so you're not deleting elements in configuration_group_id = 0 on the initial install:

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Return Authorization';
DELETE FROM configuration WHERE configuration_group_id = @t4 AND @t4 != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @t4 AND @t4 != 0;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_RETURNS_STATUS';
.
.
.

[marcopolo]

Thanks but I ran the install script already do you think it deleted something it was not suppose to? I have backup of course so I can restore if I have to.

[lat9]

Check out this (http://www.thatsoftwareguy.com/blog/...t-not-working/) entry in swguy's blog; it tells you how to get those values back ... if you're running a Zen Cart version prior to v1.5.4.

[marcopolo]

ok thanks