AbanteCart Community

Shopping Cart Operations => Support => Topic started by: popustda on April 27, 2016, 06:56:49 AM

Title: AbanteCart core v.1.2.6 Error
Post by: popustda on April 27, 2016, 06:56:49 AM: Hello guys,
i just went to check my logs and i notice this error message repeats every 40mins.
Can some1 tell me if its something critical or not important?

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
warning: AbanteCart core v.1.2.6 Error while sending QUERY packet. PID=12287 in /home/budicoo1/public_html/core/database/amysqli.php on line 71

SELECT DISTINCT
e.extension_id,
e.type,
e.key,
e.category,
e.priority,
e.version,
e.license_key,
e.date_installed,
e.date_modified,
e.date_added,
s.store_id,
st.alias as store_name,
s.value as status
FROM 9u9_extensions e
LEFT JOIN 9u9_settings s ON ( TRIM(s.`group`) = TRIM(e.`key`) AND TRIM(s.`key`) = CONCAT(TRIM(e.`key`),'_status') )
LEFT JOIN 9u9_stores st ON st.store_id = s.store_id
WHERE e.`type` IN ('extensions', 'payment', 'shipping', 'template', 'language')AND COALESCE(s.`store_id`,0) = '0' in /home/budicoo1/public_html/core/database/amysqli.php on line 106
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Title: Re: AbanteCart core v.1.2.6 Error
Post by: abolabo on April 27, 2016, 07:21:47 AM: please ask your hosting provider tech support.
Warning looks like some server restriction..
Title: Re: AbanteCart core v.1.2.6 Error
Post by: popustda on April 27, 2016, 07:38:38 AM: ok thanks. after they tell me i will post here
Title: Re: AbanteCart core v.1.2.6 Error
Post by: popustda on April 28, 2016, 02:26:59 AM: This is what they replied to me at A2 Hosting and as usual they are not very helpful.

Hello,

This error appears to be thrown by AbanteCart and seems to indicate an error with an SQL query performed in the file specified in the error message. Whether or not this is critical to the function of your application is outside of our scope of support. If there is a specific server setting required for this statement to complete successfully please advise on what that may be and we will be happy to assist.
Title: Re: AbanteCart core v.1.2.6 Error
Post by: popustda on April 29, 2016, 11:39:07 AM: is anyone able to help me with this. I am willing to pay ofcourse
Title: Re: AbanteCart core v.1.2.6 Error
Post by: abolabo on April 29, 2016, 01:39:52 PM: i do not see any problem with sql queries.
i guess it's a problem with mysql configuration (database cache, timeouts, threading etc) of your host.