Print

[The Old Man]

Hi all,
I'm having a couple of side effects from using the bridge to link Coppermine v1.3.1 to Invisionboard V2.0 PF2.
This one relates to E-Cards. The gallery is here: http://www.sarahjaneredmond.com/gallery/

if I log in using my Administrator Login and I click to send a picture via e-card, an error message displays as "There was an error while processing a database query ".

However, if I Log Out (effectively being a guest?) and I go to the same picture and click the Send as E-Card icon, it works fine.

My Group Settings are shown in the attached screenshot.

I turn on error reporting and get this error message:

While executing query "SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `legion_ipb`.ibf_members WHERE id = '1'" on Resource id #6

mySQL error: File: /home/legion/public_html/gallery/include/functions.inc.php - Line: 105

This is the debug info:

USER:
------------------
Array
(
    [ID] => db21eafce38a7d0459c0b3fef67f3d80
    [am] => 1
    [liv] => Array
        (
           

• => 6

        )

)

==========================
USER DATA:
------------------
Array
(
   

• => 1

[user_id] => 1
    [1] => Graham P. Smith
    [user_name] => Graham P. Smith
    [2] => 4
    [mgroup] => 4
    [3] => 4
    [group_id] => 4
    [4] => Admin
    [group_name] => Admin
    [5] => 0
    [group_quota] => 0
    [6] => 0
    [has_admin_access] => 1
    [7] => 1
    [can_rate_pictures] => 1
    [8] => 1
    [can_send_ecards] => 1
    [9] => 1
    [can_post_comments] => 1
    [10] => 1
    [can_upload_pictures] => 1
    [11] => 1
    [can_create_albums] => 1
    [12] => 0
    [pub_upl_need_approval] => 0
    [13] => 0
    [priv_upl_need_approval] => 0
    [14] => 3
    [upload_form_config] => 3
    [15] => 0
    [custom_user_upload] => 0
    [16] => 5
    [num_file_upload] => 5
    [17] => 3
    [num_URI_upload] => 3
    [groups] => Array
        (
           

• => 4

        )

    [can_see_all_albums] => 1
)

==========================
Queries:
------------------
Array
(
   

• => SELECT extension, mime, content FROM cpg131_filetypes;
[1] => SELECT id as user_id, name as user_name, mgroup FROM `legion_ipb`.ibf_members WHERE id='1' AND  member_login_key='dcdb3499bd9d511505d6e6388f74e79f'
    [2] => SELECT * FROM cpg131_usergroups WHERE group_id = '4'
    [3] => DELETE FROM cpg131_banned WHERE expiry < 1091784822
    [4] => SELECT * FROM cpg131_banned WHERE ip_addr='81.86.227.137' OR ip_addr='81.86.227.137' OR user_id=1
    [5] => SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `legion_ipb`.ibf_members WHERE id = '1'
)

==========================
GET :
------------------
Array
(
   

[album] => 5
    [pid] => 8
    [pos] => 0
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.8 - OK
------------------
mySQL version: 3.23.56
------------------
Coppermine version: 1.3.1
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.23 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 5
Active Links 7
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | On | On
safe_mode_exec_dir | /usr/lib/php/ | /usr/lib/php/
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/lib/php/ | /usr/lib/php/
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php: | .:/usr/lib/php:/usr/local/lib/php:
open_basedir | /home/legion/:/usr/lib/php:/usr/local/lib/php:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.09 seconds - 6 queries in 0.001 seconds - Album set :

[attachment deleted by admin]

[Nibbler]

The IPB v2 bridge is not part of coppermine,  so I don't know enough about it to help you. The problem is in the udb_get_user_infos function in that bridge file, you would need to ask the author for support on this.

[Joachim Müller]

as the issue you're facing is related to using a bridge file I moved this thread to the bbs sub-board to draw the attention of the IPB people.

GauGau

[The Old Man]

Ok thanks for the replies.

Regards,
Graham.

[tombmaster]

you are lucky. Guests can send ecards. On my board... no one can.. caz it shows some query error in the database. 

[tombmaster]

ok. Author of that mod has fixed that bug. Now your members can send e-card as well. Download the updated file.

[Joachim Müller]

@tombmaster: stop cross-posting! [:|

GauGau