Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12358
Latest: KekoWorld
New This Month: 1
New This Week: 2
New Today: 1
Stats
Total Posts: 40081
Total Topics: 7056
Most Online Today: 63
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 43
Total: 43

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

0 Members and 1 Guest are viewing this topic.

Offline HAL9000

  • SMF Gallery Pro Customer
  • Jr. Member
  • *****
  • Posts: 57
    • 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: 15042
    • 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

  • SMF Gallery Pro Customer
  • Jr. Member
  • *****
  • Posts: 57
    • 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: 15042
    • 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

  • SMF Gallery Pro Customer
  • Jr. Member
  • *****
  • Posts: 57
    • 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: 15042
    • 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
3316 Views
Last post November 01, 2007, 02:38:32 am
by Rabain
9 Replies
5347 Views
Last post March 07, 2008, 09:51:43 pm
by SMFHacks
13 Replies
6100 Views
Last post March 10, 2014, 09:56:08 am
by ardvark
1 Replies
549 Views
Last post November 11, 2018, 08:04:19 am
by SMFHacks
5 Replies
646 Views
Last post January 24, 2019, 11:28:45 am
by SMFHacks

+- Recent Topics

Only variables should be passed by reference by SMFHacks
April 01, 2020, 01:42:18 pm

Cannot install Gallery Pro on SMF 2.1 RC2 by Hatshepsut
March 19, 2020, 12:55:00 am

Newbie questions by SMFHacks
March 08, 2020, 09:28:17 am

Update detect mobile mode PHP5 to PHP7 by Plus
March 05, 2020, 11:19:05 am

Just a hello by Plus
March 05, 2020, 11:05:56 am

Enotify Copyright Problem by SMFHacks
March 04, 2020, 09:21:09 pm

Cannot import by shawnb
March 02, 2020, 12:17:00 pm

Error message with latest SMF 2.1 Github build by Hatshepsut
March 01, 2020, 10:06:10 am

[Mod]Avatars Display Integration by SMFHacks
February 15, 2020, 07:30:47 pm

[Mod]BBC Message Boxes 1.0 by SMFHacks
February 15, 2020, 07:26:46 pm

Powered by EzPortal