Joomla! Forum - community, help and support

When I enter to the Add New article form, i get this message:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'jos_categories.published' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.SQL=SELECT a.id AS value, a.title AS text, a.level, a.published FROM jos_categories AS a LEFT JOIN [jos_categories] AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = N'com_content') AND a.published IN (0,1) GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.extension, a.parent_id ORDER BY a.lft ASC

I get a similar message when i create categories too, but it does let me save the new categories.
Please, I need some help

Thank you!

I am experiencing a similar problem ...
if someone has a solution for that please post it

Same situation here. Have applied the Stable 2.51 update and still having this issue.

-bill

Same problem for me too. I've found several of the SQL queries in my local files, but I can't find the correct file with the jos_categories query. It doesn't look like there are any stored procedures for this query either... Does anyone know the location of this query?

Thought I should also mention that I'm using a full SQL 2008 instance, not MySQL...

I have submitted a bug report for this as I'm sure it's a fairly common issue, and should be fixed quickly. I'll post the resolution here when I get it.

Report this issue to the bug squad team with every possible detail ...
http://docs.joomla.org/Bug_Squad

OK, here's how to fix the category issue.

1. Browse to \\server-name\site-name\administrator\components\com_categories\models\fields (or FTP to the relevant location on your host.)
2. Edit the categoryedit.php file.
3. Search for the word "group".
4. Modify the "group" query line from to (make sure the single quote is in the right place.)
5. Save and close.

Thank you steve, that did solve my issue as well, we are still having the article problem with the same setup as everyone else having issues, was there a fix for that issue similar to the categories change?