Jump to content

 

azri445

Member Since 06 Jan 2018
Offline Last Active Nov 22 2018 07:54 AM
-----

Topics I've Started

Free Shipping

16 November 2018 - 02:42 AM

is there any way? if i want to set FREE SHIPPING, the normal shipping rate wont show up?

 

what happen now... if i set free shipping, other rate also appear.


Uploading Logo

04 September 2018 - 04:34 AM

Does anyone encounter uploading vendor logo problem? i try to upload it manually from the backend, the vendor logo not appear.


Cs-Cart Database After Upgrade

25 August 2018 - 01:30 AM

i have a problem with our server after upgrading to the latest update. Our inode and cpu usage exceed, Is there anyone encounter the same problem with me? Any MYSQL developer here can help me?

 

Suddenly our server exceed starting 22nd August, even no visitor .

 

The CPU usage is caused by the rotuku.com website. For the past 24 hours the /home/rotuku69/public_html/index.php script was executed 22600 times:
 

Code:
=== Top 10 Executed Scripts ============================================
Count Script Local Path
----- --------------------------- ------------------------------------
22600 http://rotuku.com/index.php/home/rotuku69/public_html/index.php
1 http://rotuku.com/api.php/home/rotuku69/public_html/api.php
------------------------------------------------------------------------


Additionally, the database of the website generates slow queries:
 

Code:
=== TOP 5 of 5 (total) Slow Queries for the past 24 hours ==========
1. Executed 16h 22m 29s ago for 4.116759 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 4.116759 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000074
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
2. Executed 17h 47s ago for 2.224138 sec on Database --> rotuku69_mve
Date: 2018-08-24 14:54:38 Query_time: 2.224138 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000104
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
3. Executed 4h 58m 51s ago for 2.198587 sec on Database --> rotuku69_mve
Date: 2018-08-25 02:56:34 Query_time: 2.198587 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000098
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
4. Executed 16h 22m 29s ago for 1.730769 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 1.730769 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000057
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_stored_sessions (`session_id`, `data`, `expiry`) VALUES ('35ecddb03175be3aac40d0873a80a4cc-C', 'settings|a:2:{s:14:\"cart_languageC\";a:1:{s:5:\"value\";s:2:\"zh\";}s:19:\"secondary_currencyC\";a:2:{s:5:\"value\";s:3:\"PHP\";s:6:\"expiry\";i:1535693568;}}', 1535095968);
------------------------------------------------------------------------------------------------
5. Executed 16h 22m 29s ago for 1.5912 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 1.591200 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050165
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 SELECT name, value FROM cscart_abt__ut_settings WHERE company_id = 0 AND lang_code = 'vi' AND name = 'show_button_buy_in_product_lists';
------------------------------------------------------------------------------------------------


related to the cscart_cache_handlers. 

The slow queries in question were most likely the cause for the reported issue.


Cronjob

24 August 2018 - 01:38 AM

Does anyone has the command code for clearing cache on cs-cart via cronjob in cpanel?

 

 


Cs-Cart Cause Inode Exceed

21 August 2018 - 10:32 PM

Suddenly after  upgrade, we have problem with our inode, does anyone encounter the same problem with me?

 

The Inode issue is related to the cache folder of your website increasing very rapidly which is located in: 

/home/********/public_html/var/cache

To resolve this I would advise you to contact your website developer to limit the cache size of your website so it does not grow so rapidly and exceed the inode count limit on your account.