Error_Occurred V3.0.6

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.


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


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=“Four Ways to Optimize Your MySQL Database |”][/url]

[url=“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