update OSCOMMERCE

error messages and some client access functionality has been lost recently due to PHP upgrades by server I suspect.

Anyway - need to update the site and remove all error messages and allow for clients to register and log in and not be confused by these error messages

eg:

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'dnssuppl_shop.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price, pd.products_name from products p, products_description pd left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where p.products_id = pd.products_id and products_status = '1' and find_in_set('4', products_hide_from_groups) = 0 and find_in_set('4', categories_hide_from_groups) = 0 and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]

eg:

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'dnssuppl_shop.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where opa.products_id = '41664' and opa.orders_id = opb.orders_id and opb.products_id != '41664' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and find_in_set('4', products_hide_from_groups) = 0 and find_in_set('4', categories_hide_from_groups) = 0 group by p.products_id order by o.date_purchased desc limit 6

Навыки: PHP, OSCommerce, MySQL, HTML, Zen Cart

Показать больше: shipping modules dont update oscommerce admin, quick update oscommerce description, price update oscommerce, easy csv products date update oscommerce, easy update oscommerce, products attributes update oscommerce, oscommerce product automatic sync sql mysql, update oscommerce 2009, products update oscommerce xml, debug mode sql error 1114 table phpbb_sessions full, price update oscommerce addon, update oscommerce xls, quick quantity update oscommerce

ID проекта: #28349486