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

MSSQL Union error #8434

Closed
MDjet opened this issue May 15, 2015 · 2 comments
Closed

MSSQL Union error #8434

MDjet opened this issue May 15, 2015 · 2 comments

Comments

@MDjet
Copy link

MDjet commented May 15, 2015

I have MSSQL Server 2012
I use and configurate this module https://github.com/zelenin/yii2-i18n-module
when module is get translate in
DbMessageSource.php
I get this error

SQLSTATE[07002]: [Microsoft][ODBC Driver 11 for SQL Server]COUNT field incorrect or syntax error
The SQL being executed was: (SELECT [t1].[message] AS [message], [t2].[translation] AS [translation] FROM [source_message] [t1], [message] [t2] WHERE t1.id = t2.id AND t1.category = 'frontend/pages' AND t2.language = 'ru-RU') UNION ALL ( SELECT [t1].[message] AS [message], [t2].[translation] AS [translation] FROM [source_message] [t1], [message] [t2] WHERE (t1.id = t2.id AND t1.category = 'frontend/pages' AND t2.language = 'ru') AND (t2.id NOT IN (SELECT id FROM [message] WHERE language = 'ru-RU')) )
@samdark
Copy link
Member

samdark commented May 15, 2015

Please report to extension repo. It's not Yii issue by itself.

@samdark samdark closed this as completed May 15, 2015
@zelenin
Copy link
Contributor

zelenin commented May 15, 2015

@samdark it's yii issue #6415

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