Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12369
Latest: r0sem4rie
New This Month: 5
New This Week: 0
New Today: 0
Stats
Total Posts: 39810
Total Topics: 7016
Most Online Today: 39
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 48
Total: 48

Author Topic: Error message in Gallery Pro  (Read 236 times)

0 Members and 1 Guest are viewing this topic.

Offline HAL9000

  • Newbie
  • *
  • Posts: 48
    • View Profile
    • Fifty Plus Forum
Error message in Gallery Pro
« on: May 21, 2019, 12:33:53 pm »
All of a sudden we are getting the following error message when trying to view our Gallery.

"Expression #14 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fiftyplu_FPF001.c.view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/fiftyplu/public_html/forum/Themes/default/Gallery2.template.php
Line: 4440

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, whilst your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php."

Now the site files report that everything is up to date, so I'm loathe to run the latest upgrade.php as this will remove all the mods, which I don't really want to do.

Is there some other way round this issue?
Chas

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14919
    • View Profile
Re: Error message in Gallery Pro
« Reply #1 on: May 21, 2019, 12:42:36 pm »
Easy way either install newest of smf gallery pro again.
Or edit your my.cnf or my.ini for mysql and change
sql_mode=""

And then restart mysql
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline HAL9000

  • Newbie
  • *
  • Posts: 48
    • View Profile
    • Fifty Plus Forum
Re: Error message in Gallery Pro
« Reply #2 on: May 21, 2019, 02:49:00 pm »
Thanks for the quick reply,

I regret not having enough knowledge here.

I've looked in the root of the website for these config files but they are not there and there are no options on the site cPanel for MYSQL settings.

There is a user.ini file in the root of the forum, can I add the edit there?

When you say restart mysql, do you mean reboot the server?

Thanks
Chas

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14919
    • View Profile
Re: Error message in Gallery Pro
« Reply #3 on: May 21, 2019, 03:28:39 pm »
Do you have a VPS/Server?

If so this might work
https://help.whmcs.com/m/installation/l/678317-disabling-mysql-strict-mode
Then restart the mysql service
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline HAL9000

  • Newbie
  • *
  • Posts: 48
    • View Profile
    • Fifty Plus Forum
Re: Error message in Gallery Pro
« Reply #4 on: May 21, 2019, 03:54:44 pm »
Great! thanks, that's fixed it. Cheers.

When I've got a bit more dosh I'll upgrade the gallery.

Cheers again,

Chas

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14919
    • View Profile
Re: Error message in Gallery Pro
« Reply #5 on: May 21, 2019, 03:56:20 pm »
Glad to help.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
3196 Views
Last post November 01, 2007, 02:38:32 am
by Rabain
9 Replies
5191 Views
Last post March 07, 2008, 09:51:43 pm
by SMFHacks
13 Replies
5888 Views
Last post March 10, 2014, 09:56:08 am
by ardvark
1 Replies
388 Views
Last post November 11, 2018, 08:04:19 am
by SMFHacks
5 Replies
468 Views
Last post January 24, 2019, 11:28:45 am
by SMFHacks

+- Recent Topics

How to AVOID SEO Hit when Implementing PrettyURLs by SMFHacks
September 12, 2019, 08:50:42 pm

theme by SMFHacks
September 12, 2019, 07:10:51 am

Picture Edit by SMFHacks
August 27, 2019, 11:52:06 am

Getting an error while installing SMF Gallery Pro by SMFHacks
August 18, 2019, 06:54:37 pm

Hashtag Mod Install Error by SMFHacks
August 15, 2019, 08:17:45 am

Rotating Image URLs by SMFHacks
August 05, 2019, 04:26:57 pm

[Mod]Block Proxy VPN On Registration by SMFHacks
August 01, 2019, 10:42:37 pm

[Mod]Nofollow Signature Links by SMFHacks
July 30, 2019, 11:52:28 am

Thinking of getting Ad Seller Pro as well by ajac63
July 28, 2019, 04:46:34 am

Just some questions about Ad Management mod by ajac63
July 26, 2019, 12:12:26 pm

Powered by EzPortal