News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

AbanteCart core v.1.2.6 Error

Started by popustda, April 27, 2016, 06:56:49 AM

Previous topic - Next topic

popustda

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 <b>/home/budicoo1/public_html/core/database/amysqli.php</b> on line <b>71</b>

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 <b>/home/budicoo1/public_html/core/database/amysqli.php</b> on line <b>106</b>
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

abolabo

please ask your hosting provider tech support.
Warning looks like some server restriction..
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

popustda

ok thanks. after they tell me i will post here

popustda

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.

popustda

is anyone able to help me with this. I am willing to pay ofcourse

abolabo

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.
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

Forum Rules Code of conduct
AbanteCart.com 2010 -