Google+

Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Eroare baza de date cred
#1
Salut incercam sa fac un post si imi apare eroarea asta dar am mai facut 2 inainte si nu avea nimic :| am facut un print screen sa vedeti cum arata nu stiu de ce apare .... [Image: 77420856278229358506.png] o solutie cineva ?...
#2
Incercati sa traduceti eroarea si apoi veti vedea de unde provine si care e cauza ei. Eroare iti spune clar ca se doreste compararea a doua campuri din baza de date care au o colocare diferita la una e latin_general_ci, iar la alta e utf8_general_ci. Va trebui sa ai aceeasi colocare pe ambele campuri din tabel. Schimbarea colocarii pentru o tabela se poate face astfel :

SQL Code
ALTER TABLE `mybb_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Fa un backup inainte!

Users : collective term for those who use computers. Users are divided into three types : novice, intermediate and expert.
Novice users : people who are afraid that simply pressing a key might break their computer.
Intermediate users : people who don`t know how to fix their computer after they`ve just pressed a key that broke it.
Expert users : people who break other people`s computers.
#3
Scuzati de multiplu post dar ma poate ajuta cineva cu aceasta problema ? .... deja nu pot face prea multe posturi ....

Code:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1267 - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Query:
SELECT p.pid FROM mybb_posts p WHERE p.uid='1' AND p.fid='15' AND p.subject='O SĂPTĂMÂNĂ PLINĂ DE EVENIMENTE PENTRU ROMÂNI' AND p.message='



Ma poate ajuta cineva va rog ....

#4
Nu ma poate ajuta nimeni Sad ? adica sa intre ei in php my admin eu nu prea ma descurc Sad si sa modificati daca se poate nu prea pot face posturi....
#5
Pai ai incercat macar sa faci ce ti-am zis??? Sau am postat degeaba?!
Users : collective term for those who use computers. Users are divided into three types : novice, intermediate and expert.
Novice users : people who are afraid that simply pressing a key might break their computer.
Intermediate users : people who don`t know how to fix their computer after they`ve just pressed a key that broke it.
Expert users : people who break other people`s computers.
#6

Code:
Va trebui sa ai aceeasi colocare pe ambele campuri din tabel. Schimbarea colocarii pentru o tabela se poate face astfel :

SQL Code ALTER TABLE `mybb_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci


MAn eu am citit ce-ai zis dar nici macar nu stiu unde trebuie sa intru pentru asa ceva .......

#7
phpmyAdmin, alegi baza de date dupa care tabul SQL. Nu uita sa faci un backup la inceput!
Users : collective term for those who use computers. Users are divided into three types : novice, intermediate and expert.
Novice users : people who are afraid that simply pressing a key might break their computer.
Intermediate users : people who don`t know how to fix their computer after they`ve just pressed a key that broke it.
Expert users : people who break other people`s computers.
#8
Man poate vrea cineva sa intre in phpmyadmin ala poti sa`mi explici cat vrei ca tot nu inteleg cum trebe facut alegi baza de date asta de unde fac ? si tabul SQL ala ce mai ii ? daca nu poate intra cineva acolo mai bine inchideti threadu n`are rost.
#9
rezolvat t.c...


Forum Jump:


Users browsing this thread: 1 Guest(s)