• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Error Database

Lipezito

New Member
Joined
Mar 10, 2016
Messages
9
Reaction score
0
How i fix this?

[Error - mysql_store_result] Query: SELECT `id`, `name`, `account_id`, `group_id
`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`,
`blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lo
okhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `l
astlogin`, `lastlogout`, `lastip`, `conditions`, `skulltime`, `skull`, `town_id`
, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `prey_s
tamina_1`, `prey_stamina_2`, `prey_stamina_3`, `skill_fist`, `skill_fist_tries`,
`skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_ax
e`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `ski
ll_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `skill_critical_hit
_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill
_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance
_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana
_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `sk
ill_mana_leech_amount_tries`, `xpboost_stamina`, `xpboost_value` FROM `players`
WHERE `name` = 'GOD Spock'
Message: Unknown column 'prey_stamina_1' in 'field list'

I try use
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_damage` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_damage_tries` bigint(20) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_life_leech_chance` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_life_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_life_leech_amount` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_life_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_chance` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_amount` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT 0;
 
ALTER TABLE `players` ADD COLUMN `prey_stamina_1` int(10) DEFAULT 0;
How i can give you a kiss? <3
Thank you, itworks
sorry for my bad english
Now, how i fix this ?

Message: Table 'ot.player_prey' doesn't exist
[Error - mysql_real_query] Query: INSERT INTO player_prey SET player_id = 1716,
name = 'shiversleep', mindex = 8, mcolumn = 0
Message: Table 'ot.player_prey' doesn't exist
 
Last edited:
You are definitely doing something wrong. Are you following some guide on implementing pray system?

Basically this error means there isn't a table 'ot.player_pray' in your mysql db. You likely missed some step that creates those tables, and alters existing.
 
Back
Top