Magento - Trouble Shoot Error

Tamamlanmış İlan edilme: Dec 7, 2015 Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

We are unable to login to the backend of Magento. We get this error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'SUM((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(ma' in 'field list', query was: SELECT `SUM((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(main_table.base_tax_refunded, 0) - IFNULL(main_table.base_shipping_refunded, 0))) * main_table`.`base_to_global_rate)` AS `lifetime`, `AVG((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(main_table.base_tax_refunded, 0) - IFNULL(main_table.base_shipping_refunded, 0))) * main_table`.`base_to_global_rate)` AS `average` FROM `sales_flat_order` AS `main_table` WHERE ([url removed, login to view] NOT IN('canceled')) AND ([url removed, login to view] NOT IN('new', 'pending_payment'))

Magento

Proje NO: #9070835

Proje hakkında

3 teklif Uzak proje Aktif Dec 7, 2015

Seçilen:

anil31091

Hi there, Hope you are doing great. i ll resolve it now. This is Anil Rajput having 3+ years of solid magento development experience. Worked on various magento Stores as well developed extensions. Note: Fr Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 25%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(39 Değerlendirme)
5.8

Bu iş için 3 freelancer ortalamada $23 teklif veriyor

ntlabs

Hi, This is a few mins fix. I can get this done right away. Just give the ftp access and administrator username and password. I need to access the db where it needs to be fixed. No need any payment until the j Daha Fazla

$20 USD in 0 gün içinde
(14 Değerlendirme)
3.8
sureshsarathy

Hi Sir/Madam, Thank you for giving opportunity for biding... we have gone through your requirements and we will make the site according to your exact requirements. We have 5 years experience in magento, prestashop,dr Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(20 Değerlendirme)
4.1