Camelot-Hosting down?

Echoing DrByte's comment, if you look at the details of the log:

[10-Jul-2017 16:10:43 UTC] PHP Fatal error: 1292:Incorrect datetime value: '' for column 'last_modified' at row 1 :: insert into so_payments (orders_id, payment_number, payment_name, payment_amount, payment_type, date_posted, [B]last_modified[/B]) values ('4704', '4704-', 'My Name', '8.24', '', '2017-07-10 16:09:33',[B] ''[/B]) ==> (as called by) /home/xxxxxxxx/public_html/MY_ADMIN/includes/functions/database.php on line 53 <== in /home/xxxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 155

... you'll see that the last value (last_modified), which is most likely a datetime field, is being set to an empty string ('') which is being kicked-out by those updated SQL rules. A real time like now() would be better than ''

IIRC, the so_payments table is part of super-orders code.

Well, Im still down and have been other than a short blip of life on Saturday when people still could not get in because of the whole "clear browser" deal. It went back down and has been dead since. Was told that "All the sites are up and have been since Saturday.
Dns issues been over since yesterday morning" but obviously there are still issues being resolved...

Wyvern Creations:

Well, Im still down and have been other than a short blip of life on Saturday when people still could not get in because of the whole "clear browser" deal. It went back down and has been dead since. Was told that "All the sites are up and have been since Saturday.
Dns issues been over since yesterday morning" but obviously there are still issues being resolved...

I have never been to your site, I just tried and can confirm it is not reachable due to SSL configuration issues on the server.

Can confirm that INSERT_YOUR_SITE_HERE.com/cgi-sys/defaultwebpage.cgi is setting no cache in the meta tags. Wheter or not the previous server settings did that is up in the air.

Wyvern Creations:

Well, Im still down and have been other than a short blip of life on Saturday when people still could not get in because of the whole "clear browser" deal. It went back down and has been dead since. Was told that "All the sites are up and have been since Saturday.
Dns issues been over since yesterday morning" but obviously there are still issues being resolved...

Just now checked and if just the Domain name is manually entered then http://www.wyverncreations.com/ is used and the cPanel redirect kicks in. If *https://www.wyverncreations.com/ *is used or manually entered, the site shows as it should.

Check the 'public_html/.htaccess file' for any 'http' redirects and if you don't find one there, check all .htaccess files. Contact your Hoster if you cannot work it out as they are best suited to help you in this situation since there might be a DNS server setting that is causing this problem.

lankeeyankee:

I have never been to your site, I just tried and can confirm it is not reachable due to SSL configuration issues on the server.

Site seems to be up and running now.

re:HD Work Gear

We have been up for 2-days now, but shopping cart not work with express PayPal [error code 10002] re-set the API information in payment module and self testing seems to work, but have noticed numerous customer's shopping carts drop out. We have had zero sales since camelot coming back on line. Is anyone else having payment processing issues?

hdwrkgr:

re:HD Work Gear

We have been up for 2-days now, but shopping cart not work with express PayPal [error code 10002] re-set the API information in payment module and self testing seems to work, but have noticed numerous customer's shopping carts drop out. We have had zero sales since camelot coming back on line. Is anyone else having payment processing issues?Earlier posts mentioned that there were some SSL glitches with the servers. This error is PayPal telling you that the either the credentials are incorrect or the endpoint is incorrect. If you google 10002 Zen Cart, you will find several places to look.

dbltoe:

Earlier posts mentioned that there were some SSL glitches with the servers. This error is PayPal telling you that the either the credentials are incorrect or the endpoint is incorrect. If you google 10002 Zen Cart, you will find several places to look.

dbltoe, thank you for your comment, tried to solve my PalPal express payment all day and am back to square-1, I think the issue may be that PayPal when return to my site gets an error message as the hrl is set wrong it is set to: http://www.hdworkgear.com/cgi-sys/defaultwebpage.cgi

Anyone else having this problem, if so, whats the fix?

Is anyone getting this error message? I need asvice on how to fix this, Thank you!

hdwrkgr:

dbltoe, thank you for your comment, tried to solve my PalPal express payment all day and am back to square-1, I think the issue may be that PayPal when return to my site gets an error message as the hrl is set wrong it is set to: http://www.hdworkgear.com/cgi-sys/defaultwebpage.cgi
Could be another DNS glitch. The problem is that there are hundreds of thousands of devices out there with different settings as to when they refresh their DNS. Do you know if your IP before and after the glitch are the same? I see kinda funny things here where the world gets to your nest, leaves, and comes back to your site.
The recent error is generally a result of someone double-clicking the confirm/sale button.

hdwrkgr:

dbltoe, thank you for your comment, tried to solve my PalPal express payment all day and am back to square-1, I think the issue may be that PayPal when return to my site gets an error message as the hrl is set wrong it is set to: http://www.hdworkgear.com/cgi-sys/defaultwebpage.cgi

You should check the following.

/includes/configure.php

define('HTTP_SERVER', 'http**s**://www.hdworkgear.com');
define('HTTPS_SERVER', 'https://www.hdworkgear.com');

define('ENABLE_SSL', 'true');

Admin -> Configuration -> Sessions
Cookie Domain
Force Cookie Use

• make sure they both say True

Right now a lot of links on your site, when you mouseover them, point to 'http' but are being redirected to 'https', presumably through a directive in your 'public_html/.htaccess' file. Changing the above settings as shown should help to sort that out and perhaps solve your PayPal errors as well.

Website Rob:

You should check the following.

/includes/configure.php

define('HTTP_SERVER', 'http**s**://www.hdworkgear.com');
define('HTTPS_SERVER', 'https://www.hdworkgear.com');

define('ENABLE_SSL', 'true');

Admin -> Configuration -> Sessions
Cookie Domain
Force Cookie Use

• make sure they both say True

Right now a lot of links on your site, when you mouseover them, point to 'http' but are being redirected to 'https', presumably through a directive in your 'public_html/.htaccess' file. Changing the above settings as shown should help to sort that out and perhaps solve your PayPal errors as well.

Hello, anyone else having ssl issues?

HD Work Gear is up but cannot process paypal payments due to ssl issues.

hdwrkgr:

HD Work Gear is up but cannot process paypal payments due to ssl issues.

You should put a ticket in with camelot. Tony knows the server setting and what file(s) are causing issues. You are getting great advice from the people here but all you are doing is chasing symptoms not the cause.

yd29999:

You should put a ticket in with camelot. Tony knows the server setting and what file(s) are causing issues. You are getting great advice from the people here but all you are doing is chasing symptoms not the cause.

Thank you the recommendation, I just submitted a ticket to Camelot. I want to state the issue I am have so that as soon as it is resolved I will post the solution, this is in an attempt to save someone with the same issue time in resolving the problem [because of this ongoing issue hdworkgear is essentially still broken since the server melt-down, now day 10]:

Since the server come back PayPal [PP] has not been able to communicate with my admin page, PP is able to captures the cart and customer payment information, but when the customer confirms the order an error messages occur: 10415 and 10002/API Security Incorrect. PP does capture the payment, but there is no record of the transaction recorded at the admin page. The customer is informed that an error occurred and instructed to refresh the page.

After numerous calls to PP and installing new API credentials at the payment module and tweaking my email settings, same errors continue to show, PP claims the problem is on the server side?

hdwrkgr:

Thank you the recommendation, I just submitted a ticket to Camelot. I want to state the issue I am have so that as soon as it is resolved I will post the solution, this is in an attempt to save someone with the same issue time in resolving the problem [because of this ongoing issue hdworkgear is essentially still broken since the server melt-down, now day 10]:

Since the server come back PayPal [PP] has not been able to communicate with my admin page, PP is able to captures the cart and customer payment information, but when the customer confirms the order an error messages occur: 10415 and 10002/API Security Incorrect. PP does capture the payment, but there is no record of the transaction recorded at the admin page. The customer is informed that an error occurred and instructed to refresh the page.

After numerous calls to PP and installing new API credentials at the payment module and tweaking my email settings, same errors continue to show, PP claims the problem is on the server side?

Just for future ref to anyone. Whenever a server comes up and there are issues ALWAYS contact the hosting company first before making any edits to your site. Last Sat we had a ssl issue and put a ticket in just to be on the list incase it didn't get resolved. Later that day we were told it was fixed and haven't had a problem since.

All other edits that you do could cause hair loss for no reason. [/quote PP claims the problem is on the server side/quote] this is a clear sign that you should not do anymore edits until camelot responds to your ticket.

In the learning curve, thank you.

Its not clear to me where Camelots services start and end, I try to do somethings on my own, adjust settings and testing trying to get things up and running, next time I will open a thicket and ask for help.

hdwrkgr:

Its not clear to me where Camelots services start and end, I try to do somethings on my own, adjust settings and testing trying to get things up and running, next time I will open a thicket and ask for help.

That's ok. Alot of learning and greatness comes out of fiddling. To save you some hair in the future I follow these rules. If a server is coming up or if something stops working when I haven't made any changes I go to the hosting company. If I'm fiddling and something breaks I look in the mirror then I try to retrace my steps. If I'm installing a mod and I think I did everything right then I got to the mod forum or search zc.