Post by jog2le » Wed Jun 17, 2020 9:51 pm

I would like some advice on the following issue.
Firstly here are my OC details.
OC Version: 3.0.3.2
Theme: Default Theme and Default Layout
Standard install, no modification to any of the code etc. I am not skilled enough to mess with code therefore I'm using the OC as is.
The problem is related to checkout. I have two payment extensions installed, Paypal and First Data EMEA Connect (3D Secure enabled)
Paypal is working perfectly but if the customer selects the credit/debit card option, ticks the terms and conditions and then to continue button they immediately get the error message "Internal Server Error"
I have checked error logs in both OC and Control Panel, below is a sample of regular errors, whether they are related or not I don't know.

opencart error report

Code: Select all

2020-06-14 16:09:06 - PHP Warning:  mysqli::__construct(): (HY000/2002): No such file or directory in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 7
2020-06-14 16:09:15 - PHP Warning:  mysqli::__construct(): (HY000/2002): No such file or directory in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 7
2020-06-14 16:09:15 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 10
2020-06-14 16:09:15 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 10
2020-06-14 16:09:15 - PHP Warning:  mysqli::__construct(): (HY000/2002): No such file or directory in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 7
2020-06-14 16:09:15 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 10
2020-06-14 16:09:15 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 10
2020-06-16 1:23:49 - PHP Warning:  mysqli::__construct(): (HY000/2002): No such file or directory in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 7
2020-06-16 1:23:49 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 10
2020-06-16 1:23:49 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/iconembroideryco/public_html/opencart/system/library/db/mysqli.php on line 10
cpanel report

Code: Select all

[Tue Jun 16 18:16:05.482181 2020] [core:crit] [pid 18685] (13)Permission denied: [client 93.174.93.12:59347] AH00529: /home/iconembroideryco/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/iconembroideryco/public_html/' is executable
Any help will be gratefully received.

Attachments

image.png

extensions - image.png (162.61 KiB) Viewed 1580 times

image.png

Error message - image.png (111.25 KiB) Viewed 1580 times

Last edited by straightlight on Wed Jun 17, 2020 10:29 pm, edited 1 time in total.
Reason: Added code tags.

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by letxobnav » Wed Jun 17, 2020 10:17 pm

well, the date/time of these entries indicate they are not related.
Better start web developer tools while doing what you were doing up until you get to those messages and see what errors are reported there.
turn off caching and look in the console and network tab.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by jog2le » Wed Jun 17, 2020 10:30 pm

Thanks for your reply. However can I just be up front and say that I don't know anything about web developer tools and turning caching off etc. I have simply installed the firstdata payment extension and populated all the fields with the payment gateway information.

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by letxobnav » Wed Jun 17, 2020 11:16 pm

then you need to provide the url.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by jog2le » Thu Jun 18, 2020 3:30 am

Thank you so far. Have I supplied the url that you suggested or do you need some other alternative?

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by sw!tch » Thu Jun 18, 2020 4:12 am

Check your main server logs, cPanel logs don't always house Fatal errors. Look in the root of your web space for a logs folder. If it's a 500 it will be in there somewhere.

Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm

Post by letxobnav » Thu Jun 18, 2020 9:36 am

Thank you so far. Have I supplied the url that you suggested or do you need some other alternative?
This site can’t be reached
www.iconembroidery.co.uk’s server IP address could not be found.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by jog2le » Thu Jun 18, 2020 2:55 pm

Sorry I don't know what you mean about IP address. When I click on the link provided it immediately goes to my site. What can I do to provide the server IP address.

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by letxobnav » Thu Jun 18, 2020 3:52 pm

I know the server's ip address, it just is not responding.

Attachments

Capture1.JPG

Capture1.JPG (11.93 KiB) Viewed 1413 times

Capture.JPG

Capture.JPG (18.24 KiB) Viewed 1413 times


Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by xxvirusxx » Thu Jun 18, 2020 3:53 pm

Same for me. Your website doesn't load.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by xxvirusxx » Thu Jun 18, 2020 4:37 pm

As we said...

Attachments

Screenshot_2020-06-18_11-37-12.png

Screenshot_2020-06-18_11-37-12.png (21.82 KiB) Viewed 1378 times


Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by jog2le » Thu Jun 18, 2020 4:46 pm

Sorry if I'm missing the point but if I click both those links they immediately take me to the site.
Have tried it on three different devices and all seems ok.
How can this happen?

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by jog2le » Thu Jun 18, 2020 4:49 pm

Google search for iconembroidery has the sane link to the website.

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by xxvirusxx » Thu Jun 18, 2020 5:03 pm

jog2le wrote:
Thu Jun 18, 2020 4:46 pm
How can this happen?
Possible some IP blocked/countries....
For me load only using VPN.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by paulfeakins » Thu Jun 18, 2020 5:31 pm

jog2le wrote:
Wed Jun 17, 2020 10:30 pm
However can I just be up front and say that I don't know anything about web developer tools and turning caching off etc.
There's an internal server error on your checkout preventing your ecommerce site from working, you know nothing about code, but you're poking around on the forums waiting for help? I suggest you hire a developer to fix this for you ASAP!

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by letxobnav » Thu Jun 18, 2020 5:42 pm

There's an internal server error on your checkout preventing your ecommerce site from working, you know nothing about code, but you're poking around on the forums waiting for help?
A forum moderator suggesting that that is not the purpose of this forum?

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by jog2le » Thu Jun 18, 2020 6:17 pm

Thank you letxobnav for your understanding.

In response to previous member, I'm not poking around waiting for help, I'm simply asking the community if they can offer any advice. Not everything is a money making exercise. If all fails and I can't get help then I will have no alternative but to seek a professional to sort the matter out.

New member

Posts

Joined
Sun Mar 22, 2020 12:48 am

Post by letxobnav » Thu Jun 18, 2020 6:40 pm

First ask your host why your url www.iconembroidery.co.uk does not resolve to an ip via dns, something wrong with nameservers there.
Second, ask them if they are actively blocking countries, ip ranges, etc.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan
Who is online

Users browsing this forum: No registered users and 109 guests