Email For Quote for OSCv2.3.1

[sisind]

I am running OS Commerce 2.3.3 and I am trying to install Email For Quote for OSCv2.3.1. I am getting this sql error when I am trying to run the script.

 

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 ('Email for Quote', 'EMAIL_FOR_QUOTE', 'off', 'Turn on email for quote instead of showing prices. <br /><br />Please note: To use test mode, you must specify a customer id to use for testing in the Email for Quote Admin configuration value.', '1', '998', now(), now(), NULL, 'tep_cfg_select_option(array(\'always\', \'off\', \'no price\', \'test mode\'),');

update configuration set sort_order = ((select sort_order from (select * from configuration where configuration_group_id = '1' and configuration_key != 'EMAIL_FOR_QUOTE' order by sort_order desc limit 1) as c1)+1 ) where configuration_key = 'EMAIL_FOR_QUOTE' ;

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 ('Email for Quote Admin', 'EMAIL_FOR_QUOTE_ADMIN', '0', 'Frontend customer id to show Email for Quote in test mode to.', '1', '999', now(), now(), NULL, NULL);

update configuration set sort_order = ((select sort_order from (select * from configuration where configuration_key = 'EMAIL_FOR_QUOTE') as c1)+1) where configuration_key = 'EMAIL_FOR_QUOTE_ADMIN' ;

 

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 ('Email for Quote Link Text', 'EMAIL_FOR_QUOTE_TEXT', 'Email for Quote', 'Text to display', '1', '999', now(), now(), NULL, 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 ('Email for Quote Subject', 'EMAIL_FOR_QUOTE_SUBJECT', 'Quote for product: [%s] %s', 'Quote emails subject line (sprintf() format allowed)', '1', '999', now(), now(), NULL, NULL);

 

update configuration set sort_order = ((select sort_order from (select * from configuration where configuration_key = 'EMAIL_FOR_QUOTE_ADMIN') as c1)+1) where configuration_key = 'EMAIL_FOR_QUOTE_TEXT' ;

update configuration set sort_order = ((select sort_order from (select * from configuration where configuration_key = 'EMAIL_FOR_QUOTE_TEXT') as c1)+1) where configuration_key = 'EMAIL_FOR_QUOTE_SUBJECT' ;

 

I get this error:

 

 

Error

 

SQL query: help

UPDATE configuration SET sort_order = ( (

SELECT

sort_order

FROM

(

SELECT

*

FROM

configuration

WHERE

configuration_key

=

'EMAIL_FOR_QUOTE'

) AS c1 ) +1

 

)

WHERE configuration_key = 'EMAIL_FOR_QUOTE_ADMIN';

 

 

 

MySQL said: help

#1093 - You can't specify target table 'configuration' for update in FROM clause

 

Also does know how to make contact with the author of this add-on, amseek. I did not see a way to contact him.

Edited October 6, 2013 by Jan Zonjee