Hello,
I’m attempting to add a field to the tracking sytem. I first went into
db tools and brought up “egw_tracker” table. Added a column
"tr_staffown" as integer. Clicked on “Write table”, was taken to a
verify page where it asked for the version I wanted it marked clicked
"yes" and everthing seemed OK, no errors.
Then went into etemplate and brought up tracker.edit 1.5.002 - the
highest in my list. I added a row with a label in the first column,
“Saff owner” and an “account selectbox” in the 2nd column with the name
of “tr_staffown”. Saved the template OK.
Went into the Tracker application, clicked on an existing entry to edit
it and saw my new row as created. Clicked on the pull-down and chose a
name then clicked to save the entry and got this error:
“Invalid SQL: SELECT egw_tracker.*,egw_tracker.tr_id AS tr_id FROM
egw_tracker WHERE tr_tracker=146 GROUP BY egw_tracker.tr_id,
egw_tracker. tr_summary, egw_tracker.tr_tracker, egw_tracker.cat_id,
egw_tracker.tr_version, egw_tracker. tr_status , egw_tracker.
tr_description, egw_tracker.tr_private, egw_tracker.tr_budget,
egw_tracker.tr_completion, egw_tracker.tr_creator ,
egw_tracker.tr_created, egw_tracker. tr_modifier,
egw_tracker.tr_modified, egw_tracker.tr_closed, egw_tracker.
tr_priority, egw_tracker. tr_resolution, egw_tracker. tr_cc,
egw_tracker.tr_group, egw_tracker. tr_edit_mode, egw_tracker. tr_seen
ORDER BY egw_tracker.tr_id ASC:
ERROR: column “egw_tracker.tr_staffown” must appear in the GROUP BY
clause or be used in an aggregate function”
I went into db tools and brought up the table, it still showed the new
field “tr_staffown” as part of the table “egw_tracker”. I then went into
the database directly and saw the the field “tr_staffown” was not added
to the “egw_tracker” table. So I added it manually.
I went back into eGroupware and tried to open the Tracker App but got
this error:
"Database error
Invalid SQL: SELECT egw_tracker.*,egw_tracker.tr_id AS tr_id FROM
egw_tracker WHERE tr_tracker=146 GROUP BY egw_tracker.tr_id,
egw_tracker. tr_summary, egw_tracker.tr_tracker, egw_tracker.cat_id,
egw_tracker.tr_version, egw_tracker. tr_status , egw_tracker.
tr_description, egw_tracker.tr_private, egw_tracker.tr_budget,
egw_tracker.tr_completion, egw_tracker.tr_creator ,
egw_tracker.tr_created, egw_tracker. tr_modifier,
egw_tracker.tr_modified, egw_tracker.tr_closed, egw_tracker.
tr_priority, egw_tracker. tr_resolution, egw_tracker. tr_cc,
egw_tracker.tr_group, egw_tracker. tr_edit_mode, egw_tracker. tr_seen
ORDER BY egw_tracker.tr_id ASC:
ERROR: column “egw_tracker.tr_staffown” must appear in the GROUP BY
clause or be used in an aggregate function"
Any clues as to what is going on here? Thanks!
Thomas E. Plancon
CAD/IS Manager
B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302
tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com http://www.bkaarchs.com/
Throughout its 18-year history, RSA Conference consistently attracts the
world’s best and brightest in the field, creating opportunities for Conference
attendees to learn about information security’s most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
