burt wrote: ↑Wed Sep 13, 2023 7:04 am
What does your hosts error_log say when you attempt a checkout ?
Would be interesting to see what what errors are listed in there, otherwise just stabbing in the dark.
I have found and rectified so many errors in the last few weeks with my new test site, it can be a real helper to see what is in there. Post any bits in the file in the root folder of your test site or in the live sites root folder. There may also be another in the admin files but probably not related to the payment module but may help with order stuff.
So that error is telling you that those functions are about to be gone.
You therefore have some code (perhaps in core, but likelier in addon) that uses those older tep_db_ functions.
Your task is to scan your site for any mention of tep_db_query
Scanning a site is easiest if you have a copy of your live site stored somewhere on your computer and use a program such as "grepWin" to search for text strings in files. Alternatively you might know which addons you have added, so you could directly look at the code in those addon files.
Once you have found that search string, it should be relatively obvious which is causing issues in the checkout, eg a module for checkout_success or checkout_payment, whereas the same text string in a module for (eg) product_info would not cause a checkout error. Do not try to fix things without getting further advice.
I am not here to build for you.
I am here to build with you. Let's help each other.
burt wrote: ↑Wed Sep 13, 2023 3:29 pm
So that error is telling you that those functions are about to be gone.
You therefore have some code (perhaps in core, but likelier in addon) that uses those older tep_db_ functions.
Your task is to scan your site for any mention of tep_db_query
SCREENSHOT ATTACHED
Scanning a site is easiest if you have a copy of your live site stored somewhere on your computer and use a program such as "grepWin" to search for text strings in files. Alternatively you might know which addons you have added, so you could directly look at the code in those addon files.
Once you have found that search string, it should be relatively obvious which is causing issues in the checkout, eg a module for checkout_success or checkout_payment, whereas the same text string in a module for (eg) product_info would not cause a checkout error. Do not try to fix things without getting further advice.
You do not have the required permissions to view the files attached to this post.
You haven't yet told us what version Phoenix you are using.
Problem would seem to be paypal_standard.
I believe there is an updated addon, I have never used it so can't give further advice, but it is made by one of our Certified Dev's so it should be golden.
I am not here to build for you.
I am here to build with you. Let's help each other.
Fixed it!
For some reason columns customers_country_id, delivery_country_id, and billing_country_id did not exist in my orders table. Created those table and it seems to be working now.
PBR Streetgang wrote: ↑Thu Sep 14, 2023 1:06 pm
Fixed it!
For some reason columns customers_country_id, delivery_country_id, and billing_country_id did not exist in my orders table. Created those table and it seems to be working now.
Exactly the same problem and solution as the post we previously advised you to look at on 31st July and again yesterday
