The Joomla! Forum ™

Download

Demo


Board index » Joomla! Development Forums » Joomla! Development » Joomla! 2.5 Bug Reporting

Forum rules


Please use the official Bug Tracker to report a bug: http://joomlacode.org/gf/project/joomla ... er_id=8103



Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
  Print view Previous topic | Next topic 
Author Message
seaharrior
PostPosted: Fri Mar 09, 2012 12:47 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Mar 09, 2012 12:41 pm
Posts: 1
curretnly on a fresh install on Windows 2008 R2, IIS with MS SQL 2008 R2 server, I am getting below error when I click on ADD Article.

[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
Top
 Profile  
 
plastersan
PostPosted: Tue Mar 20, 2012 7:07 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jan 04, 2012 1:20 pm
Posts: 28
Did you ever get an answer to this problem?
Top
 Profile  
 
nicolaj1234
PostPosted: Sun Mar 25, 2012 10:36 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Mar 25, 2012 10:26 am
Posts: 2
I have the same problem in the back office - while trying to access the different functions this error systematically appears.

Hope someone can help. It shouldn´t be that difficult to solve. :0)
Top
 Profile  
 
plastersan
PostPosted: Mon Mar 26, 2012 12:26 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jan 04, 2012 1:20 pm
Posts: 28
Steve Wayment should get credit for this, I'm just copy and pasting it.
The problem is actually with categories and making this change will fix the issue.

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:
...a.parent_id');
to
Code:
...a.parent_id, a.published');

(make sure the single quote is in the right place.)
5. Save and close.
Top
 Profile  
 
Planet-tech
PostPosted: Mon Mar 26, 2012 4:33 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Mar 26, 2012 4:23 pm
Posts: 1
Plasterson, thanks for the post - Steve Wayment thanks for the fix...
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 


Board index » Joomla! Development Forums » Joomla! Development » Joomla! 2.5 Bug Reporting

Who is online

Users browsing this forum: No registered users and 3 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group