[IPB integration]: E-Card - Guests can send but Admin's can't!

[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