2

I had this error message showing after I tried to upgrade the Magento 1.9.1 cm_redisSession from the magento connect interface:

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 (main_table.status NOT IN('canceled')) AND (main_table.state NOT IN('new', 'pending_payment'))";

Now I can't log in into the backend. Can you help me? What if I roll back a DB backup?

  • This has happened to me on a 1.9.1 to 1.9.2 upgrade. You can roll back the code, and it should work. What I've found is that the DB was fine, but the queries were constructed with incorrect encapsulations. I have no solution as this point. – musicliftsme Jul 22 '15 at 14:25
  • roll back the code ? you mean a magento system backup ? – Mattew Jul 22 '15 at 14:38
  • No, version control-revert. If you don't version-control, then you can try undoing the update. It was a code issue for me, not database. – musicliftsme Jul 22 '15 at 15:08
  • Because i'm not expert in this kind of situation, could you please explain me how to do that reversion? i remember you that the problem started when i tried to upgrade the cm_redissession module and that now i cannot access the backend. – Mattew Jul 22 '15 at 16:05
  • Sorry, I can't. It involves replacing community/Cm/RedisSession with earlier files you've had (and possibly some other files - I don't know). – musicliftsme Jul 22 '15 at 16:21
4

replace app/code/core/Zend with a version from 1.9.2 CE

The error your seeing is on the dashboard, the rest of your admin will work except for the customer grid and the inability to reindex category/products

  • I'll try and tell you the result in the evening! thanks in the meanwhile – Mattew Jul 25 '15 at 12:57
  • That worked! Thanks What do you mean with the customer grid and the inability to reindex category/products ? – Mattew Jul 25 '15 at 13:08
  • Before you did the replacement of those files, I found reindexing and the customer grid were broken. Once those files were replaced it all becomes fixed. – elfling Jul 28 '15 at 5:53
  • Yeah this worked for me too!! But have not tested anything (like, basically all magento functions ie: add to cart, log in, edit account..etc..its a long list for both frontend & admin) . Keep in mind im updating to 1.9.2 form 1.7. – BENN1TH Aug 16 '15 at 5:42
  • EDIT: index is completely locked with Stock "Status Index process is working now. Please try run this process later."..But customer grid works ok! Cleared cache as well. – BENN1TH Aug 16 '15 at 5:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.