Hi,

I'm using ECT v6.5.5 on a WP site, with the cart.php page purely being used to take customer payments for offline services using CardSave.

I have an issue now which was fine previously - once the payment has been processed and the customer is returned to my thanks.php page, they now see;

Access denied for user ''@'localhost' (using password: NO)Access denied for user ''@'localhost' (using password: NO)

Cannot find details for order id: xyz

So no order confirmation is shown and they're presented with a page not knowing if the payment has gone through. In each case, they payment is getting through to the merchant account.

Can you please help?

Thanks

Hi Gavin, 6.5.5 is getting a bit old might be worth updating the cart to 6.8 series. Basically the error indicates a problem with the database user permissions, however it is odd that the error is only showing on the thanks page and not all pages. I would first start with checking that the database user has not lost its permissions this can be done in the host control panel under mySQL, also check that the database location is correct. If you are not sure of what settings to use contact your host and as then if they can confirm that your current settings are correct. Sometimes hosting companies make changes I recently had to switch from using local host to the ip address of the database.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Hi Sinbad,

Thanks for the reply. Yep, I'm familiar with the cause for the error, and which settings to check, however I don't understand why the error only transpires on the thanks.php page seeing as cart.php is fine and both pages include the same db_conn_open.php?

KRs
Gavin

Hi Gavin, have you recently added SSL to the site?

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Hi Sinbad,

SSL has been there for some time, but the certificate was renewed recently. I have my return URL within CardSave set to hit the https URL.

KRs
Gavin

Gavin Cotton

Hi I located a post here near the bottom where Vince mentions not using the same connection string when there is a separate SSL folder on the server could that be the case here.

https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107236

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Hi, I had seen that thread but I still can't tie it up with my issue. I don't have a separate SSL only part of the website.

I've just tried replacing "localhost" with the IP, but still get the same error.

KRs
Gavin

Hi can you check in the .htaccess folder and let us know what is there.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Hi Sinbad,

I've emailed the .htaccess file

Thanks
Gavin

Hi,

Thought I'd update this in case it's useful to anyone else. This has now been resolved courtesy of an updated cardsave customppsend.php and customppreturn.php from Andy.

Thanks all for your assistance.

Gavin