Pagalbos (Mysql)

[Incognito.]

taigi susirisau moda su mysql susikuriau sql prisiregostruoju atsijungiu ir reikia per naujo registruotis gali registruotis su tuo paciu nick nors sql faile jis jau yra.

[GuitarHero]

Tikriausiai problema tikrinimo uzklausoje, parodyk MySQL log'a.

[Incognito.]

[20] >> mysql_connect( )

[20] CMySQLHandler::CMySQLHandler() - constructor called.

[20] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sasa" | Username: "root" ...

[20] CMySQLHandler::Connect() - Connection was successful.

[20] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[20] >> mysql_ping( Connection handle: 1 )

[20] CMySQLHandler::Ping() - Connection is still alive.

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `banai` WHERE IP = '127.0.0.1') - An error has occured. (Error ID: 1146, Table 'sasa.banai' doesn't exist)

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `banai` WHERE Vardas = 'Jack_Night') - An error has occured. (Error ID: 1146, Table 'sasa.banai' doesn't exist)

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT id FROM `users` WHERE vardas = 'Jack_Night') - An error has occured. (Error ID: 1054, Unknown column 'id' in 'field list')

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(INSERT INTO `users` (vardas,slaptazodis) VALUES ('Jack_Night', ( 'a' ))) - Successfully executed.

[20] >> mysql_insert_id( Connection handle: 1 )

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE id = 0) - An error has occured. (Error ID: 1054, Unknown column 'id' in 'where clause')

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE `vardas` = 'Jack_Night' AND `slaptazodis` = ( 'a' )) - Successfully executed.

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - Result was stored.

[20] >> mysql_num_rows( Connection handle: 1 )

[20] CMySQLHandler::NumRows() - Returned 1 row(s)

[20] >> mysql_retrieve_row( Connection handle: 1 )

[20] >> mysql_fetch_field_row( Connection handle: 1 )

[20] CMySQLHandler::FetchField("Xp") -

[20] >> mysql_fetch_field_row( Connection handle: 1 )

[20] CMySQLHandler::FetchField("Admin") -

[20] >> mysql_fetch_field_row( Connection handle: 1 )

[20] CMySQLHandler::FetchField("Superadmin") -

[20] >> mysql_fetch_field_row( Connection handle: 1 )

[20] CMySQLHandler::FetchField("Vip") -

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE vardas = 'Jack_Night') - Successfully executed.

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - Result was stored.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - Return: Jack_Night|a|0|0

[20] >> mysql_fetch_field_row( Connection handle: 1 )

[20] CMySQLHandler::FetchField("Xp") -

[20]

[20] ---------------------------

[20] MySQL Debugging activated (02/27/12)

[20] ---------------------------

[20]

[20] >> mysql_connect( )

[20] CMySQLHandler::CMySQLHandler() - constructor called.

[20] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sasa" | Username: "root" ...

[20] CMySQLHandler::Connect() - Connection was successful.

[20] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[20] >> mysql_ping( Connection handle: 1 )

[20] CMySQLHandler::Ping() - Connection is still alive.

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `banai` WHERE IP = '127.0.0.1') - An error has occured. (Error ID: 1146, Table 'sasa.banai' doesn't exist)

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `banai` WHERE Vardas = 'Jack_Night') - An error has occured. (Error ID: 1146, Table 'sasa.banai' doesn't exist)

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT id FROM `users` WHERE vardas = 'Jack_Night') - An error has occured. (Error ID: 1054, Unknown column 'id' in 'field list')

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(INSERT INTO `users` (vardas,slaptazodis) VALUES ('Jack_Night', ( 'a' ))) - Successfully executed.

[20] >> mysql_insert_id( Connection handle: 1 )

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE id = 0) - An error has occured. (Error ID: 1054, Unknown column 'id' in 'where clause')

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE `vardas` = 'Jack_Night' AND `slaptazodis` = ( 'a' )) - Successfully executed.

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - Result was stored.

[20] >> mysql_num_rows( Connection handle: 1 )

[20] CMySQLHandler::NumRows() - Returned 2 row(s)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE id = 0) - An error has occured. (Error ID: 1054, Unknown column 'id' in 'where clause')

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE `vardas` = 'Jack_Night' AND `slaptazodis` = ( 'a' )) - Successfully executed.

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - Result was stored.

[20] >> mysql_num_rows( Connection handle: 1 )

[20] CMySQLHandler::NumRows() - Returned 2 row(s)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE id = 0) - An error has occured. (Error ID: 1054, Unknown column 'id' in 'where clause')

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - No data to store.

[20] >> mysql_fetch_row_format( Connection handle: 1 )

[20] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[20] >> mysql_query( Connection handle: 1 )

[20] CMySQLHandler::Query(SELECT * FROM `users` WHERE `vardas` = 'Jack_Night' AND `slaptazodis` = ( 'a' )) - Successfully executed.

[20] >> mysql_store_result( Connection handle: 1 )

[20] CMySQLHandler::StoreResult() - Result was stored.

[20] >> mysql_num_rows( Connection handle: 1 )

[20] CMySQLHandler::NumRows() - Returned 2 row(s)

[20]

[GuitarHero]

Per phpMyAdmin susikurk banai lentele ir users lenteleje pridek id stulpeli.

-- Papildyta --

Per phpMyAdmin susikurk banai lentele ir users lenteleje pridek id stulpeli.

[Incognito.]

PRIMARY KEY (`id`)

Šitas?

[GuitarHero]

Tiesiog sukurk stulpeli pavadinimu id, int tipo su auto increcement.

[Incognito.]

Ačiu. Gauni repa.