SQL Error

[avguste]

Hey guys

I am having a small SQL error on admin panel:

General Error

Couldn't update monster info

DEBUG MODE

SQL Error : 1054 Unknown column 'monster_fight_opponent' in 'field list'

UPDATE phpbb_adr_battle_monsters SET monster_name = 'Quicksand', monster_img = 'Quicksand.gif', monster_level = 1 , monster_base_hp = 16 , monster_base_def = 69 , monster_base_att = 61 , monster_base_element = 5 , monster_base_magic_attack = 17 , monster_base_magic_resistance = 25 , monster_base_mp = 18 , monster_base_mp_power = 4 , monster_base_sp = 28 , monster_fight_opponent = '' , monster_fights = 0 , monster_fight_duration = 0 , monster_thief_skill = 5 , monster_possible_drop = 0, monster_guranteened_drop = 0, monster_loottables = '', monster_specific_drop = '', monster_season = 0, monster_weather = 0, monster_message_enable = 0, monster_message = '', monster_base_custom_spell = 'a magical spell' WHERE monster_id = 65

Line : 536
File : admin_adr_monsters.php

 

Could someone help me with this?

Thanks

[Mcfarlin]

General Error Couldn't update monster info DEBUG MODE SQL Error : 1054 Unknown column 'monster_fight_opponent' in 'field list' UPDATE phpbb_adr_battle_monsters SET monster_name = 'Quicksand', monster_img = 'Quicksand.gif', monster_level = 1 , monster_base_hp = 16 , monster_base_def = 69 , monster_base_att = 61 , monster_base_element = 5 , monster_base_magic_attack = 17 , monster_base_magic_resistance = 25 , monster_base_mp = 18 , monster_base_mp_power = 4 , monster_base_sp = 28 , monster_fight_opponent = '' , monster_fights = 0 , monster_fight_duration = 0 , monster_thief_skill = 5 , monster_possible_drop = 0, monster_guranteened_drop = 0, monster_loottables = '', monster_specific_drop = '', monster_season = 0, monster_weather = 0, monster_message_enable = 0, monster_message = '', monster_base_custom_spell = 'a magical spell' WHERE monster_id = 65 Line : 536 File : admin_adr_monsters.php

well first thing i would go look at is my table, 'field list' where your trying to update this information and see that i have added 'monster_fight_opponent' to it.

Then might want to check the count as well so as they are matching fields and input variables.

[avguste]

I dont see anywhere the "field list" table, not sure....

[Mcfarlin]

well what is it that monster_fight_opponent does?

if you do not have it in there you will have to either add it to the table or delete it from the line you have entering it into the table.

i have no idea what it does for you so i cant say either way what you should do, but id prolly run the SQL and just add it to the table.

[Joshua]

in this table

phpbb_adr_battle_monsters

 

Add this Column

 

monster_fight_opponent