Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

zend error on magento v1.7.0.2 #103

Closed
hgati opened this issue Jan 28, 2017 · 4 comments
Closed

zend error on magento v1.7.0.2 #103

hgati opened this issue Jan 28, 2017 · 4 comments

Comments

@hgati
Copy link

hgati commented Jan 28, 2017

magento category page error

SQLSTATE[42S22] [1054] Unknown column 'FLOOR((ROUND((e.min_price) * 0.000933593495, 2)) / 10) + 1' in 'order clause', query was: SELECT FLOOR((ROUND((e.min_price) * 0.000933593495, 2)) / 10) + 1 AS range, COUNT(*) AS count FROM catalog_product_index_price AS e
INNER JOIN catalog_category_product_index AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='303' WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 0.000933593495, 2)) / 10) + 1 ORDER BY FLOOR((ROUND((e.min_price) * 0.000933593495, 2)) / 10) + 1 ASC

#0 /var/www/htdocs/project/root/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute()
#1 /var/www/htdocs/project/vendor/magento/zendframework1/library/Zend/Db/Statement.php(323): Varien_Db_Statement_Pdo_Mysql->_execute()
#2 /var/www/htdocs/project/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()

php-redis-session-abstract based on zendframework v1.12
php-redis-session-abstract doesn't work on magento v1.7.0.2 (zendframework v1.11.1)

@colinmollenhour
Copy link
Owner

I fail to see how this is related to Cm_RedisSession...

@hgati
Copy link
Author

hgati commented Jan 28, 2017

i added on my composer.json - it's sql error
snap1

i removed on my composer.json - it works
snap2

@colinmollenhour
Copy link
Owner

Sorry, I have no idea why that would be.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants