Erreur DB

Bonjour/Bonsoir
Quelqu'un aurais la gentillesse de corriger cela s'il vous plait (en forme de script) ? Car je n'y arrive pas. Merci beaucoup

Citation :2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024170 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024174 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024173 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024171 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024172 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024161 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024162 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024158 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024155 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024156 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024157 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024145 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024146 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024147 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024148 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024149 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024150 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024151 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024152 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024153 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024154 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024144 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024136 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024137 Entry: 22898) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024138 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024139 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024140 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024141 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024142 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024143 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024166 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024165 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024159 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024160 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024167 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024163 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024164 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024168 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:51 Table `creature` have creature (GUID: 1024169 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024175 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024176 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024177 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024178 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024179 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024180 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024181 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024182 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024183 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024184 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024185 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024186 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024187 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:52 Table `creature` have creature (GUID: 1024188 Entry: 11982) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2011-12-31 19:09:56 Table 'creature_loot_template' entry 28923 (creature entry) not exist but used as loot id in DB.
2011-12-31 19:09:56 Table 'creature_loot_template' entry 28923 (creature entry) not exist but used as loot id in DB.
2011-12-31 19:09:58 Table 'reference_loot_template' entry 35043 isn't reference id and not referenced from loot, and then useless.
2011-12-31 19:09:59 SourceGroup 28923 in `condition` table, does not exist in `creature_loot_template`, ignoring.
2011-12-31 19:09:59 SourceGroup 28923 in `condition` table, does not exist in `creature_loot_template`, ignoring.
2011-12-31 19:10:00 SmartAIMgr::LoadSmartAIFromDB: Creature guid (68293) does not exist, skipped loading.
2011-12-31 19:10:00 SmartAIMgr::LoadSmartAIFromDB: Creature guid (68293) does not exist, skipped loading.

Merci beaucoup !!

Ce ne sont pas des erreurs mais des warnings, donc sans aucune incidence en jeu, du moins, dans ce cas-là.

Le PNJ 11982 est dans une instance normalement, hors, tu l'as placé dans une zone non-instancié, ce qui provoque les warnings.

Pour retirer ces warnings, tu dois modifier toutes les PNJ (id:11982) en retirant le flag dans la table creature_template.

[code=sql]UPDATE `creature_template` SET `flags_extra` = 0 WHERE `entry` IN (11982, 22898);[/code]
Cette requête retirera les warnings, je ne donne cependant aucune garantie quant à l'utilisation du PNJ en jeu, si il a un flag particulier, il a ses raisons !

Cordialement,
MacWarrior.

Que dois-je faire la ?

Citation :2012-01-01 13:13:27 SmartAIMgr::LoadSmartAIFromDB: Creature guid (68293) does not exist, skipped loading.
2012-01-01 13:13:27 SmartAIMgr::LoadSmartAIFromDB: Creature guid (68293) does not exist, skipped loading.

Merci

C'est des warning !!! ...
Ne t’embêtes pas à tous les corriger, ig cela ne change rien

D'accord mais je préfère ne pas les voirs x)

Fermes les yeux !