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

Help making a table! that saves characters! please

simson361

simson361

The Grim Reaper
Joined
Aug 4, 2010
Messages
626
Reaction score
27
Location
sweden
PROBLEM 1
Code: 
[01/02/2014 02:55:04] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:55:05] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 1 AND `type` = 3 AND `active` = 1 AND (`expires` > 1391219705 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:55:06] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:55:06] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 1 AND `type` = 3 AND `active` = 1 AND (`expires` > 1391219706 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:55:08] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268459948 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1391219708 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:55:08] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 1 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:55:10] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 1 ORDER BY `sid` DESC - MYSQL ERROR: Table 'tibiaot.player_depotitems' doesn't exist (1146)

PROBLEM 2
Code: 
[01/02/2014 02:58:25] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:58:31] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:58:37] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:58:47] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:03] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:08] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:08] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `active` = 1 AND (`expires` > 1391219948 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:09] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:09] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `active` = 1 AND (`expires` > 1391219949 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:09] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268459950 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1391219949 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:09] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 2 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 02:59:09] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 2 ORDER BY `sid` DESC - MYSQL ERROR: Table 'tibiaot.player_depotitems' doesn't exist (1146)

PROBLEM 3
Code: 
[01/02/2014 03:07:49] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 3 - MYSQL ERROR: Table 'tibiaot.player_depotitems' doesn't exist (1146)
[01/02/2014 03:07:49] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 3 - MYSQL ERROR: Table 'tibiaot.player_depotitems' doesn't exist (1146)
[01/02/2014 03:07:49] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 3 - MYSQL ERROR: Table 'tibiaot.player_depotitems' doesn't exist (1146)
[01/02/2014 03:07:49] Error while saving player: Simon.
[01/02/2014 03:07:50] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 03:07:50] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `active` = 1 AND (`expires` > 1391220470 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 03:07:50] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268459961 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1391220470 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 03:07:50] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 3 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Table 'tibiaot.bans' doesn't exist (1146)
[01/02/2014 03:07:50] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 3 ORDER BY `sid` DESC - MYSQL ERROR: Table 'tibiaot.player_depotitems' doesn't exist (1146)
if anyone knows what tables are missing then plase tell me :) <3
 
Sort by date Sort by votes
Problem 4
Code: 
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2060 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2061 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2062 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2063 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2064 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2065 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2066 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2067 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2071 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2072 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2073 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2074 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:02] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2075 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2076 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2077 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2078 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2079 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2080 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2081 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2082 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2083 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2084 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2085 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2086 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2087 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2088 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2089 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2090 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2091 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:03] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2092 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2093 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2094 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2095 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2096 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2097 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2098 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
[01/02/2014 03:16:04] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2099 AND `world_id` = 0 - MYSQL ERROR: Table 'tibiaot.house_lists' doesn't exist (1146)
 
Upvote 0 Downvote
PROBLEM 5
Code: 
string(126) "SELECT `skill_fist` AS `value`, `name`, `vocation` FROM `players` WHERE `group_id`<'2' ORDER BY `skill_fist` DESC LIMIT 0, 30;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'skill_fist' in 'field list'
 
Upvote 0 Downvote
Tables bans, player_depotitems and house_lists does not exist and the column skill_fist in players table does not exist as well.

Read the console errors? :p
 
Upvote 0 Downvote
ya but i dont know how to fix them im very bad at that stuff else i woldent ask now wold i? ;)
no but really i do sux at this and dont know how to fix it :)
 
Upvote 0 Downvote
PROBLEM 1: make a table called bans
PROBLEM 2: make a table called player_depotitems
PROBLEM 3: there is no difference between problem 3 and the 2 first ones
PROBLEM 4: make a table called house_lists

quick solve: import a MySQL schema that comes with your tfs datapack
 
Upvote 0 Downvote
i just recently started mixing with this stuff i dont know how to make tabels tho wold be very nice of you if you cud help me fix them if its not a to big of a problem :) @poinferno
 
Upvote 0 Downvote
simson361 said:
i just recently started mixing with this stuff i dont know how to make tabels tho wold be very nice of you if you cud help me fix them if its not a to big of a problem :) @poinferno
Click to expand...
I would help you if I had the time, sorry mate.
Go to your PHPMyAdmin and make a new database, then go to your database and click on import, browse to your mysql schema in the tfs datapack and import it, there all done
 
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
230
WikiArk21
WikiArk21
johnsamir
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
600
johnsamir
johnsamir
OTcreator
  • Question
TFS 0.X MySQL [2013] - guild ranks
Replies
1
Views
355
tobi132
T
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
2
Views
286
ShadowProwl
ShadowProwl
Back
Top