Ticket #18 (closed дефект: fixed)

Opened 1 year ago

Last modified 1 year ago

Bug: При попытке добавить имя 't' (с апострофами), выводится SQL-ошибка

Reported by: teiko Assigned to: teiko
Priority: Важный Milestone: EContact 1
Component: efio Version:
Keywords: Cc:
Working_time: state:
Time_estimation:

Description

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't) AND correct=2' at line 1 SQL=SELECT COUNT(*) FROM names WHERE name = UPPER(t) AND correct=2

Поскольку символы апострофов пропускаются в запрос

Change History

11/06/07 14:08:00 changed by teiko

  • owner changed from somebody to teiko.
  • status changed from new to assigned.

11/06/07 14:43:42 changed by teiko

  • status changed from assigned to closed.
  • resolution set to fixed.

Исправлено за счет замены одного апострофа на два, например "O'Brien"->"OBrien"

11/13/07 02:50:43 changed by

  • milestone deleted.

Milestone milestone2 deleted

11/14/07 14:19:39 changed by teiko

  • priority changed from major to Важный.
  • type changed from defect to неисправность.
  • milestone set to Создание макета системы.

11/14/07 15:21:12 changed by teiko

  • component changed from component1 to Другое.

01/03/08 19:44:46 changed by teiko

  • component changed from Другое to efio.
  • milestone changed from Создание макета системы to EContact 1.