Can somebody help me understanding this error ?
Error[color=#B94A48]Column ‘order_id’ in where clause is ambiguous [/color]b[/b][color=#B94A48] SELECT SUM(price * amount) FROM cscart_order_details LEFT JOIN cscart_orders ON (cscart_order_details.order_id = cscart_orders.order_id) WHERE order_id IN (‘16’, ‘17’, ‘19’, ‘21’, ‘22’, ‘24’, ‘26’, ‘29’, ‘33’, ‘34’, ‘35’, ‘37’, ‘38’, ‘39’, ‘40’, ‘41’, ‘43’, ‘43’, ‘44’, ‘45’, ‘46’, ‘50’, ‘53’, ‘54’, ‘59’, ‘60’, ‘61’, ‘63’, ‘68’, ‘71’, ‘72’, ‘74’, ‘76’, ‘77’, ‘79’, ‘80’, ‘82’, ‘83’, ‘84’, ‘85’, ‘86’, ‘87’, ‘88’, ‘90’, ‘91’, ‘92’, ‘93’, ‘95’, ‘97’, ‘99’, ‘100’, ‘103’, ‘104’, ‘105’, ‘106’, ‘108’, ‘109’, ‘110’, ‘111’, ‘114’, ‘115’, ‘116’, ‘117’, ‘117’, ‘118’, ‘119’, ‘121’, ‘123’, ‘126’, ‘131’, ‘132’, ‘133’, ‘142’, ‘143’, ‘144’, ‘146’, ‘154’, ‘175’, ‘176’, ‘187’, ‘189’, ‘192’, ‘193’, ‘193’, ‘194’, ‘199’, ‘200’, ‘208’, ‘214’, ‘215’, ‘226’, ‘229’, ‘232’, ‘233’, ‘235’, ‘237’, ‘237’, ‘238’, ‘240’, ‘242’, ‘243’, ‘244’, ‘246’, ‘249’, ‘253’, ‘256’, ‘259’, ‘262’, ‘266’, ‘270’, ‘272’, ‘273’, ‘274’, ‘275’, ‘277’, ‘283’, ‘286’, ‘289’, ‘290’, ‘291’, ‘291’, ‘291’, ‘291’, ‘293’, ‘293’, ‘294’, ‘300’, ‘304’, ‘305’, ‘306’, ‘314’, ‘318’, ‘318’, ‘336’, ‘337’, ‘343’, ‘344’, ‘349’, ‘357’, ‘358’, ‘359’, ‘360’, ‘361’, ‘363’, ‘366’, ‘377’, ‘378’, ‘383’, ‘385’, ‘393’, ‘394’, ‘394’, ‘394’, ‘401’, ‘413’, ‘416’, ‘418’, ‘426’, ‘432’, ‘436’, ‘442’, ‘447’, ‘448’, ‘461’, ‘461’, ‘470’, ‘472’, ‘482’, ‘483’, ‘485’, ‘486’, ‘493’, ‘496’, ‘518’, ‘729’) AND timestamp BETWEEN 1351717200 AND 1354395600 AND status != ‘T’ AND is_parent_order != ‘Y’ [/color]
Thank You.
I also get that error in the eports when changing tabs to Categories sales - Cost. Or Shipping Cost per order under More. Maybe a bug in REPORTS
Bug. This also needs to be qualified with the tablename or an alias.
[color=#B94A48]WHERE order_id
Yup. They are working on a fix
is there a fix already?
Jorden
It was fixed in 4.1.4
Check the bug tracker