forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: chula 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
(
)
[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
-
Modpack issues belong in the modpack section. Moving. Check the threads started by others that had the same issue.
-
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
, u.{$f['avatar_url']} AS avatar_url
from the queries in udb_base.inc.php. This would remove the avatar functionality.