Eroare mysql ..

[Sereja]

Am pornit un GM luat de pe net pentru un test, dar după ce scriu parola la intrare spune ca nu corespunde cu numele .. asta e logul din mysql: 

 

[03:54:33] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM users WHERE `name`='Cheloo_'", use_cache: true

[03:54:33] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:33] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 2.794 milliseconds

[03:54:33] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:33] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 11)

[03:54:33] [DEBUG] cache_get_row_count - connection: 1

[03:54:36] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `users` WHERE `Banned` = '1'", use_cache: true

[03:54:36] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:36] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.966 milliseconds

[03:54:36] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:36] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 12)

[03:54:36] [DEBUG] cache_get_row_count - connection: 1

[03:54:36] [DEBUG] cache_delete - cache_id: 12, connection: 1

[03:54:36] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:54:36] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted

[03:54:36] [DEBUG] mysql_query - connection: 1, query: "SELECT `name` FROM `users`", use_cache: true

[03:54:36] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:36] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.460 milliseconds

[03:54:36] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:36] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 12)

[03:54:36] [DEBUG] cache_get_row_count - connection: 1

[03:54:36] [DEBUG] cache_get_field_content - row: -1, field_name: "name", connection: 1, max_len: 25

[03:54:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('-1')

[03:54:36] [DEBUG] cache_delete - cache_id: 12, connection: 1

[03:54:36] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:54:36] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted

[03:54:39] [DEBUG] mysql_escape_string - source: "ionuthusi", connection: 1, max_len: 64

[03:54:39] [DEBUG] mysql_query - connection: 1, query: "INSERT INTO `users` (`name`,`password`) VALUES ('Cheloo_','ionut", use_cache: true

[03:54:39] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:39] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'CChar' doesn't have a default value

[03:54:39] [DEBUG] mysql_query - connection: 1, query: "UPDATE users SET `pHealth`='-1.0' WHERE `name`='Cheloo_'", use_cache: true

[03:54:39] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:39] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.592 milliseconds

[03:54:39] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:39] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 12)

[03:54:41] [DEBUG] mysql_escape_string - source: "ionuthusi", connection: 1, max_len: 64

[03:54:41] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM users WHERE `name`='Cheloo_' AND `password`='ionut", use_cache: true

[03:54:41] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:41] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.884 milliseconds

[03:54:41] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:41] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 13)

[03:54:41] [DEBUG] cache_get_row_count - connection: 1

[03:54:46] [DEBUG] mysql_escape_string - source: "ionuthusi", connection: 1, max_len: 64

[03:54:46] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM users WHERE `name`='Cheloo_' AND `password`='ionut", use_cache: true

[03:54:46] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:46] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.831 milliseconds

[03:54:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:46] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 14)

[03:54:46] [DEBUG] cache_get_row_count - connection: 1

[03:54:52] [DEBUG] mysql_escape_string - source: "ionuthusi", connection: 1, max_len: 64

[03:54:52] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM users WHERE `name`='Cheloo_' AND `password`='ionut", use_cache: true

[03:54:52] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:52] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.888 milliseconds

[03:54:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:52] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 15)

[03:54:52] [DEBUG] cache_get_row_count - connection: 1

[03:54:52] [DEBUG] mysql_query - connection: 1, query: "UPDATE `users` SET `Status` = '0' WHERE `name` = 'Cheloo_'", use_cache: true

[03:54:52] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:52] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.630 milliseconds

[03:54:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:52] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 16)

[03:54:52] [DEBUG] mysql_query - connection: 1, query: "UPDATE users SET `lastOn`='04.08.2016 03:54' WHERE `name`='Chelo", use_cache: true

[03:54:52] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:54:52] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.538 milliseconds

[03:54:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:54:52] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 17)

[03:55:17] [DEBUG] mysql_query - connection: 1, query: "UPDATE `users` SET `Status` = '0' WHERE `Status` = '1'", use_cache: true

[03:55:17] [DEBUG] CMySQLQuery::Execute - starting query execution

[03:55:17] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.484 milliseconds

[03:55:17] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[03:55:17] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 18)

[03:55:17] [DEBUG] mysql_close - connection: 1

[03:55:17] [DEBUG] CMySQLConnection::Disconnect - connection was closed

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[03:55:17] [DEBUG] CMySQLConnection::Disconnect - connection was closed

[03:55:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

 

 

Ma poate ajuta cineva.. ? Raman dator .. 

[zguNNy]

Nu e conectata bine baza de date

SQL = mysql_connect("localhost","root","baza de date","");

//Syntax: IP - NUME UTILIZATOR - NUME BAZA DE DATE - PAROLA BAZA DE DATA

[Sereja]

Vad ca nu e de la asta .. Totul e facut exact cum ai spus .. Cand intru spune ca nu se potriveste parola ..