Ticket #724 (closed defeito: fixed)

Opened 14 years ago

Last modified 14 years ago

Pesquisa por feriados gera erro SQL

Reported by: david.ianakiara Owned by: david.ianakiara
Priority: grave Milestone: Expresso 2.2
Component: Calendar Version: trunk
Severity: Keywords:
Cc: WorkGroup:

Description

Ao pesquisar por um feriado na tela de Gerenciamento de Feriados, o sistema apresenta o seguinte erro:

"Database error: Invalid SQL: SELECT * FROM phpgw_cal_holidays WHERE AND name LIKE '%teste%' AND (occurence < 1900 OR occurence = 2009) ORDER BY month_num,mday pgsql Error: -1 (ERROR: syntax error at or near "AND" at character 41)

File: /var/www/expresso/calendar/inc/class.soholiday.inc.php Line: 88 Function: soholiday::read_holidays / boholiday::get_holiday_list / uiholiday::edit_locale / ExecMethod?

Session halted. "

Change History

comment:1 Changed 14 years ago by david.ianakiara

Resolvido na revisão [1589]

comment:2 Changed 14 years ago by david.ianakiara

  • Status changed from new to closed
  • Resolution set to fixed

comment:3 Changed 14 years ago by niltonneto

  • Component changed from ExpressoCalendar to Calendar
  • Milestone changed from Expresso 2.1 to Expresso 2.2
Note: See TracTickets for help on using tickets.