Player storege, not saving char

[XouruS]

no clue how to fix this..

[5:8:03.281] mysql_real_query(): INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (14,'','0'),(14,'0','0'),(14,'1000','0'),(14,'1002','0'),(14,'1003','0'),(14,'1004','0'),(14,'1005','0'),(14,'1006','0'),(14,'1007','0'),(14,'1008','0'),(14,'1010','0'),(14,'1011','0'),(14,'1012','0'),(14,'1014','0'),(14,'1015','0'),(14,'1016','0'),(14,'12346','1'),(14,'30001','1') - MYSQL ERROR: Duplicate entry '14-0' for key 'player_id_2' (1062)
[5:8:03.282] Error while saving player: Syllwoo.
[5:8:04.232] Syllwoo has logged in.

char spawns in same place where it dies and souch


SOLVED

 

[jss]

It has to do with mysql entry key, i think u should create a backup for your database or smt like that..

 

[XouruS]

for now, il try makin a new database


edit: still messed up

 

[jss]

hmmm try from database drop everything from the following tables:

admin_activity_log
banners_history
counter_history
sessions

your error is strange and unknown i mean this is the first time i see this...

 

[XouruS]

hmmm try from database drop everything from the following tables:

admin_activity_log
banners_history
counter_history
sessions

your error is strange and unknown i mean this is the first time i see this...

dont have any of these bro, 8.60

 

[jss]

well all i can do is bump for ya!

 

[XouruS]

Bump

 

[Cykotitan]

while ingame, erase the player's storages with keys '' (empty string) and optionally 0, and prevent the players from getting the those storage keys in the first place

 

[XouruS]

K, il try in few hrs

 

[XouruS]

no change..

 

[jajo297]

I have the same problem of TFS ^^, maybe MYSQL isn't starting correctly? Did you use UniServer? Xampp? Other?

 

[Cykotitan]

you were supposed to locate the scripts that set those storages and do something about them

 

[XouruS]

cant find them anywhere


edit :disabled some stuff that may have caused it/ new error

[4:25:08.844] mysql_real_query(): SELECT `key`, `value` FROM `player_storage` WHERE `player_id` = 11 - MYSQL ERROR: Unknown column 'key' in 'field list' (1054)

 

[Cykotitan]

enjoy having no storages now

 

[XouruS]

enjoy having no storages now

some1 told me to delete the keys

 

[XouruS]

solved/

 

[Herpicus]

enjoy having no storages now

E what is this scam! My avatar half the size and quality!

 

[Cykotitan]

E what is this scam! My avatar half the size and quality!

higher quality, but suffering from limits imposed by admins on regulars