Exemple de problhme rencontri sur un import (up4o.php).
Il faut me remonter ce type de problhme pour correction
ERREUR : SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too
long for type character varying(10)ligne : 5
INSERT INTO "optiscan_productor"
(id,productor,comment,conge,created_at,created_by,updated_at,updated_by)
VALUES('{5a54d779-3300-49cc-af79-e58b67ee545e}','11R171',null,'B. ET JP.
FAIXO','2009-02-12
11:47:21','{c04d7ebd-a358-4b4e-89db-60c765471f93}','2009-02-12
11:47:21','{c04d7ebd-a358-4b4e-89db-60c765471f93}');
Ici c'est le code congi et le nom du producteur qui ont ite inversis...
C'est corrigi.
Par aileurs, ce producteur a iti ricrie lors de la viste 1 minute aprhs, il
faudra ` l'occasion faire du minage :
id<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallow&data
base=optiscan&schema=public&table=optiscan_productor&subject=table&return_url
=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3Doptisc
an%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=1&sortdir=asc&strings=c
ollapsed&page=13>
productor<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallow
&database=optiscan&schema=public&table=optiscan_productor&subject=table&retur
n_url=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3Do
ptiscan%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=2&sortdir=asc&stri
ngs=collapsed&page=13>
comment<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallow&d
atabase=optiscan&schema=public&table=optiscan_productor&subject=table&return_
url=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3Dopt
iscan%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=3&sortdir=asc&string
s=collapsed&page=13>
conge<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallow&dat
abase=optiscan&schema=public&table=optiscan_productor&subject=table&return_ur
l=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3Doptis
can%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=4&sortdir=asc&strings=
collapsed&page=13>
created_at<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallo
w&database=optiscan&schema=public&table=optiscan_productor&subject=table&retu
rn_url=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3D
optiscan%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=5&sortdir=asc&str
ings=collapsed&page=13>
created_by<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallo
w&database=optiscan&schema=public&table=optiscan_productor&subject=table&retu
rn_url=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3D
optiscan%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=6&sortdir=asc&str
ings=collapsed&page=13>
updated_at<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallo
w&database=optiscan&schema=public&table=optiscan_productor&subject=table&retu
rn_url=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3D
optiscan%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=7&sortdir=asc&str
ings=collapsed&page=13>
updated_by<http://optiscan.fr/4pgs/display.php?server=127.0.0.1%3A5432%3Aallo
w&database=optiscan&schema=public&table=optiscan_productor&subject=table&retu
rn_url=tables.php%3Fserver%3D127.0.0.1%253A5432%253Aallow%26amp%3Bdatabase%3D
optiscan%26amp%3Bschema%3Dpublic&return_desc=Retour&sortkey=8&sortdir=asc&str
ings=collapsed&page=13>
56fe264a-e3d7-47bc-ac2a-9f4d3ca53ba0 B. et JP. Faixo *NULL* 11R171 2009-02-12
11:48:08 c04d7ebd-a358-4b4e-89db-60c765471f93 2009-02-12 11:48:08
c04d7ebd-a358-4b4e-89db-60c765471f93 5a54d779-3300-49cc-af79-e58b67ee545e B.
ET JP. FAIXO *NULL* 11R171 2009-02-12 11:47:21
c04d7ebd-a358-4b4e-89db-60c765471f93 2009-02-12 11:47:21
c04d7ebd-a358-4b4e-89db-60c765471f93
*Par ailleurs, il est impiratif de n'uploader le fichier export.dat qu'une
seule fois ...*
Xavier.
