Herstel database

[maliakreta]

Hallo,

Ik deed herstel database en kreeg deze fout melding. wat moet ik nu doen zonder dat ik alle gegevens kwijt ben ik vertel er gelijk bij dat ik een leek op dit gebied ben.dit krijg ik te zien.

SQL Error : 1064 You have an error in your SQL syntax near '19', '1', 'Peter', '6f9f502ba6c17f342732f88bf1052a5c', '1099336802', '-7', '1098' at line 1
Ik heb ook geen verstand van sql

Gr John

[mosymuis]

Zoek die volledige regel eens op in je backup?

[maliakreta]

Dit is de regel

INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('19', '1', 'Peter', '6f9f502ba6c17f342732f88bf1052a5c', '1102714516', '0', '1102262382', '1098480118', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '1098480143', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'peter.vergoossen@hetnet.nl', '', 'http://home.hetnet.nl/~ptr008/index.html', 'Echt', '', '', '', '', '', '', '', '', NULL);

Gr maliakreta

[mosymuis]

Daar is niets mis mee. Wat zijn de regels ervoor en erna? Hoe heb je deze backup gemaakt?

[maliakreta]

De backup heb ik via het forum gemaakt en wilde het ook zo terug zetten

En toen gaf het dez melding

Gr

[maliakreta]

Hallo,

Ik heb het nog een keer geprobeerd en krijg dit toch als fout melding terwijl ik niets veranderd hebt.



Algemene Fout
Error importing backup file

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '56', '1', 'marian', '1729bc477f7b098b508c1e99269c74a1', '1103449817', '0', '1103' at line 1

INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('15', '1', 'Maliaholic', '9ad64c9a277f345e5ee97bb6375330dd', '1102931532', '0', '1102689641', '1097519225', '0', '25', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1395139960416ea110c21c0.jpg', '1', 'desireevanewijk@hotmail.com', '', '', 'Haarlem', 'There\'s No Better Place 2 Go, There\'s No Better Place 2 Be, There\'s No Better Place To Stay... INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('56', '1', 'marian', '1729bc477f7b098b508c1e99269c74a1', '1103449817', '0', '1103407865', '1103407746', '0', '0', '1.00', '3', 'dutch', 'D d M Y G:i', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', NULL, '', '0', 'marian.hoogenboom@xs4all.nl', '', '', 'Hellevoetsluis', '', '', '', '', '', '', 'Malia, Kreta, Meropi', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('19', '1', 'Peter', '6f9f502ba6c17f342732f88bf1052a5c', '1102714516', '0', '1102262382', '1098480118', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '1098480143', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'peter.vergoossen@hetnet.nl', '', 'http://home.hetnet.nl/~ptr008/index.html', 'Echt', '', '', '', '', '', '', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('16', '1', 'jaap muis', '42c7718517446ffc6d10b508a5f6e108', '1099254820', '0', '1098606148', '1098004254', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '1099254820', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', NULL, 'maliakreta/griekvlag.gif', '3', 'jaap.muis@planet.nl', '', '', 'Zwartsluis', 'Wij zijn gek van kreta met name van Malia en omg. Het app. Meropi is geweldig vooral de Luxe en dan maar niet te spreken van de Fam. Meropi gewelige lieve mensen.', '3bffca7057', '', '', '', '', 'Kreta', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('17', '1', 'druut', 'f561aaf6ef0bf14d4208bb46a4ccb3ad', '1098025268', '5', '1098025093', '1098025080', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', NULL, '', '0', 'sandravdruten@hotmail.com', '', '', '', '', '', '', '', '', '', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('18', '1', 'Jigger', 'c6a7228b42ef056b06ad81ba55364771', '1103101429', '-1', '1101909473', '1098362551', '0', '3', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '1', '1099997359', NULL, '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'schutmartine@hotmail.com', '', 'http://crete.prest.nl', '', '', '', '', '', '', '', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('20', '1', 'Joycie', 'e95379014ac0b0d028e2b3092dc06ea7', '1098541884', '0', '1098541827', '1098541681', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'j.bonnet@kabelfoon.net', '', '', 'IJsselstein', '', '', '', '', '', '', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('21', '1', 'nikos', 'f54146a3fc82ab17e5265695b23f646b', '1098907518', '13', '1098545129', '1098545098', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', '0', '', '0', 'tihy@otenet.gr', '', 'http://www.hetverguldevarken.com', 'Malia-Kreta', '', '', '', '', 'nikos', 'kok', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('22', '1', 'Jos', 'c99474aa3c13743d1c9e49b32aef3a75', '1098545761', '0', '1098545761', '1098545722', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'jhbouwman@home.nl', '', '', 'Enschede', '', '', '', '', '', 'Controller', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('23', '1', 'Jan', 'b25675fcea1126b2e22191521e837d3c', '1103276103', '0', '1103212208', '1098553162', '0', '4', '1.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'j.dijk8@chello.nl', '', '', 'Spijkenisse', '', '', '', '', '', 'Iets in de haven van Rotterdam', 'Griekenland', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('24', '1', 'Rob', '7d207ce9e36a6a60ec529d1f62038ed2', '1098572679', '-1', '1098572125', '1098571983', '0', '0', '2.00', '3', 'dutch', '24-10-2004', '0', '0', '1098572047', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', NULL, '', '0', 'Rosa@zeelandnet.nl', '26436019', '', 'Vlissingen', '', '', '', '', 'Putisas@hotmail.com', 'Bedrijfsleider', 'MALIA!!!!!', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('25', '1', 'Peet', '4a91a2195a5d291e2753e2d941d2f6f3', '1099174488', '0', '1099123458', '1098604665', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '1099174488', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', NULL, '', '0', 'ph30042@hotmail.com', '', '', 'Goes', 'Voor 4e keer naar Malia geweest App Akrogiali, was weer geweldig.', '05074a235e', '', '', 'ph30042@hotmail.com', 'Security', 'Kreta', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('26', '1', 'fransgea', '618870ba4918d5aee7148e2b25a1e9d8', '0', '0', '0', '1098620190', '0', '0', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', NULL, '', '0', 'fransgea@planet.nl', '', '', '', '', '', '', '', '', '', '', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('27', '1', 'liek', '0dc11676c3ae96ecb4e0a56af3c0dd10', '1100959671', '0', '1100358714', '1098625365', '0', '1', '2.00', '3', 'dutch', 'D M d, Y g:i a', '0', '0', '1098625427', NULL, '0', '0', '0', '0', '1', '1', '1', '1', '0', '0', '0', NULL, '', '0', 'AvO@imail.nl', '', '', 'vlaardingen', '', '', '', '', '', 'huisvrouw', 'griekenland', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('57', '1', 'Karin', '35d17ba49efb7406f9998d6c3d5c096c', '1103465259', '-4', '1103465193', '1103465148', '0', '0', '1.00', '3', 'dutch', 'D d M Y G:i', '0', '0', '0', NULL, '1', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', NULL, 'maliakreta/meropikarin04.gif', '3', 'emmelotj@wanadoo.nl', '', 'http://www.maliakreta.com', 'Houten', '', '', '', '', '', '', 'Kreta, Malia, Meropi', '', NULL); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('32', '1', 'Arjan&

Line : 980
File : /www/htdocs/maliakre/forum/admin/admin_db_utilities.php


Powered by phpBB 2.0.10 © 2001 phpBB Group

Ik hoop dat je me kan helpen.

Gr maliakreta

[maliakreta]

Hallo,

Het probleem opgelost, op de een of andere manier waren er 2 regels gesplitst en daar liep de backup op vast.

Gr maliakreta

[mosymuis]

Tip: je database backups voortaan maken in phpMyAdmin, in plaats van phpBB. Kan je een hoop problemen schelen.

[maliakreta]

Hoi,

Kan je mij vertellen hoe ik dat moet doen.

Gr maliakreta

[mosymuis]

Probeer het gewoon eens. Gebruik de "export" tab.

[maliakreta]

Hallo,

Een leek, moet ik dat op de server doen?

Gr maliakreta

[mosymuis]

Je bent bekend met het fenomeen phpMyAdmin?

[maliakreta]

Helaas niet,

ik heb wel al een wat van de server gehaald. weet niet of dat correct is. en weet ook niet hoe ik het terug moet zetten.

Gr maliakreta