Dear all,
My website got a problem, customer cannot submit order while checkout, after click the “SUBMIT MY ORDER” button, it jump to “Sorry, service is temporarily unavailable” page, anyone can help to solve it? thank you so much.
I take a vedio, please click the following link to see:
VID 20160504 WA0006 - YouTube
Thanks all.
Do you have any custom mod/addon?
thanks your reply.
I think I don’t have custom mod/addon, but I am not sure what is it.
The problem is i did nothing, but this error happen suddenly, is it cache problem?
How to clear cache?
Is payment method paypal?
Please go to config.local.php & activate the error mode (1).
Go to config.php & open development mode
When you will submit order , you will get a error … share here … or PM me with temporary credentials … I will help you
thanks your reply.
no, not paypal, choose any payment will get same result, it will jump to “Sorry, service is temporarily unavailable” page.
For clear cache … go to /home/your website root/var/cache
Del this directory & check
Thanks your reply vivekgpt48
I don’t have too much knowledge about computer…
I found config.local.php but I don’t know how to activate the error mode
I went to config.php but I don’t know how to open development mode
I went to /home/my website root/var/cache
I saw few folders(see attactment), am I need to delete all?
Yes delete all for delete cache
Please check this https://googleweblight.com/?lite_url=https://cscart4u.wordpress.com/2014/08/23/enable-debug-and-development-mode-in-cs-cart/&ei=v5yL-gwe&lc=en-IN&s=1&m=360&host=www.google.co.in&ts=1462392011&sig=APY536zdcztZknzl0LgrLMmff4AzU2C27g.
http://googleweblight.com/?lite_url=http://docs.cs-cart.com/4.3.x/developer_guide/getting_started/configuring_cscart.html&ei=-Q6-ijGo&lc=en-IN&s=1&m=360&host=www.google.co.in&ts=1462392122&sig=APY536wHrkqf08fbV4gFCGnOQhjJGDptyg
Please read this
PHP Deprecated
Message
mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
Error at
app/functions/fn.cart.php, line: 1096
Backtrace
File: app/functions/fn.cart.php
Line: 1096
Function: {closure}
File: app/functions/fn.cart.php
Line: 984
Function: fn_create_order_details
File: app/functions/fn.cart.php
Line: 1257
Function: fn_update_order
File: app/functions/fn.cart.php
Line: 7911
Function: fn_place_order
File: app/controllers/frontend/checkout.php
Line: 346
Function: fn_checkout_place_order
File: app/functions/fn.control.php
Line: 680
Function: include
File: app/functions/fn.control.php
Line: 451
Function: fn_run_controller
File: index.php
Line: 25
Function: fn_dispatch
PHP Notice
Message
Undefined variable: list_price
Error at
app/functions/fn.cart.php, line: 1122
Backtrace
File: app/functions/fn.cart.php
Line: 1122
Function: {closure}
File: app/functions/fn.cart.php
Line: 984
Function: fn_create_order_details
File: app/functions/fn.cart.php
Line: 1257
Function: fn_update_order
File: app/functions/fn.cart.php
Line: 7911
Function: fn_place_order
File: app/controllers/frontend/checkout.php
Line: 346
Function: fn_checkout_place_order
File: app/functions/fn.control.php
Line: 680
Function: include
File: app/functions/fn.control.php
Line: 451
Function: fn_run_controller
File: index.php
Line: 25
Function: fn_dispatch
Tygh\Exceptions\AException
Message
Column ‘discount’ cannot be null (1048)
INSERT INTO cscart_order_details (item_id
, order_id
, product_id
, product_code
, price
, discount
, amount
, profit
, weight
, weight1
, order_date
, extra
) VALUES (1041233088, 40583, 941, ‘’, 8, NULL, 1, 6.5, ‘40.00’, ‘40.00’, ‘2016-05-05’, ‘a:10:{s:15:"product_options";a:0:{}s:18:"unlimited_download";s:1:"N";s:11:"points_info";a:4:{s:9:"raw_price";d:80;s:5:"price";d:80;s:13:"display_price";d:80;s:6:"reward";d:10;}s:7:"product";s:15:"å°æŸ“髮梳掃";s:10:"company_id";s:1:"1";s:6:"is_edp";s:1:"N";s:12:"edp_shipping";s:1:"N";s:8:"discount";i:0;s:10:"base_price";d:8;s:12:"stored_price";s:1:"N";}’)
Error at
app/Tygh/Database.php, line: 714
Backtrace
File: app/Tygh/Database.php
Line: 359
Function: error
File: app/functions/fn.database.php
Line: 130
Function: query
File: app/functions/fn.cart.php
Line: 1132
Function: db_query
File: app/functions/fn.cart.php
Line: 984
Function: fn_create_order_details
File: app/functions/fn.cart.php
Line: 1257
Function: fn_update_order
File: app/functions/fn.cart.php
Line: 7911
Function: fn_place_order
File: app/controllers/frontend/checkout.php
Line: 346
Function: fn_checkout_place_order
File: app/functions/fn.control.php
Line: 680
Function: include
File: app/functions/fn.control.php
Line: 451
Function: fn_run_controller
File: index.php
Line: 25
Function: fn_dispatch
I think your site does have custom mods as this table cscart_order_details's structure is different from default cs-cart one. Have you tried to contact your developer?
For Solution Please PM me.
Yes I agree with cscartrocks , your store have a custom code that putting down your site.
Thanks all, I forward the error message to my developer already, they will try to fix it, hope will recover very soon.
Thanks again.