Ability to Repair Online Store

[EZPaintball-Evins]

Hey Everyone,

My store was live, and was accepting payments through paypal but when I would try to checkout using just the credit card number ( so the card information could be manually entered by the store owner) the online store would generate an error stating that the CVV field did not exist. I went have and executed the commands in PhpAdmin to enter the missing fields in the MySQL database... so I thought my errors were solved.

Well, I couldn't be further from the truth, now the online store will not even load... I get the following error:

 

Warning: mysql_connect(): Access denied for user: '[email protected]' (Using password: YES) in /hsphere/local/home/ezpaintb/easypaintball.com/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

I checked my configure.php file and the links to my database are still intact, so I don't have a clue as to where to go from there. Thanks in advance for any and all help on this issues, I'm trying not to have to reset the online store and start over!!

 

 

Thanks,

Evins

P.S. I tried searching but you can't use the phrase because you can't enter words less than 4 letter into the search engine... so I was having trouble getting relevant results.

[Guest]

what commands did you execute in phpmyadmin? it appears the username is different in the configure.php than what it should be

[EZPaintball-Evins]

Greetings again,

I entered the following commands...

 

 

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

 

 

INSERT INTO configuration VALUES ( 185, 'CVV2 Number', 'CVVNUMBER_MIN_LENGTH', 3, 'Minimum Length of CVV2 Number', 2, 17, '2004-01-08 10:30:00', '2004-01-08 10:30:00', NULL , NULL )

 

 

Before I entered these two lines in phpAdmin... the online store would go all the way through the checkout process and then when you entered your CVV you'd get an error code that the 'cvvnumber' field doesn't exist. So, I went back and added the command, per the contributions instruction, and then it resulted in the error of not being able to connect to the database.

 

Thanks,

Evins