From: SourceForge.net <no...@so...> - 2005-06-29 14:29:59
|
Bugs item #1223985, was opened at 2005-06-20 10:54 Message generated for change (Settings changed) made by micattack You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=554338&aid=1223985&group_id=78745 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: tts >Group: HEAD / development branch Status: Open Resolution: None >Priority: 7 Submitted By: Leonard Tulipan (micattack) >Assigned to: Ralf Becker (ralfbecker) Summary: postgres sql error Initial Comment: Just tested a daily-cvs from last week. We get this SQL error. Mind you that we use postgres and not mysql. Here's the error. We think it's this line "c.account_lid group_name" should be "c.account_lid as group_name", but are not shure. This error happens when I click on "submit new". But it happens all around the TTS App. Database error: Invalid SQL: SELECT a.cat_id, b.cat_name, a.account_id group_id, c.account_lid group_name, d.account_id user_id, d.account_lid user_name FROM phpgw_tts_categories_groups a, phpgw_categories b, phpgw_accounts c, phpgw_accounts d, phpgw_acl ga, phpgw_acl gu WHERE a.cat_id = b.cat_id AND a.account_id = c.account_id AND a.account_id = ga.acl_account AND ga.acl_appname = 'tts' AND ga.acl_location='run' AND d.account_id = gu.acl_account AND gu.acl_appname = 'phpgw_group' AND gu.acl_location = c.account_id ORDER BY b.cat_name, c.account_lid, d.account_lid pgsql Error: -1 (ERROR: syntax error at or near "group_id" at character 43 ) File: /var/www/html/testgroupware/tts/newticket.php Line: 140 Warning: implode(): Bad arguments. in /var/www/html/testgroupware/phpgwapi/inc/common_functions.inc.php on line 1140 ---------------------------------------------------------------------- Comment By: Leonard Tulipan (micattack) Date: 2005-06-20 10:56 Message: Logged In: YES user_id=205382 Just saw, that this seems to be a duplicate of 1143950, but it got more info in it ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=554338&aid=1223985&group_id=78745 |