phpMyAdmin or mysql run ?

[magicandmischief182]

In phpMyAdmin or from commandline mysql run:

 

ALTER TABLE `orders` ADD `cc_cvv2

 

 

 

What does that mean to do? Where do I go to get there so I can add that?

Thanks.

Jeff

[Hotclutch]

In phpMyAdmin or from commandline mysql run:

 

ALTER TABLE `orders` ADD `cc_cvv2

 

 

 

What does that mean to do? Where do I go to get there so I can add that?

Thanks.

Jeff

 

Go to phpMyAdmin from your Control panel. Then click on SQL. In the white box copy and paste the above command. Then click Go. You should backup your database before making any changes with phpMyAdmin.

[magicandmischief182]

Go to phpMyAdmin from your Control panel. Then click on SQL. In the white box copy and paste the above command. Then click Go. You should backup your database before making any changes with phpMyAdmin.

 

 

That's what I did, then I got this error:

 

Error

 

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

 

ERROR: Unclosed quote @ 25

STR: `

SQL: ALTER TABLE `orders` ADD `cc_cvv2

 

 

SQL query:

 

ALTER TABLE `orders` ADD `cc_cvv2

 

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[angryquaker]

Add the closing quote at the end of the line, so instead of

 

ALTER TABLE `orders` ADD `cc_cvv2

 

you want

 

ALTER TABLE 'orders' ADD 'cc_cvv2'

 

That's what I'd try, anyway.

 

Namasté,

Russ

[magicandmischief182]

Tried that, got this error:

Error

 

SQL query:

 

ALTER TABLE 'orders' ADD 'cc_cvv2'

 

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''orders' ADD 'cc_cvv2'' at line 1

[angryquaker]

Sorry, I'm a noob, and thought those ` quotes looked wrong, so I used regular ' single quotes. Try

 

ALTER TABLE `orders` ADD `cc_cvv2`

 

and see if that does it.

 

Namasté,

Russ

[magicandmischief182]

Sorry, I'm a noob, and thought those ` quotes looked wrong, so I used regular ' single quotes. Try

 

ALTER TABLE `orders` ADD `cc_cvv2`

 

and see if that does it.

 

Namasté,

Russ

That didn't work either.

[knifeman]

Which contribution are you trying to install?

 

If you are installing

cvv2 for entire order,

 

then the correct sql statement is:

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

 

 

Tim

 

 

In phpMyAdmin or from commandline mysql run:

 

ALTER TABLE `orders` ADD `cc_cvv2

 

 

 

What does that mean to do? Where do I go to get there so I can add that?

Thanks.

Jeff