Please any advice? Content User IP Time Database (error)
Error: Unknown column ‘cscart_order_details.order_id’ in ‘where clause’ (1054)
Query: SELECT SUM(total) FROM cscart_orders WHERE cscart_order_details.order_id IN (‘1’, ‘3’, ‘4’, ‘5’, ‘7’, ‘8’, ‘9’, ‘10’, ‘10’, ‘11’, ‘12’, ‘13’, ‘14’, ‘14’, ‘15’, ‘16’, ‘17’, ‘17’, ‘18’, ‘21’, ‘21’, ‘22’, ‘22’, ‘23’, ‘24’, ‘25’, ‘25’, ‘27’, ‘27’, ‘28’, ‘29’, ‘29’, ‘29’, ‘30’, ‘33’, ‘34’, ‘35’, ‘37’, ‘40’, ‘40’, ‘43’, ‘44’, ‘48’, ‘52’, ‘52’, ‘52’, ‘55’, ‘55’, ‘55’, ‘57’, ‘58’, ‘59’, ‘59’, ‘60’, ‘64’, ‘65’, ‘68’, ‘69’, ‘71’, ‘71’, ‘73’, ‘73’, ‘73’, ‘73’, ‘73’, ‘73’, ‘74’, ‘78’, ‘78’, ‘79’, ‘80’, ‘80’, ‘83’, ‘84’, ‘86’, ‘88’, ‘89’, ‘89’, ‘90’, ‘90’, ‘90’, ‘90’, ‘90’, ‘90’, ‘90’, ‘90’, ‘90’, ‘92’, ‘92’, ‘94’, ‘94’, ‘94’, ‘94’, ‘95’, ‘95’, ‘98’, ‘99’, ‘99’, ‘100’, ‘100’, ‘102’, ‘103’, ‘103’, ‘104’, ‘104’, ‘106’, ‘107’, ‘109’, ‘109’, ‘109’, ‘111’, ‘112’, ‘113’, ‘114’, ‘117’, ‘118’, ‘118’, ‘121’, ‘121’, ‘126’, ‘126’, ‘127’, ‘127’, ‘127’, ‘132’, ‘133’, ‘134’, ‘134’, ‘134’, ‘136’, ‘136’, ‘136’, ‘136’, ‘136’, ‘146’, ‘146’, ‘150’, ‘151’, ‘151’, ‘152’, ‘153’, ‘154’, ‘155’, ‘157’, ‘159’, ‘160’, ‘160’, ‘161’, ‘161’, ‘163’, ‘163’, ‘170’, ‘171’, ‘172’, ‘175’, ‘175’, ‘178’, ‘179’, ‘181’, ‘181’, ‘181’, ‘181’, ‘181’, ‘181’, ‘182’, ‘185’, ‘186’, ‘186’, ‘187’, ‘193’, ‘196’, ‘197’, ‘197’, ‘197’, ‘198’, ‘198’, ‘198’, ‘198’, ‘199’, ‘200’, ‘200’, ‘203’, ‘204’, ‘204’, ‘205’, ‘205’, ‘207’, ‘207’, ‘209’, ‘212’, ‘212’, ‘214’, ‘217’, ‘218’, ‘221’, ‘221’, ‘222’, ‘222’, ‘227’, ‘227’, ‘228’, ‘231’, ‘232’, ‘235’, ‘236’, ‘237’, ‘237’, ‘238’, ‘242’, ‘242’, ‘242’, ‘243’, ‘243’, ‘252’, ‘252’, ‘254’, ‘254’, ‘255’, ‘257’, ‘263’, ‘263’, ‘263’, ‘267’, ‘268’, ‘268’, ‘269’, ‘271’, ‘271’, ‘272’, ‘273’, ‘274’, ‘274’, ‘276’, ‘276’, ‘277’, ‘277’, ‘280’, ‘281’, ‘282’, ‘282’, ‘282’, ‘284’, ‘284’, ‘284’, ‘286’, ‘286’, ‘286’, ‘288’, ‘291’, ‘292’, ‘292’, ‘293’, ‘296’, ‘296’, ‘296’, ‘297’, ‘300’, ‘302’, ‘302’, ‘304’, ‘304’, ‘305’, ‘306’, ‘306’, ‘307’, ‘307’, ‘307’, ‘307’, ‘308’, ‘308’, ‘308’, ‘312’, ‘312’, ‘312’, ‘315’, ‘318’, ‘319’, ‘320’, ‘320’, ‘320’, ‘320’, ‘321’, ‘321’, ‘322’, ‘323’, ‘324’, ‘325’, ‘325’, ‘325’, ‘326’, ‘326’, ‘328’, ‘329’, ‘330’, ‘331’, ‘332’, ‘334’, ‘334’, ‘335’, ‘335’, ‘336’, ‘336’, ‘336’, ‘338’, ‘339’, ‘339’, ‘340’, ‘340’, ‘343’, ‘344’, ‘345’, ‘345’, ‘346’, ‘348’, ‘348’, ‘349’, ‘352’, ‘353’, ‘354’, ‘360’, ‘361’, ‘361’, ‘362’, ‘363’, ‘363’, ‘363’, ‘364’, ‘364’, ‘365’, ‘365’, ‘366’, ‘367’, ‘368’, ‘371’, ‘373’, ‘374’, ‘375’, ‘377’, ‘378’, ‘378’, ‘381’, ‘382’, ‘383’, ‘383’, ‘384’, ‘384’, ‘388’, ‘388’, ‘389’, ‘389’, ‘390’, ‘390’, ‘391’, ‘391’, ‘393’, ‘393’, ‘393’, ‘396’, ‘397’, ‘399’, ‘400’, ‘403’, ‘403’, ‘408’, ‘410’, ‘411’, ‘411’, ‘411’, ‘411’, ‘412’, ‘413’, ‘413’, ‘415’, ‘418’, ‘424’, ‘424’, ‘429’, ‘430’, ‘433’, ‘435’, ‘436’, ‘436’, ‘438’, ‘438’, ‘440’, ‘440’, ‘442’, ‘442’, ‘442’, ‘448’) AND timestamp BETWEEN 1388527200 AND 1391205600 AND status != ‘T’ AND is_parent_order != ‘Y’
[size=3]/home/vapeking/public_html/admin.php (fn_dispatch): 26[/size]
/home/vapeking/public_html/app/functions/fn.control.php (fn_run_controller): 380
/home/vapeking/public_html/app/functions/fn.control.php (include): 592
/home/vapeking/public_html/app/controllers/backend/sales_reports.php (fn_get_report_statistics): 213
/home/vapeking/public_html/app/functions/fn.sales_reports.php (db_get_field): 478
/home/vapeking/public_html/app/functions/fn.database.php (call_user_func_array): 66
/home/vapeking/public_html/app/Tygh/Database.php (getField): 167
/home/vapeking/public_html/app/Tygh/Database.php (query): 322
What version?
That I think was fixed in 4.1.3 or will be in 4.1.4
http://forum.cs-cart…ror-in-reports/
You must have a serious db issue if it can't find the order_I'd since it is the primary key of that table.