Sudden Database Error

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.