Magento - Trouble Shoot Error
$10-30 USD
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'))
Proje NO: #9070835
Proje hakkında
Seçilen:
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
Bu iş için 3 freelancer ortalamada $23 teklif veriyor
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
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