MYSQL PROBLEM
#6

DEBUG REPORT

PHP код:
[23:11:36] >> mysql_queryConnection handle)
[
23:11:36CMySQLHandler::Query(SELECT `IPFROM `playerdataWHERE `user` = 'Danyal' LIMIT 1) - Successfully executed.
[
23:11:36] >> mysql_store_resultConnection handle)
[
23:11:36CMySQLHandler::StoreResult() - Result was stored.
[
23:11:36] >> mysql_num_rowsConnection handle)
[
23:11:36CMySQLHandler::NumRows() - Returned 0 row(s)
[
23:11:36] >> mysql_free_resultConnection handle)
[
23:11:36CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:11:38] >> mysql_real_escape_string( Connection handle: 1 )
[23:11:38] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
[23:11:38] >> mysql_query( Connection handle: 1 )
[23:11:38] CMySQLHandler::Query(INSERT INTO playerdata (user, password, DriftingPoints, Cash, VipLevel, AdminLevel, Kills, Deaths, Locked, Number, Wanted, Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Gun7, Gun8, Gun9, Gun10, Gun11, Gun12, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, Ammo7, Ammo8, Ammo9, Ammo10, Ammo11, Ammo12, IP) VALUES('
Danyal', SHA1('123456'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Not Banned')) - An error has occured. (Error ID: 1036, Table 'playerdata' is read only)
[23:12:00] >> mysql_query( Connection handle: 1 )
[23:12:00] CMySQLHandler::Query(UPDATE playerdata SET DriftingPoints=0, Cash=0, VipLevel=0, AdminLevel=0, Kills=0, Deaths=0, Locked=0, Number=0, Wanted=0, Gun1=0, Gun2=0, Gun3=0, Gun4=0, Gun5=0, Gun6=0, Gun7=0, Gun8=0, Gun9=0, Gun10=0, Gun11=0, Gun12=0, Ammo1=0, Ammo2=0, Ammo3=0, Ammo4=0, Ammo5=0, Ammo6=0, Ammo7=0, Ammo8=0, Ammo9=0, Ammo10=0, Ammo11=0, Ammo12=0/*posx=0.000000, posy=0.000000, posz=0.000000, posa=*/  WHERE user='') - Successfully executed.
[23:12:22] >> mysql_query( Connection handle: 1 )
[23:12:22] CMySQLHandler::Query(SELECT `IP` FROM `playerdata` WHERE `user` = '
Danyal' LIMIT 1) - Successfully executed.
[23:12:22] >> mysql_store_result( Connection handle: 1 )
[23:12:22] CMySQLHandler::StoreResult() - Result was stored.
[23:12:22] >> mysql_num_rows( Connection handle: 1 )
[23:12:22] CMySQLHandler::NumRows() - Returned 0 row(s)
[23:12:22] >> mysql_free_result( Connection handle: 1 )
[23:12:22] CMySQLHandler::FreeResult() - Result was successfully free'
d.
[
23:12:32] >> mysql_real_escape_stringConnection handle)
[
23:12:32CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
[23:12:32] >> mysql_queryConnection handle)
[
23:12:32CMySQLHandler::Query(INSERT INTO playerdata (userpasswordDriftingPointsCashVipLevelAdminLevelKillsDeathsLockedNumberWantedGun1Gun2Gun3Gun4Gun5Gun6Gun7Gun8Gun9Gun10Gun11Gun12Ammo1Ammo2Ammo3Ammo4Ammo5Ammo6Ammo7Ammo8Ammo9Ammo10Ammo11Ammo12IPVALUES('Danyal'SHA1('123456'), 000000000000000000000000000000000'Not Banned')) - An error has occured. (Error ID1036Table 'playerdata' is read only
I solved that problem but now player data isn't saved in DATABASE
Reply


Messages In This Thread
MYSQL PROBLEM - by Danyal - 11.02.2012, 15:58
Re: MYSQL PROBLEM - by Scenario - 11.02.2012, 15:59
Re: MYSQL PROBLEM - by KingHual - 11.02.2012, 16:02
Re: MYSQL PROBLEM - by [MG]Dimi - 11.02.2012, 16:03
Re: MYSQL PROBLEM - by Vince - 11.02.2012, 16:09
Re: MYSQL PROBLEM - by Danyal - 11.02.2012, 17:13
Re: MYSQL PROBLEM - by Scenario - 11.02.2012, 17:43

Forum Jump:


Users browsing this thread: 2 Guest(s)