Gallery searching

Bugs item #1662130, was opened at 2007-02-16 23:55
Message generated for change (Tracker Item Submitted) made
by Item Submitter
You can respond by visiting: 
https://sourcefo
rge.net/tracker/?func=detail&atid=749176&aid=1662130
&group_id=141358

Please note that this message will contain a full copy of
the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Fisheye
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Gallery searching

Initial Comment:
[ - 1.1.0  - ] [ Sat Feb 17 09:55:04 2007 ]
 
------------------------------------------------------------
-----------------------------------
  #### USER AGENT: Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1
  #### ACCT: ID: 2 - Login: admin - e-mail: adminteodesign.bg
  #### URL: http://www.teodesign.bg/bitw
eaver/fisheye/list_galleries.php?sort_mode=real_name_asc

  #### REFERRER: http://www.teodesign.bg/bitweaver/fisheye/list_galle
ries.php
  #### HOST: www.teodesign.bg
  #### IP: 127.0.0.1
  #### SQL: SELECT DISTINCT( tfg.`gallery_id` ) AS
`hash_key`, tfg.*, tc.*, uu.`login`, uu.`real_name`,
ptc.`content_type_guid` AS `preview_content_type_guid` 
,ts.`security_id`, ts.`security_description`,
ts.`is_private`, ts.`is_hidden`, ts.`access_question`,
ts.`access_answer`      FROM `bw_tiki_fisheye_gallery` tfg  
  LEFT OUTER JOIN `bw_tiki_content` ptc ON(
tfg.`preview_content_id`=ptc.`content_id` ),
`bw_users_users` uu, `bw_tiki_content` tc     INNER JOIN
`bw_tiki_fisheye_gallery_image_map` tfgim ON
(tfgim.`gallery_content_id`=tc.`content_id`)  LEFT OUTER
JOIN  `bw_tiki_fisheye_gallery_image_map` tfgim2 ON
(tfgim2.`item_content_id`=tc.`content_id`) LEFT OUTER JOIN
`bw_tiki_content_security_map` tcs ON
(tc.`content_id`=tcs.`content_id`) LEFT OUTER JOIN
`bw_tiki_security` ts ON (ts.`security_id`=tcs.`security_id`
)     WHERE tfg.`content_id` = tc.`content_id` AND
uu.`user_id` = tc.`user_id`  AND tfgim2.`item_content_id` IS
NULL   ORDER BY tc.`real_name` ASC  LIMIT 0,10
  #### ADODB: Errno: 1054  Message: Unknown column
'tc.real_name' in 'order clause'


    }}}}}}}    -> bit_error_string(Array[7])
    }}}}}}} LINE:   40,
E:apache2htdocsbitweaverkernelbit_error_inc.php
    }}}}}}    -> bit_error_handler(mysql, EXECUTE, 1054,
Unknown column 'tc.real_name' in 'order clause', SELECT
DISTINCT( tfg.`gallery_id` ) AS `hash_key`, tfg.*, tc.*,
..., false, Object:ADODB_mysql)
    }}}}}} LINE:  879,
E:apache2htdocsbitweaverutiladodbadodb.inc.php
    }}}}}    -> ADOConnection::_Execute(SELECT DISTINCT(
tfg.`gallery_id` ) AS `hash_key`, tfg.*, tc.*, ..., false)
    }}}}} LINE:  854,
E:apache2htdocsbitweaverutiladodbadodb.inc.php
    }}}}    ->
ADOConnection::ADOConnection::Execute(SELECT DISTINCT(
tfg.`gallery_id` ) AS `hash_key`, tfg.*, tc.*, ...,
Array[0])
    }}}} LINE:  484,
E:apache2htdocsbitweaverutiladodbdriversadodb-mysql.i
nc.php
    }}}    ->
ADOConnection::ADOConnection::ADODB_mysql::SelectLimit(SELEC
T DISTINCT( tfg.`gallery_id` ) AS `hash_key`, tfg.*, tc.*,
..., 10, 0, Array[0])
    }}} LINE:  377,
E:apache2htdocsbitweaverkernelBitDb.php
    }}    ->
ADOConnection::ADOConnection::ADODB_mysql::BitDb::query(SELE
CT DISTINCT( tfg.`gallery_id` ) AS `hash_key`, tfg.*, tc.*,
..., Array[0], 10, 0)
    }} LINE:  540,
E:apache2htdocsbitweaverfisheyeFisheyeGallery.php
    }    ->
ADOConnection::ADOConnection::ADODB_mysql::BitDb::FisheyeGal
lery::getList(Array[14])
    } LINE:   33,
E:apache2htdocsbitweaverfisheyelist_galleries.php

------------------------------------------------------------
----------

You can respond by visiting: 
https://sourcefo
rge.net/tracker/?func=detail&atid=749176&aid=1662130
&group_id=141358

------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief
surveys-and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bitweaver-support mailing list
Bitweaver-supportlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bitwe
aver-support