When I built my site years ago, I added several albums in Gallery on my web site. I was hit will hundreds if not thousands of porn spams in my response fields so I closed down my Gallery albums. I long ago forgot my login and the web site was discontinued. I downloaded the full app and files and have saved on my hard drive. I would love to get the albums and labels out so that I can put on a new web site but have no idea how to do this or if it is even possible. I would love some help from the community. I am not a programmer and this is not something I can fix. I can I load them into a new version of Gallery without the spam? Or can I export the albums to build into WP albums? I do not know what to do.
Thank you in advance. John
--
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/e785c90b-ce26-41a4-8bf6-cea4b960e6f3n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/679c047d-6b1b-42c6-a849-62fb11b7a71dn%40googlegroups.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 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/4cf90d52-0e35-4d28-be5e-7e4da16c0f94n%40googlegroups.com.
Andrew,
You seem to indicate you are are not going to try to upgrade your old Gallery 2 installation to the latest version of Gallery 3. This is an often a maddening and frustrating process, particularly when your server environment is not exactly stable as you seem to indicate. You could easily spend many days trying to do this and not have any success. I think your plan to move your images out of the old G2 installation and put them on someplace like Flickr is the best idea. After you've successfully done that you can decide if you want to try to upgrade the old installation to G3.
The very first thing you should do -- no matter which way you go -- is to download the "album" folder and sub-folders inside the Gallery image storage location (this is /var folder in Gallery 3... no idea what it is called in G2 since I never used that version). You need to get those original images safely onto your local computer hard drive (or into the "cloud" if you're so inclined) so that if something goes wrong while working on the database to access the text data that you already have those images in hand as a back up.
Remember, Gallery does not actually store the images inside of the MySQL database -- the database only contains a reference link to the physical location of each image in the image folder. Those images stored in your gallery's image folder and sub-folders will be in there with their original names intact -- it will be easy to identify which is which. So your idea of moving the images onto someplace like Flickr should be easy to do.
As for the text data... now that is actually stored inside the database. I can only be of limited assistance, since I never used Gallery2 and I am only slightly familiar with the structure of the data tables inside the database used by Gallery3 (which has a different structure from the G2 database). There are 23 individual data tables inside the G3 database which work in concert with different aspects of Gallery. During operation they work interactively with each other, storing textual info/links/descriptions/comments/preference settings, etc. into different fields inside one data table or another. It's a very complex interaction and easily broken when manually accessing a data table directly.
Sorry if what I'm saying here is stuff you already know, but you have never told us what your database manipulation experience and skills are so:
Since you have Cpanel access what you need to do is locate the Cpanel app called phpMyAdmin and once it loads, click on the name of your database in the left-hand column. This will open up a large window in the right hand column which will display the individual data tables -- you can click on one any of the data tables open it up. This will show you the individual rows of stored data in the table and the data fields contained in each row.
You can click on the "Edit" option to view and modify this data in detail (usually you have to click on a individual row before you can edit it) BEEP! BEEP! BEEP! -- manually editing *anything* in a data table is incredibly dangerous if you do not know exactly what you're doing -- What I suggest you do is only use the "Edit" function to poke around in the various data tables to identify which bits of text are located where, without actually changing anything (either on purpose or accidentally).
That's the only way you're going to be able to figure out which fields of which tables to extract with your python script for later use. I'm attaching an image to this message which shows the initial phpMyAdmin page of a new, empty Gallery 3 installation:
-- J.R.
On 5/24/22 7:03 PM, Andrew L wrote:
Thanks. The Gallery2 install is dormant - I haven't added pictures for many years. I may well play with it and try to upgrade it to Gallery3. I could try to use .htaccess to set the PHP version. Even if I successfully upgrade, I won't add more photos to the gallery.
However, before I attempt that, I would like to extract the captions from the MySQL database and find a way to link them to the JPGs in the album file structure.
Can anyone help me find the image captions text in the MySQL database?
On Tuesday, 24 May 2022 at 01:33:30 UTC+1 Kazuo Kuroi wrote:
Hi Andrew,
Who is your cpanel host? In many cases you may be able to switch your PHP handler using the htaccess. I used to host with A2, and IMH and both allowed this, but it was kinda screwy (both switched to lsapi)
If you need help, I can assist you. It's probably a good idea to upgrade to G3 and G3 Revival anyways if the gallery is still being used.
--
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/5b2e3999-1dce-4c35-ad1c-d57ececdf4a6n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/b6d59460-a627-4334-b2ad-ee37f743dd68n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/a37e9643-da57-d18f-941d-ebfa7f3928ba%40thepostalzone.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/f69ad304-32e1-40ec-9669-32e8fefc7fc1n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/c84ad202-42ba-419d-8e46-8dc11af9a19dn%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/0bc51ec1-6ac4-4254-93c9-58ce448ec08fn%40googlegroups.com.