phpBB2 by Przemo

[Myszoor]

witam

jakiś czas po aktualizacji forum (przez jednego z tutejszych modów) do aktualnej wersji okazało się, że nie da się zarejestrować nowego usera

komunikat jest taki:

Kod:

Could not insert data into users table DEBUG MODE INSERT INTO phpbb_users (username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_interests, user_from, user_field_1,user_field_2,user_field_3,user_field_4,user_field_5, user_sig, user_sig_bbcode_uid, user_sig_image, user_avatar, user_avatar_type, user_viewemail, user_viewaim, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_gg, user_notify_pm, user_popup_pm, user_timezone, user_lang, user_custom_color, user_custom_rank, user_style, user_gender, allowpm, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_ip, user_ip_login_check, user_active, user_actkey) VALUES ('1212', 1392053085, '$H$9ZH6krkLrgHqdCd1VZAilBsFKq2UOv.', '121211@12312.da', '', '', '', '', '', '12121', 'qweqweq', '', '', '', '', '', '', '', 0, 1, 1, '', '', '', 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 'polish', '', '', 3, '0', 1, 0, 1, '999999', '0', 'd519c403', 1, 0, '7d90737396d8bc8123313b') Line : 908 File : usercp_register.php

podmiana (za radą owego moda który przez natłok zajęć nie miał już niby czasu by naprawić problem do którego się w końcu przyczynił i ograniczył się w działaniach tylko do owej rady) pliku "usercp_register.php" na czysty z paczki instalacyjnej niczego nie zmieniła. Naprawa przerasta moją wiedzę, więc proszę o pomoc ...

help : |

[Gadatliwa Kasia]

[Woytec]

Wykonaj w phpmyadminie i pokaż treść błędu. Czy aktualizacja bazy była wykonana?

Kod:

INSERT INTO phpbb_users (username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_interests, user_from, user_field_1,user_field_2,user_field_3,user_field_4,user_field_5, user_sig, user_sig_bbcode_uid, user_sig_image, user_avatar, user_avatar_type, user_viewemail, user_viewaim, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_gg, user_notify_pm, user_popup_pm, user_timezone, user_lang, user_custom_color, user_custom_rank, user_style, user_gender, allowpm, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_ip, user_ip_login_check, user_active, user_actkey) VALUES ('1212', 1392053085, '$H$9ZH6krkLrgHqdCd1VZAilBsFKq2UOv.', '121211@12312.da', '', '', '', '', '', '12121', 'qweqweq', '', '', '', '', '', '', '', 0, 1, 1, '', '', '', 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 'polish', '', '', 3, '0', 1, 0, 1, '999999', '0', 'd519c403', 1, 0, '7d90737396d8bc8123313b')

[Myszoor]

[Woytec]

[Myszoor]

[Woytec]

Kod:

ALTER TABLE `phpbb_users` CHANGE `user_id` `user_id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;

[Myszoor]

[Woytec]

W nowszej wersji dodano auto_increment ale skrypt aktualizacyjny tego nie zmienił.

[ziemi]

Witam , mam podobny problem...

Przy rejestrcji wyskakuje

Cytat:

Could not insert data into users table DEBUG MODE INSERT INTO phpbb_users (username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_interests, user_from, user_field_1, user_sig, user_sig_bbcode_uid, user_sig_image, user_avatar, user_avatar_type, user_viewemail, user_viewaim, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_gg, user_notify_pm, user_popup_pm, user_timezone, user_lang, user_custom_color, user_custom_rank, user_style, user_gender, allowpm, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_ip, user_ip_login_check, user_active, user_actkey) VALUES ('weraa', 1422532906, '$H$9rkxJwVkM3BsSCxKqh8mc52xId2WDQ1', 'ziemi2@wp.pl', '', '', '', '', '', '', '', '', '', '', 0, 1, 1, '', '', '', 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 'polish', '', '', 6, '0', 1, 0, 1, '999999', '0', '2598134d', 1, 1, '') Line : 908 File : usercp_register.php

Wrzuciłem zapytanie i to co napisałesś Wojtec

Cytat:

ALTER TABLE `phpbb_users` CHANGE `user_id` `user_id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;

ale wywala mi bład

Cytat:

#1062 - ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1130' for key 'PRIMARY'

[Gadatliwa Kasia]

[Woytec]

Wykonaj w phpmyadmin i pokaż komunikat:

Kod:

INSERT INTO phpbb_users (username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_interests, user_from, user_field_1, user_sig, user_sig_bbcode_uid, user_sig_image, user_avatar, user_avatar_type, user_viewemail, user_viewaim, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_gg, user_notify_pm, user_popup_pm, user_timezone, user_lang, user_custom_color, user_custom_rank, user_style, user_gender, allowpm, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_ip, user_ip_login_check, user_active, user_actkey) VALUES ('weraa', 1422532906, '$H$9rkxJwVkM3BsSCxKqh8mc52xId2WDQ1', 'ziemi2@wp.pl', '', '', '', '', '', '', '', '', '', '', 0, 1, 1, '', '', '', 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 'polish', '', '', 6, '0', 1, 0, 1, '999999', '0', '2598134d', 1, 1, '')