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:
QuoteWhile 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:
QuoteUSER:
------------------
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]
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.
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
Ok thanks for the replies.
Regards,
Graham.
you are lucky. Guests can send ecards. On my board... no one can.. caz it shows some query error in the database. :o
ok. Author of that mod has fixed that bug. Now your members can send e-card as well. Download the updated file.
@tombmaster: stop cross-posting! [:|
GauGau