Een vriend heeft een forum, en hij stopt. Nu, heeft hij alle mysql gegeven, maar als ik users en topics wil inladen, dan krijg ik dit:
Hoe kan ik dit oplossen?FOUT:
SQL-query:
INSERT INTO `phpbb_forums` ( `forum_id` , `parent_id` , `left_id` , `right_id` , `forum_parents` , `forum_name` , `forum_desc` , `forum_desc_bitfield` , `forum_desc_options` , `forum_desc_uid` , `forum_link` , `forum_password` , `forum_style` , `forum_image` , `forum_rules` , `forum_rules_link` , `forum_rules_bitfield` , `forum_rules_options` , `forum_rules_uid` , `forum_topics_per_page` , `forum_type` , `forum_status` , `forum_posts` , `forum_topics` , `forum_topics_real` , `forum_last_post_id` , `forum_last_poster_id` , `forum_last_post_subject` , `forum_last_post_time` , `forum_last_poster_name` , `forum_last_poster_colour` , `forum_flags` , `display_subforum_list` , `display_on_index` , `enable_indexing` , `enable_icons` , `enable_prune` , `prune_next` , `prune_days` , `prune_viewed` , `prune_freq` )
VALUES ( 1, 0, 1, 12, '', 0x416c67656d65656e, '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 1, 0, 0, 0, 0, 0 ) , ( 2, 1, 2, 3, 0x613a313a7b693a313b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 0x4e6965757773, 0x426573707265656b206465206e696575776520757064617465732076616e206465207369746520656e2f6f662070686f746f73686f702068696572, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 43, 6, 6, 1501, 53, 0x52653a205b30362d31322d30385d2048657420272752656e64657220466f72756d2727, 1228575171, 0x637275776479, '', 32, 1, 1, 1, 1, 0, 0, 0, 0, 0 ) , ( 3, 0, 13, 48, '', 0x44657369676e, '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 4, 13, 54, 57, 0x613a313a7b693a31333b613a323a7b693a303b733a31303a224e6f6e2d64657369676e223b693a313b693a303b7d7d, 0x416c67656d656e65205072616174, 0x416c6c657320776174206e696574206d65742064657369676e202f2070686f746f73686f70207465206d616b656e206865656674206761617420686965722e2e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 32, 3, 3, 1365, 63, 0x52653a20486574204c696e757820746f706963, 1227377086, 0x666c61736865657572, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 5, 4, 55, 56, 0x613a323a7b693a31333b613a323a7b693a303b733a31303a224e6f6e2d64657369676e223b693a313b693a303b7d693a343b613a323a7b693a303b733a31343a22416c67656d656e65205072616174223b693a313b693a313b7d7d, 0x5374656c206a657a656c6620766f6f7221, 0x416c73206a65206e696575772062656e742c207374656c206a657a656c662064616e206576656e20766f6f722e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 30, 6, 6, 1363, 79, 0x52653a20496e667573696f6e, 1227373283, 0x42726b7942, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 18, 1, 6, 7, 0x613a313a7b693a313b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 0x466f72756d2061616e76756c6c696e67656e, 0x416c73206a652065656e204275672076696e64206f662065656e2049646565206865627420766f6f722068657420666f72756d206b616e206a65207a65206869657220706f7374656e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 38, 7, 7, 1511, 2, 0x52653a20427567203f, 1228666924, 0x4461726b6861776b, 0x414130303030, 32, 1, 1, 1, 1, 0, 0, 7, 7, 1 ) , ( 6, 1, 4, 5, 0x613a313a7b693a313b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 0x4c6564656e20466f72756d, 0x416c6c65656e20746f6567616e6b656c696a6b20746f74206765726567697374726565726465206c6564656e2e2e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 64, 6, 6, 1536, 55, 0x52653a20506f7374206a65206465736b746f70, 1229869301, 0x4a6f62, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 7, 3, 18, 25, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x4f6e7477657270, 0x506f7374206a65206c6161747374652064657369676e207765726b2068696572206f6620616476657274656572206a65207369746520686965722e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 60, 7, 7, 1582, 84, 0x52653a204765617273204f662057617220736967, 1233003817, 0x77616e6472, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 8, 3, 38, 39, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x5369676e61747572652052657175657374, 0x5665727a6f656b206a65207369676e617475726520686965722e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 21, 6, 6, 1223, 54, 0x52653a205b444f4e455d204b697769205369676e6174757265, 1226581476, 0x44616272756e6f, 0x414130303030, 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 9, 3, 40, 41, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x4176617461722052657175657374, 0x5265717565737420686965722065656e20617661746172206f66206965747320616e6465727321, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 38, 8, 8, 1519, 54, 0x52653a204c6f676f202b2061666669636865206765767261616764, 1228840724, 0x44616272756e6f, 0x414130303030, 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 10, 3, 26, 29, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x5475746f7269616c73, 0x506f73742065656e207475746f7269616c207761617220752064656e6b742064617420616e646572656e207761742061616e2068656262656e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 127, 1, 0, 165, 22, 22, 1559, 79, 0x52653a205b50535d2052656e646572207370656369616c2066782065787472616374696f6e, 1231142342, 0x42726b7942, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 11, 7, 19, 22, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a373b613a323a7b693a303b733a373a224f6e7477657270223b693a313b693a313b7d7d, 0x534f545720656e20576564737472696a64656e, 0x48696572206b756e206a6520737472696a64656e206f6d206465207369676e61747572652076616e206465207765656b20656e7a2e2e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 68, 5, 5, 1476, 62, 0x52653a2044657369676e206b616d70696f656e7363686170204e6f76656d626572203230303821, 1227907416, 0x496e667573696f6e, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 12, 10, 27, 28, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a31303b613a323a7b693a303b733a393a225475746f7269616c73223b693a313b693a313b7d7d, 0x5265717565737421, 0x526571756573742068696572206e6965757765207475746f7269616c7321, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 31, 6, 6, 1491, 81, 0x52653a20486f652064657a65203344207465787420656666656374, 1228246056, 0x426173626f79, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 16, 13, 52, 53, 0x613a313a7b693a31333b613a323a7b693a303b733a31303a224e6f6e2d64657369676e223b693a313b693a303b7d7d, 0x46756e202f205370616d, 0x5a657420686965722076616e20616c6c657320646174204e49455453206d65742064657369676e207465206d616b656e2068656566742e2e2e206f66206765776f6f6e20626c61617421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 360, 23, 23, 1530, 57, 0x52653a20484554204f6666696369656c65205370616d746f706963, 1229351542, 0x6f7a6162, '', 32, 1, 1, 1, 1, 0, 0, 7, 7, 1 ) , ( 13, 0, 49, 58, '', 0x4e6f6e2d64657369676e, '', '', 7, '', '', '', 0, 0x44616272756e6f, '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 7, 7, 1 ) , ( 14, 13, 50, 51, 0x613a313a7b693a31333b613a323a7b693a303b733a31303a224e6f6e2d64657369676e223b693a313b693a303b7d7d, 0x47616d6573, 0x50726174656e206f7665722067616d657320646f65206a65206869657221, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 79, 6, 6, 1524, 55, 0x52653a205b4669727374506572736f6e53686f6f746572202d20494a4a495d20736f4c646965722066526f6e542021, 1229196433, 0x4a6f62, '', 32, 1, 1, 1, 1, 0, 0, 7, 7, 1 ) , ( 21, 3, 14, 15, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x416c67656d65656e, 0x416c2068657420616c67656d656e6520646174206d65742050686f746f73686f70207465206d616b656e2068656566742e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 9, 1, 1, 1435, 79, 0x52653a2042657374616e6420616368746572766f656773656c73, 1227629918, 0x42726b7942, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 20, 19, 9, 10, '', 0x537567676573746965206265737072656b696e67656e, 0x466f72756d206f6d20676f65646520737567676573746965732076616e206c6564656e207465206265737072656b656e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 3, 1, 1, 1051, 54, 0x52653a202727416c67656d65656e20526174696e67205379737465656d2727, 1226165964, 0x44616272756e6f, 0x414130303030, 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 19, 1, 8, 11, 0x613a313a7b693a313b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 0x41646d696e20466f72756d, 0x566f6f722041646d696e732f4d6f6473206f6e6c792121, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 9, 4, 4, 1498, 2, 0x52653a20272752656e64657220466f72756d2727, 1228498456, 0x4461726b6861776b, 0x414130303030, 32, 1, 1, 1, 1, 0, 0, 7, 7, 1 ) , ( 23, 3, 30, 37, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x446f776e6c6f616473, 0x5a6f656b206a652062727573686573206f6620616e6465726520646f776e6c6f6164733f2044616e207a6974206a65206869657220676f656421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 1, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 7, 7, 1 ) , ( 22, 3, 16, 17, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x50686f746f73686f702068756c70, 0x4b756e206a652064696520746f6f6c206e6965742076696e64656e3f20536e6170206a652064657a65206f70746965206e6965743f20506f73742068696572206a652050686f746f73686f702076726167656e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 11, 2, 2, 1424, 79, 0x52653a204c75697374657220546f6f6c, 1227593687, 0x42726b7942, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 26, 23, 33, 34, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a32333b613a323a7b693a303b733a393a22446f776e6c6f616473223b693a313b693a313b7d7d, 0x466f6e7473, 0x466f6e747320686965722e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 6, 3, 3, 1468, 53, 0x52653a205b43656e747261616c5d205761742069732064697420766f6f7220666f6e743f, 1227882731, 0x637275776479, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 24, 11, 20, 21, 0x613a333a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a373b613a323a7b693a303b733a373a224f6e7477657270223b693a313b693a313b7d693a31313b613a323a7b693a303b733a31393a22534f545720656e20576564737472696a64656e223b693a313b693a313b7d7d, 0x5374656d6d696e672d616368696566, 0x4869657220737461616e206465207374656d6d696e67656e2076616e20776564737472696a64656e2064696520766f6f7262696a207a696a6e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 8, 1, 1, 1025, 2, 0x52653a20534f5457202332205374656d6d696e67, 1226095468, 0x4461726b6861776b, 0x414130303030, 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 25, 23, 31, 32, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a32333b613a323a7b693a303b733a393a22446f776e6c6f616473223b693a313b693a313b7d7d, 0x42727573686573, 0x42727573686573206761616e20686965722e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 11, 1, 1, 1489, 57, 0x52653a2048656c65626f656c20427275736865732e, 1228163264, 0x6f7a6162, '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 27, 23, 35, 36, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a32333b613a323a7b693a303b733a393a22446f776e6c6f616473223b693a313b693a313b7d7d, 0x416e64657273, 0x4465207265737420686965722e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 28, 3, 42, 47, 0x613a313a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d7d, 0x52656e646572696e67, 0x52656e6465727320646965206a696a206865622067656d61616b742c2072656e6465722074757427732c2072656e6465722074697073206574632e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 29, 28, 43, 44, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a32383b613a323a7b693a303b733a393a2252656e646572696e67223b693a313b693a313b7d7d, 0x486f6d656d6164652052656e64657273, 0x48696572206a6f752072656e6465727320646965206a696a20686562742067656d61616b74207a6f64617420646520616e64657265206469652077656572206b756e6e656e206765627275696b656e21, '', 7, '', '', '', 0, 0x44616272756e6f, '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 30, 28, 45, 46, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a32383b613a323a7b693a303b733a393a2252656e646572696e67223b693a313b693a313b7d7d, 0x5469702773202f205475742773, 0x4465206e61616d207a6567742068657420616c2e2e2e, '', 7, '', '', '', 0, 0x44616272756e6f, '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) , ( 31, 7, 23, 24, 0x613a323a7b693a333b613a323a7b693a303b733a363a2244657369676e223b693a313b693a303b7d693a373b613a323a7b693a303b733a373a224f6e7477657270223b693a313b693a313b7d7d, 0x53686f77726f6f6d73, 0x496564657265656e207a276e20746f706963206f6d206b756e737420696e20746520686f77656e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 245, 13, 13, 1583, 54, 0x52653a20426173626f792033442064657369676e73, 1233405078, 0x44616272756e6f, 0x414130303030, 32, 1, 0, 1, 0, 0, 0, 7, 7, 1 ) ;
MySQL retourneerde:
#1062 - Duplicate entry '1' for key 1
Bedankt,
Jeffrey!
