Welcome, Guest. Please login or register.

Author Topic: Gallery back online  (Read 9756 times)

Description:

0 Members and 1 Guest are viewing this topic.

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« on: May 23, 2009, 03:27:56 AM »
Quote
for some reason we can not yet understand, there are absolutely no user comments on photos anywhere in the database since 2004.


Cue twilight zone soundtrack :)

To add to the caveat list, image ranking statistics couldn't readily be imported. If, after everything else, we figure out where the missing comments went, then I'll see what can be done about that.
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #1 on: May 23, 2009, 10:03:04 AM »
No tips required. I would have missed the gallery as much as the next guy.

-edit-

Actually, if anybody does want to give a tip, then perhaps a donation to OCA (see sig) or feed the amiga.org kitty

-/edit-

Just a note to make. It seems the new gallery allows you to edit your old content, which is a pretty nice feature.

However, I would ask that people don't until we've had a chance to track down the missing comments. The reason is that the only connection between the old gallery and the new is in the physical name of the image file. If that changes, we won't be able to match up any of the missing comments.
« Last Edit: May 23, 2009, 10:14:03 AM by Karlos »
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #2 on: May 23, 2009, 09:10:08 PM »
Quote from: DJBase;455860
Might it be possible to add a link for "Find all pictures of user XY" in the user profile? And maybe also a link like "see all my pictures" when I enter the gallery?

That already works. If you look at any image in the gallery, in the details you can see who uploaded it. If you click on their name, you can view all the images associated with them.

-edit-

Oh wait, you mean in the view of the user's profile... Never mind, my bad.
« Last Edit: May 23, 2009, 09:12:59 PM by Karlos »
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #3 on: May 24, 2009, 01:16:48 PM »
Quote from: Wayne;455731

For some reason we can not yet understand, There are absolutely no user comments on photos anywhere in the database since 2004.  
The database has NOT been changed, or altered in any way since the transition to vBulletin.  There was just something that happened 5 years ago (maybe an upgrade) which changed where myalbum (the module) stored said comments and neither Karlos nor I have been able to find them as of yet.  When / if we do, we'll upload them later.

Fixed

It seems that a site update was responsible. The update unified the comment system for all modules, such that one table held everything. My import was using the original tables that were in use before the site update.

I've just updated the gallery with the missing 5 years worth of comments. The caveats about excluded images and orphaned posts highlighted by Wayne above still apply.

That said, almost 12000 comments were translated .
« Last Edit: May 24, 2009, 01:22:12 PM by Karlos »
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #4 on: May 24, 2009, 01:24:51 PM »
Unfortunately, the rating systems were a bit too disparate still, so the images are all unrated again. Time to vote your favourites.

I still need to address the problem of posts that refer to the old gallery. This shouldn't be too dissimilar to the reference to old xoops thread issue, which has been fixed already.
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #5 on: May 24, 2009, 02:49:36 PM »
Quote from: cecilia;455967
unfortuunately the search in the galleries (public) doesn't seem to be working. and I mean I'm searching for titles


Not working, or not available?
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #6 on: May 24, 2009, 04:28:08 PM »
Quote from: cecilia;455990
not working, bubbilah

Seems to work here. A search for "summer" brought up my old "summer in manchester" image.

However, you need to use a wildcard character if the word you are looking for isn't at the start.

For example, "ASCI" didn't find anything but "*ASCI*" found the ascii joke images...
« Last Edit: May 24, 2009, 04:33:20 PM by Karlos »
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #7 on: May 24, 2009, 08:43:23 PM »
Quote from: cecilia;456029
well, I have the titles of the pics I want to find (from the Notification page of Olde Amiga org). So there's no need to 'guess'.

i'll try again later


It's also possible they weren't imported. Just try the first part of the title and a *...
int p; // A
 

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16878
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: Gallery back online
« Reply #8 on: May 26, 2009, 07:56:58 AM »
It ain't over yet...

At some point I'll need to do a link fix for the gallery. This basically involves updating all references to the old xoops myalbum module in people's posts to point to their equivalent image in photoplog. We did this for the forum section already, updating references to xoop's old newbb threads.
int p; // A