search

austins / Vanilla-App-Articles

Provides a way to publish articles with Vanilla Forums.
https://open.vanillaforums.com/addon/articles-application
GNU General Public License v2.0
11 stars 2 forks source link

Query errors on Vanilla 3.3 #77

Open jpfleury opened 4 years ago

jpfleury commented 4 years ago

Hi,

Trying to enable Articles 1.2.1a1 on Vanilla 3.3 leads to the following popup error the first time I click on the toggle switch:

In aggregated query without GROUP BY, expression
#3 of SELECT list contains nonaggregated column
'vanilla.a.LastArticleCommentID'; this is incompatible
with sql_mode=only_full_group_by

The application remains disabled, but the second time I click on the toggle switch, it's enabled and seems to work.

I also have this popup error when publishing a comment under an article. The comment will be there if I refresh the page though.

austins commented 4 years ago

Is MySQL strict mode enabled on your server? It causes some addons to error out in Vanilla. Disabling it should fix it. https://open.vanillaforums.com/discussion/comment/253933/#Comment_253933

I believe that many fixes have been made in Vanilla's core to make it work with strict mode, but I'm not sure if 100% of it was fixed. If this is something I could fix in the addon, I could take a look.