problema mysql

Discutii despre tot ce nu se incadreaza in celelalte categorii.

Moderators: Moderatori ajutatori, Moderatori

Post Reply
Krypton.
Membru, skill 0
Membru, skill 0
Posts: 40
Joined: 16 Sep 2014, 19:58
Detinator Steam: Da
CS Status: Citesc forumul eXtreamCS.com...!
Fond eXtream: 0
Has thanked: 2 times
Contact:

07 Mar 2020, 11:31

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,,
eXtreamSHOP
User avatar
trekA
Moderator
Moderator
Posts: 175
Joined: 09 Mar 2019, 23:13
Detinator Steam: Da
CS Status: WIDO.PLAYARENA.RO
SteamID: picanetu
Reputatie: Moderator
Membru Club eXtreamCS (17 Feb - 17 Mai)
Fond eXtream: 0
Location: Piatra Neamț
Has thanked: 56 times
Been thanked: 17 times
Contact:

07 Mar 2020, 11:39

Image
Krypton.
Membru, skill 0
Membru, skill 0
Posts: 40
Joined: 16 Sep 2014, 19:58
Detinator Steam: Da
CS Status: Citesc forumul eXtreamCS.com...!
Fond eXtream: 0
Has thanked: 2 times
Contact:

07 Mar 2020, 11:47

era o chestie care o inseram in mysql si voila usser nou cu grad de administrator
Krypton.
Membru, skill 0
Membru, skill 0
Posts: 40
Joined: 16 Sep 2014, 19:58
Detinator Steam: Da
CS Status: Citesc forumul eXtreamCS.com...!
Fond eXtream: 0
Has thanked: 2 times
Contact:

07 Mar 2020, 11:56

nu reusesc sai fac nimic....
User avatar
Mădălin
Fost moderator
Fost moderator
Posts: 4963
Joined: 06 Mar 2013, 21:40
Detinator Steam: Nu
Reputatie: Fost Administrator
Fost manager cs.extream.ro
Has thanked: 17 times
Been thanked: 237 times

07 Mar 2020, 12:48

Ce versiune phpbb?
Krypton.
Membru, skill 0
Membru, skill 0
Posts: 40
Joined: 16 Sep 2014, 19:58
Detinator Steam: Da
CS Status: Citesc forumul eXtreamCS.com...!
Fond eXtream: 0
Has thanked: 2 times
Contact:

07 Mar 2020, 15:03

Ultima versiune ... 3.3
User avatar
Mădălin
Fost moderator
Fost moderator
Posts: 4963
Joined: 06 Mar 2013, 21:40
Detinator Steam: Nu
Reputatie: Fost Administrator
Fost manager cs.extream.ro
Has thanked: 17 times
Been thanked: 237 times

07 Mar 2020, 16:33

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', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
User/passwd: admindemo
Krypton.
Membru, skill 0
Membru, skill 0
Posts: 40
Joined: 16 Sep 2014, 19:58
Detinator Steam: Da
CS Status: Citesc forumul eXtreamCS.com...!
Fond eXtream: 0
Has thanked: 2 times
Contact:

07 Mar 2020, 18:04

Si utilizatorul si parola admin demo
Krypton.
Membru, skill 0
Membru, skill 0
Posts: 40
Joined: 16 Sep 2014, 19:58
Detinator Steam: Da
CS Status: Citesc forumul eXtreamCS.com...!
Fond eXtream: 0
Has thanked: 2 times
Contact:

08 Mar 2020, 19:36

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', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '')

MySQL zice: Documentație
#1054 - Coloana invalida 'user_from' in 'field list'
User avatar
The Kalu
eXtream Mod
eXtream Mod
Posts: 12358
Joined: 09 Oct 2010, 11:39
Detinator Steam: Da
Reputatie: Fost membru Club eXtreamCS (6 luni)
Nume anterior: Terra
Has thanked: 197 times
Been thanked: 340 times

08 Mar 2020, 19:38

Nu corespund coloanele cu tabela respectiva, sterge din interogare user_from si "" una dintre ele.
SnitchBitch
Utilizator neserios (tepar)
Utilizator neserios (tepar)
Posts: 104
Joined: 24 Oct 2016, 10: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

08 Mar 2020, 20:03

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

Image
Image

"Buy reclama if you want" =)))))))))
User avatar
Mădălin
Fost moderator
Fost moderator
Posts: 4963
Joined: 06 Mar 2013, 21:40
Detinator Steam: Nu
Reputatie: Fost Administrator
Fost manager cs.extream.ro
Has thanked: 17 times
Been thanked: 237 times

08 Mar 2020, 20:25

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
Image

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

Return to “Discutii generale”

  • Information