Browse Stores
0
Your shopping cart is empty.
-
Welcome, Guest
- Home
- Categories
- Stores
- Sale
- Live Auctions
- Wish List
- Sign Up / Sign In
[Cube\Exception]
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #59 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yourbidz_v8.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 (7483, 7492, 7493, 7494, 7495, 7496, 7497, 7498, 7499, 7500, 7501, 7502, 7510, 7503, 7504, 7505, 7506, 7507, 7508, 7509)) 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 #59 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yourbidz_v8.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 (7483, 7492, 7493, 7494, 7495, 7496, 7497, 7498, 7499, 7500, 7501, 7502, 7510, 7503, 7504, 7505, 7506, 7507, 7508, 7509)) 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.