Error when trying to open gallery after upgrading from Gallery Lite to Pro

[janwegener]

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

[SMFHacks]

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';


[janwegener]

Hi,

I just executed the sql and it solved the issue 

Thanks a lot for the fast help,
Jan

[SMFHacks]

Glad to help