Discussion :

[erehcab]

Bonjour à tous,

je stocke en BDD des informations sérialisées et lorsque je veux les dé-sérialiser j'ai une notice php :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

Notice: unserialize() [function.unserialize]: Error at offset 5313 of 5321 bytes

Voilà le var_dump() de la variable sérialisée qui génère l'erreur :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
string(5321) "a:6:{i:0;a:54:{s:9:"Store_grp";s:3:"VIK";s:8:"Order_id";s:5:"16560";s:10:"Product_id";s:8:"VIKOT001";s:6:"Sku_id";s:1:"0";s:4:"Size";s:2:"T0";s:5:"Color";s:6:"BUBBLE";s:7:"Barcode";s:13:"3603526019562";s:5:"Model";s:5:"G2842";s:17:"StoreGrp_order_id";s:1:" ";s:6:"Field1";s:1:" ";s:6:"Field2";s:1:" ";s:6:"Field3";s:1:" ";s:6:"Field4";s:1:" ";s:6:"Field5";s:1:" ";s:6:"Field6";s:1:" ";s:6:"Field7";s:1:" ";s:6:"Field8";s:1:" ";s:6:"Field9";s:1:" ";s:7:"Field10";s:1:" ";s:9:"Fieldadd1";s:1:" ";s:9:"Fieldadd2";s:1:" ";s:9:"Fieldadd3";s:1:" ";s:9:"Fieldadd4";s:1:" ";s:9:"Fieldadd5";s:1:" ";s:9:"Fieldadd6";s:1:" ";s:9:"Fieldadd7";s:1:" ";s:9:"Fieldadd8";s:1:" ";s:9:"Fieldadd9";s:1:" ";s:10:"Fieldadd10";s:1:" ";s:21:"Qty_requestedByClient";s:3:"300";s:13:"Qty_toProduce";s:3:"321";s:13:"Date_produced";N;s:19:"Date_lastReproduced";N;s:14:"Product_POL_id";N;s:12:"Product_type";s:16:"variable confirm";s:14:"Product_status";s:1:"1";s:11:"Product_qty";s:4:"3900";s:14:"Product_family";s:12:"price Ticket";s:15:"Product_CallOut";s:13:"Price sticker";s:12:"Product_Desc";s:56:"Sticker 35 x 40 mm - with variable data - breakable part";s:25:"Product_StoreGrp_Order_id";s:5:"90082";s:16:"Layout_requested";s:1:"0";s:20:"Layout_released_date";N;s:16:"Layout_confirmed";N;s:20:"Layout_approved_date";N;s:11:"Sales_price";s:1:" ";s:14:"Sales_currency";s:1:" ";s:10:"Sales_unit";s:1:" ";s:14:"Purchase_price";s:1:" ";s:17:"Purchase_currency";s:1:" ";s:13:"Purchase_unit";s:1:" ";s:13:"DO_Label_name";s:13:"Price sticker";s:5:"sku_0";a:4:{i:0;a:33:{s:9:"Store_grp";s:3:"VIK";s:8:"Order_id";s:5:"16560";s:10:"Product_id";s:8:"VIKOT001";s:6:"Sku_id";s:1:"0";s:4:"Size";s:2:"T0";s:5:"Color";s:6:"BUBBLE";s:7:"Barcode";s:13:"3603526019562";s:5:"Model";s:5:"G2842";s:17:"StoreGrp_order_id";s:1:" ";s:6:"Field1";s:1:" ";s:6:"Field2";s:1:" ";s:6:"Field3";s:1:" ";s:6:"Field4";s:1:" ";s:6:"Field5";s:1:" ";s:6:"Field6";s:1:" ";s:6:"Field7";s:1:" ";s:6:"Field8";s:1:" ";s:6:"Field9";s:1:" ";s:7:"Field10";s:1:" ";s:9:"Fieldadd1";s:1:" ";s:9:"Fieldadd2";s:1:" ";s:9:"Fieldadd3";s:1:" ";s:9:"Fieldadd4";s:1:" ";s:9:"Fieldadd5";s:1:" ";s:9:"Fieldadd6";s:1:" ";s:9:"Fieldadd7";s:1:" ";s:9:"Fieldadd8";s:1:" ";s:9:"Fieldadd9";s:1:" ";s:10:"Fieldadd10";s:1:" ";s:21:"Qty_requestedByClient";s:3:"300";s:13:"Qty_toProduce";s:3:"324";s:13:"Date_produced";N;s:19:"Date_lastReproduced";N;}i:1;a:33:{s:9:"Store_grp";s:3:"VIK";s:8:"Order_id";s:5:"16560";s:10:"Product_id";s:8:"VIKOT001";s:6:"Sku_id";s:1:"1";s:4:"Size";s:2:"T1";s:5:"Color";s:6:"BUBBLE";s:7:"Barcode";s:13:"3603526019579";s:5:"Model";s:5:"G2842";s:17:"StoreGrp_order_id";s:1:" ";s:6:"Field1";s:1:" ";s:6:"Field2";s:1:" ";s:6:"Field3";s:1:" ";s:6:"Field4";s:1:" ";s:6:"Field5";s:1:" ";s:6:"Field6";s:1:" ";s:6:"Field7";s:1:" ";s:6:"Field8";s:1:" ";s:6:"Field9";s:1:" ";s:7:"Field10";s:1:" ";s:9:"Fieldadd1";s:1:" ";s:9:"Fieldadd2";s:1:" ";s:9:"Fieldadd3";s:1:" ";s:9:"Fieldadd4";s:1:" ";s:9:"Fieldadd5";s:1:" ";s:9:"Fieldadd6";s:1:" ";s:9:"Fieldadd7";s:1:" ";s:9:"Fieldadd8";s:1:" ";s:9:"Fieldadd9";s:1:" ";s:10:"Fieldadd10";s:1:" ";s:21:"Qty_requestedByClient";s:3:"500";s:13:"Qty_toProduce";s:3:"540";s:13:"Date_produced";N;s:19:"Date_lastReproduced";N;}i:2;a:33:{s:9:"Store_grp";s:3:"VIK";s:8:"Order_id";s:5:"16560";s:10:"Product_id";s:8:"VIKOT001";s:6:"Sku_id";s:1:"2";s:4:"Size";s:2:"T2";s:5:"Color";s:6:"BUBBLE";s:7:"Barcode";s:13:"3603526019586";s:5:"Model";s:5:"G2842";s:17:"StoreGrp_order_id";s:1:" ";s:6:"Field1";s:1:" ";s:6:"Field2";s:1:" ";s:6:"Field3";s:1:" ";s:6:"Field4";s:1:" ";s:6:"Field5";s:1:" ";s:6:"Field6";s:1:" ";s:6:"Field7";s:1:" ";s:6:"Field8";s:1:" ";s:6:"Field9";s:1:" ";s:7:"Field10";s:1:" ";s:9:"Fieldadd1";s:1:" ";s:9:"Fieldadd2";s:1:" ";s:9:"Fieldadd3";s:1:" ";s:9:"Fieldadd4";s:1:" ";s:9:"Fieldadd5";s:1:" ";s:9:"Fieldadd6";s:1:" ";s:9:"Fieldadd7";s:1:" ";s:9:"Fieldadd8";s:1:" ";s:9:"Fieldadd9";s:1:" ";s:10:"Fieldadd10";s:1:" ";s:21:"Qty_requestedByClient";s:3:"400";s:13:"Qty_toProduce";s:3:"432";s:13:"Date_produced";N;s:19:"Date_lastReproduced";N;}i:3;a:33:{s:9:"Store_grp";s:3:"VIK";s:8:"Order_id";s:5:"16560";s:10:"Product_id";s:8:"VIKOT001";s:6:"Sku_id";s:1:"3";s:4:"Size";s:2:"T3";s:5:"Color";s:6:"BUBBLE";s:7:"Barcode";s:13:"3603526019593";s:5:"Model";s:5:"G2842";s:17:"StoreGrp_order_id";s:1:" ";s:6:"Field1";s:1:" ";s:6:"Field2";s:1:" ";s:6:"Field3";s:1:" ";s:6:"Field4";s:1:" ";s:6:"Field5";s:1:" ";s:6:"Field6";s:1:" ";s:6:"Field7";s:1:" ";s:6:"Field8";s:1:" ";s:6:"Field9";s:1:" ";s:7:"Field10";s:1:" ";s:9:"Fieldadd1";s:1:" ";s:9:"Fieldadd2";s:1:" ";s:9:"Fieldadd3";s:1:" ";s:9:"Fieldadd4";s:1:" ";s:9:"Fieldadd5";s:1:" ";s:9:"Fieldadd6";s:1:" ";s:9:"Fieldadd7";s:1:" ";s:9:"Fieldadd8";s:1:" ";s:9:"Fieldadd9";s:1:" ";s:10:"Fieldadd10";s:1:" ";s:21:"Qty_requestedByClient";s:3:"100";s:13:"Qty_toProduce";s:3:"108";s:13:"Date_produced";N;s:19:"Date_lastReproduced";N;}}s:5:"sku_1";a:242:{s:7:"BARCODE";s:13:"3603526019562";s:11:"CLIENTORDER";s:5:"90082";s:5:"COLOR";s:6:"BUBBLE";s:10:"COLOR_CODE";s:2:"GH";s:14:"COMPO_TI1_MAT1";s:5:"COTON";s:18:"COMPO_TI1_MAT1_ARA";s:5:"?????";s:18:"COMPO_TI1_MAT1_CHI";s:1:"?";s:18:"COMPO_TI1_MAT1_ENG";s:6:"COTTON";s:18:"COMPO_TI1_MAT1_GER";s:9:"BAUMWOLLE";s:18:"COMPO_TI1_MAT1_HEB";s:5:"?????";s:18:"COMPO_TI1_MAT1_ITA";s:6:"COTONE";s:18:"COMPO_TI1_MAT1_JAP";s:1:"?";s:18:"COMPO_TI1_MAT1_POR";s:7:"ALGOD"

Je n'arrive absolument à comprendre pourquoi j'ai cette notice si quelqu'un peut m'aider ça serait cool !

[rawsrc]

Bonjour,

tu es raccord sur les charsets ?

[erehcab]

je suis en utf8

[rawsrc]

utf-8 pour le site, la base de données et le paramétrage du charset pour la connexion.
D'ailleurs tu utilises mysql_ ou PDO ?

[erehcab]

j'utilise utf-8 pour tout, et je suis connecté via les fonctions PDO de Zend.

[rawsrc]

Ok, donc ça c'est reglé.
Maintenant, je pencherai pour un problème avec un caractère de retour à la ligne les merveilleux "\n" "\r" "\r\n"Joues avec et ré-essaies.
Sinon tu peux toujours essayer d'encoder tout ce qui n'est pas alphanumérique et de décoder à la déserialisation