Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4260
Latest: Verrick
New This Month: 3
New This Week: 0
New Today: 0
Stats
Total Posts: 43301
Total Topics: 7525
Most Online Today: 105
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 87
Total: 87

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

0 Members and 1 Guest are viewing this topic.

Offline Ken.

  • 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.

  • 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: 16455
    • 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.

  • 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.

  • 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: 16455
    • 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.

  • 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
9737 Views
Last post October 30, 2008, 06:59:15 pm
by m.ehm
17 Replies
19915 Views
Last post September 30, 2010, 10:29:16 am
by CWVRV
31 Replies
13913 Views
Last post August 01, 2011, 04:35:23 pm
by docmikeb
3 Replies
15207 Views
Last post November 19, 2012, 11:54:22 pm
by SeaChaser
5 Replies
1271 Views
Last post September 22, 2021, 04:24:11 pm
by SMFHacks

+- Recent Topics

Pretty Urls extras by SMFHacks
May 13, 2024, 10:28:54 am

Mod question by Verrick
May 11, 2024, 02:42:50 pm

i have paid but cant download ad pro. by SMFHacks
May 02, 2024, 11:29:38 pm

Please Help! by SMFHacks
April 17, 2024, 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

Powered by EzPortal