great work guys

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.

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>
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

my problem is solved. This was caused by 3rd party app which i guess is not compatible with newest abantecart.
I had to uninstall it and now its working.

Thanks for your help

Hello guys,
Can you pleas tell me if it is possible to limit products to only one payment option?
i 3 different payment options (Credit cart, bank and cash on delivery) and i would like to limit some of my products to only bank payments and i dont know how to do it if possible at all?
Also some products i have on stock and i can accept "cash on delivery" payment but for some other products which i dropship (i ship from China directly to my customer after i receive payment) and for these products i also want to limit only to bank and paypal payment option and i cant accept "cash on delivery"
Do you have any suggestions?

Thanks in advance

and this will not affect my website functionality?

i did and the problem is still here. Any other suggestion ?