Integration Corrupted Gallery?

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

site: www.WeizenWeizen.Com

I suspect that my Gallery is corrupted. I further suspect that the integration somehow caused the corruption.

Gallery -> Maintenance-> Integrity Check passes

Gallery -> User Albums -> Create albums = When user is created

Currently, the site is usable (thank you, Dari)

On two occassions, over a period of many weks, I went to work and when I returned home, I noticed that a new user had registered and that the Gallery root was not accessable. User galleries were accessable.

I asked one user and he said he registered via the forum and not via Gallery. (aside: if the string for "Registrer" was changed to the NULL string in the Gallery language packs, nobody could click on it.)

On both occassions, Dari fixed something. I do know that there are bogus user gallery album names. For example, there is currently a Weizentoni (correct) and a Weizentoni_ (bogus: user name plus a trailing underscore) in g2data/albums.

phpbb correctly has user weizen.w, but Gallery2 has no user weizen.w. I think this is because of the 'dot' in the user's name. I did not sync because last time I sync'd and it did not help. I left it as is in case somebody wants to investigate.

weizen.w did not cause the problem. He registered on Nov 29. My second round of problems began on Nov 23 or so.

g2Img is currently broken. However, it used to work. I believe that g2Img is having a problem with some corruption in Gallery or the integration:
loadEntitiesById failed for 7142. Here is the error message from G2:
Error (ERROR_MISSING_OBJECT)

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 169 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 298 (gallerystorageextras::loadentities)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 71 (mysqlstorage::loadentities)
* in modules/core/classes/GalleryCoreApi.class at line 2259 (galleryentityhelper_simple::loadentitiesbyid)
* in /home/weizen/public_html/phpbb2/g2image/g2image.php at line 148 (gallerycoreapi::loadentitiesbyid)
* in /home/weizen/public_html/phpbb2/g2image/g2image.php at line 195
* in /home/weizen/public_html/phpbb2/g2image/g2image.php at line 78

I have a hierarchical user album structure. A new user's album is created in root. I then move it to a subdirectory.

I have always played by the rules. I have never telnetted to the host and moved files or directories. I have always used available menu options.

Once I set a user non-active user to active.

Since this second round of corruptions, I have not touched a thing. Dari got us working again, but I have not moved any new user albums nor deleted and invalid albums (dups with underscores).

I strongly believe that there is something to be learned by watching g2Img fall on its sword.

Finally, I'm having a problem getting the language choices (German / English) to behave as I want. This is probably a Gallery problem and not an integration issue. I am contacting them. I mention this "just in case".

Thanks for listening--
--Luke

AdBot

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

Hi Luke,

Without knowing what dari had to do to get your site working again, it may be hard for me to diagnose the problem, but I will respond to some of these issues based on what I know...

Quote: › I suspect that my Gallery is corrupted. I further suspect that the integration somehow caused the corruption.

I agree with the first sentence, not necessarily with the second, because the integration does not touch user albums. This is all managed by Gallery.

Quote: › I asked one user and he said he registered via the forum and not via Gallery. (aside: if the string for "Registrer" was changed to the NULL string in the Gallery language packs, nobody could click on it.)

All registration should be done via the forum and not through Gallery at all. A better way to accomplish this is to disable Gallery registration by setting it to embed only in the config file and make sure the optional user registration module is not installed or disabled.

Code: › #
#-----[ OPEN ]------------------------------------------
#
../gallery2/config.php

#
#-----[ FIND ]------------------------------------------
#
$gallery->setConfig('mode.embed.only', false);

#
#-----[ REPLACE WITH ]------------------------------------------
#
$gallery->setConfig('mode.embed.only', true);

Quote: › On both occassions, Dari fixed something. I do know that there are bogus user gallery album names. For example, there is currently a Weizentoni (correct) and a Weizentoni_ (bogus: user name plus a trailing underscore) in g2data/albums.

I don't know what dari did to fix things and again, the integration does not create or manage Gallery albums.

Quote: › phpbb correctly has user weizen.w, but Gallery2 has no user weizen.w. I think this is because of the 'dot' in the user's name. I did not sync because last time I sync'd and it did not help. I left it as is in case somebody wants to investigate.

I just created a user in phpbb2 with a dot in the name and it worked fine through the integration in both apps. Don't forget the user is not immediately created in Gallery, but only after first Gallery access.

Quote: › g2Img is currently broken. However, it used to work. I believe that g2Img is having a problem with some corruption in Gallery or the integration:

Since this second round of corruptions, I have not touched a thing. Dari got us working again, but I have not moved any new user albums nor deleted and invalid albums (dups with underscores).

I strongly believe that there is something to be learned by watching g2Img fall on its sword.

Again, this points to a Gallery corruption problem. The integration does not tell g2image anything about the users album id, it gets this information from Gallery itself. Sounds suspiciously like something is off by one in a gallery db table somewhere...

Quote: › Finally, I'm having a problem getting the language choices (German / English) to behave as I want. This is probably a Gallery problem and not an integration issue. I am contacting them. I mention this "just in case".

I don't think this has anything to do with integration either. It simply adds a couple language files and adds a few mods to the existing english files in phpbb.

It seems to me something has gotten screwed up in at least one of your gallery db tables. I don't have an explanation for you, but I can tell you the integration does not directly manipulate any of the gallery tables and it does not manipulate the user albums in any way whatsoever. It only manages users and groups through the appropriate gallery api calls.

If there is anything else I can do, I'm glad to help! Smile

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

Hi jettyrat.

Quick response. Thanks!

jettyrat wrote: › Don't forget the user is not immediately created in Gallery, but only after first Gallery access.

But what is this option?

Gallery -> User Albums -> Create albums = When user is created

....Puzzled Question

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

weizenjaeger wrote: › Hi jettyrat.

Quick response. Thanks!

jettyrat wrote: › Don't forget the user is not immediately created in Gallery, but only after first Gallery access.

But what is this option?

Gallery -> User Albums -> Create albums = When user is created

....Puzzled Question

The way the integration works is that when a user creates an account in phpBB, their account is not immediately created in Gallery. They don't get an account in Gallery until they visit the integrated Gallery for the first time. It is at this time their album should get created by the Gallery create albums module you have enabled. One could probably add a hook in the phpbb login script to have the Gallery account created right away. I guess the logic of the current method is not to create Gallery accounts for users who do not intend to use Gallery and only create their account the first time they login to phpBB and then visit Gallery.

I've been thinking about your problems, but I still don't have an answer as to why things got screwed up in Gallery. One thing has occurred to me though, it is possible your language problems may be coming from the integration.
1. The integration does not pull the users language preference from phpBB2 to Gallery unless this mod [nukedgallery.net] is applied.
2. Because Gallery uses utf-8 character sets and phpBB2 uses ISO-8859-1 character sets, there is some 'on-the-fly' utf-8 translation being done by the integration if you have the 'UTF-8 Translate' option enabled in the phpbb ACP Gallery settings. You can try switching this on and off to see if it is causing any of the problems.

Maybe when dari pops back in, he can shed some light on the problems with your installation. Smile

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

jettyrat wrote: ›

Quote: › phpbb correctly has user weizen.w, but Gallery2 has no user weizen.w. I think this is because of the 'dot' in the user's name. I did not sync because last time I sync'd and it did not help. I left it as is in case somebody wants to investigate.

I just created a user in phpbb2 with a dot in the name and it worked fine through the integration in both apps.

In previous, private emails, I was informed that periods (and double quotes?) were not OK and that the gallery devs acknowledge that the g2 useralbum plugin needs to sanitize the username before creating the album.

I agree that it might be an off-by-one problem. I hate those Mad

I think I first need to find somebody to verify that my Gallery is not corrupt (or fix it if it is corrupt). Should I contact Gallery paid support? Or maybe the g2Img author? He could identify the corruption as it is his code being slaughtered.

With a known, clean Gallery, I could then experiment creating various user names.

jettyrat wrote: › All registration should be done via the forum and not through Gallery at all. A better way to accomplish this is to disable Gallery registration by setting it to embed only in the config file and make sure the optional user registration module is not installed or disabled.

Sounds like this should not have been part of my site.

I think the language problem is within Gallery. It just doesn't behave the way I understand that it should behave (user's pref vs. browser's pref vs some API vs I-forget-what).

Thanks Very Happy

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

Quote: › In previous, private emails, I was informed that periods (and double quotes?) were not OK and that the gallery devs acknowledge that the g2 useralbum plugin needs to sanitize the username before creating the album.

When I tested the username test.test it worked fine, but I did not have the useralbum module installed so it could be that there is a problem with this module.

Quote: › I think I first need to find somebody to verify that my Gallery is not corrupt (or fix it if it is corrupt). Should I contact Gallery paid support? Or maybe the g2Img author? He could identify the corruption as it is his code being slaughtered.

The problem with the g2image author is that the code that is in the current phpBB2 integration is several versions behind the current g2image release. He may be able to offer some insight though. I've sent dari a new release of the phpBB2 integration which uses the latest g2image release, but he hasn't had time to release it yet.

I have no idea about Gallery paid support, I've never used it. If dari was able to fix it before, he might have an idea of what is causing the problems...

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

jettyrat wrote: › I guess the logic of the current method is not to create Gallery accounts for users who do not intend to use Gallery and only create their account the first time they login to phpBB and then visit Gallery.

That was also my thought, precisely.

jettyrat wrote: › One could probably add a hook in the phpbb login script to have the Gallery account created right away.

That would be a nice option to have in the integration. I'd pay for it to be an option.

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

Just took a look at the phpBB2 login script and it's not as easy as placing a hook there like I thought, another reason the integration is implemented the way it is. The user does not get a full session until index.php is reached and we would not want to put the hook there as it would be called every time the index page is loaded even if the user is already logged in and that would incur a large resource overhead penalty on the server.

It could still be done with another entry in the user table, so the hook would only be called if this entry was not set. Do you have the add-on 'gallery_link_in_profile' mod installed? This already has the field 'user_gallery' added to the db? If not, it could still be made to work without the mod.

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

jettyrat wrote: › Do you have the add-on 'gallery_link_in_profile' mod installed?

Yes, the 'gallery_link_in_profile' mod is installed and works great Very Happy

Do you need access to my site? I can PM/email account name and password to you.

I'm happy to pay for this.

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

As long as you have the 'gallery_link_in_profile' add-on installed and the phpbb_users table has the field 'user_gallery' in it and g2helper.inc has the function '_mapGalleryLink' in it, the code is simple:

Code: › #
#-----[ OPEN ]------------------------------------------
#
index.php

#
#-----[ FIND ]------------------------------------------
#
//
// End session management
//

#
#-----[ AFTER, ADD ]------------------------------------------
#
if (empty($userdata['user_gallery'])) {
require($phpbb_root_path . 'g2helper.inc');
$g2h = new g2helper($db);
$g2h->init($userdata);
$g2h->done();
}

I tested with username test.test and the gallery account is created immediately upon first phpbb login. I don't have the useralbum pulg-in installed, but presumably the album would be created immediately as well since the user is logged in to gallery as soon as the account is created and then logged out. This simply using the existing gallery login function from g2helper.inc. Obviously don't use the dot if there is a problem with it in the useralbum plug-in. Maybe this module is the root of you problems in the first place!

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

jettyrat wrote: › Obviously don't use the dot if there is a problem with it in the useralbum plug-in.

I cannot prevent new users from using dots. Nor do I want to prevent them from using dots. And there may be other gotchas besides dots Sad

Note: Most of my users know each other and are using their long-time eBay nicks.

jettyrat wrote: › Maybe this module is the root of you problems in the first place!

I've thought long and hard about this. Unfortunately, my recollection is that my problems started before my first "dot" user.

To sum up, I must wait for your slick 'gallery_link_in_profile' trick until my other grief is fixed.

Having said that, I'd be interested in either/both of two variants:
(1) An enable/disable "Immediate Gallery Creation" option under Forum Admin -> Gallery 2 -> Administration Options
(2) A "Create User's Gallery Right Now" button under User Admin -> Management -> Special admin-only fields

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

All I can say about the dots is phpbb2, basic gallery2 and the integration handle these just fine in my testing, so the problem must be in the plugin module.

Either admin option could be done, but both would obviously require more mods and code written...

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

jettyrat wrote: › Either admin option could be done, but both would obviously require more mods and code written...

Perhaps we can make it happen. Give me an estimate.

Meanwhile, I hope my site isn't in trouble.

A new user with an empty album has had his album disappear. He very well could have deleted it himself by accident. He is still a phpBB member and a Gallery member, but his root album is gone and the link to his gallery is gone. It previously existed.

I have created a new album, changed the ownership, and linked the user to the new album. I hope it works.

I can't think of a way to prevent a user from deleting his own root album.

weizenjaeger · Beginner Joined: Dec 02, 2007 Posts: 9

The WeizenWeizen.com Gallery is broken again.

User h0bbel signed up about a week ago. That is Gallery paid support to investigate German/English language issues.

Today, user pemaheke signed up. I came home from work, and Gallery is corrupted. I have not touched a thing..... I haven't even been online!

No dots in pemaheke's name. Looks like he has two entries in Gallery root.

Accessing user albums directly works fine.

Accessing the Gallery root causes:

Code: › Error (ERROR_MISSING_OBJECT) : Missing object for 24730

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 2075 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 98 (gallerystorageextras::_identifyentities)
* in modules/core/classes/GalleryStorage.class at line 298 (gallerystorageextras::loadentities)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 71 (mysqlstorage::loadentities)
* in modules/core/classes/GalleryCoreApi.class at line 2259 (galleryentityhelper_simple::loadentitiesbyid)
* in modules/core/classes/GalleryTheme.class at line 1285 (gallerycoreapi::loadentitiesbyid)
* in themes/matrix/theme.inc at line 65 (matrixtheme::loadcommontemplatedata)
* in modules/core/classes/GalleryTheme.class at line 926 (matrixtheme::showalbumpage)
* in modules/core/classes/GalleryView.class at line 308 (matrixtheme::loadtemplate)
* in main.php at line 441 (showitemview::doloadtemplate)
* in main.php at line 94
* in modules/core/classes/GalleryEmbed.class at line 179
* in /home/weizen/public_html/phpbb2/gallery2.php at line 40 (galleryembed::handlerequest)

System Information
Gallery version 2.2.2
PHP version 4.4.4 cgi
Webserver Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
Database mysqlt 4.1.22-standard
Toolkits ImageMagick, Thumbnail, Gd
Operating system Linux gator285.hostgator.com 2.6.17.11-grsechg #9 SMP Fri Dec 8 00:02:22 CST 2006 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11

How to I resolve this problem?

I have requested Gallery paid support quite some time ago, but have not heard from them. (That is a different request from my German/English grief).

I am not going to do research and fix this myself. I do not have the time. I need a contact and I have a PayPal account.

What about the fellow who wrote the g2 useralbum plugin?

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

I know this doesn't help you much, but I have no other clear answer. It seems the problem is the creation of two albums for new users, one of which is no good, hence the missing object error from gallery. I don't know anything about how the useralbum plugin works. If I have time next week, maybe I'll try installing this plugin and just have a look at what it does with mapping, etc.

I suppose it wouldn't hurt to ask the author of the plugin for any input or ideas, if you haven't already.