Can Somebody Help Me Understanding This Error?

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