"Error - Item not found" when trying to access user page in admin area (g2 2.3)

taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Tue, 2008-11-04 08:34

Hi everybody,

when trying to acess users page in admin area I get the following error message. I hope anybody can help me solving this because I have no idea :(

Quote:
Error

Item not found.

Back to the Gallery
Error Detail -
Error (ERROR_MISSING_OBJECT) : Missing object for 44

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 2054 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 98 (GalleryStorageExtras::_identifyEntities)
* in modules/core/classes/GalleryStorage.class at line 313 (GalleryStorageExtras::loadEntities)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 71 (GalleryStorage::loadEntities)
* in modules/core/classes/GalleryCoreApi.class at line 2361 (GalleryEntityHelper_simple::loadEntitiesById)
* in modules/core/AdminUsers.inc at line 198 (GalleryCoreApi::loadEntitiesById)
* in modules/core/SiteAdmin.inc at line 209 (AdminUsersView::loadTemplate)
* in modules/core/classes/GalleryView.class at line 293 (SiteAdminView::loadTemplate)
* in main.php at line 465 (GalleryView::doLoadTemplate)
* in main.php at line 104
* in main.php at line 88

System Information
Gallery version 2.3
PHP version 5.2.6 apache2handler
Webserver Apache/2.2
Database mysqli 5.0.32-Debian_7etch6-log
Toolkits Thumbnail, Gd
Operating system Linux wp134 2.6.22.19-he-xeon-64gb+2 #1 SMP Tue Sep 2 14:02:52 CEST 2008 i686
Browser Mozilla/5.0 (X11; U; Linux i686; de; rv:1.9.0.3) Gecko/2008092510 Ubuntu/8.04 (hardy) Firefox/3.0.3

Thanks in advance!
Taiko

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2008-11-04 23:17

Enabled debug mode, go to that page that has the error, copy and paste the output into a text file, zip it, and attach to this thread.
FAQ: How to set/use Gallery in debug mode?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Wed, 2008-11-05 16:20

Done! Thank you very much in advance!!! :)

*edit: sry wrong attachment, I replaced it

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-11-05 17:01

Well I don't see any errors, but I know nothing about Joomla integrations.

-- Moving thread to the Joomla forum.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Wed, 2008-11-05 18:26

Thanks for checking the debug!

It is not an usual Joomla! integration. It is a standalone gallery2 in a Joomla subfolder, new users are written to the gallery2 database and logins/logouts are syncronized, that's it. This is all working, just the user page in admin area is not.

Is the problem that users are written to the database? How can I make G2 to accept the new users (if it doesn't and is showing the error because of that)?

Regards,
Taiko

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-11-05 18:35

If you want I can take a look. In G2 standalone, create a temporary user, add that user to the Site Admin group and PM me the login details (click Write to author)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-11-05 19:31

got your message, just let me know when you have Gallery back in buffered debug mode.

Thanks
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Wed, 2008-11-05 20:31

done:)

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-11-05 21:05

hmmm, I don't know if this will work or not. Try clearing the database cache, Site Admin > Maintenance clear database cache
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Wed, 2008-11-05 21:32

I already did, but it didn't help :(

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-11-05 22:33

Then the only other thing I can think of is to take a look at your database. Unfortunately I don't know every place the user ids are suppose to show up. I'd take a look at the g2_user table first to see if the g_id column has an entry for 44

But I really don't know how to fix this. I'll have to get a dev in here taking a look.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-11-05 22:48

Actually looking at the log closer, take a look at the g_Entity table and browse the g_id row and see if there is an entry for 44. It should be incremental so you should see it on the 1st or 2nd page. If it's missing, then as for adding that entry back in, I don't have a clue.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Thu, 2008-11-06 01:34

Hi nivekiam, thank you very much for your efforts.

There is actually a user with the g_id=44, but no entry in g_Entity with g_id=44.

It is actually ddifficult to see what I could add there and I don't think that it is related to the user. She shouldn't have uploaded anything.

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2008-11-06 05:23

First make a backup of your database. Not an XML backup from G2, but a real backup from your control panel.

Now, just far warning, I don't know what I'm doing when dabbling in the database. But, if this was my install and from what I've seen from digging around this is what I'd do.

In phpMyAdmin, go to the g2_Entity table. Click Insert (at the top)

Create 1 new row for that user. For timestamp, I don't know what to put, in my screenshot below I only copied from an existing user:

Once that is filled out click Go

[img]http://gallery.menalto.com/files/g2_entity_44.gif[/img]
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Thu, 2008-11-06 09:09

I tried that and got a different error message now.

Quote:
Error

Item not found.

Back to the Gallery
Error Detail -
Error (ERROR_MISSING_OBJECT) : Entity with id [59] is a [GalleryDerivativeImage] and does not extend the required entity type [GalleryUser].

* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 129 (GalleryCoreApi::error)
* in modules/core/classes/GalleryCoreApi.class at line 2361 (GalleryEntityHelper_simple::loadEntitiesById)
* in modules/core/AdminUsers.inc at line 198 (GalleryCoreApi::loadEntitiesById)
* in modules/core/SiteAdmin.inc at line 209 (AdminUsersView::loadTemplate)
* in modules/core/classes/GalleryView.class at line 293 (SiteAdminView::loadTemplate)
* in main.php at line 465 (GalleryView::doLoadTemplate)
* in main.php at line 104
* in main.php at line 88

May this be related to that I created several users in the database by myself? I copied them from Joomla because they should use the same User:password combination. Users can login but maybe some data is missing related to images, albums etc.?

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2008-11-06 23:09

You manually edited the database to add users? If so, that's a bad thing. If I were you I'd delete those users, probably directly from the database just like you added them because you can't get to the User's admin interface page anyway.

This probably includes that user with the id 44 doesn't it? If so, also delete that other entry I had you create above. Users should only be created through the user interface or gallery api, the database should never be edited manually unless instructed to do so to fix something that's corrupt.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
taikonaut

Joined: 2008-10-07
Posts: 22
Posted: Wed, 2009-07-08 14:22

Hi nivekiam,

I did not! I have a script that uses gallery api but something seems to be wrong:S

Unfortunately I can not change to J!1.5. Somehow the user id is not auto increased but increased in another table, is that right?
Is there a detailed documentation how to use gallery api and to add new users?

important: Can I re-install gallery2 or even update without losing my albums, pictures and their information?

Thanks a lot in advance!

Regards,
Taiko

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-08 15:33
Quote:
important: Can I re-install gallery2 or even update without losing my albums, pictures and their information?

You should be able to, but I don't know about the Joomla integration.

As for using the API, this is where I'd start:
http://codex.gallery2.org/Gallery2:API
http://codex.gallery2.org/Gallery2:Embedding
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
montylee

Joined: 2007-04-14
Posts: 21
Posted: Fri, 2009-07-10 20:02

I'm experiencing a similar failure in that Gallery 2.3 fails when trying to access the Users (Site Admin). Everything else works great.

The thread - http://gallery.menalto.com/node/88960

So perhaps if you get a solution it would apply to my problem.