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

parse error: unknown column: d_pricetm #107

Closed
nicdnepr opened this issue Oct 23, 2018 · 1 comment
Closed

parse error: unknown column: d_pricetm #107

nicdnepr opened this issue Oct 23, 2018 · 1 comment
Labels
status:to be verified Needs to be reproduced and validated. type:bug Bug

Comments

@nicdnepr
Copy link

nicdnepr commented Oct 23, 2018

What steps will reproduce the problem?

find()->select(['d_pricetm'=>new Expression('d_pricetm/66.40')])->limit(1)->all();

What's expected?

correct work

What do you get instead?

SQLSTATE[42000]: Syntax error or access violation: 1064 index itemdota: parse error: unknown column: d_pricetm
The SQL being executed was: SELECT d_pricetm/66.40 AS `d_pricetm` FROM `itemdota` LIMIT 1

direct sql

SELECT d_pricetm/66.40 AS `d_pricetm` FROM `itemdota` LIMIT 1

works no errors

Additional info

Q A
Yii version 2.0.15.1
Yii Sphinx version 2.0.11
Sphinx server version 2.2.11
PHP version 7
Operating system ubuntu
@samdark samdark added type:bug Bug status:to be verified Needs to be reproduced and validated. labels Oct 23, 2018
@nicdnepr
Copy link
Author

Sorry
It was wrong console
sql not works in sphinx console

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status:to be verified Needs to be reproduced and validated. type:bug Bug
Projects
None yet
Development

No branches or pull requests

2 participants