Author Topic: AbanteCart core v.1.2.6 Error  (Read 4570 times)

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
AbanteCart core v.1.2.6 Error
« 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 <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>
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: AbanteCart core v.1.2.6 Error
« Reply #1 on: April 27, 2016, 07:21:47 AM »
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

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: AbanteCart core v.1.2.6 Error
« Reply #2 on: April 27, 2016, 07:38:38 AM »
ok thanks. after they tell me i will post here

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: AbanteCart core v.1.2.6 Error
« Reply #3 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.

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: AbanteCart core v.1.2.6 Error
« Reply #4 on: April 29, 2016, 11:39:07 AM »
is anyone able to help me with this. I am willing to pay ofcourse

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: AbanteCart core v.1.2.6 Error
« Reply #5 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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod