Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4257
Latest: Alex998.
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43295
Total Topics: 7523
Most Online Today: 251
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 126
Total: 126

Author Topic: Errors With Older Version.  (Read 1885 times)

0 Members and 1 Guest are viewing this topic.

Offline Ken.

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 113
  • TP Rules!
    • View Profile
Errors With Older Version.
« on: May 09, 2023, 12:36:12 pm »
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

Quote
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:
Quote
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

Offline Ken.

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 113
  • TP Rules!
    • View Profile
Re: Errors With Older Version.
« Reply #1 on: May 09, 2023, 12:45:13 pm »
My current version is: 9.0.1

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16452
    • View Profile
Re: Errors With Older Version.
« Reply #2 on: May 09, 2023, 02:18:44 pm »
Might be fixed in new version if not that is something I can work on.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Ken.

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 113
  • TP Rules!
    • View Profile
Re: Errors With Older Version.
« Reply #3 on: May 09, 2023, 04:50:12 pm »
OK, thanks.
I'll renew and update shortly.

Offline Ken.

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 113
  • TP Rules!
    • View Profile
Re: Errors With Older Version.
« Reply #4 on: May 09, 2023, 05:10:16 pm »
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

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16452
    • View Profile
Re: Errors With Older Version.
« Reply #5 on: May 09, 2023, 05:14:05 pm »
You do not need to uninstall in this case just install on top following the upgrade link.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Ken.

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 113
  • TP Rules!
    • View Profile
Re: Errors With Older Version.
« Reply #6 on: May 09, 2023, 05:35:40 pm »
That worked and all is well now!

Thanks man... you are the best.  8)

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
9705 Views
Last post October 30, 2008, 06:59:15 pm
by m.ehm
17 Replies
19725 Views
Last post September 30, 2010, 10:29:16 am
by CWVRV
31 Replies
13819 Views
Last post August 01, 2011, 04:35:23 pm
by docmikeb
3 Replies
15122 Views
Last post November 19, 2012, 11:54:22 pm
by SeaChaser
5 Replies
1229 Views
Last post September 22, 2021, 04:24:11 pm
by SMFHacks

+- Recent Topics

Please Help! by SMFHacks
Today at 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

No thumbnails on new uploads by Tonyvic
March 29, 2024, 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

Powered by EzPortal