Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Buddy list not working while bridged  (Read 4035 times)

0 Members and 1 Guest are viewing this topic.

nickfzx

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 285
Buddy list not working while bridged
« on: March 20, 2007, 08:45:58 am »

Hey Stramm,

so I have the latest modpack and latest coppermine bridged with punbb.

It is all working fine and nicely but when I enable the buddy list and click on friend list I get this error:

Code: [Select]
There was an error while processing a database query
I have tried this on two separate installations with the same result.  I have searched and I have heard it said that the buddy list does work while bridged...with phpbb at least anyway.

Any ideas?


below is the debug info:
Quote
While executing query "SELECT id, buddy_ok, buddy_block, buddy_id, since, u.id AS avatar_url, u.username as buddy_name FROM copper_buddy as b LEFT JOIN db2734_amateurillustrator.users as u on b.buddy_id=u.id WHERE buddy_ok='YES' AND b.user_id = 2 ORDER BY buddy_name ASC LIMIT 0, 25;" on 0

mySQL error: Column 'id' in field list is ambiguous

mysite.com/coppermine/include/functions.inc.php - Line: 248

Code: [Select]
USER:
------------------
Array
(
    [ID] => eee316238eaaadf2e8771a80de3c3b82
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => Nick
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [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] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM copper_filetypes; (0s)
    [1] => select * from copper_plugins order by priority asc; (0s)
    [2] => SELECT * FROM copper_bridge (0s)
    [3] => SELECT u.id AS id, u.username AS username, u.password AS password, u.id AS avatar_url, u.email_setting AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.group_id+100 AS group_id FROM db2734_amateurillustrator.users AS u INNER JOIN db2734_amateurillustrator.groups AS g ON u.group_id=g.g_id WHERE u.id='2' (0.013s)
    [4] => 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 copper_usergroups WHERE group_id in (1) (0s)
    [5] => SELECT group_name FROM  copper_usergroups WHERE group_id= 1 (0s)
    [6] => SELECT user_favpics FROM copper_favpics WHERE user_id = 2 (0s)
    [7] => SELECT count(*) FROM  copper_pms WHERE owner=2 (0s)
    [8] => SELECT count(*) FROM  copper_pms WHERE owner=2 AND showed='0' (0s)
    [9] => SELECT count(*) FROM  copper_buddy WHERE user_id=2 (0s)
    [10] => SELECT count(*) FROM  copper_buddy_req WHERE buddy_to=2 (0s)
    [11] => DELETE FROM copper_banned WHERE expiry < '2007-03-20 07:41:49' (0s)
    [12] => SELECT * FROM copper_banned WHERE (ip_addr='62.49.188.201' OR ip_addr='62.49.188.201' OR user_id=2) AND brute_force=0 (0s)
    [13] => SELECT count(*) FROM  copper_buddy WHERE user_id=2 AND buddy_ok = 'YES' (0s)
    [14] => SELECT count(*) FROM  copper_buddy WHERE user_id=2 AND buddy_block = 'YES' (0s)
    [15] => SELECT count(*) FROM  copper_buddy_req WHERE buddy_to=2 (0s)
    [16] => SELECT count(*) FROM  copper_buddy_req WHERE buddy_from=2 (0s)
    [17] => SELECT id, buddy_ok, buddy_block, buddy_id, since, u.id AS avatar_url, u.username as buddy_name FROM copper_buddy as b LEFT JOIN db2734_amateurillustrator.users as u on b.buddy_id=u.id WHERE buddy_ok='YES' AND b.user_id = 2 ORDER BY buddy_name ASC LIMIT 0, 25; (0s)
    [18] => SELECT COUNT(*) FROM copper_pictures WHERE approved = 'NO' (0s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.4 - OK
------------------
mySQL version: 4.1.11-Debian_4sarge4
------------------
Coppermine version: 1.4.10 modpack v1(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 4.1.11
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.2
Linked Version 1.2.2
==========================
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/local/php-4.4.4-6/share/pear | .:/usr/local/php-4.4.4-6/share/pear
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 | 10000 | 10000
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 50M | 50M
==========================
Page generated in 0.087 seconds - 19 queries in 0.013 seconds - Album set : ; Meta set: ;
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Buddy list not working while bridged
« Reply #1 on: March 20, 2007, 10:24:32 am »

Do not post debug_output unless a supporter explicitely asks for it. Usually, the error message (the actual query that fails) is enough.
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy list not working while bridged
« Reply #2 on: March 20, 2007, 10:31:59 am »

known and hopefully solved issue

reference thread
http://forum.coppermine-gallery.net/index.php?topic=38473.0

the fix you can download on my site
http://stramm.st.funpic.org/displayimage.php?pos=-172

nickfzx

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 285
Re: Buddy list not working while bridged
« Reply #3 on: March 20, 2007, 02:43:03 pm »

I applied the fix and read the thread but still the exact same error.

you may have linked the wrong thread, the one you linked is titled: "auto add buddy upon registration?"

which I don't think is related to my problem.

Thanks for getting back quickly.

Sorry GauGau for the breach of rules.
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy list not working while bridged
« Reply #4 on: March 21, 2007, 07:35:04 am »

works on my test install... I need some more time to check things. What punbb version you're using, that's fresh installs?

nickfzx

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 285
Re: Buddy list not working while bridged
« Reply #5 on: March 21, 2007, 07:42:09 am »

tried on two installs, neither is 100% fresh

punbb is 1.2.2 (the latest is 1.2.4) I think I may have manually applied the 1.2.4 fix so it is basically up to date.

I will setup a new fresh install with all latest versions and let you know how that goes.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.