Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Login And Logout Pages = "service Unavailable" Rate Topic   - - - - -

 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 24 August 2016 - 02:29 AM #1

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.ph...t_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!


CS-Cart 4.7.1


 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3812 posts

Posted 24 August 2016 - 05:21 AM #2

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.ph...t_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


Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 24 August 2016 - 11:44 AM #3

Code is the same for login or logout

<!--


Tygh\Exceptions\AException


Message
Column 'order_id' cannot be null (1048)REPLACE INTO cscart_user_session_products (`user_id`, `timestamp`, `type`, `user_type`, `item_id`, `item_type`, `product_id`, `amount`, `price`, `session_id`, `ip_address`, `company_id`, `order_id`, `extra`) VALUES (1039, 1472038825, 'C', 'R', 175690165, 'P', 634, 1, 12, '8e7fd9384406cf72f9f49c252181e843-1-C', '49245bb4', 1, NULL, 'a:29:{s:7:\"user_id\";s:4:\"1039\";s:9:\"timestamp\";s:10:\"1450404823\";s:4:\"type\";s:1:\"C\";s:9:\"user_type\";s:1:\"R\";s:7:\"item_id\";s:9:\"175690165\";s:9:\"item_type\";s:1:\"P\";s:10:\"product_id\";i:634;s:6:\"amount\";i:1;s:5:\"price\";d:12;s:10:\"session_id\";s:36:\"d79dbb3bc10d26e9cc0a7464b3fc3c15_1_C\";s:10:\"ip_address\";s:8:\"49d26aae\";s:10:\"company_id\";s:1:\"1\";s:8:\"order_id\";N;s:12:\"product_code\";s:6:\"A-133A\";s:7:\"product\";s:28:\"A-133A Tzute Pocket Passport\";s:15:\"product_options\";a:0:{}s:12:\"stored_price\";s:1:\"N\";s:9:\"main_pair\";a:5:{s:7:\"pair_id\";s:4:\"3538\";s:8:\"image_id\";s:1:\"0\";s:11:\"detailed_id\";s:4:\"4952\";s:8:\"position\";s:1:\"0\";s:8:\"detailed\";a:8:{s:10:\"image_path\";s:70:\"http://www.tld.com/images/detailed/4/A-133A.jpg?t=1449688534\";s:3:\"alt\";s:0:\"\";s:7:\"image_x\";s:3:\"496\";s:7:\"image_y\";s:3:\"496\";s:15:\"http_image_path\";s:70:\"http://www.tld.com/images/detailed/4/A-133A.jpg?t=1449688534\";s:16:\"https_image_path\";s:71:\"https://www.tld.com/images/detailed/4/A-133A.jpg?t=1449688534\";s:13:\"absolute_path\";s:55:\"/home/tld/public_html/images/detailed/4/A-133A.jpg\";s:13:\"relative_path\";s:21:\"detailed/4/A-133A.jpg\";}}s:5:\"extra\";a:2:{s:15:\"product_options\";a:0:{}s:18:\"unlimited_download\";s:1:\"N\";}s:15:\"stored_discount\";s:1:\"N\";s:12:\"amount_total\";i:1;s:12:\"options_type\";s:1:\"P\";s:15:\"exceptions_type\";s:1:\"F\";s:15:\"modifiers_price\";d:0;s:6:\"is_edp\";s:1:\"N\";s:12:\"edp_shipping\";s:1:\"N\";s:10:\"base_price\";d:12;s:12:\"category_ids\";a:3:{i:0;i:5;i:1;i:65;i:2;i:1;}s:13:\"display_price\";d:12;}')


Error at
app/Tygh/Database/Connection.php, line: 863


Backtrace
File:app/Tygh/Database/Connection.php
Line:458
Function:error


File:app/functions/fn.database.php
Line:129
Function:query


File:app/functions/fn.cart.php
Line:1552
Function:db_query


File:app/functions/fn.users.php
Line:1304
Function:fn_save_cart_content


File:app/functions/fn.users.php
Line:2406
Function:fn_init_user_session_data


File:app/controllers/common/auth.php
Line:70
Function:fn_login_user


File:app/functions/fn.control.php
Line:699
Function:include


File:app/functions/fn.control.php
Line:455
Function:fn_run_controller


File:index.php
Line:25
Function:fn_dispatch




-->

CS-Cart 4.7.1


 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3812 posts

Posted 24 August 2016 - 01:24 PM #4

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

<!--


Tygh\Exceptions\AException


Message
Column 'order_id' cannot be null (1048)REPLACE INTO cscart_user_session_products (`user_id`, `timestamp`, `type`, `user_type`, `item_id`, `item_type`, `product_id`, `amount`, `price`, `session_id`, `ip_address`, `company_id`, `order_id`, `extra`) VALUES (1039, 1472038825, 'C', 'R', 175690165, 'P', 634, 1, 12, '8e7fd9384406cf72f9f49c252181e843-1-C', '49245bb4', 1, NULL, 'a:29:{s:7:\"user_id\";s:4:\"1039\";s:9:\"timestamp\";s:10:\"1450404823\";s:4:\"type\";s:1:\"C\";s:9:\"user_type\";s:1:\"R\";s:7:\"item_id\";s:9:\"175690165\";s:9:\"item_type\";s:1:\"P\";s:10:\"product_id\";i:634;s:6:\"amount\";i:1;s:5:\"price\";d:12;s:10:\"session_id\";s:36:\"d79dbb3bc10d26e9cc0a7464b3fc3c15_1_C\";s:10:\"ip_address\";s:8:\"49d26aae\";s:10:\"company_id\";s:1:\"1\";s:8:\"order_id\";N;s:12:\"product_code\";s:6:\"A-133A\";s:7:\"product\";s:28:\"A-133A Tzute Pocket Passport\";s:15:\"product_options\";a:0:{}s:12:\"stored_price\";s:1:\"N\";s:9:\"main_pair\";a:5:{s:7:\"pair_id\";s:4:\"3538\";s:8:\"image_id\";s:1:\"0\";s:11:\"detailed_id\";s:4:\"4952\";s:8:\"position\";s:1:\"0\";s:8:\"detailed\";a:8:{s:10:\"image_path\";s:70:\"http://www.tld.com/images/detailed/4/A-133A.jpg?t=1449688534\";s:3:\"alt\";s:0:\"\";s:7:\"image_x\";s:3:\"496\";s:7:\"image_y\";s:3:\"496\";s:15:\"http_image_path\";s:70:\"http://www.tld.com/images/detailed/4/A-133A.jpg?t=1449688534\";s:16:\"https_image_path\";s:71:\"https://www.tld.com/images/detailed/4/A-133A.jpg?t=1449688534\";s:13:\"absolute_path\";s:55:\"/home/tld/public_html/images/detailed/4/A-133A.jpg\";s:13:\"relative_path\";s:21:\"detailed/4/A-133A.jpg\";}}s:5:\"extra\";a:2:{s:15:\"product_options\";a:0:{}s:18:\"unlimited_download\";s:1:\"N\";}s:15:\"stored_discount\";s:1:\"N\";s:12:\"amount_total\";i:1;s:12:\"options_type\";s:1:\"P\";s:15:\"exceptions_type\";s:1:\"F\";s:15:\"modifiers_price\";d:0;s:6:\"is_edp\";s:1:\"N\";s:12:\"edp_shipping\";s:1:\"N\";s:10:\"base_price\";d:12;s:12:\"category_ids\";a:3:{i:0;i:5;i:1;i:65;i:2;i:1;}s:13:\"display_price\";d:12;}')


Error at
app/Tygh/Database/Connection.php, line: 863


Backtrace
File:app/Tygh/Database/Connection.php
Line:458
Function:error


File:app/functions/fn.database.php
Line:129
Function:query


File:app/functions/fn.cart.php
Line:1552
Function:db_query


File:app/functions/fn.users.php
Line:1304
Function:fn_save_cart_content


File:app/functions/fn.users.php
Line:2406
Function:fn_init_user_session_data


File:app/controllers/common/auth.php
Line:70
Function:fn_login_user


File:app/functions/fn.control.php
Line:699
Function:include


File:app/functions/fn.control.php
Line:455
Function:fn_run_controller


File:index.php
Line:25
Function:fn_dispatch




-->

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21741 posts

Posted 24 August 2016 - 02:16 PM #5

Please take a look:

 

http://forum.cs-cart...-be-null-b1048b


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 24 August 2016 - 09:27 PM #6

Thanks eCom but URL not found 


CS-Cart 4.7.1


 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 24 August 2016 - 11:28 PM #7

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

 

https://gist.github....63d159cd1103fe4


CS-Cart 4.7.1


 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 24 August 2016 - 11:33 PM #8

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....63d159cd1103fe4

From this thread: http://forum.cs-cart...-be-null-b1048b


CS-Cart 4.7.1


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21741 posts

Posted 25 August 2016 - 07:07 AM #9

We are glad to hear that the issue is solved


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • n.armonis
  • Newbie
  • Members
  • Join Date: 07-Jul 13
  • 7 posts

Posted 04 October 2016 - 03:41 PM #10

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...t-be-null-1048/

 

Best regards,

Nick