mambo / G2 image block module and user error

aravot
aravot's picture

Joined: 2005-03-05
Posts: 61
Posted: Sun, 2005-07-31 20:21

I have Mambo 4.5.2.3, SMF 1.0.3 and G2 bridged

I use the following component MOS_SMF_BRIDGEv3.19a_stableto bridge Mambo and SMF, than michiel_1981's 2.0.6 component for G2.

Now for some unknown reason few users don't show up in Mambo backend under ‘User Manager’ but those user can still login and out of Mambo however when those user login receive following error message (I have debug site enabled)

Notice: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g2.group_id='Registered'' at line 4 in /home/mysite.com/public_html/orstio/includes/database.php on line 221 

/home/mysite.com/public_html/orstio/includes/database.php:319
/home/mysite.com/public_html/orstio/includes/gacl_api.class.php:1679
/home/mysite.com/public_html/orstio/includes/mambo.php:467
/home/mysite.com/public_html/orstio/includes/mambo.php:424
/home/mysite.com/public_html/orstio/index.php:107
Notice: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g2.group_id='Public Backend'' at line 4 in /home/mysite.com/public_html/orstio/includes/database.php on line 221

/home/mysite.com/public_html/orstio/includes/database.php:319
/home/mysite.com/public_html/orstio/includes/gacl_api.class.php:1679
/home/mysite.com/public_html/orstio/includes/mambo.php:468
/home/mysite.com/public_html/orstio/includes/mambo.php:424
/home/mysite.com/public_html/orstio/index.php:107
Notice: Undefined index: is_admin in /home/mysite.com/public_html/orstio/smf/Sources/Security.php on line 556

Notice: Undefined index: permissions in /home/mysite.com/public_html/orstio/smf/Sources/Security.php on line 563

Warning: in_array(): Wrong datatype for second argument in /home/mysite.com/public_html/orstio/smf/Sources/Security.php on line 563
session_start(): Cannot send session cache limiter - headers already sent (output started at /home/mysite.com/public_html/orstio/includes/database.php:221)

And this message in Mambo front-end in place of Gallery Block Module

Input Array does not match ?: SELECT DISTINCT g2_AccessMap.g_accessListId FROM g2_AccessMap WHERE (g2_AccessMap.g_userId = NULL OR g2_AccessMap.g_groupId IN (1)) AND g2_AccessMap.g_permission & 1 =
Fatal G2 error
Here's the error from G2:
Error (ERROR_STORAGE_FAILURE)

    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1166 (gallerystatus::error)
    * in modules/core/classes/GalleryStorage.class at line 225 (mysqldatabasestorage::search)
    * in modules/core/classes/Gallery.class at line 223 (gallerystorage::search)
    * in modules/core/classes/helpers/GalleryPermissionHelper_simple.class at line 89 (gallery::search)
    * in modules/core/classes/GalleryCoreApi.class at line 399 (gallerypermissionhelper_simple::fetchaccesslistids)
    * in modules/imageblock/classes/ImageBlockHelper.class at line 435 (gallerycoreapi::fetchaccesslistids)
    * in modules/imageblock/classes/ImageBlockHelper.class at line 335 (imageblockhelper::cacheviewabletree)
    * in modules/imageblock/classes/ImageBlockHelper.class at line 202 (imageblockhelper::fetchviewabledata)
    * in modules/imageblock/classes/ImageBlockHelper.class at line 85 (imageblockhelper::_addblock)
    * in modules/core/classes/GalleryEmbed.class at line 742 (imageblockhelper::loadimageblocks)
    * in /home/mysite.com/public_html/orstio/modules/mod_gallery_block.php at line 57 (galleryembed::getimageblock)
    * in /home/mysite.com/public_html/orstio/includes/frontend.html.php at line 264
    * in /home/mysite.com/public_html/orstio/includes/frontend.php at line 122 (modules_html::module2)
    * in /home/mysite.com/public_html/orstio/templates/247portal-b-blue/index.php at line 95
    * in /home/mysite.com/public_html/orstio/index.php at line 204

Don't know if the error is cause by Mambo, SMF bridge or G2 component but since I saw 'g2.group_id' in the errors I thought I post it here.

If link to site is required and test account please PM me.
 
michiel_1981

Joined: 2005-05-19
Posts: 430
Posted: Mon, 2005-08-01 06:51

aravot,

could you try a sync the users. if no go, please post your table build from your mambo user table.
Using the bridge are any files altered from mambo it self?

regards,
Michiel
 
aravot
aravot's picture

Joined: 2005-03-05
Posts: 61
Posted: Mon, 2005-08-01 15:29

Michiel,

Synced user, no change same result, don't know what you mean by table build sorry, as far as I know no files are altered in Mambo.

I have posted the question in SMF too here is the link if you want to check over there too.

http://www.simplemachines.org/community/index.php?topic=42849.msg317472
 
michiel_1981

Joined: 2005-05-19
Posts: 430
Posted: Mon, 2005-08-01 16:15

aravot,

your users have to be in the mambo user table with all this info present
*email
*username
*fullname
*password
*blocked or not

else syncing will be done, but is wrong and what i can see from your screen shots at simplemachine this isn't the case.

regards,
Michiel
 
aravot
aravot's picture

Joined: 2005-03-05
Posts: 61
Posted: Mon, 2005-08-01 16:59

Michiel,

It is solved actually a work around, see SMF forum (link above).

Thanks
Aravot