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

MS SQL Server error with SELECT DISTINCT #712

Closed
Nodeblue opened this issue Jul 1, 2013 · 1 comment
Closed

MS SQL Server error with SELECT DISTINCT #712

Nodeblue opened this issue Jul 1, 2013 · 1 comment
Assignees
Labels
Milestone

Comments

@Nodeblue
Copy link

Nodeblue commented Jul 1, 2013

File: \inc\PMF\Faq.php
Line: 683
Version: 2.8.1
Environment: Windows 2008 R2, PHP 5.4, IIS 7.5, SQL Server 2008 R2

SELECT DISTINCT is not supported for the text data type in MS SQL.

http://forum.phpmyfaq.de/viewtopic.php?f=7&t=15394#p41669

@thorsten
Copy link
Owner

thorsten commented Jul 2, 2013

Quite interesting, the DISTINCT is on the id column.

thorsten added a commit that referenced this issue Jul 2, 2013
@ghost ghost assigned thorsten Jul 2, 2013
@thorsten thorsten closed this as completed Jul 2, 2013
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants