Error on album deletion.

[Harold Hallikainen]

I get the error below on trying to delete an album. It appears it does not like a long filename, though it took it in a server upload. So, how do I fix this?

THANKS!

Harold

Hey wait, you're an admin! We can tell you stuff.

There's an error message below and you can find more details in gallery3/var/logs (look for the file with the most recent date on it). Stuck? Stop by the Gallery 3 Forums and ask for help. You can also look at our list of open tickets to see if the problem you're seeing has been reported. If you post a request, here's some useful information to include:

Platform information

• Host name: kiwi.hallikainen.org
• Operating system: Linux 4.18.0-372.16.1.el8_6.x86_64
• Apache: Unknown
• PHP: 7.2.24
• MySQL: 8.0.26
• Server load: 0.87 1.22 1.33
• Graphics toolkit: imagemagick

Gallery stats

• Version: 3.1.3 (Revival)
• Albums: 75
• Photos: 2085

Database_Exception [ Database Error ]:#1406: Data too long for column 'relative_path_cache' at row 1 [ UPDATE `items` SET `relative_path_cache` = 'MembersOnly/Slideshow/6-Logos/KCPR%20Artwork/Julie_Meridian_1998_Fundraiser_Julie%20drew%20editorial%20cartoons%20for%20the%20Mustang%20Daily_%20In%201999%2C%20while%20sitting%20on%20the%20couch%20in%20KCPR%27s%20lobby%2C%20she%20drew%20this%20fundraising%20design.jpg', `relative_url_cache` = 'MembersOnly/Slideshow/6-Logos/KCPR-Artwork/Julie_Meridian_1998_Fundraiser_Julie-drew-editorial-cartoons-for-the-Mustang-Daily_-In-1999-while-sitting-on-the-couch-in-KCPR-s-lobby-she-drew-this-fundraising-design' WHERE `id` = '2855' ]

1. SYSPATH/libraries/Database_Mysqli_Result.php[ 27 ]

   22        } 23        elseif (is_bool($result)) 24        { 25            if ($result == FALSE) 26            { 27                throw new Database_Exception('#:errno: :error [ :query ]', 28                    array(':error' => $link->error, 29                    ':query' => $sql, 30                    ':errno' => $link->errno)); 31            } 32            else

2. SYSPATH/libraries/Database_Mysqli.php[ 79 ] » Database_Mysqli_Result_Core->__construct( arguments )

3. SYSPATH/libraries/Database.php[ 272 ] » Database_Mysqli_Core->query_execute( arguments )

4. MODPATH/gallery/libraries/MY_Database.php[ 48 ] » Database_Core->query( arguments )

5. SYSPATH/libraries/Database_Builder.php[ 973 ] » Database->query( arguments )

6. SYSPATH/libraries/ORM.php[ 804 ] » Database_Builder_Core->execute( arguments )

7. MODPATH/gallery/libraries/MY_ORM.php[ 34 ] » ORM_Core->save()

8. MODPATH/gallery/libraries/ORM_MPTT.php[ 79 ] » ORM->save()

9. MODPATH/gallery/models/item.php[ 544 ] » ORM_MPTT_Core->save()

10. MODPATH/gallery/models/item.php[ 305 ] » Item_Model_Core->save()

11. MODPATH/gallery/models/item.php[ 170 ] » Item_Model_Core->relative_path()

12. MODPATH/gallery/models/item.php[ 94 ] » Item_Model_Core->file_path()

13. MODPATH/gallery/libraries/ORM_MPTT.php[ 96 ] » Item_Model_Core->delete()

14. MODPATH/gallery/models/item.php[ 98 ] » ORM_MPTT_Core->delete()

15. MODPATH/gallery/libraries/ORM_MPTT.php[ 96 ] » Item_Model_Core->delete()

16. MODPATH/gallery/models/item.php[ 98 ] » ORM_MPTT_Core->delete()

17. MODPATH/gallery/libraries/ORM_MPTT.php[ 96 ] » Item_Model_Core->delete()

18. MODPATH/gallery/models/item.php[ 98 ] » ORM_MPTT_Core->delete()

19. MODPATH/gallery/controllers/quick.php[ 104 ] » Item_Model_Core->delete()

20. {PHP internal call} » Quick_Controller->delete( arguments )

21. SYSPATH/core/Kohana.php[ 331 ] » ReflectionMethod->invokeArgs( arguments )

22. SYSPATH/core/Event.php[ 208 ] » Kohana_Core::instance( arguments )

23. APPPATH/Bootstrap.php[ 67 ] » Event_Core::run( arguments )

24. DOCROOT/index.php[ 123 ] » require( arguments )

Environment

[J.R.]

Harold,

Yeah... in these days when super-long file and folder/album names are the norm, we need to remember that Gallery 3 was created over 10 years ago when there was often a limit on the length of a name. The error message you sent us definitely indicates that's what happened.

There's a chance that the album was never actually created and so you don't have to delete it. Can you navigate to it within the Gallery interface? If so, is there something there -- or is it totally blank? Let us know about that to help target the problem.

If you can't navigate to it, then it's probably did not get logged into the Gallery databases because of the name-too-long error and you can forget about it and just create a new album with a shorter name and see if that works. How long can an album name be? Dang, I have no idea. I have an album with a name 30 characters long and that includes 3 "spaces" in the name which works fine Did you use any special characters in the name? That might cause a problem.

It looks like the album name your tried to create has at least 100 characters. Yeah, almost certainly too long. Even if the system accepted a name that long, doing lots of super-long names like that is going to slow your gallery performance to a crawl. Also it looks like in the middle of the name you have an "underline" character:
-Mustang-Daily_-

Finally, this error-on-delete album can be cleared by going into your Gallery as admin, going over to "Maintenance" and running all of the Maintenance Procedures you see there in the order they appear (but skip "Update Translations" as that translation service no longer exists). If you've never done this before, the final, most important procedure called "Fix Your Gallery" will take quite a long while to complete. This process makes an attempt to clean up database errors and cross-link failures. Sometimes you have to go through all the procedures in order several times to get a good result.

It looks like you already have 75 working albums containing about 2085 images... so the system has been working up to now. Have you changed anything about the installation lately? Added any modules? And if you're using the slideshow module be aware that it has not been updated in a long time and seems to be problematic, particularly when accessing  a lot of images.

-- J.R.

--
WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST or REPLY TO ALL so your reply goes out to everyone in the group. If you click REPLY or REPLY TO SENDER Google will *only* send your reply to the original author (not recommended).
 
To post a NEW MESSAGE to the group, send an new email to:
gallery...@googlegroups.com
 
To view or sign in to this group on the web, use this URL:
https://groups.google.com/forum/#!forum/gallery-3-users
---
You received this message because you are subscribed to the Google Groups "Gallery 3 Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gallery-3-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/fc8495c8-d9df-4217-b75d-6bcd9f957b8dn%40googlegroups.com.

[Harold Hallikainen]

Thanks for the quick response! Running "Fix your Gallery" gives me a
similar error message, then it quits:

Fix your Gallery

#1406: Data too long for column 'relative_path_cache' at row 1 [ UPDATE
`items` SET `relative_path_cache` =
'MembersOnly/Slideshow/6-Logos/KCPR%20Artwork/Julie_Meridian_1998_Fundraiser_Julie%20drew%20editorial%20cartoons%20for%20the%20Mustang%20Daily_%20I

More ideas?

THANKS!

Harold

> You received this message because you are subscribed to a topic in the
> Google Groups "Gallery 3 Users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to

> gallery-3-use...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/91107fd3-1522-742a-b520-b485356edf65%40thepostalzone.com.
>


--
FCC Rules Updated Daily at http://www.hallikainen.com
Not sent from an iPhone.

[Harold Hallikainen]

Looking at the log, I see:

Task Fix your Gallery started (task id 5)
Database_Exception: #1406: Data too long for column 'relative_path_cache'

at row 1 [ UPDATE `items`
SET `relative_path_cache` =
'MembersOnly/Slideshow/6-Logos/KCPR%20Artwork/Julie_Meridian_1998_Fundraiser_Julie%20drew%20editorial%20cartoons%20for%20the%20Mustang%20Daily_%20In%201999%2C%20while%20sitting%20on%20the%20couch%20in%20KCPR%27s%20lobby%2C%20she%20drew%20this%20fundraising%20design.jpg',
`relative_url_cache` =
'MembersOnly/Slideshow/6-Logos/KCPR-Artwork/Julie_Meridian_1998_Fundraiser_Julie-drew-editorial-cartoons-for-the-Mustang-Daily_-In-1999-while-sitting-on-the-couch-in-KCPR-s-lobby-she-drew-this-fundraising-design'

WHERE `id` = '2855' ] in
/home/kcpr/public_html/gallery3/system/libraries/Database_Mysqli_Result.php:27
Stack trace:
#0
/home/kcpr/public_html/gallery3/system/libraries/Database_Mysqli.php(79):
Database_Mysqli_Result_Core->__construct(false, 'UPDATE `items`\n...',
Object(mysqli), true)
#1 /home/kcpr/public_html/gallery3/system/libraries/Database.php(272):
Database_Mysqli_Core->query_execute('UPDATE `items`\n...')
#2
/home/kcpr/public_html/gallery3/modules/gallery/libraries/MY_Database.php(48):
Database_Core->query('UPDATE `items`\n...')
#3
/home/kcpr/public_html/gallery3/system/libraries/Database_Builder.php(973):
Database->query('UPDATE `items`\n...')
#4 /home/kcpr/public_html/gallery3/system/libraries/ORM.php(804):
Database_Builder_Core->execute(Object(Database_Mysqli))
#5
/home/kcpr/public_html/gallery3/modules/gallery/libraries/MY_ORM.php(34):
ORM_Core->save()
#6
/home/kcpr/public_html/gallery3/modules/gallery/libraries/ORM_MPTT.php(79):
ORM->save()
#7 /home/kcpr/public_html/gallery3/modules/gallery/models/item.php(544):
ORM_MPTT_Core->save()
#8 /home/kcpr/public_html/gallery3/modules/gallery/models/item.php(305):
Item_Model_Core->save()
#9
/home/kcpr/public_html/gallery3/modules/gallery/helpers/gallery_task.php(692):
Item_Model_Core->relative_path()
#10 /home/kcpr/public_html/gallery3/modules/gallery/helpers/task.php(90):
gallery_task_Core::fix(Object(Task_Model))
#11
/home/kcpr/public_html/gallery3/modules/gallery/controllers/admin_maintenance.php(195):
task_Core::run('5')
#12
/home/kcpr/public_html/gallery3/modules/gallery/controllers/admin.php(62):
Admin_Maintenance_Controller->run('5')
#13 [internal function]: Admin_Controller->__call('Admin_maintenan...',
Array)
#14 /home/kcpr/public_html/gallery3/system/core/Kohana.php(331):
ReflectionMethod->invokeArgs(Object(Admin_Controller), Array)
#15 /home/kcpr/public_html/gallery3/system/core/Event.php(208):
Kohana_Core::instance(NULL)
#16 /home/kcpr/public_html/gallery3/application/Bootstrap.php(67):
Event_Core::run('system.execute')
#17 /home/kcpr/public_html/gallery3/index.php(123):
require('/home/kcpr/publ...')
#18 {main}



On Wed, August 17, 2022 7:13 pm, 'Harold Hallikainen' via Gallery 3 Users

> https://groups.google.com/d/msgid/gallery-3-users/16b461c9da1cd1af9b1c558311ff0197.squirrel%40hallikainen.org.

[J.R.]

Harold,

Hmmm... this could be serious, since I've never seen the Fix Your Gallery procedure actually "quit"  and abort even when there was some scrambled stuff in my own database. But it may not have actually quit -- sometimes it will chew on a problem it has found for an hour or more until it finally gives up and moves on to other operations and finally completes. So sometimes it can look like the  Fix Your Gallery procedure has "locked up", because it's just sitting there, not changing -- but it only looks like it's locked up -- at some point it should finish with a message that says:

" 2085 / 2079 operations complete "
 
-- which indicates that out of the 2085 diagnostic check-and-attempt-to-repair operations it ran, all but 6 of them completed successfully. It is not unusual to have a few operations which did not complete, but if there are a lot of them then that's a cause for concern.

The problem seems to be caused by an image file named:

Julie_Meridian_1998_Fundraiser_Julie-drew-editorial-cartoons-for-the-Mustang-Daily_-In-1999-while-sitting-on-the-couch-in-KCPR-s-lobby-she-drew-this-fundraising-design.jpg

This is a very bad image name to use in a database system because there are no spaces between the words, like, the words in the name-are-all_connected-with-a-chain-of-hyphens-and_underline_characters which means the name cannot "word wrap" when it is placed in a text field in the database. It all has to fit in the field on one line and database fields always have a specified size which was exceeded by the name having to be treated as one continuous word. That's probably what has thrown the cross-linking for the album out of whack. In the future, better to leave spaces between words in image file names (or an album name, for that matter) .

As for having any other suggestions, please answer the question I asked earlier to give me some idea of what to try next:

Can you navigate to the problem album with the regular Gallery user interface? If you can see the album, can you click on it and get into it? Are there any pictures in there -- or is it just a totally empty album?

Let me know.

-- J.R.

On 8/17/22 10:15 PM, 'Harold Hallikainen' via Gallery 3 Users wrote:

Looking at the log, I see:

Task Fix your Gallery started (task id 5)
Database_Exception: #1406: Data too long for column 'relative_path_cache'
at row 1 [ UPDATE `items`
SET `relative_path_cache` =
'MembersOnly/Slideshow/6-Logos/KCPR%20Artwork/Julie_Meridian_1998_Fundraiser_Julie%20drew%20editorial%20cartoons%20for%20the%20Mustang%20Daily_%20In%201999%2C%20while%20sitting%20on%20the%20couch%20in%20KCPR%27s%20lobby%2C%20she%20drew%20this%20fundraising%20design.jpg',
`relative_url_cache` =

Julie_Meridian_1998_Fundraiser_Julie-drew-editorial-cartoons-for-the-Mustang-Daily_-In-1999-while-sitting-on-the-couch-in-KCPR-s-lobby-she-drew-this-fundraising-design'

WHERE `id` = '2855' ] i
/home/kcpr/public_html/gallery3/system/libraries/Database_Mysqli_Result.php:27
Stack trace:
#0
/home/kcpr/public_html/gallery3/system/libraries/Database_Mysqli.php(79):
Database_Mysqli_Result_Core->__construct(false, 'UPDATE `items`\n...',
Object(mysqli), true)
#1 /home/kcpr/public_html/gallery3/system/libraries/Database.php(272):
Database_Mysqli_Core->query_execute('UPDATE `items`\n...')
#2
/home/kcpr/public_html/gallery3/modules/gallery/libraries/MY_Database.php(48):
Database_Core->query('UPDATE `items`\n...')
#3
/home/kcpr/public_html/gallery3/system/libraries/Database_Builder.php(973):
Database->query('UPDATE `items`\n...')
#4 /home/kcpr/public_html/gallery3/system/libraries/ORM.php(804):
Database_Builder_Core->execute(Object(Database_Mysqli))
#5
/home/kcpr/public_html/gallery3/modules/gallery/libraries/MY_ORM.php(34):
ORM_Core->save()
#6
/home/kcpr/public_html/gallery3/modules/gallery/libraries/ORM_MPTT.php(79):
ORM->save()
#7 /home/kcpr/public_html/gallery3/modules/gallery/models/item.php(544):
ORM_MPTT_Core->save()
#8 /home/kcpr/public_html/gallery3/modules/gallery/models/item.php(305):
Item_Model_Core->save()
#9
/home/kcpr/public_html/gallery3/modules/gallery/helpers/gallery_task.php(692):
Item_Model_Core->relative_path()
#10 /home/kcpr/public_html/gallery3/modules/gallery/helpers/task.php(90):
gallery_task_Core::fix(Object(Task_Model))
#11
/home/kcpr/public_html/gallery3/modules/gallery/controllers/admin_maintenance.php(195):
task_Core::run('5')
#12
/home/kcpr/public_html/gallery3/modules/gallery/controllers/admin.php(62):
Admin_Maintenance_Controller->run('5')
#13 [internal function]: Admin_Controller->__call('Admin_maintenan...',
Array)
#14 /home/kcpr/public_html/gallery3/system/core/Kohana.php(331):
ReflectionMethod->invokeArgs(Object(Admin_Controller), Array)
#15 /home/kcpr/public_html/gallery3/system/core/Event.php(208):
Kohana_Core::instance(NULL)
#16 /home/kcpr/public_html/gallery3/application/Bootstrap.php(67):
Event_Core::run('system.execute')
#17 /home/kcpr/public_html/gallery3/index.php(123):
require('/home/kcpr/publ...')
#18 {main}



On Wed, August 17, 2022 7:13 pm, 'Harold Hallikainen' via Gallery 3 Users
wrote:

[Harold Hallikainen]

Thanks for the help!

KCPR>Alumni Gal…>Members Only>KCPR 50th Anniv…>6-Logos

I see a blank thumnail with 9 gray blocks in it. If I click that
thumbnail, I get to KCPR Artwork with no photos visible.

Looking at
/home/kcpr/public_html/gallery3/var/albums/MembersOnly/Slideshow/6-Logos/KCPR
Artwork

I see several images including a few with very long filenames.

How does "Fix Your Gallery" work? If I were to delete the offending photos
on the server, would it delete those problematic records?

The photos were sent to me, and I was not aware of the very long filename
or that there was a limit on filename length.

THANKS!

Harold

> topic in the Google Groups "Gallery 3 Users"

> https://groups.google.com/d/msgid/gallery-3-users/8efd7db0-3b37-3195-071d-cf4974f53b70%40thepostalzone.com.

[J.R.]

Harold,

Looks like you're going to have to send us the URL for you gallery so I can take a look at it.

-- J.R.

[Harold Hallikainen]

Thanks! The URL is https://kcpralumni.org/gallery3/index.php/ . The
problem area is in a Members Only album. Do you need membership or perhaps
admin? The problem only shows up in the Members Only album where I am
trying to delete the album with the long filenames. I shortened the file
names and uploaded it again to
https://kcpralumni.org/gallery3/index.php/KCPR-50th-Anniversary-Slideshow
. That seems to work fine. The issue is deleting the album from the
Members Only directory.

THANKS!

Harold

> topic in the Google Groups "Gallery 3
> Users" group. To unsubscribe from this topic,

> https://groups.google.com/d/msgid/gallery-3-users/8efd7db0-3b37-3195-071d-cf4974f53b70%40thepostalzone.com.

>
>
> --
> WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST
> or REPLY TO ALL so your reply goes out to everyone in the group. If you
> click REPLY or REPLY TO SENDER Google will *only* send your reply to the
> original author (not recommended).
>
> To post a NEW MESSAGE to the group, send an new email to:
> gallery...@googlegroups.com
>
> To view or sign in to this group on the web, use this URL:
> https://groups.google.com/forum/#!forum/gallery-3-users
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "Gallery 3 Users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> gallery-3-use...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/3c87c966-a383-9a96-8b6f-ce9e78ebd3c4%40thepostalzone.com.

[J.R.]

Harold,

No, DO NOT Manually delete the images from the server -- this will only make things worse. I've been through this exact same situation before and know what can happen: Those images already have cross-links installed in the various databases fields. Manually deleting the images themselves from the server leaves those cross links still in the databases as "orphans" with the system having no way to clean up the mess.

I have to leave the house right now (Thursday, 8:30 PM EST) -- but I will send you another message in a couple of hours outlining the next steps that have to be taken to clean this up. Like the man said, "Do nothing until you hear from me".

-- J.R.

[Harold Hallikainen]

Thanks! I thought deleting the images would be dangerous! But, then maybe
the database deleted records for images that do not exist in a cleanup.
Bad guess, I guess!

Again, THANKS! Archive.org shows my use of Gallery (2) back to 2002. It
has, and is, serving me well!

Harold

> topic in the Google Groups "Gallery 3
> Users" group. To unsubscribe from this

> https://groups.google.com/d/msgid/gallery-3-users/8efd7db0-3b37-3195-071d-cf4974f53b70%40thepostalzone.com.
> -- WHEN USING AN EMAIL PROGRAM to reply to this message,
> click REPLY TO LIST or REPLY TO ALL so your reply goes out to
> everyone in the group. If you click REPLY or REPLY TO SENDER
> Google will *only* send your reply to the original author (not
> recommended). To post a NEW MESSAGE to the group, send an
> new email to: gallery...@googlegroups.com To view or
> sign in to this group on the web, use this URL:
> https://groups.google.com/forum/#!forum/gallery-3-users ---
> You received this message because you are subscribed to a
> topic in the Google Groups "Gallery 3 Users"
> group. To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
> To unsubscribe from this group and all its topics, send an
> email to gallery-3-use...@googlegroups.com. To
> view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/3c87c966-a383-9a96-8b6f-ce9e78ebd3c4%40thepostalzone.com.

>
>
> --
> WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST
> or REPLY TO ALL so your reply goes out to everyone in the group. If you
> click REPLY or REPLY TO SENDER Google will *only* send your reply to the
> original author (not recommended).
>
> To post a NEW MESSAGE to the group, send an new email to:
> gallery...@googlegroups.com
>
> To view or sign in to this group on the web, use this URL:
> https://groups.google.com/forum/#!forum/gallery-3-users
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "Gallery 3 Users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> gallery-3-use...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/e1812807-ea0d-2d23-a29b-9b581f49f32e%40thepostalzone.com.

[J.R.]

I have sent a private message to Harold on this issue. It's getting kind of complex. If we come up with a solution I will post what we discover to this thread. Meanwhile, anyone else have any tips on how to delete an album that contains files which also cannot be deleted? Of course, Gallery will not allow an admin to delete an album until it has been emptied of all files first... a chicken and broken egg conundrum.

--J.R.

[Kerry Marshall]

Hi,

 

I remember there used to be a gallery clean up script where you could point it at a folder and it would change all the permissions to let you remove files

 

I don’t seem to have it to hand so I’ll see if I can dig it up from an archive

 

Cheers

Kerry

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/ee6181bf-68c0-f7c1-d238-f573e495e940%40thepostalzone.com.

[Kerry Marshall]

The cleanup script is still in the archive

 

Maybe this would help: http://codex.galleryproject.org/Downloads:Cleanup_Script.html

 

Cheers

Kerry

 

 

From: <gallery...@googlegroups.com> on behalf of "J.R." <jrl...@thepostalzone.com>
Reply-To: <gallery...@googlegroups.com>
Date: Friday, 19 August 2022 at 5:43 PM
To: <gallery...@googlegroups.com>
Subject: Re: [gallery-3-users] Error on album deletion.

 

I have sent a private message to Harold on this issue. It's getting kind of complex. If we come up with a solution I will post what we discover to this thread. Meanwhile, anyone else have any tips on how to delete an album that contains files which also cannot be deleted? Of course, Gallery will not allow an admin to delete an album until it has been emptied of all files first... a chicken and broken egg conundrum.

--J.R.

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/ee6181bf-68c0-f7c1-d238-f573e495e940%40thepostalzone.com.

[mikt...@hotmail.com]

Harold,

It is a long shot, but if you can get to the album, have you tried to rename the album/files with something short. this may then let you delete or whatever you want to do with them

Tony

[Harold Hallikainen]

Thanks for the suggestion! The image with the long filename is not showing
up within the album, so I can't delete it there.

Harold

On Fri, August 19, 2022 5:04 am, mikt...@hotmail.com wrote:
> Harold,
>
> It is a long shot, but if you can get to the album, have you tried to
> rename the album/files with something short. this may then let you delete
> or whatever you want to do with them
>
> Tony
> On Friday, 19 August 2022 at 5:35:14 pm UTC+9:30 KAMPIC wrote:
>
>> The cleanup script is still in the archive
>>
>>
>>
>> Maybe this would help:
>> http://codex.galleryproject.org/Downloads:Cleanup_Script.html
>>
>>
>>
>> Cheers
>>
>> Kerry
>>
>>
>>
>>
>>

>> *From: *<gallery...@googlegroups.com> on behalf of "J.R." <
>> jrl...@thepostalzone.com>
>> *Reply-To: *<gallery...@googlegroups.com>
>> *Date: *Friday, 19 August 2022 at 5:43 PM
>> *To: *<gallery...@googlegroups.com>
>> *Subject: *Re: [gallery-3-users] Error on album deletion.

>> topic in the Google Groups &amp;quot;Gallery 3
>>
>> Users&amp;quot; group. To unsubscribe from this topic,
>>
>> visit
>>
>> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
>>
>> To unsubscribe from this group and all its topics, send an
>>
>> email to gallery-3-use...@googlegroups.com. To
>>
>> view this discussion on the web visit
>>
>> https://groups.google.com/d/msgid/gallery-3-users/8efd7db0-3b37-3195-071d-cf4974f53b70%40thepostalzone.com.
>>
>> -- WHEN USING AN EMAIL PROGRAM to reply to this message,
>>
>> click REPLY TO LIST or REPLY TO ALL so your reply goes out to
>>
>> everyone in the group. If you click REPLY or REPLY TO SENDER
>>
>> Google will *only* send your reply to the original author (not
>>
>> recommended). To post a NEW MESSAGE to the group, send an
>>
>> new email to: gallery...@googlegroups.com To view or
>>
>> sign in to this group on the web, use this URL:
>>
>> https://groups.google.com/forum/#!forum/gallery-3-users ---
>>
>> You received this message because you are subscribed to a
>>

>> topic in the Google Groups &quot;Gallery 3 Users&quot;

>>
>> group. To unsubscribe from this topic, visit
>>
>> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
>>
>> To unsubscribe from this group and all its topics, send an
>>
>> email to gallery-3-use...@googlegroups.com. To
>>
>> view this discussion on the web visit
>>
>> https://groups.google.com/d/msgid/gallery-3-users/3c87c966-a383-9a96-8b6f-ce9e78ebd3c4%40thepostalzone.com.
>>
>>
>>
>>
>>
>> --
>>
>> WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO
>> LIST
>>
>> or REPLY TO ALL so your reply goes out to everyone in the group. If you
>>
>> click REPLY or REPLY TO SENDER Google will *only* send your reply to the
>>
>> original author (not recommended).
>>
>>
>>
>> To post a NEW MESSAGE to the group, send an new email to:
>>
>> gallery...@googlegroups.com
>>
>>
>>
>> To view or sign in to this group on the web, use this URL:
>>
>> https://groups.google.com/forum/#!forum/gallery-3-users
>>
>> ---
>>
>> You received this message because you are subscribed to a topic in the
>>

>> Google Groups "Gallery 3 Users" group.

>> <https://groups.google.com/d/msgid/gallery-3-users/ee6181bf-68c0-f7c1-d238-f573e495e940%40thepostalzone.com?utm_medium=email&utm_source=footer>
>> .

>>
>>
>
> --
> WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST
> or REPLY TO ALL so your reply goes out to everyone in the group. If you
> click REPLY or REPLY TO SENDER Google will *only* send your reply to the
> original author (not recommended).
>
> To post a NEW MESSAGE to the group, send an new email to:
> gallery...@googlegroups.com
>
> To view or sign in to this group on the web, use this URL:
> https://groups.google.com/forum/#!forum/gallery-3-users
> ---
> You received this message because you are subscribed to the Google Groups
> "Gallery 3 Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to gallery-3-use...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/c523c03a-1ec3-492c-9186-0fd47d6467aen%40googlegroups.com.

[Harold Hallikainen]

Thanks! It looks like that just changes file permissions so files can be
renamed or deleted by someone other than the owner. Since I have root
access, that will not give me any more than I already have. As J.R. has
pointed out, just deleting the offending files will cause problems since
the database would still be pointing to them.

Thanks for the suggestion!

Harold

> Google Groups "Gallery 3 Users" group.
> To unsubscribe from this topic, visit

> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> gallery-3-use...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/CE156256-7601-4008-AA21-AE845371F343%40gmail.com.

[Harold Hallikainen]

Thanks JR! To prevent problems in the future, what limitations are there
on image filenames? Total length, embedded spaces, etc.? Ideally Gallery
would catch these issues on the way in. I'm using Server Add to add large
collections of photos.

Harold

[Brad Dutton]

I'm a little surprised gallery doesn't limit anything in the interface because as JR pointed out there are some character limits of 256 in the database. I'm not sure how these limits were determined previously but that seems like something we could increase. Give me a few days but I'll try and increase that to 1024 (another arbitrary limit?) and see what happens. If that works I can publish a new release.

Thanks,
Brad

[Harold Hallikainen]

THANKS! I imagine this would require restructuring the data in the database.

Harold

> --
> WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST
> or REPLY TO ALL so your reply goes out to everyone in the group. If you
> click REPLY or REPLY TO SENDER Google will *only* send your reply to the
> original author (not recommended).
>
> To post a NEW MESSAGE to the group, send an new email to:
> gallery...@googlegroups.com
>
> To view or sign in to this group on the web, use this URL:
> https://groups.google.com/forum/#!forum/gallery-3-users
> ---
> You received this message because you are subscribed to a topic in the

> Google Groups "Gallery 3 Users" group.

> To unsubscribe from this topic, visit

> https://groups.google.com/d/topic/gallery-3-users/jvtpS6q7YS0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> gallery-3-use...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/gallery-3-users/4a2f709a-d074-4854-b618-f4e6021c4814n%40googlegroups.com.

[J.R.]

Brad,

If you think that's best. In  part I'm sure the character limit was (maybe still is) a performance issue. For people with mega fast internet connections that may not be much of an issue, but half the U.S. (not to mention the rest of the world) is still creeping along with 1 GB or less speed (my own DSL connection -- the only one available in my rural area -- is only 500K, a measly 1/2 GB of speed).

But if you're going to do it, please look into the special character issue. A lot of people now seem to feel the need to add special characters to  their image file names. I know there are a few which are forbidden in text fields because those characters are used as operators in SQL, but all are special characters including "-" and "_" currently forbidden in Gallery image names?

Finally... heh... as long as you're looking... I see that Gallery's basic "Darn Something Went Wrong" error message which Harold triggered contains 2 dead support/help links:

"Hey wait, you're an admin! We can tell you stuff: There's an error message below and you can find more details in gallery3/var/logs (look for the file with the most recent date on it). Stuck? Stop by the Gallery 3 Forums and ask for help. You can also look at our list of open tickets to see if the problem you're seeing has been reported."

It's always something, ain't it? :)

-- J.R.

--
WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST or REPLY TO ALL so your reply goes out to everyone in the group. If you click REPLY or REPLY TO SENDER Google will *only* send your reply to the original author (not recommended).
 
To post a NEW MESSAGE to the group, send an new email to:
gallery...@googlegroups.com
 
To view or sign in to this group on the web, use this URL:
https://groups.google.com/forum/#!forum/gallery-3-users
---
You received this message because you are subscribed to the Google Groups "Gallery 3 Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gallery-3-use...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/4a2f709a-d074-4854-b618-f4e6021c4814n%40googlegroups.com.

[J.R.]

Kerry,

Thanks for the reminder... but I believe what this script will do is change file permissions to something like "664" so any user (not just admin) can modify/delete them. In Harold's case the error log indicated the file(s) in question are already set to allow modify/delete by someone logged-in as admin. From Bharat's instructions of the download page:

"Open it in your browser, and enter the path to your albums directory and this script will make every file in that path (that it can access) writable by everybody. After that, you should be able to delete the files manually via your FTP client or via the shell."

I'm going to test it, just to see. There's a good chance that modern PHP 7 and 8 servers will not allow such a script to execute for security reasons.

-- J.R.

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/CE156256-7601-4008-AA21-AE845371F343%40gmail.com.

[J.R.]

Tony,

In this case it probably will not work -- or maybe make things worse because:

1) The extremely long image file names have already been inserted into the Database fields (or perhaps a truncated version of them since they were so long). So if you tried to do change the name from within Gallery itself, you would likely get the same failure error message because the image name in the database field does not match the actual name of the image files stored in /var/albums and /var/resizes and /var/thumbs.

2) If you use the server CPanel File Manager to go into the /var/ and manually change the file name (or simply delete it), then the name in the database field will *still* not match what it is in the /var... or what's not there anymore if you have simply delete the image files from the /var/. You still get the failure error message. Dang...

It's a tricky problem, which is why I'm going to be working with Harold privately to see what can be done -- i.e. direct manual "database surgery" which, like any critical surgery, is extremely dangerous and not something to be tried without prior experience.

-- J.R.

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/c523c03a-1ec3-492c-9186-0fd47d6467aen%40googlegroups.com.

[J.R.]

Harold and Brad,

This is Brad's area of expertise, but yeah, I suspect altering the size of the necessary fields in the affected databases might be a good development concept, but would probably result in what amounts to a "full new version" release of Gallery 3 -- whereby to apply it to an existing installation of Gallery 3.13 or 3.15 would require a special script to automatically rebuild the existing databases to match. This would give us Gallery3 version 4.0 which would be nice... but, um, realistically could open up a big can of debugging worms.

-- J.R.

[Info.RockEdge]

It might be possible with direct access to the database and phpmyadmin to truncate the "items" table (not delete) to clear it.

Next step would be if access to the /var/albums is also available, to delete the actual image files and replace them or rename them in place.

Enable the server add module.

Use the server add module to reload the newly renamed image files.

All totally theoretical but I have several G3 installations on localhost machines just for dev or design work that I can test these steps out on.

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/f7a027a9-5bd2-92a5-86cf-b001da52d9e4%40thepostalzone.com.

[Brad Dutton]

Those links are already updated, his gallery installation isn't :)