Guests can email - but registered users trigger 'Critical error'

[dylanmalone]

Our installation is new (obviously our site is too-- but growing fast, mentioned by Jay Leno tonight actually).  Everything is working well on our Coppermine / SMF board integrated site, except that registered users break the eCard feature (which we would get a lot of use out of).

The error is:
While executing query "SELECT realName as user_name, ID_GROUP as mgroup, ID_POST_GROUP, emailAddress as user_email, dateRegistered as user_regdate, websiteURL as user_website FROM `forum`.smf_members WHERE I
D_MEMBER = '1'" on 0

mySQL error: 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 'D_MEMBER = '1'' at line 2

----------------------------------------------------
Here's the full debug info:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 6a7ae6157f1da621f87882d4fc2ecd57
    [am] => 1
    [liv] => Array
        (
            [0] => 22
            [1] => 4
            [2] => 13
            [3] => 6
            [4] => 26
        )

    [name] => Dylan Malone
    [email] => dylanm@mac.com
)

==========================
USER DATA:
------------------
Array
(
    [disk_max] => 20000
    [disk_min] => 20000
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [group_name] => Administrator
    [upload_form_config] => 3
    [group_quota] => 20000
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [0] => 1
            [1] => 5
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg132_filetypes;
    [1] =>
SELECT variable, value
FROM smf_settings
    [2] =>
SELECT mem.*, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.ID_MEMBER = 1)
WHERE mem.ID_MEMBER = 1
LIMIT 1
    [3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg132_usergroups WHERE group_id in (1,5)
    [4] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1
    [5] => DELETE FROM cpg132_banned WHERE expiry < 1100163864
    [6] => SELECT * FROM cpg132_banned WHERE ip_addr='207.202.146.79' OR ip_addr='207.202.146.79' OR user_id=1
    [7] => SELECT realName as user_name, ID_GROUP as mgroup, ID_POST_GROUP, emailAddress as user_email, dateRegistered as user_regdate, websiteURL as user_website FROM `forum`.smf_members WHERE I
D_MEMBER = '1'
)

==========================
GET :
------------------
Array
(
    [album] => lastup
    [cat] => -2
    [pid] => 26
    [pos] => 1
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.2 - OK
------------------
mySQL version: 4.0.18
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
module doesn't exist
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /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 | Off | Off
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php | .:/usr/lib/php
open_basedir | no value | 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 | 8M | 8M
==========================
Page generated in 0.086 seconds - 8 queries in 0.009 seconds - Album set :

I noticed in the above code a mention that there was no GD (which is true, we're using Image Magik)-- I can't imagine it matters, since the ecards work fine for guests... weird.  I'd be very grateful for ideas.

[Joachim Müller]

please post a link to your page (and a test account if needed to send ecards), so I can have a look (with debug_mode enabled). I suspect there's something fishy with the line breaks...
If you can't switch on debug_mode for everyone, please attach a screenshot of the error message (using "additional options" when composing your reply).

Joachim

[dylanmalone]

Thanks for the quick response.

Here's our coppermine page (again, brand new, no real customization yet):
http://www.algore-08.com/gallery/

And you can login as:
user: ecard
pass: testing

If you need an Administrative account please email me at dylan@algore-08.com and I'll give you a different login.

As I said, if you don't login at all, the ecard works perfectly.  Login first, it breaks.  Darned strange.  Must have something to do with the SMF bridge not giving Coppermine something it expects for ecards.  (our SMF installation is pretty plain vanilla-- no modifications of any kind)

[Joachim Müller]

it appears your bridge file is broken somehow. Get a fresh copy of the bridge file from the cvs and re-apply your integration settings (back up your existing bridge file first). Make sure to use a plain text editor (notepad.exe is fine).

Joachim

[dylanmalone]

It's fixed with that suggestion.  Thank you, I feel guilty that I didn't think to try that without pestering you first.  Excellent software, excellent support.

With gratitude,
    Dylan