CCV help, please.

[windmillgirl]

Hi everyone,

 

Another question that will probably make you say, 'DUH!' out loud.

 

I need to put the CCV box in. I downloaded the CCV 1.23a and changed all my php files accordingly. In the install.txt Directions, it says to:

 

1.) SQL statements needed just copy and paste these into your SQL query window and hit 'Go':

 

ALTER TABLE `orders` ADD `cvvnumber` VARCHAR(4) default NULL AFTER `cc_expires`;

 

***If you have not altered your Configuration Table in the database:

 

INSERT INTO configuration VALUES ( 136, 'CVV2 Number', 'CVVNUMBER_MIN_LENGTH', 3, 'Minimum Length of CVV2 Number', 2, 17, '2003-02-20 10:30:00', '2003-02-20 10:30:00', NULL , NULL );

 

***If you have made some alterations to the Configuration Table you will need to change the '136' and '17' to represent the next configuration_id and sort_order(group 2) for your particular database.

 

 

INSERT INTO configuration VALUES ( 141, 'CVV Max Length', 'CVVNUMBER_MAX_LENGTH', 4, 'Maximum Length of CVV Number', 3, 19, '2003-02-20 10:31:00', '2003-02-20 10:31:00', NULL , NULL );

 

***As in the previous entry the '141' and '19' might be different if you have already modified your configuration table. The '4' is the value for maximum length of the CVV number which is needed for American Express cards (the 3 in the query is the group_id so don't change). If you just plan on accepting Visa/MC/Discover you can change this to '3' in the query or the number can also be changed in your admin tool->configuration->maximum values

 

Where on earth do I do this? I should also let it be known that I'm using the older OsCommerce.

 

Thanks.

 

feeling really stupid

~Vick

[Guest]

SQL statements are database commands. How do you interact with your database? How did you create the database, for example? If you are using a host, they should provide some kind of method for you to do this. Some programs are phpMyAdmin and MySQL Control Center.

 

If it turns out that you have phpMyAdmin, you would select your catalog database. On the page, there should be a box with a caption "Run SQL query/queries on database." If you copy and paste the SQL commands into the box and click Go, it should process the command.

 

If you have something else and this does not help, post back. I'm sure that someone else will be using the same method as you are. You might have to ask your host what database configuration method they provide.

 

Good luck,

Matt