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 = '1' order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

1114 - The table 'sessions' is full

update sessions set expiry = '1790144723', value = 'sessiontoken|s:32:\"b421b9ef332e077e4bc2451b39c4ac1c\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"EUR\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:2:{i:0;a:4:{s:4:\"page\";s:25:\"product_reviews_write.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:2:{s:8:\"language\";s:2:\"en\";s:11:\"products_id\";s:3:\"150\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:9:\"login.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:26:\"l1ufeb9ffsq717fb3ddcq7t65l\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:4:{s:4:\"page\";s:25:\"product_reviews_write.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:2:{s:8:\"language\";s:2:\"en\";s:11:\"products_id\";s:3:\"150\";}s:4:\"post\";a:0:{}}}' where sesskey = 'l1ufeb9ffsq717fb3ddcq7t65l'

[TEP STOP]