Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 177
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 187
Total: 187

Author Topic: Errors With Older Version.  (Read 1832 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: 16436
    • 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: 16436
    • 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
9692 Views
Last post October 30, 2008, 06:59:15 pm
by m.ehm
17 Replies
19675 Views
Last post September 30, 2010, 10:29:16 am
by CWVRV
31 Replies
13759 Views
Last post August 01, 2011, 04:35:23 pm
by docmikeb
3 Replies
15079 Views
Last post November 19, 2012, 11:54:22 pm
by SeaChaser
5 Replies
1213 Views
Last post September 22, 2021, 04:24:11 pm
by SMFHacks

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

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

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal