[ihatetn931]

I have solved this

[RichyB]

Does the other things save correctly?

I am new to MySQL, but I can help diagnose problems.

[ihatetn931]

Quote:

Originally Posted by RichyB Does the other things save correctly? I am new to MySQL, but I can help diagnose problems.

Nothing saves to the database but the player name and the password, Everything esle gets set to zeros and floats are set to nothing

[[HiC]TheKiller]

At the top of your script put

pawn Код:

mysql_debug(1);

Then tell me if errors come up in you sa-mp directory in the MySQL log.

[ihatetn931]

I'm using strickens mysql plugin, I don't belive it has a debug function

When i add it i get this

Код:

\\SERVER\sa-mp server\gamemodes\SWRP.pwn(23) : error 010: invalid function or declaration

Edit nevermind there is
mysql_log

[RichyB]

I don't see what is wrong in that part.
All looks good.
It must be something else.
When are you saving the account?

[[HiC]TheKiller]

It's mysql_log for StrickenKids plugin

pawn Код:

mysql_log(LOG_ONLY_ERRORS);

And tell me what happens.

[ihatetn931]

Here is the mysql_log

Код:

[07/16/10 08:09:55] ----------------------------------------------

[07/16/10 08:09:55] MySQL logging enabled. Logging all actions.

[07/16/10 08:09:55] ----------------------------------------------

[07/16/10 08:10:06] Function: 'mysql_real_escape_string' called with result: "Shadow_Testing".

[07/16/10 08:10:06] Function: 'mysql_query' executed: "SELECT `id` FROM `players` WHERE `Username` = 'Shadow_Testing'" with result: "0".

[07/16/10 08:10:06] Function: 'mysql_num_rows' called with result: "0".

[07/16/10 08:10:09] Function: 'mysql_real_escape_string' called with result: "Shadow_Testing".

[07/16/10 08:10:09] Function: 'mysql_real_escape_string' called with result: "password".

[07/16/10 08:10:09] Function: 'mysql_query' executed: "INSERT INTO `players` (Username, Password) VALUES('Shadow_Testing', 'password')" with result: "0".

[07/16/10 08:10:11] Function: 'mysql_real_escape_string' called with result: "28".

[07/16/10 08:10:11] Function: 'mysql_query' executed: "UPDATE `players` SET `Age` = '50' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:14] Function: 'mysql_real_escape_string' called with result: "Atheist".

[07/16/10 08:10:14] Function: 'mysql_query' executed: "UPDATE `players` SET `Religon` = 'Atheist' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:16] Function: 'mysql_real_escape_string' called with result: "".

[07/16/10 08:10:16] Function: 'mysql_query' executed: "UPDATE `players` SET `Spawn` = '' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:19] Function: 'mysql_query' executed: "SELECT * FROM `players` WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' could not find field: 'id'..

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:19] Error (0): Function: 'mysql_fetch_field' called when no result stored.

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Age` = '0', `Religon` = '0', `Tut` = '0', `Reg` = '999' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`LeftWorld` = '0' WHERE `id` = '0'' at line 1.

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Cash` = '500', `Skin` = '0', `Admin` = '0', `Mod` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Faction` = '255', `Rank` = '255', `WantedLevel` = '0', `Jailed` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `JailTime` = '0', `Health` = '50.000000', `Armour` = '0.000000', `Hours` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `PayCheck` = '0', `AllowedPayday` = '0', `Bank` = '1500', `Level` = '1' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Carlic` = '0', `Fighting` = '', `LockerM` = '0', `Card` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `CardM` = '0', `9mm` = '0', `Deagle` = '0', `Shotgun` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `MSMSG` = '0', `Ak` = '0', `Country` = '0', `ALocked` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `CK` = '0', `Weaplic` = '0', `FishLic` = '0', `Fishes` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `WeedSeeds` = '0', `Weed` = '0', `CokeSeeds` = '0', `Coke` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `LSD` = '0', `GotArmour` = '0', `Phone` = '0', `PhoneNumber` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `PhoneCard` = '255', `Contact` = '0', `Biz1` = '999', `Biz2` = '999' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `GPS` = '0', `PhoneB` = '0', `Laptop` = '0', `Virus` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `AntiVirus` = '0', `PMIN` = '0', `Spawn` = '0', `Crashed` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Walk` = '0', `Sex` = '0', `Job` = '0', `Outfit1` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Outfit2` = '0', `Outfit3` = '0', `Shovel` = '0', `Knife` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Baseball` = '0', `Bombs` = '0', `BombMats` = '0', `AJailed` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Watch` = '0', `Mats` = '0', `M4` = '0', `Sniper` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Sawn` = '0', `Flame` = '0', `Dead` = '0', `VIP` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `House1` = '0', `House2` = '0', `Rent` = '0', `Gun1` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Gun2` = '0', `Gun3` = '0', `Gun4` = '0', `Gun5` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Gun6` = '0', `Gun7` = '0', `Gun8` = '0', `Gun9` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Gun10` = '0', `Gun11` = '0', `Gun12` = '0', `Ammo1` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Ammo2` = '0', `Ammo3` = '0', `Ammo4` = '0', `Ammo5` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Ammo6` = '0', `Ammo7` = '0', `Ammo8` = '0', `Ammo9` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Ammo10` = '0', `Ammo11` = '0', `Ammo12` = '0', `Mask` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Prison` = '0', `PrisonTime` = '0', `LGun1` = '0', `LAmmo1` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `LGun2` = '0', `LAmmo2` = '0', `LGun3` = '0', `LAmmo3` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Cigars` = '0', `TimesSmoked` = '0', `Disease` = '0', `Spray` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Battery` = '0', `Bug` = '0', `Int` = '0', `Local` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Exp` = '0', `Days` = '0', `pMins` = '0', `Flyinglic` = '0' WHERE `id` = '0'" with result: "0".

[07/16/10 08:10:53] Function: 'mysql_query' executed: "UPDATE `players` SET `Carkey1` = '0', `Carkey2` = '0', `Carkey3` = '0' WHERE `id` = '0'" with result: "0".

I did log all just incase

[ihatetn931]

I still can't figure out the issue please help if you don't mind