Grosse erreur compte

[BakeModz 45]

[Message d'introduction]

 

Version des files : 2013

Domaine (Base de données, Core, etc.) : bdd

Votre niveau (débutant, intermédiaire, avancé) : Inter

 

Description du problème : Tous les compte ont plus de pseudo level 0, ils sont tous guerrier.

Comment reproduire le problème : 

Recherches et tests effectué : Reboot

Résultat des recherches et tests :  Non fonctionelle

 

Message d'erreur, capture d'écran :

 

 

SYSERR: Jul  2 03:59:23 :: pid_init: 

 

Start of pid: 1401

 

SYSERR: Jul  2 03:59:23 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'b.id' in 'where clause'

query: SELECT a.empire,a.pid,b.name,a.money,a.windate FROM monarch a, player  b WHERE a.pid = b.id

SYSERR: Jul  2 03:59:23 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'p1.id' in 'where clause'

query: SELECT pid1, pid2, love_point, time, is_married, p1.name, p2.name FROM marriage, player  as p1, player  as p2 WHERE p1.id = pid1 AND p2.id = pid2

SYSERR: Jul  2 03:59:57 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=22 errno: 1054)

SYSERR: Jul  2 03:59:57 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=100 errno: 1054)

SYSERR: Jul  2 04:00:56 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=385 errno: 1054)

SYSERR: Jul  2 04:01:12 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'id' in 'field list'

query: INSERT INTO player  (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, gold, playtime, skill_level, quickslot) VALUES(0, 385, 'Malika', 1, 5, 3, 3, 5, 6, 0, 0, 957371, 255076, 0, 770, 300, 0, 0, 0, 800, 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\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\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\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\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\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\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\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\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\

SYSERR: Jul  2 04:01:12 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid1=0 WHERE id=385

SYSERR: Jul  2 04:01:12 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'id' in 'where clause'

query: DELETE FROM player  WHERE id=0

SYSERR: Jul  2 04:02:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=31 errno: 1054)

SYSERR: Jul  2 04:04:04 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Jul  2 04:04:04 :: pid_deinit: 

End of pid

 

SYSERR: Jul  2 04:04:07 :: pid_init: 

Start of pid: 1499

 

SYSERR: Jul  2 04:04:07 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'b.id' in 'where clause'

query: SELECT a.empire,a.pid,b.name,a.money,a.windate FROM monarch a, player  b WHERE a.pid = b.id

SYSERR: Jul  2 04:04:07 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'p1.id' in 'where clause'

query: SELECT pid1, pid2, love_point, time, is_married, p1.name, p2.name FROM marriage, player  as p1, player  as p2 WHERE p1.id = pid1 AND p2.id = pid2

SYSERR: Jul  2 04:04:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=100 errno: 1054)

SYSERR: Jul  2 04:04:32 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=22 errno: 1054)

SYSERR: Jul  2 04:06:01 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=302 errno: 1054)

SYSERR: Jul  2 04:06:08 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=302 errno: 1054)

SYSERR: Jul  2 04:06:08 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,level,level_step,st,ht,dx,iq,exp,stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair,skill_level,quickslot,skill_group,alignment,mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point FROM player  WHERE id=193 errno: 1054)

SYSERR: Jul  2 04:06:09 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

SYSERR: Jul  2 04:10:37 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=385 errno: 1054)

SYSERR: Jul  2 04:10:38 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Jul  2 04:10:38 :: pid_deinit: 

End of pid

 

SYSERR: Jul  2 04:10:41 :: pid_init: 

Start of pid: 1569

 

SYSERR: Jul  2 04:10:41 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'b.id' in 'where clause'

query: SELECT a.empire,a.pid,b.name,a.money,a.windate FROM monarch a, player  b WHERE a.pid = b.id

SYSERR: Jul  2 04:10:41 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'p1.id' in 'where clause'

query: SELECT pid1, pid2, love_point, time, is_married, p1.name, p2.name FROM marriage, player  as p1, player  as p2 WHERE p1.id = pid1 AND p2.id = pid2

SYSERR: Jul  2 04:11:01 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=100 errno: 1054)

SYSERR: Jul  2 04:11:08 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=380 errno: 1054)

SYSERR: Jul  2 04:11:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=380 errno: 1054)

SYSERR: Jul  2 04:11:15 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,level,level_step,st,ht,dx,iq,exp,stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair,skill_level,quickslot,skill_group,alignment,mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point FROM player  WHERE id=236 errno: 1054)

SYSERR: Jul  2 04:11:15 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

SYSERR: Jul  2 04:11:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player  WHERE account_id=100 errno: 1054)

SYSERR: Jul  2 04:11:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'id' in 'field list' (query: SELECT id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,level,level_step,st,ht,dx,iq,exp,stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair,skill_level,quickslot,skill_group,alignment,mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point FROM player  WHERE id=33 errno: 1054)

SYSERR: Jul  2 04:11:25 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

 

 

 

 

En postant ma demande d'aide, j'affirme avoir lu et accepté le règlement des demandes d'aides.

[Galet 473]

Enlève ces joueurs de player_index