Problem adding articles in Joomla 2.5 on IIS with SQL Server

This forum is for issues with installing Joomla! 2.5 (All 1.6 and 1.7 releases have reached end of life and should be updated to 2.5.) on IIS webservers.

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.
Locked
dany_freire
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Wed Dec 17, 2008 9:18 pm

Problem adding articles in Joomla 2.5 on IIS with SQL Server

Post by dany_freire » Wed Feb 08, 2012 10:19 pm

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!

mariosazzam
Joomla! Fledgling
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

Post by mariosazzam » Thu Feb 09, 2012 12:16 pm

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

bfaulk1
Joomla! Fledgling
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

Post by bfaulk1 » Thu Feb 16, 2012 4:47 am

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

-bill

stevewayment
Joomla! Apprentice
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

Post by stevewayment » Thu Feb 16, 2012 7:48 pm

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?

stevewayment
Joomla! Apprentice
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

Post by stevewayment » Fri Feb 17, 2012 11:24 pm

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.

User avatar
Z9iT
Joomla! Enthusiast
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

Post by Z9iT » Sat Feb 18, 2012 3:18 pm

Report this issue to the bug squad team with every possible detail ...
http://docs.joomla.org/Bug_Squad
http://z9it.com....Bringing the best of www, in a gist...

stevewayment
Joomla! Apprentice
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

Post by stevewayment » Mon Feb 20, 2012 7:12 pm

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

Code: Select all

...a.parent_id');
to

Code: Select all

...a.parent_id, a.published');
(make sure the single quote is in the right place.)
5. Save and close.

plastersan
Joomla! Apprentice
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

Post by plastersan » Tue Mar 20, 2012 7:28 pm

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?


Locked

Return to “Joomla! 2.5 on IIS webserver”