SMFHacks.com
SMF Gallery Pro => Support => Topic started by: janwegener 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
-
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
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';
-
Hi,
I just executed the sql and it solved the issue :D
Thanks a lot for the fast help,
Jan
-
Glad to help