Ticket #239 (new bugs)

Opened 11 years ago

SQL quering srmrequestcredentials do not uses prepared statement

Reported by: tigran Owned by:
Priority: critical Milestone:
Component: srm Keywords:
Cc: cgw@… Sub Version:

Description

RROR: syntax error at or near "Asta" at character 120 STATEMENT: SELECT * FROM srmrequestcredentials WHERE CREDENTIALNAME='/C=IT/O=INFN/OU=Personal Ce rtificate/L=Milano/CN=Lidia Dell'Asta' AND ROLE='/atlas' ERROR: syntax error at or near "Asta" at character 160 STATEMENT: UPDATE srmrequestcredentials SET ID = -2127765797, CREATIONTIME = 1247210369308, CREDENTIALNAME = '/C=IT/O=INFN/OU=Personal Certificate/L=Milano/CN=Lidia Dell'Asta', ROLE = '/atlas', NUMBEROFUSERS = 0, DELEGATEDCREDENTIALS =NULL, CREDENTIALEXPIRATION = 0 WHERE ID='-2127765797' ERROR: syntax error at or near "Asta" at character 133 STATEMENT: INSERT INTO srmrequestcredentials VALUES ( -2127765797, 1247210369308, '/C=IT/O=INFN/OU=Personal Certificate/L=Milano/CN=Lidia Dell'Asta', '/atlas', 0, NULL, 0 ) ERROR: syntax error at or near "Asta" at character 120 STATEMENT: SELECT * FROM srmrequestcredentials WHERE CREDENTIALNAME='/C=IT/O=INFN/OU=Personal Certificate/L=Milano/CN=Lidia Dell'Asta' AND ROLE='/atlas' ERROR: syntax error at or near "Asta" at character 160

Note: See TracTickets for help on using tickets.