Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11932
Latest: maxanthony1976
New This Month: 16
New This Week: 0
New Today: 0
Stats
Total Posts: 37952
Total Topics: 6680
Most Online Today: 66
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 54
Total: 54

Author Topic: Error when trying to open gallery after upgrading from Gallery Lite to Pro  (Read 441 times)

0 Members and 1 Guest are viewing this topic.

Offline janwegener

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 2
    • View Profile
Hi,

I just bought the upgrade for the SMF Gallery Lite to Pro.
As written in the ReadME.txt I uninstalled the Gallery Lite before installing the Gallery Pro.

When I now click on the Gallery button in my forum then I receive the following error:
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'smf_tierfreunde.p.view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Datei: /var/www/vhosts/exguide.de/tierfreunde.exguide.de/Sources/Gallery2.php
Zeile: 661

Hinweis: Ihre Datenbank scheint veraltet zu sein! Ihre Dateien haben die Version SMF 2.0.13, wogegen die Datenbank die Version 2.0.2 hat. Es wird dringend empfohlen, die neueste Version der upgrade.php auszuführen.


The last sentence is in german the quick translation is: "Your database is out of date and seems to be 2.0.2 while your files are version 2.0.13".

Any advise how to solve the issue? The forum is showing me that it is running on SMF 2.0.13 when I check the admin page.

The forum can be accessed here:
http://tierfreunde.exguide.de/index.php

Thanks a lot,
Jan

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14055
    • View Profile
Try this file attached copy to your sources folder and see if it helps.

Or if you have access to mysql directly run these commands

Code: [Select]
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
« Last Edit: May 04, 2017, 02:56:26 pm by SMFHacks »
Get your Forum Ranked! at http://www.forumrankings.net - find out how your forum compares with others! Also contests/promotions for verified sites.

Offline janwegener

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 2
    • View Profile
Hi,

I just executed the sql and it solved the issue  :D

Thanks a lot for the fast help,
Jan

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14055
    • View Profile
Glad to help
Get your Forum Ranked! at http://www.forumrankings.net - find out how your forum compares with others! Also contests/promotions for verified sites.

 

Related Topics

  Subject / Started by Replies Last post
12 Replies
11819 Views
Last post June 25, 2007, 03:25:31 am
by william777
1 Replies
2800 Views
Last post November 01, 2007, 02:38:32 am
by Rabain
4 Replies
3598 Views
Last post January 17, 2008, 07:53:27 pm
by SMFHacks
2 Replies
3826 Views
Last post January 18, 2008, 01:39:51 am
by Rob Meades
3 Replies
3277 Views
Last post March 04, 2010, 06:10:43 pm
by morokat

+- Recent Topics

Are you killing your forum? by shuban
May 25, 2017, 01:26:02 pm

[Mod]Unofficial SMF 1.1.23 for PHP7 by shuban
May 25, 2017, 01:15:53 pm

Bulk Upload Option? by SMFHacks
May 25, 2017, 01:07:41 pm

nCode Image Resizer ssl sertifika ? by sempatiko
May 23, 2017, 02:50:28 pm

seo4smf_lite-3.2.0-2.1.x by sempatiko
May 23, 2017, 02:34:10 pm

SMF Staff mod button image by SMFHacks
May 22, 2017, 06:50:40 pm

License Key by SMFHacks
May 21, 2017, 08:57:45 am

BadgeAwards2 Does not work with PHP7 / SMF 2.0.14 by balon
May 18, 2017, 02:58:25 pm

SMF 2.0.14 Released with PHP 7 Support and Unofficial SMF 1.1.23 by SMFHacks
May 14, 2017, 11:49:58 pm

Error when trying to open gallery after upgrading from Gallery Lite to Pro by SMFHacks
May 04, 2017, 03:30:12 pm

Powered by EzPortal