G2 ERROR_COLLISION Messages

Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Sat, 2008-07-05 16:14

I've done a search and could not find anything new about a problem I'm having with WPG2 3.0.7 and Gallery 2.2.5. This morning, I'd installed WPG2 3.0.6, had an error, searched this forum, deactivated/uninstalled 3.0.6, installed/activated BTEV 1.8.1, installed/activated 3.0.7, and I'm still having an error with WPG2.

The original error with 3.0.6 was a failure in the G2 rewrites that were cleared up with the BTEV. Now the error is that Users | Gallery2 users fails with the following errors:

Fatal G2 error
Here's the error from G2: Error (ERROR_COLLISION)

* in modules/core/classes/GalleryUser.class at line 149 (GalleryCoreApi::error)
* in modules/core/classes/GalleryEmbed.class at line 344 (GalleryUser::create)
* in /server_location/wordpress/wp-content/plugins/wpg2/wpg2embed.inc at line 257 (GalleryEmbed::createUser)
* in /server_location/wordpress/wp-content/plugins/wpg2/wpg2usersadmin.php at line 124
* in /server_location/wordpress/wp-admin/admin.php at line 69
* in /server_location/wordpress/wp-admin/users.php at line 2

and BTEV reported "WPG2 COULD NOT FIND G2 USER: <my user account>".

Interestingly, I had not created <my user account> in Gallery but I'm guessing that WPG2 did because the account is there and also an admin. If there is anymore information required, please let me know. So, I hope that the gurus here can do the voodoo they do and help me unf__k my site!

Cheers!!

Config data
Gallery version = 2.2.5 core 1.2.0.7
PHP version = 5.2.6 cgi
Webserver = Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8b DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Database = mysqli 5.0.51a-community, lock.system=flock
Toolkits = ArchiveUpload, Exif, Getid3, LinkItemToolkit, Thumbnail, Gd
Acceleration = none, none
Operating system = Linux my_hosting_service.com 2.6.18-53.el5 #1 SMP Mon Nov 12 02:22:48 EST 2007 i686
WPG2 version = 3.0.7
BTEV version = 1.8.1

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Tue, 2008-07-08 09:59

.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2008-07-08 14:18

Moved to WPG2 Plugin Support 3.x forums

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Tue, 2008-07-08 14:50

Thanks.

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Wed, 2008-07-09 02:48

Poppa_Bear

Nvigate to Wordpress -> Dashboard -> Users -> Wordpress Gallery2 users tab and the user mapping should be re-created (hopefully correctly) ;)
____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Wed, 2008-07-09 04:22

oz,

thanks for the suggestion, however, that is where the problem lies. Every time I go to the G2 Users tab, per your directions, I get the error message shown above. BTEV is showing the source as "/plugins/wpg2/wpg2embed.inc"; dunno if that is relevant.

Anything else?

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Thu, 2008-07-10 09:42

.

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Fri, 2008-07-11 03:16

Hiya Poppa_Bear,

Sorry sorry but very little more I can do to help you. The last ditch attempt could be that you have some corruption in your g2_ExternalIdMap table that WPG2 cannot repair. If you log into your Database via phpmyadmin and manually clear your g2_ExternalIdMap, then try visiting the Gallery2 Users Tab

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Tue, 2008-07-15 12:01

oz-

Thanks for the info. I went into PHPmyAdmin and deleted the contents of the g2_ExternalIdMap. No change; still unable to see G2 Users in WP. I just updated to WP2.6 and, after activating the WP2G plugin, I was able to see the G2 Users page. As there were a few accounts where the passwords were incompatible with G2, I remembered the "fix" was to log off then log back in. After doing so, I am back to being unable to connect to the G2 Users in WP.

Does this provide any more information? Any help?

Cheers!!

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Tue, 2008-07-15 18:50

oz-

BTW, here's the output from BTEV:

Array
(
[type] => NOTICE
[date] => 2008-07-15 20:45:28
[source] => /public_html/wordpress/wp-content/plugins/wpg2/wpg2embed.inc
[file_line] => 1092
[user_id] => 3
[ip_address] => xxx.xxx.xxx.xxx
[event_id] => 12135
[event_no] => 1024
[description] => WPG2 COULD NOT FIND G2 USER:Poppa
[trace] =>
)

Does this help any?

Cheers!!

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Wed, 2008-07-16 17:13

OK, after a couple of other issues, I decided to reinstall G2. Just like the 07-15 14:01 post, I was able to see that my current account was password incompatible and, after cycling the logon, still the same crash issue. If I log into WP2.6 as the site admin, I can see that all accounts are now compatible. When I tried to give my user account G2 rights, the page bombs out to the original crash. Hope that this is enough data points for a some sort of resolution.

Cheers!!

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Thu, 2008-07-17 04:44

Unfortunately not because I just cannot reproduce this issue.. You are running WPG2 3.07 right?

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
mogmismo

Joined: 2008-06-18
Posts: 2
Posted: Tue, 2008-07-29 18:55

I had this same issue, with wpg2 3.0.7 also, and tried everything above. Found the problem and the solution: Wordpress's built-in "admin" account that is created during install had my email address, and so did the account that I created for myself. Either remove the admin user or change the email address to something else, and the collision errors went away. (I like leaving the wordpress admin as a backdoor for myself into my WP system).

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Wed, 2008-07-30 03:59

So you had two Wordpress Accounts with the same Email Account??

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Wed, 2008-07-30 05:13

mogmismo- That was it, exactly! Thanks!!

oz- The default admin account for my WP install had the same email address as my WP user account. My WP user account was also an admin to the WP site and to the Gallery site. The default admin account is only a subscriber to the WP site and not even a Gallery user. Once I changed the email address for the admin account to something other than what my user/admin account had, WPG2 came right up and is working great.

Fellas, thanks so much for the help and patience.

Cheers!!

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Wed, 2008-07-30 06:43

Ok Slow moment here..

Can you help me out with your account mapping.. Say for example your Wordpress Account

admin ->

user ->

Gallery2

admin ->

Have I got this right??

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
Poppa_Bear

Joined: 2008-07-05
Posts: 13
Posted: Wed, 2008-07-30 10:10

At WP install, I used my hotmail account as the email address for the default admin account. I then changed the role of the admin account (since I couldn't delete it) to a WP subscriber. I then created my user account, gave it the >>same<< hotmail address then added it to the WP admin group. Then I started having problems with the WPG2 plugin as described in my original post.

Based off of mosmismo's suggestion, I changed the email address for the WP admin account to some garbage account, like

, and left my user account as is. Now, everything works as advertised. My apologies for any confusion. Does this help?

Cheers!!

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Wed, 2008-07-30 11:50

Ahh so you have TWO Wordpress accounts with the same email address. Interesting, I suspect that is not allowed. Thanks for this.. That will help track down the behaviour..

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2008-07-30 13:44
Quote:
Ahh so you have TWO Wordpress accounts with the same email address. Interesting, I suspect that is not allowed.

What if I have one email address for the family and I would like to have my son and daughter have their own account in WP. Is this a WP limitation or a WPG2 limit?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Wed, 2008-07-30 22:44

floridave,

I suspect it is a G2 limit as it is G2 that is generating the ERROR_COLLISION not WP. WPG2 will happily create the Account in G2 right up to the point of getting the ERROR_COLLISION. I have opened a bug report against WPG2 3.1 to add some code to fix this.

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
mogmismo

Joined: 2008-06-18
Posts: 2
Posted: Mon, 2008-08-04 02:19

yep: user@domain was set as the admin user's email (I like to get these emails too)
and: user@domain was set to my wordpress user's id.

Wordpress has no problem with this that I have ever experienced.

 
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Mon, 2008-08-04 03:41

No I believe issue is in Gallery2 technically you should not have more than one user using the same email address and I can understand that logic...
____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

 
Peorth

Joined: 2008-08-09
Posts: 1
Posted: Sat, 2008-08-09 22:14

I had the same error, seemingly after upgrading to WP 2.6. I followed the suggested steps, including the email address fix. I did have same email addresses for 2 accounts, but my issue was not fixed after correcting this. When logging in as a different account that also had admin rights on both WP and G2, I didn't have the problem. I remember that in G2, I had renamed the admin account from ADMIN to my own user account. I changed this back to admin, created a new account matching my WP account, gave admin permissions and everything is fixed. Just an FYI for those who may have similar problems still. A suggestion to maybe think about making the admin account in Gallery unchangeable so users can't rename and end up with this issue.

 
visualtorrent

Joined: 2005-10-11
Posts: 4
Posted: Fri, 2008-10-17 20:25

I had a similar error like this, due to the fact that my website is running phpbb3 with gallery2 integration there. My users already have accounts in gallery2 by the time they make it to the blog. Would it be simple to just include some conditional logic to abandon the account creation if an account already exists? To that end, it would be nice if the user integration portion of the plugin could be entirely disabled. I could alternately use WP Gallery Remote, but it doesn't seem to have as many great options as WPG2.