Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Still getting fatal error  (Read 3396 times)

0 Members and 1 Guest are viewing this topic.

chula

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Still getting fatal error
« on: May 23, 2008, 01:31:12 am »

Okay so i thought my gallery is fine because the thumbnails are showing up on the index page. But when I clicked on the images, I got these

While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u.avatar_url AS avatar_url FROM cpg_comments AS c LEFT JOIN `beaalonz_copp1`.cpg_users AS u ON c.author_id=u.user_id WHERE pid='3704' ORDER BY c.msg_id DESC" on Resource id #5

mySQL error: Unknown column 'u.avatar_url' in 'field list'



File: /home/beaalonz/public_html/gallery/include/functions.inc.php - Line: 248

USER:
------------------
Array
(
    [ID] => 0adfdd82156c35077c0e4d05b837893d
    [am] => 1
    [lang] => english
    [liv] => Array
        (
           
  • => 3656
  • [1] => 3655
                [2] => 3654
                [3] => 182
                [4] => 3704
            )

    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
       
[user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           
  • => 3

        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [upload_form_config] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [has_admin_access] => 0
    [group_name] => Anonymous
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg_filetypes; (0s)
  • [1] => select * from cpg_plugins order by priority asc; (0s)
        [2] => delete from `beaalonz_copp1`.cpg_sessions where time<1211495324 and remember=0; (0.001s)
        [3] => delete from `beaalonz_copp1`.cpg_sessions where time<1210289324; (0.001s)
        [4] => select user_id from `beaalonz_copp1`.cpg_sessions where session_id = 'fa5ba1c4bd727ab8f9c33e9df701997b' (0.002s)
        [5] => select user_id as id, user_password as password from `beaalonz_copp1`.cpg_users where user_id=0 (0s)
        [6] => 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 cpg_usergroups WHERE group_id in (3) (0s)
        [7] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 3 (0s)
        [8] => update `beaalonz_copp1`.cpg_sessions set time='1211498924' where session_id = 'fa5ba1c4bd727ab8f9c33e9df701997b' (0.003s)
        [9] => DELETE FROM cpg_banned WHERE expiry < '2008-05-23 08:28:44' (0s)
        [10] => SELECT * FROM cpg_banned WHERE (ip_addr='71.206.91.144' OR ip_addr='71.206.91.144' OR user_id=0) AND brute_force=0 (0s)
        [11] => SELECT aid FROM cpg_albums (0s)
        [12] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50,51,52,53,54,55,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,76,77,78,79,80,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98)  (0.001s)
        [13] => SELECT * FROM cpg_pictures WHERE approved = 'YES' AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50,51,52,53,54,55,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,76,77,78,79,80,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98)  ORDER BY pid DESC  LIMIT 0 ,1 (0.007s)
        [14] => SELECT title, comments, votes, category, aid FROM cpg_albums WHERE aid='91' LIMIT 1 (0.004s)
        [15] => SELECT name, parent FROM cpg_categories WHERE cid = '25' (0s)
        [16] => SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u.avatar_url AS avatar_url FROM cpg_comments AS c LEFT JOIN `beaalonz_copp1`.cpg_users AS u ON c.author_id=u.user_id WHERE pid='3704' ORDER BY c.msg_id DESC (0.001s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
       
[album] => lastup
    [cat] => 0
    [pos] => 0
)

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

==========================
Page generated in 0.17 seconds - 17 queries in 0.02 seconds - Album set : AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50,51,52,53,54,55,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,76,77,78,79,80,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98) ; Meta set: AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50,51,52,53,54,55,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,76,77,78,79,80,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98) ;

Someone help please? My gallery is www.bea-alonzo.com/gallery/index.php

Thank you
Logged

Nibbler

  • Guest
Re: Still getting fatal error
« Reply #1 on: May 23, 2008, 02:01:36 am »

Modpack issues belong in the modpack section. Moving. Check the threads started by others that had the same issue.
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Still getting fatal error
« Reply #2 on: May 23, 2008, 09:10:17 am »

It's exactly what I've told you in the other thread. The avatar field isn't known cause you haven't defied that in your bridge file.
Compare to the supported bridge files and define the avatar in there.

Alternatively you could remove
Code: [Select]
, u.{$f['avatar_url']} AS avatar_urlfrom the queries in udb_base.inc.php. This would remove the avatar functionality.
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 21 queries.