Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12341
Latest: susan212
New This Month: 5
New This Week: 1
New Today: 1
Stats
Total Posts: 39774
Total Topics: 7004
Most Online Today: 46
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 29
Total: 29

Author Topic: Error message in Gallery Pro  (Read 107 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: 14900
    • 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: 14900
    • 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: 14900
    • 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
3125 Views
Last post November 01, 2007, 02:38:32 am
by Rabain
9 Replies
5041 Views
Last post March 07, 2008, 09:51:43 pm
by SMFHacks
13 Replies
5735 Views
Last post March 10, 2014, 09:56:08 am
by ardvark
1 Replies
294 Views
Last post November 11, 2018, 08:04:19 am
by SMFHacks
5 Replies
319 Views
Last post January 24, 2019, 11:28:45 am
by SMFHacks

+- Recent Topics

About Comments Approval by ajac63
June 12, 2019, 07:48:52 pm

Pretty Urls extras by SMFHacks
June 06, 2019, 12:14:53 pm

About using chmod to secure files by ajac63
June 05, 2019, 04:02:28 am

Bulk upload image problem by SMFHacks
June 01, 2019, 07:24:00 pm

About Watermark Options by ajac63
May 30, 2019, 05:25:39 pm

Why PayPal only by ajac63
May 30, 2019, 04:20:47 pm

Seller ToU not showing by ajac63
May 29, 2019, 01:59:24 am

Not happy by ajac63
May 28, 2019, 06:37:58 pm

About Number of Images for Basic Ad by ajac63
May 26, 2019, 10:33:46 pm

Error when intalling SMF Gallery Pro 6.7 by SMFHacks
May 26, 2019, 04:56:46 pm

Powered by EzPortal