Problem adding articles in Joomla 2.5 on IIS with SQL Server
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
-
- Joomla! Apprentice
- Posts: 8
- Joined: Wed Dec 17, 2008 9:18 pm
Problem adding articles in Joomla 2.5 on IIS with SQL Server
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!
[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!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Feb 09, 2012 11:03 am
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
I am experiencing a similar problem ...
if someone has a solution for that please post it
if someone has a solution for that please post it
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Jan 30, 2012 10:21 pm
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
Same situation here. Have applied the Stable 2.51 update and still having this issue.
-bill
-bill
-
- Joomla! Apprentice
- Posts: 6
- Joined: Tue Feb 14, 2012 11:40 pm
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
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?
-
- Joomla! Apprentice
- Posts: 6
- Joined: Tue Feb 14, 2012 11:40 pm
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
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.
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.
- Z9iT
- Joomla! Enthusiast
- Posts: 166
- Joined: Fri Oct 14, 2011 8:15 am
- Contact:
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
Report this issue to the bug squad team with every possible detail ...
http://docs.joomla.org/Bug_Squad
http://docs.joomla.org/Bug_Squad
http://z9it.com....Bringing the best of www, in a gist...
-
- Joomla! Apprentice
- Posts: 6
- Joined: Tue Feb 14, 2012 11:40 pm
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
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.
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
Code: Select all
...a.parent_id');
Code: Select all
...a.parent_id, a.published');
5. Save and close.
-
- Joomla! Apprentice
- Posts: 28
- Joined: Wed Jan 04, 2012 1:20 pm
Re: Problem adding articles in Joomla 2.5 on IIS with SQL Se
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?