Welcome, Guest. Please login or register.

ShoutBox!

Scrubmeister

2024-04-19, 10:32:40
Good to see the site back faster than ever. :)
 

Skhilled

2024-04-18, 21:09:09
I've upgraded the server...more resources. ;)
 

Ken

2024-04-18, 20:57:10
Now that you mention it...  :D
 

Skhilled

2024-04-18, 20:47:19
...and, you should notice that the site is much faster.  :o
 

Ken

2024-04-18, 20:31:37
Hey Steve.
 

Skhilled

2024-04-18, 17:56:10
Re-read the message below...
 

Skhilled

2024-03-31, 15:22:06
Oh yeah, you need to upgrade the site first...
 

Ken

2024-03-30, 09:54:54
Whoops! I forgot that the SMF install here on OFF is out of date!  :'(
 

Ken

2024-03-30, 09:44:48
 Conga-Rats Steve!  :thumbup:
Me gonna install it here just for the fun of it!  :)
 

Skhilled

2024-03-29, 22:15:23
Released!  :D

Recent Topics

TP Articles


Search in titles
Search in article texts

Author Topic: Errors in Gallery  (Read 2772 times)

0 Members and 1 Guest are viewing this topic.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11699
  • Gender: Male
  • View Gallery
Errors in Gallery
« on: May 09, 2023, 11:49:02 AM »
Just started getting some troubling error messages when trying to access the Gallery.  :censored:

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
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11699
  • Gender: Male
  • View Gallery
Re: Errors in Gallery
« Reply #1 on: May 09, 2023, 06:11:14 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
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9064
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Errors in Gallery
« Reply #2 on: May 09, 2023, 06:58:54 PM »
Yeah, you've got some old mods that should be removed.

For the 'Test Failed' I'd simple uninstall all of the mods, make sure all of their files are gone (except for any images) then upload all new smf files. Well, 'IF" you are going to get rid of the old ones. If they don't have an upgrade for the mods you'll probably always have errors. So, either you can deal with the errors, etc. or get rid of the old ones.

BTW, SMF will tell you to just ignore the db upgrade error. :P

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11699
  • Gender: Male
  • View Gallery
Re: Errors in Gallery
« Reply #3 on: May 09, 2023, 07:17:35 PM »
SMFHacks told me to just install the newer version on top of the old, currently installed version, and it worked out! Works good with no errors.  :thumbup:
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9064
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Errors in Gallery
« Reply #4 on: May 09, 2023, 07:22:30 PM »
Great! :) I thought the one you were using was no longer being updated.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11699
  • Gender: Male
  • View Gallery
Re: Errors in Gallery
« Reply #5 on: May 09, 2023, 07:38:22 PM »
It is, but my subscription was expired.  :-[
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9064
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Errors in Gallery
« Reply #6 on: May 09, 2023, 07:46:20 PM »
Ok, I get it.