[Réglé] Problème Mycode image

[sc4t]

J'ai résolue mon problème tous seul comme un grand.. 

Je donne la solution.
Apres avoir sauvegarder ma table mybb_attachments je les supprimer puis recréer la table mybb_attachments.

Code :

DROP TABLE IF EXISTS `mybb_attachments`;
CREATE TABLE IF NOT EXISTS `mybb_attachments` (
 `aid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
 `posthash` varchar(50) NOT NULL DEFAULT '',
 `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
 `filename` varchar(120) NOT NULL DEFAULT '',
 `filetype` varchar(120) NOT NULL DEFAULT '',
 `filesize` int(10) UNSIGNED NOT NULL DEFAULT '0',
 `attachname` varchar(120) NOT NULL DEFAULT '',
 `downloads` int(10) UNSIGNED NOT NULL DEFAULT '0',
 `dateuploaded` int(10) UNSIGNED NOT NULL DEFAULT '0',
 `visible` tinyint(1) NOT NULL DEFAULT '0',
 `thumbnail` varchar(120) NOT NULL DEFAULT '',
 PRIMARY KEY (`aid`),
 KEY `pid` (`pid`,`visible`),
 KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
COMMIT;

Ensuite j'ai insérer toutes les données de mes pieces jointes dans la nouvelle table..

Code :

INSERT INTO `mybb_attachments` (`aid`, `pid`, `posthash`, `uid`, `filename`, `filetype`, `filesize`, `attachname`, `downloads`, `dateuploaded`, `visible`, `thumbnail`) VALUES
(4586, 35713, '82862469a3503fe2757709e02e5e8fcf', 0, 'CLEACHOCS.jpg', 'image/jpeg', 45534, 'post_365_0.attach', 10, 0, 1, ''),
(4587, 35717, '82776852573dabff32aaceb7a5edfbac', 372, 'pincej.jpg', 'image/jpeg', 13284, 'post_372_0.attach', 7, 0, 1, ''),
(4588, 35721, 'e3f5a125e5c5331c2c749317b17afb61', 0, '798958DSC00492.jpg', 'image/jpeg', 54657, 'post_365_0_2558.attach', 167, 0, 1, ''),
(4589, 35721, '7c3401af93f48bd20b1c19ab51eaa477', 0, '399048DSC00494.jpg', 'image/jpeg', 50092, 'post_365_0_2559.attach', 117, 0, 1, ''),
(4613, 36375, 'b3914492210af283cdc61d7ea7b05d5e', 0, 'baotiantiger2png.png', 'image/png', 720000, 'post_365_0_2633.attach', 9, 0, 1, ''),
(4614, 36375, 'e65f4503a99a77a893b50e2df2917768', 0, 'baotiantiger3png.png', 'image/png', 311866, 'post_365_0_2634.attach', 8, 0, 1, ''),
(4615, 36375, '19c96ef5079797cc184c1df2a55dce49', 0, 'baotiantiger4png.png', 'image/png', 576053, 'post_365_0_2635.attach', 7, 0, 1, ''),
(4616, 36375, 'c6d4aa5a9716322e0abe520a7b2e696b', 0, 'baotiantiger5png.png', 'image/png', 266038, 'post_365_0_2636.attach', 9, 0, 1, ''),
(4617, 36505, '82432ecbf9a8d16845ad8d9815115661', 0, 'mini_9350311.jpg', 'image/jpeg', 4171, 'post_0_0_2615.attach', 9, 0, 1, ''),
(6099, 47665, '7f142124064ce993ce47672028444b0b', 0, 'maxresdefault.jpg', 'image/jpeg', 91086, 'post_365_1502174969.attach', 24, 0, 1, ''),
(6100, 47666, 'bbb1f21270d89ecad46fd72f5cf38be7', 0, 'si vous avez aimé.jpg', 'image/jpeg', 106064, 'post_365_1502175900.attach', 18, 0, 1, ''),
(6101, 47677, 'e0f7a2c0b2306a7d0c8f501702d01623', 0, 'instantané_001.png', 'image/png', 476100, 'post_365_1502306327.attach', 8, 0, 1, ''),
(6102, 47682, 'b42ecef0c5cc2ebc42ed763a5acf608d', 643, 'Screenshot_2017-08-09-21-46-52.png', 'image/png', 305186, 'post_643_1502308184.attach', 8, 0, 1, ''),
(6103, 47684, '7cdaf29c2e4f8380136cb8c50ef9bae1', 643, 'Screenshot_2017-08-09-20-37-16-1.png', 'image/png', 671835, 'post_643_1502308426.attach', 8, 0, 1, ''),
(6104, 47686, '93d727701f5cfba2064baae36fb113d7', 643, 'Screenshot_2017-08-09-20-54-19-1.png', 'image/png', 299727, 'post_643_1502354172.attach', 7, 0, 1, ''),
(6105, 47686, 'c4c228b6d9ad2e1d66777f2e66f94885', 643, '20170810_104318-1.jpg', 'image/jpeg', 481466, 'post_643_1502354695.attach', 7, 0, 1, ''),
(6106, 47686, '61c3f5c8b6aef41503dcf38f6b1a8062', 643, '20170810_104246-1.jpg', 'image/jpeg', 128222, 'post_643_1502354707.attach', 7, 0, 1, ''),
(6107, 47688, '0c5baae02706e701b05d4532cd37d80e', 0, 'si vous avez aimé.jpg', 'image/jpeg', 106064, 'post_365_1502377405.attach', 11, 0, 1, ''),
(6108, 47813, '', 3, 'cdi 1.png', 'image/png', 912535, '201708/post_3_1504173425_b8a2603d5feef7b0635c6c580436da8f.attach', 6, 1504173425, 1, ''),
(6109, 47813, '', 3, 'cd1 2.png', 'image/png', 929291, '201708/post_3_1504173439_c9733afcf865a5716be6cb30d8ff4e24.attach', 1, 1504173439, 1, ''),
(6111, 47829, '', 758, 'Collage 2017-09-05 19_12_09.jpg', 'image/jpeg', 248150, '201709/post_758_1504674949_b8e30186e8a90b1124bbdf145945f678.attach', 5, 1504674949, 1, ''),
(6112, 47829, '', 758, 'IMG_20170905_192002_652.JPG', 'image/jpeg', 123174, '201709/post_758_1504675234_86a41789fe97131ddafd41050837dfd2.attach', 8, 1504675234, 1, ''),
(6113, 47857, '', 722, 'kit gy6.jpg', 'image/jpeg', 260050, '201709/post_722_1505812190_984a9b9c660a342e01d7f913213e000c.attach', 10, 1505812190, 1, ''),
(6114, 47858, '', 3, 'kit gy6.jpg', 'image/jpeg', 188942, '201709/post_3_1505816292_fb4d29adc0eaba979ce21eb13360f3d8.attach', 8, 1505816292, 1, ''),
(6115, 47858, '', 3, 'joint-d-echappement-artein-adaptable.jpg', 'image/jpeg', 10308, '201709/post_3_1505816437_d18bc2c3b7fcc75c9de26a5571fc45a2.attach', 7, 1505816437, 1, ''),
(6116, 47858, '', 3, 'joint-echappement-d20.jpg', 'image/jpeg', 64147, '201709/post_3_1505816447_5462a8483832ae523f7f5d6738a278b0.attach', 7, 1505816447, 1, ''),
(6117, 47872, '', 722, 'resized_2.jpg', 'image/jpeg', 199160, '201709/post_722_1505991596_fbd3acd41542b5aa3f2e4a0640e0c93e.attach', 6, 1505991596, 1, ''),
(6118, 47873, '', 3, 't7o3zifo9nxu1wr2.jpg', 'image/jpeg', 59249, '201709/post_3_1505993046_dc739d8e1ca2335d0c0f53ff9b40ac13.attach', 5, 1505993046, 1, ''),
(6119, 47873, '', 3, 'big-2826320a39.jpg', 'image/jpeg', 74543, '201709/post_3_1505993387_d7e4c2ec761e7cf50a39d9b92d9acc3e.attach', 4, 1505993387, 1, ''),
(6120, 47874, '', 3, 'GIvsxx2Yu8d_InkedIMG-20170903-162321-LI.jpg', 'image/jpeg', 151530, '201709/post_3_1506056162_e8a9d6940d04116f01b1e3c7275c814f.attach', 4, 1506056162, 1, ''),
(6121, 47889, '', 3, '5408_4d9cb99487963.jpg', 'image/jpeg', 218097, '201709/post_3_1506341895_f573d08cab49cf62674d530d7972c098.attach', 12, 1506341895, 1, ''),
(6122, 47889, '', 3, '5408_4d9b12ef25ae5.jpg', 'image/jpeg', 202498, '201709/post_3_1506341907_17ece5e5d2704c42a423d8e3c76fa88d.attach', 11, 1506341907, 1, ''),
(6123, 47889, '', 3, '5408_4d9b1639c42dc.jpg', 'image/jpeg', 230492, '201709/post_3_1506341918_23f18980d8903c05f19f366a699b9e1a.attach', 11, 1506341918, 1, ''),
(6124, 47889, '', 3, '5408_4d9cb8e841d92.jpg', 'image/jpeg', 183384, '201709/post_3_1506341927_16d5f6e19a31666ed957bc8060702923.attach', 10, 1506341927, 1, ''),
(6125, 47889, '', 3, 'fourche.png', 'image/png', 153216, '201709/post_3_1506342151_415aeb7893ba9d0a7bf812e696e40d04.attach', 11, 1506342151, 1, ''),
(6126, 47915, '', 3, 'vidme.png', 'image/png', 34524, '201709/post_3_1506662108_dd58f139d2f89cb2432c33dee715e96a.attach', 0, 1506662108, 1, ''),
(6128, 47932, '', 3, '65_5704.jpg', 'image/jpeg', 35739, '201710/post_3_1507104714_bd65062eca400e12b3733fcd66aa3b27.attach', 27, 1507104714, 1, ''),
(0, 47965, '', 3, 'logo.png', 'image/png', 19126, '201710/post_3_1507732420_dab9ca4f1fb2cc7e7390c5512d2cd036.attach', 1, 1507732420, 1, ''),
(0, 47966, '', 3, 'logo.png', 'image/png', 19126, '201710/post_3_1507733101_4b01c42827ab0d28cc1d5289c77a4849.attach', 1, 1507733101, 1, ''),
(0, 47967, '', 3, 'carbon-logo.png', 'image/png', 16365, '201710/post_3_1507738801_9ba75147f4a61e440f561d735613e244.attach', 1, 1507738801, 1, '');
COMMIT;