phpBB3 SEO Sitemap

MSSQL Error 8120 - phpBB3 SEO Sitemap

MSSQL Error 8120

by vsabah » Fri Jul 03, 2015 12:35 am

Hi,

I take this error... Why?

SQL ERROR [ mssql ]

Column 'pbb_pforums.forum_type' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Column '%.*ls.%.*ls' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. [8120]

Bu sayfa açılırken bir sql hatası oluştu. Bu problem devam ederse lütfen Mesaj Panosu Yöneticisi ile iletişime geçin.


Image
User avatar
vsabah
Registered User
Posts: 358
Joined: Wed Apr 05, 2006 5:57 pm
Location: Konya / Türkiye
Contact:

Re: MSSQL Error 8120

by Shredder » Sat Aug 08, 2015 7:41 pm

Open core.php
FIND

Code: Select all

GROUP BY f.forum_id';

REPLACE WITH

Code: Select all

GROUP BY f.forum_id, f.forum_type, f.forum_name, f.forum_topics_per_page';

It will be fixed in the next version.
Shredder
Registered User
Posts: 116
Joined: Tue Aug 04, 2009 11:56 pm
Contact: