Pagina 1 van 1

Herstel database

Geplaatst: 19 dec 2004, 16:38
door 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

Geplaatst: 20 dec 2004, 13:44
door mosymuis
Zoek die volledige regel eens op in je backup?

Geplaatst: 20 dec 2004, 13:51
door 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

Geplaatst: 20 dec 2004, 13:54
door mosymuis
Daar is niets mis mee. Wat zijn de regels ervoor en erna? Hoe heb je deze backup gemaakt?

Geplaatst: 20 dec 2004, 13:57
door maliakreta
De backup heb ik via het forum gemaakt en wilde het ook zo terug zetten

En toen gaf het dez melding

Gr

Geplaatst: 20 dec 2004, 14:18
door 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

Geplaatst: 20 dec 2004, 17:17
door 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

Geplaatst: 20 dec 2004, 17:43
door mosymuis
Tip: je database backups voortaan maken in phpMyAdmin, in plaats van phpBB. Kan je een hoop problemen schelen.

Geplaatst: 20 dec 2004, 17:51
door maliakreta
Hoi,

Kan je mij vertellen hoe ik dat moet doen.

Gr maliakreta

Geplaatst: 20 dec 2004, 17:52
door mosymuis
Probeer het gewoon eens. Gebruik de "export" tab.

Geplaatst: 20 dec 2004, 17:57
door maliakreta
Hallo,

Een leek, moet ik dat op de server doen?

Gr maliakreta

Geplaatst: 20 dec 2004, 18:01
door mosymuis
Je bent bekend met het fenomeen phpMyAdmin?

Geplaatst: 20 dec 2004, 18:47
door 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