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

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '3' order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

1114 - The table 'sessions' is full

update sessions set expiry = '1790131408', value = 'sessiontoken|s:32:\"09977090c4c45d6867fb36fd9ed2944b\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:1:{i:152;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:170;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"97075\";s:12:\"content_type\";b:0;}language|s:7:\"espanol\";languages_id|s:1:\"3\";currency|s:3:\"EUR\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:2:{i:0;a:4:{s:4:\"page\";s:19:\"product_reviews.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:2:{s:6:\"action\";s:7:\"buy_now\";s:11:\"products_id\";s:3:\"152\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:26:\"f4f5ks19mm37rj2ukgij64b2e6\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}' where sesskey = 'f4f5ks19mm37rj2ukgij64b2e6'

[TEP STOP]