• 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!

Errors in web [PHP] [Gesior]

Imfreezing

Imfreezing

Krossa Kapitalismen
Joined
Jun 7, 2012
Messages
1,009
Solutions
1
Reaction score
88
Location
Edron
i get this error when trying to enter account management
Code: 
Query:    SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'pierre'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `bans`.`id`, `bans`.`type`, `bans`.`value`, `bans`.`param`, `bans`.`active`, `bans`.`expires`, `bans`.`added`, `bans`.`admin_id`, `bans`.`comment` FROM `bans` WHERE `type` = '3' AND `value` = '17' AND `active` = '1'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `players`.`id`, `players`.`name`, `players`.`world_id`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`rank_id`, `players`.`guildnick`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`direction`, `players`.`loss_experience`, `players`.`loss_mana`, `players`.`loss_skills`, `players`.`loss_containers`, `players`.`loss_items`, `players`.`premend`, `players`.`online`, `players`.`marriage`, `players`.`promotion`, `players`.`deleted`, `players`.`description`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '17' ORDER BY `name` ASC
SQLSTATE:    42S22
Driver code:    1054
Error message:    Unknown column 'players.loss_experience' in 'field list'

Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\classes\databaselist.php on line 68
 
Sort by date Sort by votes
kamilwxx said:
Here you go (you have to execute this query in your database)
Code: 
ALTER TABLE `players` ADD `loss_experience` INT NOT NULL DEFAULT 100;
Click to expand...
it did execute but
Code: 
Query:    SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = '85212364'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `bans`.`id`, `bans`.`type`, `bans`.`value`, `bans`.`param`, `bans`.`active`, `bans`.`expires`, `bans`.`added`, `bans`.`admin_id`, `bans`.`comment` FROM `bans` WHERE `type` = '3' AND `value` = '16' AND `active` = '1'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `players`.`id`, `players`.`name`, `players`.`world_id`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`rank_id`, `players`.`guildnick`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`direction`, `players`.`loss_experience`, `players`.`loss_mana`, `players`.`loss_skills`, `players`.`loss_containers`, `players`.`loss_items`, `players`.`premend`, `players`.`online`, `players`.`marriage`, `players`.`promotion`, `players`.`deleted`, `players`.`description`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '16' ORDER BY `name` ASC
SQLSTATE:    42S22
Driver code:    1054
Error message:    Unknown column 'players.loss_mana' in 'field list'

Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\classes\databaselist.php on line 68
 
Upvote 0 Downvote
Query: SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = '1'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `bans`.`id`, `bans`.`type`, `bans`.`value`, `bans`.`param`, `bans`.`active`, `bans`.`expires`, `bans`.`added`, `bans`.`admin_id`, `bans`.`comment` FROM `bans` WHERE `type` = '3' AND `value` = '18' AND `active` = '1'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `players`.`id`, `players`.`name`, `players`.`world_id`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`rank_id`, `players`.`guildnick`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`direction`, `players`.`loss_experience`, `players`.`loss_mana`, `players`.`loss_skills`, `players`.`loss_containers`, `players`.`loss_items`, `players`.`premend`, `players`.`online`, `players`.`marriage`, `players`.`promotion`, `players`.`deleted`, `players`.`description`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '18' ORDER BY `name` ASC
SQLSTATE: 42S22
Driver code: 1054
Error message: Unknown column 'players.loss_skills' in 'field list'

Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\classes\databaselist.php on line 68
 
Upvote 0 Downvote
Each message gave you a different error:
1)Error message: Unknown column 'players.loss_experience' in 'field list'
2)Error message: Unknown column 'players.loss_mana' in 'field list'
3)Error message: Unknown column 'players.loss_skills' in 'field list'

Do the same thing for them all, i'd think.
Code: 
ALTER TABLE `players` ADD `loss_experience` INT NOT NULL DEFAULT 100;
Code: 
ALTER TABLE `players` ADD `loss_mana` INT NOT NULL DEFAULT 100;
Code: 
ALTER TABLE `players` ADD `loss_skills` INT NOT NULL DEFAULT 100;
 
Upvote 0 Downvote
Cadyan said:
Each message gave you a different error:
1)Error message: Unknown column 'players.loss_experience' in 'field list'
2)Error message: Unknown column 'players.loss_mana' in 'field list'
3)Error message: Unknown column 'players.loss_skills' in 'field list'

Do the same thing for them all, i'd think.
Code: 
ALTER TABLE `players` ADD `loss_experience` INT NOT NULL DEFAULT 100;
Code: 
ALTER TABLE `players` ADD `loss_mana` INT NOT NULL DEFAULT 100;
Code: 
ALTER TABLE `players` ADD `loss_skills` INT NOT NULL DEFAULT 100;
Click to expand...
i have the same error when i try to past any code from your codes i got this
#1060 - Duplicate column name 'loss_skills'
 
Upvote 0 Downvote
3mR said:
i have the same error when i try to past any code from your codes i got this
#1060 - Duplicate column name 'loss_skills'
Click to expand...
You get this error because column "loss_skills" already exists in the database, which means you won't need to add that to the database again.
 
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
230
WikiArk21
WikiArk21
abdala ragab
  • Question
TFS 1.X+ ban script error tfs 1.2
2
Replies
35
Views
1K
DevRuby
DevRuby
Shoorkill
  • Question
AAC gesior creates an account, but when selecting a character in the game he receives an account error or wrong password.
Replies
2
Views
290
Shoorkill
Shoorkill
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
2
Views
282
ShadowProwl
ShadowProwl
F
  • Question
TFS 1.X+ IOLoginData::loginserverAuthentication
Replies
10
Views
815
ForgottenNot
F
OTcreator
  • Question
MyACC [ONI TEMPLATE] Outfit on TOP5.
Replies
1
Views
361
Addams
Addams
E
  • Solved
TFS 1.X+ [Error - mysql_store_result] Query: SELECT 'QuestPoints' FROM 'players' WHERE 'id' =8
Replies
2
Views
286
Erna
E
D
  • Question
Summon not coming back
Replies
3
Views
263
jimmywest10
J
Back
Top