SMFHacks.com
User Information
Forum Stats
Show Posts
1
Support / Error when trying to open gallery after upgrading from Gallery Lite to Pro
« on: May 04, 2017, 02:35:40 pm »
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
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
Recent Topics