lsces
commented
12 years ago Matt wrote:
/#### ERROR CODE: Errno: -1 Message: ERROR: column lf.storage_path does not exist LINE 4: uu."login", uu."real_name", lf."storage_path" /
The explanation is that storage_path has been replaced by file_name as the path is always the same, but we need to dig a little deeper to find why you get the error :(
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
mtkr0l
Database: Postgres 9.1 (updated from git: Utils and Pigenholes)
URL: #### REFERRER: http://10.211.55.3/pigeonholes/list.php
HOST: 10.211.55.3
IP: 10.211.55.2
DB: postgres7://xxxxx@localhost/xxxxx
SQL: SELECT pigm._, lc."content_id", lc."last_modified", lc."user_id", lc."title", lc."content_type_guid", lc."created", lct."content_name", lcds."data" AS "summary", uu."login", uu."real_name", lf."storage_path" FROM "pigeonhole_members" pigm INNER JOIN "pigeonholes" pig ON ( pig."content_id" = pigm."parent_id" ) INNER JOIN "liberty_content" lc ON ( lc."content_id" = pigm."content_id" ) INNER JOIN "liberty_content_types" lct ON ( lc."content_type_guid" = lct."content_type_guid" ) INNER JOIN "users_users" uu ON ( uu."user_id" = lc."user_id" ) LEFT OUTER JOIN "liberty_content_data" lcds ON ( lcds."content_id" = lc."content_id" AND lcds."data_type" = 'summary' ) LEFT OUTER JOIN "liberty_attachments" latt ON ( latt."content_id" = lc."content_id" AND latt."is_primary" = 'y' ) LEFT OUTER JOIN "liberty_files" lf ON ( lf."file_id" = latt."foreign_id" ) WHERE pig."content_id" = ? ORDER BY lc."content_type_guid", lc."title" ASC
[37]
ERROR CODE: Errno: -1 Message: ERROR: column lf.storage_path does not exist
LINE 4: uu."login", uu."real_name", lf."storagepath" }}}}}}}} LINE: 672, /var/www/kernel/BitDbAdodb.php }}}}}}}} -> bit_error_string(Array[6]) }}}}}}} LINE: 1072, /var/www/util/adodb/adodb.inc.php }}}}}}} -> bitdb_error_handler(postgres7, EXECUTE, -1, ERROR: column lf.storagepath does not exist LINE 4: uu."log..., SELECT pigm., lc."content_id", lc."lastmodified", lc."user..., Array[1], Object:ADODB_postgres7) }}}}}} LINE: 1043, /var/www/util/adodb/adodb.inc.php }}}}}} -> ADOConnection::_Execute(SELECT pigm.*, lc."content_id", lc."lastmodified", lc."user..., Array[1]) }}}}} LINE: 260, /var/www/kernel/BitDbAdodb.php }}}}} -> ADOConnection::ADOConnection::Execute(SELECT pigm._, lc."content_id", lc."lastmodified", lc."user..., Array[1]) }}}} LINE: 189, /var/www/pigeonholes/Pigeonholes.php }}}} -> ADOConnection::ADOConnection::BitDbAdodb::query( SELECT pigm._, lc.
content_id, lc.last_modified, lc.`u..., Array[1], -1, null) }}} LINE: 115, /var/www/pigeonholes/Pigeonholes.php }}} -> ADOConnection::ADOConnection::BitDbAdodb::Pigeonholes::getMemberList(Array[10]) }} LINE: 18, /var/www/pigeonholes/lookup_pigeonholes_inc.php }} -> ADOConnection::ADOConnection::BitDbAdodb::Pigeonholes::Pigeonholes::load(true) } LINE: 25, /var/www/pigeonholes/edit_pigeonholes.php