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,,
problema mysql
Moderators: Moderatori ajutatori, Moderatori
- Mădălin
- Administrator
- Posts: 5295
- Joined: 06 Mar 2013, 21:40
- Detinator Steam: Nu
- Reputatie: Administrator
Fost manager cs.extream.ro
Web designer
Administratorul anului 2023 - Has thanked: 45 times
- Been thanked: 310 times
- Contact:
Intra in phpmyadmin si in baza ta de date ruleaza codul asta:
User/passwd: admindemo
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', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-
- Membru, skill 0
- Posts: 60
- Joined: 16 Sep 2014, 20:58
- Detinator Steam: Da
- CS Status: Citesc forumul eXtreamCS.com...!
- Fond eXtream: 0
- Has thanked: 2 times
- Contact:
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'
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'
-
- Utilizator neserios (tepar)
- Posts: 104
- Joined: 24 Oct 2016, 11:12
- Detinator Steam: Da
- CS Status: Status asemanator cu cel de la programel
- SteamID: Nu stiu dastea
- Reputatie: Utilizator neserios (tepar)
- Fond eXtream: 0
- Location: Balta Alba
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
"Buy reclama if you want" =)))))))))
- Mădălin
- Administrator
- Posts: 5295
- Joined: 06 Mar 2013, 21:40
- Detinator Steam: Nu
- Reputatie: Administrator
Fost manager cs.extream.ro
Web designer
Administratorul anului 2023 - Has thanked: 45 times
- Been thanked: 310 times
- Contact:
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.
Acum te poti loga cu full acces pe noul cont creat si poti modifica ce vrei tu.
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.