backup terugzetten wil niet
Geplaatst: 27 jul 2007, 15:57
- Adres van je forum: http://www.deto82.nl/forum
Event. modificaties op je forum:calender / verjaardag / portal
Wanneer ontstond het probleem? backup terugzetten
phpBB versie: 2.0.22
Heb je onlangs iets verandert aan je forum? nee
Wat is het probleem?
Code: Selecteer alles
SQL-query:
INSERT INTO `phpbb_posts` ( `post_id` , `topic_id` , `forum_id` , `poster_id` , `post_time` , `poster_ip` , `post_username` , `enable_bbcode` , `enable_html` , `enable_smilies` , `enable_sig` , `post_edit_time` , `post_edit_count` )
VALUES ( 25, 3, 19, 5, 1102779410, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 3, 3, 19, 2, 1102548299, '3ec3d382', '', 1, 0, 1, 0, NULL , 0 ) , ( 106, 29, 4, 8, 1104499410, 'd54b0c32', '', 0, 0, 1, 0, NULL , 0 ) , ( 5, 5, 19, 2, 1102549235, '3ec3d382', '', 1, 0, 1, 0, NULL , 0 ) , ( 6, 6, 19, 5, 1102570869, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 7, 6, 19, 4, 1102587881, '3ec3d382', '', 1, 0, 1, 0, NULL , 0 ) , ( 8, 7, 19, -1, 1102589677, '1884d443', 'imcaaatje1', 1, 0, 1, 0, NULL , 0 ) , ( 9, 6, 19, 6, 1102608982, 'd50af705', '', 1, 0, 1, 0, NULL , 0 ) , ( 10, 7, 19, 6, 1102609203, 'd50af705', '', 1, 0, 1, 0, NULL , 0 ) , ( 105, 30, 19, 9, 1104496434, 'd481b2f0', '', 1, 0, 1, 0, NULL , 0 ) , ( 104, 29, 4, 5, 1104495738, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 13, 3, 19, 5, 1102609659, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 14, 8, 19, 5, 1102609986, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 15, 8, 19, 5, 1102631543, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 16, 3, 19, 4, 1102673318, 'd5da4112', '', 1, 0, 1, 0, NULL , 0 ) , ( 17, 3, 19, -1, 1102699280, '51cc7fd0', '', 1, 0, 1, 0, NULL , 0 ) , ( 18, 3, 19, -1, 1102699363, '51cc7fd0', '', 1, 0, 1, 0, NULL , 0 ) , ( 24, 3, 19, 2, 1102776937, '3ec3d382', '', 1, 0, 1, 0, NULL , 0 ) , ( 23, 12, 19, 2, 1102775329, '3ec3d382', '', 1, 0, 1, 0, NULL , 0 ) , ( 26, 3, 19, 4, 1102779528, '3ec3d382', '', 1, 0, 1, 0, NULL , 0 ) , ( 27, 12, 19, 5, 1102779559, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 28, 5, 19, 5, 1102801764, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 29, 12, 19, 10, 1102854286, 'c3794ebd', '', 1, 0, 1, 0, NULL , 0 ) , ( 30, 6, 19, 10, 1102854658, 'c3794ebd', '', 1, 0, 1, 0, NULL , 0 ) , ( 31, 13, 19, 10, 1102855277, 'c3794ebd', '', 1, 0, 1, 0, NULL , 0 ) , ( 32, 13, 19, 5, 1102871853, '51cc7fd0', '', 1, 0, 1, 1, NULL , 0 ) , ( 33, 6, 19, 13, 1102931740, '53742348', '', 1, 0, 1, 0, NULL , 0 ) , ( 34, 12, 19, 9, 1102938549, 'd481b2f0', '', 1, 0, 1, 0, NULL , 0 ) , ( 35, 13, 19, 4, 1102958715, '5039bc53', '', 1, 0, 1, 0, NULL , 0 ) , ( 36, 12, 19, 4, 1102959294, '5039bc53', '', 1, 0, 1, 0, NULL , 0 ) ,
MySQL retourneerde:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 31
Ik ben helemaal ten einde raad omdat ik eerder een backup terug gezet heb op de oude server en dat was geen probleem. (moest alleen in veel stukjes geplakt. Door bovenstaande foutmelding loopt tevens m'n eigen computer hopeloos vast. Tevens de vraag of ik anders eventueel alleen de gebruikers kan verhuizen zodat niemand zich opnieuw hoeft aan te melden.