Hi,
I am hosted on Hostgator and my cs cart was running fine for a month and now all of the sudden I am receiving this error…is this something I can fix on CS-Cart files or something my host has to do? Thanks for the help.
Database error: Out of memory (Needed 8388572 bytes) (5)
Invalid query: SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tag_links.user_id, COUNT(cscart_tag_links.tag_id) as popularity, COUNT(DISTINCT(cscart_tag_links.user_id)) as users, cscart_tags.tag, cscart_tags.status FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1 AND cscart_tag_links.object_type = ‘P’ AND cscart_tag_links.object_id = ‘29778’ GROUP BY cscart_tags.tag_id ORDER BY cscart_tags.tag asc
Backtrace:
File: /home/user/public_html/core/fn.database.php
Line: 296
Function: db_error
File: /home/user/public_html/core/fn.database.php
Line: 56
Function: db_query
File: /home/user/public_html/addons/tags/func.php
Line: 107
Function: db_get_hash_array
File: /home/user/public_html/addons/tags/func.php
Line: 284
Function: fn_get_tags
File: /home/user/public_html/core/fn.control.php
Line: 66
Function: fn_tags_get_additional_product_data
File: /home/user/public_html/core/fn.catalog.php
Line: 409
Function: fn_set_hook
File: /home/user/public_html/core/fn.cms.php
Line: 736
Function: fn_gather_additional_product_data
File: /home/user/public_html/core/templater_plugins/function.block.php
Line: 232
Function: fn_get_block_items
File: /home/user/public_html/core/templater_plugins/function.block.php
Line: 64
Function: smarty_function_block_output
File: /home/user/public_html/core/templater_plugins/function.block.php
Line: 32
Function: smarty_function_group_output
File: /home/user/public_html/var/compiled/customer/%%72^72D^72DAF6E8%%main.tpl.php
Line: 11
Function: smarty_function_block
File: /home/user/public_html/core/class.templater.php
Line: 76
Function: include
File: /home/user/public_html/var/compiled/customer/%%45^45E^45E480CD%%index.tpl.php
Line: 347
Function: _smarty_include
File: /home/user/public_html/lib/templater/Smarty.class.php
Line: 1258
Function: include
File: /home/user/public_html/lib/templater/Smarty.class.php
Line: 1108
Function: fetch
File: /home/user/public_html/core/class.templater.php
Line: 110
Function: display
File: /home/user/public_html/core/fn.control.php
Line: 493
Function: display
File: /home/user/public_html/index.php
Line: 15
Function: fn_dispatch
Hostgator server running low on power probably, Change from hostgator or get them to increase your limit.
Is it intermittant, you could change config.local.php
from this
@ini_set(‘memory_limit’, ‘48M’);
to this
@ini_set(‘memory_limit’, ‘128M’);
But not recommended for permanent fix, just if you are desperate.
John
Thanks for the prompt respond…what will be the permanent fix?
[quote name=‘super9xman’]Thanks for the prompt respond…what will be the permanent fix?[/quote]
Move from hostgator?
You could disable tags incase the problem exist as part of the database.
j.
Yea I am having to update to a VPS now…
Not sure why John believes that increasing the memory_limit from 48M is a temporary solution. Many sites that make use of lots of filters and features will require the site to use more memory. Same goes if you use the PDF modules or do larger product imports, etc.
128M should be good for most stores but don’t be afraid to go up from the distributed value of 48M. You probably do NOT need to upgrade your server package if you are happy with the performance of your current site.