|
#2357 - SQL Error since last svn trunk update
| Ticket geändert von Ralf Becker am 2009/11/05 09:15 |
| Verfolgungssystem: Bugs |
| Kategorie: Calendar |
| Version: Trunk |
| Status: Geschlossen |
| Lösung: Gelöst |
| Prozent erledigt: 0% |
| Priorität: 5 - mittlere |
| Erstellt von: Stefan Roder |
| Zugewiesen an: Ralf Becker |
| Zusammenfassung: #2357 - SQL Error since last svn trunk update |
The following error appears by trying to open a link to the tracker from within Felamimail:
Invalid SQL: SELECT egw_cal_repeats.*,egw_cal.*,MIN(cal_start) AS cal_start,MIN(cal_end) AS cal_end,tz_id FROM egw_cal ,egw_cal_dates LEFT JOIN egw_cal_repeats ON egw_cal_dates.cal_id=egw_cal_repeats.cal_id WHERE egw_cal.cal_id=egw_cal_dates.cal_id AND (egw_cal.cal_id = 579) GROUP BY egw_cal.cal_id,egw_cal.cal_uid,egw_cal.cal_owner,egw_cal.cal_category,egw_cal.cal_modified,egw_cal.cal_priority,egw_cal.cal_public,egw_cal.cal_title,egw_cal.cal_description,egw_cal.cal_location,egw_cal.cal_reference,egw_cal.cal_modifier,egw_cal.cal_non_blocking,egw_cal.cal_special,egw_cal.cal_etag,egw_cal.cal_creator,egw_cal.cal_created,egw_cal.cal_recurrence,egw_cal_repeats.cal_id,egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception:
Unknown column 'tz_id' in 'field list'
The ticket is unreachable.
Seems to have something to do with the calendar. |
| Kommentar von Ralf Becker am 2009/11/05 09:15: |
This bug is fixed in our subversion repository now.
You can update via subversion with the following commands:
cd /path/to/egroupware
svn update * # mind the */asterisk
To check if you have svn installed try running svn version. To install the svn command under Linux install the package "subversion". For Windows you can use eg. TortoiseSVN (http://tortoisesvn.tigris.org).
Hi Stefan,
they dont appear any more by default, if they get closed because they are fixed ;-)
As it is the case with this one.
Ralf |
| Kommentar von Stefan Roder am 2009/11/04 15:25: |
More news: even the calendarevents show this error:
Invalid SQL: SELECT egw_cal_repeats.*,egw_cal.*,MIN(cal_start) AS cal_start,MIN(cal_end) AS cal_end,tz_id FROM egw_cal ,egw_cal_dates LEFT JOIN egw_cal_repeats ON egw_cal_dates.cal_id=egw_cal_repeats.cal_id WHERE egw_cal.cal_id=egw_cal_dates.cal_id AND (egw_cal.cal_id = 546 AND cal_start >= 1256684400) GROUP BY egw_cal.cal_id,egw_cal.cal_uid,egw_cal.cal_owner,egw_cal.cal_category,egw_cal.cal_modified,egw_cal.cal_priority,egw_cal.cal_public,egw_cal.cal_title,egw_cal.cal_description,egw_cal.cal_location,egw_cal.cal_reference,egw_cal.cal_modifier,egw_cal.cal_non_blocking,egw_cal.cal_special,egw_cal.cal_etag,egw_cal.cal_creator,egw_cal.cal_created,egw_cal.cal_recurrence,egw_cal_repeats.cal_id,egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception:
Unknown column 'tz_id' in 'field list'
and leave the module in a non-functional state. |
| Kommentar von Stefan Roder am 2009/11/04 13:33: |
| Did some further investigation and found out, that the error with the tickets depends on custom fields I added to the trackerconfiguration. If this field is left empty, the tickets are shown as expected - all the others mount into an errormessage. |
| Kommentar von Stefan Roder am 1970/01/01 01:00: |
Update: just recognised, that all the tickets in the tracker fail to appear with the same message as posted before.
|
Linked entries: Bugs #2357: SQL Error since last svn trunk update
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july_______________________________________________
eGroupWare-tracker mailing list
eGroupWare-tracker@...
https://lists.sourceforge.net/lists/listinfo/egroupware-tracker
|
