Ok so i did some research on :
Code:
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.web_log.user_id' which is not functionally
dependent on columns in GROUP BY clause; this is incompatible
with sql_mode=only_full_group_by
I then changed $products query in catalog/Googlefroogle.php
from:
Code:
$products_query = "SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight" . $additional_attributes . " FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)"
. $additional_tables .
"WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
AND (
p.products_image IS NOT NULL
OR p.products_image != ''
OR p.products_image != '" . PRODUCTS_IMAGE_NO_IMAGE . "'
)
GROUP BY pd.products_name
ORDER BY p.products_id ASC" . $limit . $offset . ";";
To
Code:
$products_query = "SELECT p.products_id, p.products_model, pd.products_description, pd.products_name, p.products_image, p.products_tax_class_id, p.products_price, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, p.master_categories_id, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight" . $additional_attributes . " FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON (p2c.products_id = p.products_id)" . $additional_tables;
$order_by .= " GROUP BY pd.products_name, p.products_id";
$where = " WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = " . (int) $languages->fields['languages_id'] . "
AND (
p.products_image IS NOT NULL
AND p.products_image != ''
AND p.products_image != '" . PRODUCTS_IMAGE_NO_IMAGE . "'
)";
This fixed the problem and generated the feed.
I now get a shipping rate log error warning
[12-Feb-2020 16:56:01 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=33&y=6&key=fcbfcf8577, IP address: 100.2.167.42#1 google_base->shipping_rate() called at [/home/teer/public_html/includes/classes/google_base.php:338]
#2 google_base->create_regular_product() called at [/home/teer/public_html/googlefroogle.php:479]
--> PHP Warning: A non-numeric value encountered in /home/teer/public_html/includes/classes/google_base.php on line 590.
thanx
Mike
Bookmarks