vBulletin - Sync users via SQL

3towers

Joined: 2007-04-24
Posts: 2
Posted: Tue, 2007-04-24 18:50

Hello!

I'm just evaluating gallery2 and wanted to test if I could easily integrate it to our forums (some vbulletin boards tied together with some triggers in mysql5.0).
So I started by changing some of the core files and user table of gallery2 so it can handle passwords hashed by vb. The first test with the admin account worked very well. After that I imported some users from our boards to the gallery2 tables and linked them to groups. But it doesn't work with these freshly imported users (no login possible). Because I can not find any difference to the admin user (accept the other users aren't in the admin group) I think it has something to do with the caching system!? Whenever I go to the admin panel and click on "Users" I get following error:

Error (ERROR_MISSING_OBJECT) : Missing object for 9494

    * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1887 (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 (GalleryStorage::loadEntities)
    * in modules/core/classes/GalleryCoreApi.class at line 2251 (GalleryEntityHelper_simple::loadEntitiesById)
    * in modules/core/AdminUsers.inc at line 197 (GalleryCoreApi::loadEntitiesById)
    * in modules/core/SiteAdmin.inc at line 201 (AdminUsersView::loadTemplate)
    * in modules/core/classes/GalleryView.class at line 300 (SiteAdminView::loadTemplate)
    * in main.php at line 441 (GalleryView::doLoadTemplate)
    * in main.php at line 94
    * in main.php at line 83

 System Information
Gallery version 	2.2.1
PHP version 	5.2.1-pl3-gentoo cgi-fcgi
Webserver 	Apache
Database 	mysqli 5.0.38
Toolkits 	SquareThumb, ImageMagick, Thumbnail, NetPBM, Gd
Operating system 	Linux apocalypse 2.6.18-hardened-r6 #5 SMP Mon Apr 16 12:02:20 CEST 2007 x86_64
Browser 	Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3

The missing object 9494 is a user id. When I delete that user ithe gallery complains about the next one. Any help on that would be greatly appreciated!

Best regards
Tim
 
3towers

Joined: 2007-04-24
Posts: 2
Posted: Wed, 2007-04-25 05:36

I found the problem. I had to add the users to the g2_Entity table as well as GalleryUser objects. Now everything seems to work.