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?

Improve this question
7
  • 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.
    – laketuna
    Commented Jul 22, 2015 at 14:25
  • roll back the code ? you mean a magento system backup ?
    – Mattew
    Commented Jul 22, 2015 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.
    – laketuna
    Commented Jul 22, 2015 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
    Commented Jul 22, 2015 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).
    – laketuna
    Commented Jul 22, 2015 at 16:21

1 Answer 1

Reset to default
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

Improve this answer
6
  • I'll try and tell you the result in the evening! thanks in the meanwhile
    – Mattew
    Commented Jul 25, 2015 at 12:57
  • That worked! Thanks What do you mean with the customer grid and the inability to reindex category/products ?
    – Mattew
    Commented Jul 25, 2015 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
    Commented Jul 28, 2015 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
    Commented Aug 16, 2015 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
    Commented Aug 16, 2015 at 5:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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