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

How to Update SQL??

chanteelee

chanteelee

BR?
Joined
Jul 15, 2008
Messages
38
Reaction score
0
Location
BRAZIL
I was using the revision 866

So i decided to use the last 8.11 version -> 905

There are lot's of changes in the SQL of this version...

And i have a large DB and don't wanna reset nothing...

So, how to update my SQL to the newer version, without loosing data?
 
The is no changes on the database between the revision 866 (tags/0.2) and 905 (tags/0.2).

Probably you downloaded the revision 905 of the trunk.
 
Code: 
[29/07/2008  10:36:01] Error during getDataInt(lastwarning).
[29/07/2008  10:36:17] >> Loading raids
[29/07/2008  10:36:17] mysql_real_query(): SELECT `id`, `text` FROM `server_motd` ORDER BY `id` DESC LIMIT 1: MYSQL ERROR: Table 'otserv.server_motd' doesn't exist
[29/07/2008  10:36:17] mysql_store_result(): SELECT `id`, `text` FROM `server_motd` ORDER BY `id` DESC LIMIT 1: MYSQL ERROR: Table 'otserv.server_motd' doesn't exist
[29/07/2008  10:36:17] > ERROR: Failed to load motd!
[29/07/2008  10:36:17] mysql_real_query(): SELECT `record` FROM `server_record` ORDER BY `timestamp` DESC LIMIT 1: MYSQL ERROR: Table 'otserv.server_record' doesn't exist
[29/07/2008  10:36:17] mysql_store_result(): SELECT `record` FROM `server_record` ORDER BY `timestamp` DESC LIMIT 1: MYSQL ERROR: Table 'otserv.server_record' doesn't exist
[29/07/2008  10:36:17] > ERROR: Failed to load online record!
[29/07/2008  10:36:17] >> All modules has been loaded, server starting up...
[29/07/2008  10:36:17] >> FCC Server Online!

[29/07/2008  10:36:52] mysql_real_query(): INSERT INTO `houses` (`id`, `owner`, `paid`, `warnings`, `lastwarning`) VALUES (1, 12, 1218916454, 0, 0),(2, 17, 1219013658, 3, 0),(3, 76, 1218916454, 0, 0),(4, 667, 1219892460, 0, 0),(5, 566, 1219684308, 0, 0),(6, 500, 1219170923, 1, 0),(7, 49, 1218845844, 0, 0),(8, 195, 1219428926, 0, 0),(9, 6, 1219631249, 0, 0),(10, 768, 1219878750, 0, 0),(11, 130, 1219013658, 2, 0),(12, 11, 1218916454, 0, 0),(13, 108, 1218916454, 0, 0),(14, 745, 1219719633, 0, 0),(15, 953, 1219867656, 0, 0),(16, 262, 1219631249, 2, 0),(17, 69, 1219706297, 0, 0),(18, 48, 1219706297, 0, 0),(19, 4, 1218845844, 0, 0),(20, 403, 1219222330, 0, 0),(21, 206, 1219191300, 0, 0),(22, 15, 1219125575, 0, 0),(23, 96, 1219531856, 0, 0),(24, 790, 0, 3, 0),(25, 44, 1219706297, 0, 0),(26, 478, 1219459962, 1, 0),(27, 367, 1219892460, 0, 0),(28, 482, 0, 6, 0),(29, 0, 0, 0, 0),(30, 0, 0, 0, 0),(31, 628, 1219553598, 0, 0),(32, 497, 0, 3, 0),(33, 51, 1219125575, 0, 0),(34, 670, 1219878750, 0, 0),(35, 0, 0, 0, 0),(36, 0, 0, 0, 0),(37, 0, 0, 0, 0),(38, 0, 0, 0, 0),(39, 0, 0, 0, 0),(40, 0, 0, 0, 0),(41, 0, 0, 0, 0),(42, 0, 0, 0, 0),(43, 0, 0, 0, 0),(44, 0, 0, 0, 0),(45, 0, 0, 0, 0),(46, 0, 0, 0, 0),(47, 0, 0, 0, 0),(48, 0, 0, 0, 0),(49, 0, 0, 0, 0),(50, 0, 0, 0, 0),(51, 0, 0, 0, 0),(52, 0, 0, 0, 0),(53, 0, 0, 0, 0),(54, 0, 0, 0, 0),(55, 0, 0, 0, 0),(56, 0, 0, 0, 0),(57, 0, 0, 0, 0),(58, 0, 0, 0, 0),(59, 0, 0, 0, 0),(60, 0, 0, 0, 0),(61, 0, 0, 0, 0),(62, 229, 1219366477, 2, 0),(63, 0, 0, 0, 0),(64, 0, 0, 0, 0),(65, 0, 0, 0, 0),(66, 0, 0, 0, 0),(67, 0, 0, 0, 0),(68, 0, 0, 0, 0),(69, 0, 0, 0, 0),(70, 0, 0, 0, 0),(71, 0, 0, 0, 0),(72, 266, 1219806006, 2, 0),(73, 103, 1219266005, 0, 0),(74, 169, 1219631249, 0, 0),(75, 9, 1219013658, 0, 0),(76, 56, 1219631249, 2, 0),(77, 134, 1219292117, 0, 0),(78, 270, 1219366477, 7, 0),(79, 60, 1219867656, 0, 0),(80, 0, 0, 0, 0),(81, 0, 0, 0, 0),(82, 0, 0, 0, 0),(83, 0, 0, 0, 0),(84, 0, 0, 0, 0),(85, 0, 0, 0, 0),(86, 0, 0, 0, 0),(87, 0, 0, 0, 0),(88, 0, 0, 0, 0),(89, 0, 0, 0, 0),(90, 0, 0, 0, 0),(91, 0, 0, 0, 0),(92, 0, 0, 0, 0),(93, 0, 0, 0, 0),(94, 0, 0, 0, 0),(95, 0, 0, 0, 0),(96, 0, 0, 0, 0),(97, 0, 0, 0, 0),(98, 0, 0, 0, 0),(99, 0, 0, 0, 0),(100, 0, 0, 0, 0),(101, 0, 0, 0, 0),(102, 0, 0, 0, 0),(103, 0, 0, 0, 0),(104, 0, 0, 0, 0),(105, 0, 0, 0, 0),(106, 0, 0, 0, 0),(107, 0, 0, 0, 0),(108, 0, 0, 0, 0),(109, 693, 0, 5, 0),(110, 0, 0, 0, 0),(111, 0, 0, 0, 0),(112, 0, 0, 0, 0),(113, 222, 0, 0, 0),(114, 302, 0, 0, 0),(115, 484, 0, 0, 0),(116, 485, 0, 0, 0),(121, 784, 1219867656, 0, 0),(122, 0, 0, 0, 0),(123, 0, 0, 0, 0),(124, 0, 0, 0, 0),(125, 0, 0, 0, 0),(126, 0, 0, 0, 0),(127, 0, 0, 0, 0),(128, 0, 0, 0, 0),(129, 0, 0, 0, 0),(130, 0, 0, 0, 0): MYSQL ERROR: Unknown column 'lastwarning' in 'field list'
0, 0),(93, 0, 0, 0, 0),(94, 0, 0, 0, 0),(95, 0, 0, 0, 0),(96, 0, 0, 0, 0),(97, 0, 0, 0, 0),(98, 0, 0, 0, 0),(99, 0, 0, 0, 0),(100, 0, 0, 0, 0),(101, 0, 0, 0, 0),(102, 0, 0, 0, 0),(103, 0, 0, 0, 0),(104, 0, 0, 0, 0),(105, 0, 0, 0, 0),(106, 0, 0, 0, 0),(107, 0, 0, 0, 0),(108, 0, 0, 0, 0),(109, 693, 0, 5, 0),(110, 0, 0, 0, 0),(111, 0, 0, 0, 0),(112, 0, 0, 0, 0),(113, 222, 0, 0, 0),(114, 302, 0, 0, 0),(115, 484, 0, 0, 0),(116, 485, 0, 0, 0),(121, 784, 1219867656, 0, 0),(122, 0, 0, 0, 0),(123, 0, 0, 0, 0),(124, 0, 0, 0, 0),(125, 0, 0, 0, 0),(126, 0, 0, 0, 0),(127, 0, 0, 0, 0),(128, 0, 0, 0, 0),(129, 0, 0, 0, 0),(130, 0, 0, 0, 0): MYSQL ERROR: Unknown column 'lastwarning' in 'field list'
[29/07/2008  10:40:30] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Steve Nitros': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_store_result(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Steve Nitros': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Maskavo': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_store_result(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Maskavo': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Eclipse': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_store_result(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Eclipse': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Evil Sorc': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_store_result(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items` FROM `players` WHERE `name`='Evil Sorc': MYSQL ERROR: Unknown column 'balance' in 'field list'
[29/07/2008  10:40:31] mysql_real_query(): UPDATE `bans` SET `active` = 0 WHERE `expires` = 0 AND `active` = 1;: MYSQL ERROR: Unknown column 'expires' in 'where clause'



I think there are changes for 866 to 905 ...
 
Last edited:
As Nightmare said, you downloaded TRUNK. Download revision 905 OF TAGS (in tags folder of the project).

Tags doesn't have lastwarning in houses table, neither tables named server_record and server_motd, it puts these informations on txt files.

Yours,
Rafael Hamdan;
 
You must log in or register to reply here.

Similar threads

Michcol94
  • Question
OTClient Files SPR and DAT Conveter from protocol 8.6 to a minimum of 10.98
Replies
1
Views
892
johnsamir
johnsamir
ghunalma
(trying to add 12.72 on mehah OTC 3.1) Error Query: UPDATE `accounts`
Replies
2
Views
245
ghunalma
ghunalma
W
I'm asking for your opinion
Replies
3
Views
501
Westbay
W
222222
Linux How to build and install MariaDB from source - and how to secure your database.
Replies
0
Views
182
222222
222222
Codinablack
Does anyone want an updated TFS 1.4.x+
2 3 4
Replies
60
Views
3K
Codinablack
Codinablack
P
  • Question
[Canary 13.21] manage_storage.lua usage doesn't seem to find proper key-values.
Replies
0
Views
390
pepeg123
P
Jpstafe
  • Question
Does anyone know how to put this exhaust?
2
Replies
24
Views
2K
Jpstafe
Jpstafe
R
Programmer Rewrite DASH - OTCv8 (U$ 50)
Replies
9
Views
1K
Danger II
Danger II
Giorox
Naive Dockerized TFS 1.5
Replies
6
Views
2K
iNux
I
222222
Don't use MySQL - use MariaDB
Replies
2
Views
769
Srnt
S
Back
Top