Sql config

[parma]

hey there,

im installing a cvv contribution to my site and have uploaded all the following folders and files

 

admin

images

includes

 

the readme now tells me i have to update the sql. ok i have done PART 1, but am having trouble with PART 2, could someone please help me with this? The SQL Error below is referring to PART 2.

 

SQL Error

SELECT *

FROM `configuration`

WHERE 1 (

 

`configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `date_added`

)

VALUES (

'CVV Min Length', 'CVV_NUMBER_MIN_LENGTH', '4', 'Minimum length of cvv number', '2', '13', now( )

)

LIMIT 0 , 30

 

PART 1

ALTER TABLE `orders` ADD `cvv_number` VARCHAR( 4 ) AFTER `cc_number`;


ALTER TABLE `orders` ADD `cc_start` VARCHAR( 4 ) AFTER `cc_expires`;

 

PART 2

INSERT INTO `configuration` 
(`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`date_added`) VALUES 
('CVV Min Length','CVV_NUMBER_MIN_LENGTH','4','Minimum length of cvv number','2','13',now());



INSERT INTO `configuration` (`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`date_added`) VALUES
('CVV Max Length', 'CVV_NUMBER_MAX_LENGTH', 4, 'Maximum Length of cvv Number', '3', '13',now());

 

Hope someone can give me help on this

 

regards

 

M Parmar

[parma]

I just need to know where to enter that code in sql