Login And Logout Pages = "service Unavailable"

Since upgrading to 4.3.9 the default Login and Logout pages land users on the "service unavailable" banner.

For Login - I'm logged in but land on the homepage with a Service Unavailable banner. To resolve I just hit the back button or put the cursor in URL field and hit return. A full page refresh asks if I want to resubmit the form (even though the URL is the homepage).

For logout - I'm not able to logout. The only way to get past the Service Unavailable page is to delete all cookies. Logout URL = https://TLD/index.php?dispatch=auth.logout&redirect_url=index.php

Once I delete all cookies that URL will take me straight to the homepage.

Happening on Firefox 47 and latest Chrome.

Website uses SSL for secure pages only. I have tried enabling SSL for all pages once logged in - no affect.

Any thoughts or help appreciated!

Since upgrading to 4.3.9 the default Login and Logout pages land users on the "service unavailable" banner.

For Login - I'm logged in but land on the homepage with a Service Unavailable banner. To resolve I just hit the back button or put the cursor in URL field and hit return. A full page refresh asks if I want to resubmit the form (even though the URL is the homepage).

For logout - I'm not able to logout. The only way to get past the Service Unavailable page is to delete all cookies. Logout URL = https://TLD/index.php?dispatch=auth.logout&redirect_url=index.php

Once I delete all cookies that URL will take me straight to the homepage.

Happening on Firefox 47 and latest Chrome.

Website uses SSL for secure pages only. I have tried enabling SSL for all pages once logged in - no affect.

Any thoughts or help appreciated!

Check the error message in the source code of the Service unavailable page and provide it here

Code is the same for login or logout

The problem requires examination on your server. Please contact us via Customer Help Desk and provide temporary access to your server by clicking on the Add record link on the Access information page of your Help Desk account so that we could examine the issue.

As an alternative you can try clearing the cscart_user_session_products table of the installation database. This will remove all products from the users carts so please backup the database first.

Code is the same for login or logout

Please take a look:

http://forum.cs-cart.com/tracker/issue-6435-column-order-id-cannot-be-null-b1048b

Thanks eCom but URL not found

Thanks eComLabs - URL working now and the posted fix works as well. THANK YOU SIR!

https://gist.github.com/vpkopylov/fdee1412edc420a2063d159cd1103fe4

The problem requires examination on your server. Please contact us via Customer Help Desk and provide temporary access to your server by clicking on the Add record link on the Access information page of your Help Desk account so that we could examine the issue.

As an alternative you can try clearing the cscart_user_session_products table of the installation database. This will remove all products from the users carts so please backup the database first.

Thanks CS-Cart team - Adding the "fix" code here from 4.3.10 worked - https://gist.github.com/vpkopylov/fdee1412edc420a2063d159cd1103fe4

From this thread: http://forum.cs-cart.com/tracker/issue-6435-column-order-id-cannot-be-null-b1048b

We are glad to hear that the issue is solved

Hi to everybody,

The fault here is on the database. Please go to the table cscart_user_session_products. Enable the structure view and at the value order_id change the default value to NULL.

This affects all 4.3.9 installations so I would love CS.Cart would deploy a fix about it.

We spent some time...

Thankfully, people here have found it so I am posting their post URL to thank them:

http://forum.cs-cart.com/topic/45641-column-order-id-cannot-be-null-1048/

Best regards,

Nick