Welcome, Guest. Please login or register.

ShoutBox!

 

Skhilled

2024-03-24, 09:52:09
It may be released as early as today...if we all agree on it. ;)
 

Skhilled

2024-03-24, 09:37:46
Thank you, sir!  :)
 

Ken

2024-03-24, 09:28:38
I like it. Dark themes are not my first choice, but I like the crisp, clean lines.  :thumbup:
 

Skhilled

2024-03-24, 08:56:28
The original theme is here:

https://www.jpr62.com/demos/index.php
 

Skhilled

2024-03-24, 08:53:17
You can always see the latest previews here but registration is disabled:

https://skhilled.com/cztest/index.php
 

Ken

2024-03-24, 08:50:36
Any previews yet?
 

Skhilled

2024-03-24, 08:46:18
We almost have another theme completed.  :laugh:
 

Skhilled

2024-03-24, 08:45:18
What's up, bro?  :drinking:
 

Ken

2024-03-24, 08:42:45
Hi Steve.  :)
 

Skhilled

2024-02-21, 21:11:25
I missed that one. LOL

Recent Topics

TP Articles


Search in titles
Search in article texts

Author Topic: Errors in Gallery  (Read 2281 times)

0 Members and 1 Guest are viewing this topic.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11657
  • 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: 11657
  • 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: 8972
  • 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: 11657
  • 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: 8972
  • 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: 11657
  • 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: 8972
  • 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.