Errors With Older Version.

[Ken.]

I was getting ready to renew my license and download the latest version of SMF Gallery Pro, so I went too open my gallery and got these error messages.
...today was the first time I have opened my gallery in a couple of weeks.
Link to my gallery;
https://www.ourfamilyforum.org/FamilyForum/index.php?action=gallery

Database Error
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ourfamil_smf46.p.view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/ourfamil/public_html/FamilyForum/Sources/Gallery2.php
Line: 699

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.19, while your database is at version 2.0.12. The above error might possibly go away if you execute the latest version of upgrade.php.

And this from the SMF error log:

Apply Filter: Only show the error messages of this IP address 216.131.104.168 
  Reverse chronological order of list Today at 11:34:56 AM
Apply Filter: Only show the error messages of this session b46b3cbb855581cae7fdd81e70ee747c
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URL
https://www.ourfamilyforum.org/FamilyForum/index.php?action=gallery
Apply Filter: Only show the errors with the same message
Database Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ourfamil_smf46.p.view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Apply Filter: Only show the errors from this file
File: /home/ourfamil/public_html/FamilyForum/Sources/Gallery2.php
Line: 699

[Ken.]

My current version is: 9.0.1

[SMFHacks]

Might be fixed in new version if not that is something I can work on.

[Ken.]

OK, thanks.
I'll renew and update shortly.

[Ken.]

Trying to uninstall the currently installed version of the SMF Gallery(9.0.1a) and it's throwing errors for some of the files:

Code: [Select]

6. Execute Modification ./Sources/Subs.php Test failed
1. Replace ./Sources/Subs.php Test successful
2. Replace ./Sources/Subs.php Test successful
3. Add Before ./Sources/Subs.php Test failed
* 7. Execute Modification ./Sources/ManagePermissions.php Test successful
8. Execute Modification ./Sources/PrettyUrls-Filters.php Skipping file
* 9. Execute Modification ./Sources/Load.php Test failed
1. Replace ./Sources/Load.php Test failed

[SMFHacks]

You do not need to uninstall in this case just install on top following the upgrade link.

[Ken.]

That worked and all is well now!

Thanks man... you are the best.