How do I update user albums to point to the user albums that where imported?
Gallery version = 2.2-rc-1 core 1.1.26
PHP version = 4.3.2 apache2filter
Webserver = Apache/2.0.46 (CentOS)
Database = mysql 4.1.18-standard, lock.system=flock
Toolkits = ArchiveUpload, Exif, Ffmpeg, ImageMagick, Gd
Acceleration = none, none
Operating system = Linux badassmustangs.com 2.4.21-40.EL #1 Wed Mar 15 14:30:04 EST 2006 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2
Rows in GalleryAccessMap table = 100
Rows in GalleryAccessSubscriberMap table = 2434
Rows in GalleryUser table = 18
Rows in GalleryItem table = 2432
Rows in GalleryAlbumItem table = 239
Rows in GalleryCacheMap table = 0
Posted: Thu, 2007-03-08 14:26
Posts: 32509
imported from where/what?
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 13
I imported all my user albums from coppermine.
Posts: 32509
there's no feature to do that with a few clicks.
see:
modules/useralbum/UserAlbumHelper.class function createUserAlbum().
- i'd go to site admin -> useralbum. change the "when to create" setting to "when first accessed."
- if you look at createUserAlbum(), you see that it mainly does 3 things:
1. create an album
2. set permissions for that album such that the user has all permissions for that album
3. map the id of the album to the user id
i guess you don't need step 1, you have those albums already.
i see that you have 18 users. so there's no point in automating things too much.
you'll have to look up the album ids and user ids and you can then map them by inserting a row in the g2_PluginParameterMap table.
GalleryCoreApi::setPluginParameter('module', 'useralbum', 'albumId', $albumId, $user->getId());
which translates into this SQL:
INSERT INTO g2_PluginParameterMap (g_pluginId, g_pluginType, g_parameterName, g_parameterValue, g_itemId)
VALUES ('useralbum', 'module', 'albumId', $albumId, $user->getId());
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 13
Thank you, I manually updated the database. Now my user's albums are correct!