Browse Stores
Antiques & Art
(3)
Boats
(1)
Collectables
(13)
Computing
(6)
Electronics
(2)
Everything Else
(5)
Farm & Garden
(3)
Firearms and Weapons
(88)
Gaming
(7)
Health
(1)
Home and Garden
(16)
Music
(1)
Sports
(3)
Tools
(85)
Toys & Games
(2)
[Cube\Exception]
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #52 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'goodfind_newauction.l.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT u.*, l.id AS listing_id FROM ppb_users AS u LEFT JOIN ppb_listings AS l ON l.user_id = u.id WHERE (u.store_category_id IN (1140, 1149, 1150, 1151, 1152, 1153, 1168, 1154, 1158, 1155, 1156, 1157, 1160, 1159, 1161, 1162, 1169, 1172, 1163, 1164, 1165, 1166, 1167, 1170, 1171)) AND (u.active = 1) AND (u.approved = 1) AND (u.store_active = 1) AND (l.list_in != 'site') AND (l.closed = 0) AND (l.deleted = 0) AND (l.active = 1) AND (l.approved = 1) GROUP BY u.id ORDER BY u.created_at DESC LIMIT 20
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #52 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'goodfind_newauction.l.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT u.*, l.id AS listing_id FROM ppb_users AS u LEFT JOIN ppb_listings AS l ON l.user_id = u.id WHERE (u.store_category_id IN (1140, 1149, 1150, 1151, 1152, 1153, 1168, 1154, 1158, 1155, 1156, 1157, 1160, 1159, 1161, 1162, 1169, 1172, 1163, 1164, 1165, 1166, 1167, 1170, 1171)) AND (u.active = 1) AND (u.approved = 1) AND (u.store_active = 1) AND (l.list_in != 'site') AND (l.closed = 0) AND (l.deleted = 0) AND (l.active = 1) AND (l.approved = 1) GROUP BY u.id ORDER BY u.created_at DESC LIMIT 20
Our website uses cookies. By continuing, you consent to the use of cookies on your device, unless you have disabled them from your browser.