Problem z przeniesieniem bazy danych użytkowników, HELP :) Opcje

[darkdream]

Siemka Wszystkim.

Trafiłam na Wasze forum bo standardowo mam problem i mam nadzieje, że mi pomożecie (IMG:style_emoticons/default/smile.gif)

Chce przenieść baze danych forum na inny serwer.

Miałam troche problemów z tym - tym bardziej, że jestem zielona z sql. Ale google pomaga (IMG:style_emoticons/default/smile.gif)

Niestety nie w tym przypadku który zaraz opisze.

Otóż największy problem sprawia mi przeniesienie danych użytkowników. To jest część zapytania do sql:

Kod

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_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_viewaim, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allowsig, 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_sig_image, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd, user_birthday, user_next_birthday_greeting, user_custom_rank, user_photo, user_photo_type, user_custom_color, user_badlogin, user_blocktime, user_block_by, disallow_forums, can_custom_ranks, can_custom_color, user_gender, can_topic_color, user_notify_gg, allowpm, no_report_popup, refresh_report_popup, no_report_mail, user_avatar_width, user_avatar_height, special_rank, user_allow_helped, user_ip, user_ip_login_check, user_spend_time, user_visit, user_session_start, read_tracking_last_update, user_jr, transfer) VALUES ( '-1', '0', 'Anonymous', '', '0', '0', '0', '1093813219', '0', '141', '1.00', NULL, 'polish', '0', '0', '0', NULL, '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '1', '0', '0', '', '0', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '999999', '0', NULL, NULL, '0', NULL, '0', '0', NULL, NULL, '1', '1', '0', '1', '0', '1', '0', '0', '0', NULL, NULL, NULL, '1', '', '1', '0', '0', '0', '0', '0', '0905.10485760');

I wywala mi błąd

Kod

Błąd

Zapytanie SQL:

# # Zrzut danych tabeli `phpbb_users` # 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_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_viewaim, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allowsig, 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_sig_image, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd, user_birthday, user_next_birthday_greeting, user_custom_rank, user_photo, user_photo_type, user_custom_color, user_badlogin, user_blocktime, user_block_by, disallow_forums, can_custom_ranks, can_custom_color, user_gender, can_topic_color, u[...]

MySQL zwrócił komunikat:

#1054 - Unknown column 'transfer' in 'field list'

Próbowałam usunąć wszędzie transfer, ale to nie pomaga...

Czy moglibyście mi poradzić co mam zrobić - walcze już z tym trzeci dzień....

Dziękuje Wam i pozdrawiam Was (IMG:style_emoticons/default/smile.gif)

Marta

[oi.]

Poradziłem sobie z tym zmieniając nr id usera

[SQL] pobierz, plaintext 
(user_id,
[SQL] pobierz, plaintext 

na -1
forum powróciło do normy.