SMFHacks.com

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

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:

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

SMF 2.0.11
SMF Gallery Pro 7.0.8

Missing images on upload:
I'm having an image upload issue after upgrading to this latest version. The images appear to upload and the image data displays but without the image.
http://www.ourfamilyforum.org/FamilyForum/index.php?action=gallery

Thanks... Ken.

Sorry if this has been covered, didn't find any info on the issue.

When trying to access any of the albums or category's in my install the following error page comes up.

An Error Has Occurred!
The category doesn't exist.

The only error showing in the forum error log is this:

http://www.ourfamilyforum.org/index.php?action=gallery;sa=view;id=7956
Apply Filter: Only show the errors with the same message
8: Undefined index: approved
Apply Filter: Only show the errors from this file
File: /home/ourfamil/public_html/Themes/default/languages/TPShout.english.php (view_picture sub template - eval?)
Line: 1625

Thanks... Ken.

This may have been covered before, but a search didn't return an answer.


There seems to be no easy way to select an 'Image Linking Codes' link so that it can be used in a topic/post.
Is there any way to simply click on the link box causing the link to be selected or highlighted so that it can then be copied into a post?
... dragging your cursor across the link to highlight it is very ineffective because this method rarely works as expected.

Thanks... Ken.

My gallery has developed an issue with newly added pictures:
When adding a picture the process appears to work correctly and as you can see in the screen shot below the image details show up as they should, but the image itself is not there. I've tried to load pics using "Add a picture", "Bulk add" and "ftp add" and get the same results. The "[Regenerate Thumbnails]" function has been tried and has no effect.

There was a file permissions issue with my host in that some of my files on the server were owned by "nobody" and my host had to reset the ownership to me, but that was in a completely different area of my site and should not have anything to do with this issue... I think.

My site is the same but the domain name has been changed, so will my license need to be updated to the new name? I looked through the license board but did not see how to make the change to the new name.

Old name: http://www.mykimbrell.com/FamilyForum/index.php

New name: http://www.ourfamilyforum.org/FamilyForum/index.php

Thanks... Ken

Many of my members simply email their pictures to me so that I can post them in their albums... I know they could load them into the gallery themselves, but that's the way it is. 

So, are these ideas possible?

1/Batch change for 'ownership' so that you could do a whole series of pictures, or an entire album.

2/Feature where by the change process would give you an error pop up if you try to change the owner name to one that is not in the member base. ... did that one on about 20 pics!