problema mysql

[Krypton.]

buna zius imi cer scuze daca am scris gresit dar am o problema cu forumul phpbb si baza e date mysql ... am pus o baza de date mai veche care o aveam prin laptop si nu mai stiu parola .... mentionez ca nu pot sa regenerez parola ... forumul este in constructie ....
stiu ca era o metoda sa fac un alt cont de utilizator in mysql dar nu stiu cum ajutati.ma si pe mine va rog .... multumesc anticipat,,

[trekA]

https://dev.mysql.com/doc/refman/8.0/en ... sions.html
Vezi daca te ajuta.

[Krypton.]

era o chestie care o inseram in mysql si voila usser nou cu grad de administrator

[Krypton.]

nu reusesc sai fac nimic....

[Mădălin]

Ce versiune phpbb?

[Krypton.]

Ultima versiune ... 3.3

[Mădălin]

Intra in phpmyadmin si in baza ta de date ruleaza codul asta:

Code: Select all

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'admindemo', 'admindemo', 0, '46650caa32f2fc242005ee7dafeb7894', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

User/passwd: admindemo

[Krypton.]

Si utilizatorul si parola admin demo

[Krypton.]

Eroare

Interogare SQL:

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'admindemo', 'admindemo', 0, '46650caa32f2fc242005ee7dafeb7894', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '')

MySQL zice: Documentație
#1054 - Coloana invalida 'user_from' in 'field list'

[The Kalu]

Nu corespund coloanele cu tabela respectiva, sterge din interogare user_from si "" una dintre ele.

[SnitchBitch]

Cel mai bine intrii in phpmyadmin te duci la tabelu respectiv si apesi pe insert -> completezi totate coloanele( unde nu stii lasi gol) si apesi Go

[Mădălin]

Cel mai simplu, daca nu te descurci nici asa...

1. Fa un cont nou pe forumul tau.
2. Intra in phpmyadmin.
3. Selecteaza tabela 'phpbb_users'.
4. Cauta in tabela 'phpbb_users' noul cont facut si da click pe Edit.
5. In casuta de la user_type sa fie numarul 3 (acces de fondator).
6. In casuta de la group_id sa fie numarul 5 (grupul de administratori).
7. In casuta de la user_permissions sterge si inlocuieste permisiunile cu urmatoarele:
8. Save.

Code: Select all

001ekfzik0zj6ez2zu
hwby9w000000
m6awadqmx0qo

Acum te poti loga cu full acces pe noul cont creat si poti modifica ce vrei tu.