Hi all,
Could someone please help me?
I am using V3.0.6
I get an “Error_Occurred” message whenever I connect on my site.
And we now use cdn. And we don't change any script.
We read “Error occured” topic.
http://forum.cs-cart…-error-occured/
We edit file & upload. Result is…
Database error: Can't find record in 'cscart_cache' (1032)
Invalid query: SELECT data, expiry FROM cscart_cache WHERE name = 'lang_cache.C_GET_index_index_EN_USD' AND company_id = 0
Backtrace:
File: /home/xxxx/public_html/core/fn.database.php
Line: 267
Function: db_error
File: /home/xxxx/public_html/core/fn.database.php
Line: 78
Function: db_query
File: /home/xxxx/public_html/core/classes/cache_backend/mysql.php
Line: 64
Function: db_get_row
File: /home/xxxx/public_html/core/classes/registry.php
Line: 252
Function: get
File: /home/xxxx/public_html/core/classes/registry.php
Line: 280
Function: _cache_actions
File: /home/xxxx/public_html/core/classes/registry.php
Line: 221
Function: _get_cache
File: /home/koreanwh/public_html/core/fn.init.php
Line: 1004
Function: register_cache
File: /home/xxxx/public_html/core/fn.init.php
Line: 1141
Function: fn_init_cache_level
File: /home/xxxx/public_html/init.php
Line: 133
Function: fn_init
File: /home/xxxx/public_html/index.php
Line: 18
Function: require
Hoping someone has a solution.
Thanks Wayne
Where do you get this table cscart_cache?
Thank you for your attention. We use vps server + cloudflare cdn. We think vps server. But it is a don't correct.
Fatal error[color=#000000][font=Gulim][size=1]: Allowed memory size of 536870912 bytes exhausted (tried to allocate 1140270 bytes) in[/size][/font][/color]/home/xxxx/public_html/core/db/mysqli.php[color=#000000][font=Gulim][size=1] on line [/size][/font][/color]117
Dear cscartrocks. Thank you for your reply. We solve it. We check our vps “[color=#282828][font=arial, verdana, tahoma, sans-serif][size=4]cscart_cache” Thank you!![/size][/font][/color]
We receive our hosting company.
They say…
[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3]I have looked into the situation and I noticed that your koreanwh_cscart database is quite large in size. It is over 1.8 GB in size, and there also seem to be a large number of slow MySQL queries executed towards the database. I have copied the slow MySQL slow queries on your VPS into a file named [/size][/font][/color]slow-queries.txt[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3] in the home folder of your[/size][/font][/color]koreanwh[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3] cPanel account for you to preview. [/size][/font][/color]
[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3]Having a database that large would likely lead to issues such as this. MySQL queries should generally not need more than 1 second to be executed. In addition, your PHP scripts must be optimized to query the database fast and access only information which is needed. [/size][/font][/color]
[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3]The issue appears to be with the way your applications handles big sets of data, coupled with the fact that it is not well optimized.[/size][/font][/color]
[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3]I can advise you to check the following links for more details how to optimize your MySQL database and PHP scripts:[/size][/font][/color]
[url=“http://phplens.com/lens/php-book/optimizing-debugging-php.php”]http://phplens.com/lens/php-book/optimizing-debugging-php.php[/url]
[url=“Four Ways to Optimize Your MySQL Database | Developer.com”]http://www.developer.com/db/article.php/3667831/Four-Ways-to-Optimize-Your-MySQL-Database.htm[/url]
[url=“Analyze - WebSiteOptimization.com”]http://www.websiteoptimization.com/services/analyze/[/url][color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3].[/size][/font][/color]
[color=#666666][font=Arial, Tahoma, Verdana, sans-serif][size=3]However, I would also strongly advise you to contact a professional developer, who is closely familiar with MySQL and possesses the required skill set to dedicate the time and help optimize your site and database to help prevent situations such as this.[/size][/font][/color]
We want know… this is a have a all cs-cart version?
do you have statistics turned on, Admin>statistics. If so choose clear stats to enable some space. Then admin>database > optimize
Also do the same with admin>logs
Then clear the cache