Projet

Général

Profil

Bug #3107

brouillon en mode SQL (calvados.dev)

Ajouté par Thomas Noël il y a presque 11 ans. Mis à jour il y a presque 11 ans.

Statut:
Rejeté
Priorité:
Normal
Assigné à:
Version cible:
-
Début:
21 juin 2013
Echéance:
% réalisé:

0%

Temps estimé:
Patch proposed:
Planning:

Description

Depuis le passage de calvados.dev en SQL, quand on veut enregistrer un brouillon :

Exception:
  type = '<class 'psycopg2.ProgrammingError'>', value = 'can't adapt type 'bytearray''

Stack trace (most recent call first):
  File "/var/vhosts/calvados.dev.au-quotidien.com/src/wcs.git/wcs/sql.py", line 497, in store
   495                                        ', '.join(column_names),
   496                                        ', '.join(['%%(%s)s' % x for x in column_names]))
>  497             cur.execute(sql_statement, sql_dict)
   498             self.id = cur.fetchone()[0]
   499         else:

  locals: 
     sql_statement = 'INSERT INTO formdata_25_test_victor_premiere_demande_d (id, f125, f124, f127, f126, f120, f123, f122, f14_display, f128, f133, f74_display, f102_display, f37_display, f43, workflow_roles_array, user_id, f44, f36_display, f83, user_hash, f83_display, f135, f11_display, f78, f69, f93, f118, f94, f141_display, f114, f98, f117, f110, f111, f112, f113, f30_display, f53, f50, f26_display, f117_display, f11, f16, f14, f15, f141, f145, f144, f9, f88, f109, f89, f105, f102, f44_display, workflow_roles, f79_display, f23, f22, f21, f20, receipt_time, f26, id_display, f24, f67, f66, f64, f79, status, f27, f144_display, f74, f42, f145_display, f45, f130, f136, f134, workflow_data, f20_display, f46, f30, f31, f32, f33, f34, f35, f36, f37, f38, f75, f76, f77, f71)\n                               VALUES (DEFAULT, %(f125)s, %(f124)s, %(f127)s, %(f126)s, %(f120)s, %(f123)s, %(f122)s, %(f14_display)s, %(f128)s, %(f133)s, %(f74_display)s, %(f102_display)s, %(f37_display)s, %(f43)s, %(workflow_roles_array)s, %(user_id)s, %(f44)s, %(f36_display)s, %(f83)s, %(user_hash)s, %(f83_display)s, %(f135)s, %(f11_display)s, %(f78)s, %(f69)s, %(f93)s, %(f118)s, %(f94)s, %(f141_display)s, %(f114)s, %(f98)s, %(f117)s, %(f110)s, %(f111)s, %(f112)s, %(f113)s, %(f30_display)s, %(f53)s, %(f50)s, %(f26_display)s, %(f117_display)s, %(f11)s, %(f16)s, %(f14)s, %(f15)s, %(f141)s, %(f145)s, %(f144)s, %(f9)s, %(f88)s, %(f109)s, %(f89)s, %(f105)s, %(f102)s, %(f44_display)s, %(workflow_roles)s, %(f79_display)s, %(f23)s, %(f22)s, %(f21)s, %(f20)s, %(receipt_time)s, %(f26)s, %(id_display)s, %(f24)s, %(f67)s, %(f66)s, %(f64)s, %(f79)s, %(status)s, %(f27)s, %(f144_display)s, %(f74)s, %(f42)s, %(f145_display)s, %(f45)s, %(f130)s, %(f136)s, %(f134)s, %(workflow_data)s, %(f20_display)s, %(f46)s, %(f30)s, %(f31)s, %(f32)s, %(f33)s, %(f34)s, %(f35)s, %(f36)s, %(f37)s, %(f38)s, %(f75)s, %(f76)s, %(f77)s, %(f71)s)\n                               RETURNING id'
     cur = <cursor object at 0x439d050; closed: 0>
     sql_dict = {'f125': None, 'f124': None, 'f127': None, 'f126': None, 'f120': None, 'f123': None, 'f122': None, 'f14_display': None, 'f128': None, 'f133': None, 'f74_display': None, 'f102_display': None, 'f37_display': None, 'f43': None, 'workflow_roles_array': None, 'user_id': 2, 'f44': None, 'f36_display': None, 'f83': None, 'user_hash': None, 'f83_display': None, 'f135': None, 'f11_display': None, 'f78': None, 'f69': None, 'f93': None, 'f118': None, 'f94': None, 'f141_display': None, 'f114': None, 'f98': None, 'f117': None, 'f110': None, 'f111': None, 'f112': None, 'f113': None, 'f30_display': None, 'f53': None, 'f50': None, 'f26_display': None, 'f117_display': None, 'f11': None, 'f16': None, 'f14': None, 'f15': None, 'f141': None, 'f145': None, 'f144': None, 'f9': True, 'f88': None, 'f109': None, 'f89': None, 'f105': None, 'f102': None, 'f44_display': None, 'workflow_roles': None, 'f79_display': None, 'f23': None, 'f22': None, 'f21': None, 'f20': None, 'receipt_time': None, 'f26': None, 'id_display': None, 'f24': None, 'f67': None, 'f66': None, 'f64': None, 'f79': None, 'status': 'draft', 'f27': None, 'f144_display': None, 'f74': None, 'f42': None, 'f145_display': None, 'f45': None, 'f130': None, 'f136': None, 'f134': None, 'workflow_data': bytearray(b'N.'), 'f20_display': None, 'f46': None, 'f30': None, 'f31': None, 'f32': None, 'f33': None, 'f34': None, 'f35': None, 'f36': None, 'f37': None, 'f38': None, 'f75': None, 'f76': None, 'f77': None, 'f71': None}
     self = <Premiere-Demande-D-Apa-A-Domicile id:None>
     column_names = ['f125', 'f124', 'f127', 'f126', 'f120', 'f123', 'f122', 'f14_display', 'f128', 'f133', 'f74_display', 'f102_display', 'f37_display', 'f43', 'workflow_roles_array', 'user_id', 'f44', 'f36_display', 'f83', 'user_hash', 'f83_display', 'f135', 'f11_display', 'f78', 'f69', 'f93', 'f118', 'f94', 'f141_display', 'f114', 'f98', 'f117', 'f110', 'f111', 'f112', 'f113', 'f30_display', 'f53', 'f50', 'f26_display', 'f117_display', 'f11', 'f16', 'f14', 'f15', 'f141', 'f145', 'f144', 'f9', 'f88', 'f109', 'f89', 'f105', 'f102', 'f44_display', 'workflow_roles', 'f79_display', 'f23', 'f22', 'f21', 'f20', 'receipt_time', 'f26', 'id_display', 'f24', 'f67', 'f66', 'f64', 'f79', 'status', 'f27', 'f144_display', 'f74', 'f42', 'f145_display', 'f45', 'f130', 'f136', 'f134', 'workflow_data', 'f20_display', 'f46', 'f30', 'f31', 'f32', 'f33', 'f34', 'f35', 'f36', 'f37', 'f38', 'f75', 'f76', 'f77', 'f71']
     x = 'f71'
     conn = <connection object at 0x387c050; dsn: 'dbname=cg14', closed: 0>

  File "/var/vhosts/calvados.dev.au-quotidien.com/src/wcs.git/wcs/sql.py", line 95, in f
    93         except psycopg2.Error:
    94             get_connection().rollback()
>   95             raise
    96     return f
    97 

Historique

#1

Mis à jour par Frédéric Péters il y a presque 11 ans

  • Statut changé de Nouveau à Rejeté

→ mettre à jour psycopg2 (la version dans les backports pour squeze, 2.4.2-1~bpo60+1, convient).

Formats disponibles : Atom PDF