RDB Tool crashes when trying to Load from SQL QuestResource 7.2

[nano1995]

Hello everyone,

I am trying to make an rdb file for my server, I edited some quests and tried to export some recourse to see the effects in the game,

I downloaded RDB Tool and copied QuestResource from 7.1 and made some tweaks to it, but once I try to "Load from SQL" RDB Tool crashes, no error massages appears.

This is the script file:

 Spoiler

rdb.fields = {
	{"id", TYPE_INT32},
	{"text_id_quest", TYPE_INT32},
	{"text_id_summary", TYPE_INT32},
	{"text_id_status", TYPE_INT32},
	{"limit_begin_time", TYPE_INT32},
	{"limit_end_time", TYPE_INT32},
	{"limit_level", TYPE_INT32},
	{"limit_job_level", TYPE_INT32},
	{"limit_max_level", TYPE_INT32},
	{"limit_max_job_level", TYPE_INT32},
	{"limit_deva", TYPE_BIT},
	{"limit_asura", TYPE_BIT},
	{"limit_gaia", TYPE_BIT},
	{"limit_fighter", TYPE_BIT},
	{"limit_hunter", TYPE_BIT},
	{"limit_magician", TYPE_BIT},
	{"limit_summoner", TYPE_BIT},
	{"limit_job", TYPE_INT32},
	{"limit_favor_group_id", TYPE_INT32 | TYPE_RDBIGNORE},
	{"limit_favor", TYPE_INT32},
	{"repeatable", TYPE_INT32},
	{"invoke_condition", TYPE_INT32},
	{"invoke_value", TYPE_INT32},
	{"time_limit_type", TYPE_INT16},
	{"time_limit", TYPE_INT32},
	{"type", TYPE_INT32},
	{"value1", TYPE_INT32},
	{"value2", TYPE_INT32},
	{"value3", TYPE_INT32},
	{"value4", TYPE_INT32},
	{"value5", TYPE_INT32},
	{"value6", TYPE_INT32},
	{"value7", TYPE_INT32},
	{"value8", TYPE_INT32},
	{"value9", TYPE_INT32},
	{"value10", TYPE_INT32},
	{"value11", TYPE_INT32},
	{"value12", TYPE_INT32},
	{"drop_group_id", TYPE_INT32},
	{"quest_difficulty", TYPE_INT32},
	{"favor_group_id", TYPE_INT32 | TYPE_RDBIGNORE},
	{"hate_group_id", TYPE_INT32 | TYPE_RDBIGNORE},
	{"favor", TYPE_INT32},
	{"exp", TYPE_INT32},
	{"jp", TYPE_INT32},
	{"holicpoint", TYPE_INT32},
	{"gold", TYPE_INT32},
	{"default_reward_id", TYPE_INT32},
	{"default_reward_level", TYPE_INT32},
	{"default_reward_quantity", TYPE_INT32},
	{"optional_reward_id1", TYPE_INT32},
	{"optional_reward_level1", TYPE_INT32},
	{"optional_reward_quantity1", TYPE_INT32},
	{"optional_reward_id2", TYPE_INT32},
	{"optional_reward_level2", TYPE_INT32},
	{"optional_reward_quantity2", TYPE_INT32},
	{"optional_reward_id3", TYPE_INT32},
	{"optional_reward_level3", TYPE_INT32},
	{"optional_reward_quantity3", TYPE_INT32},
	{"optional_reward_id4", TYPE_INT32},
	{"optional_reward_level4", TYPE_INT32},
	{"optional_reward_quantity4", TYPE_INT32},
	{"optional_reward_id5", TYPE_INT32},
	{"optional_reward_level5", TYPE_INT32},
	{"optional_reward_quantity5", TYPE_INT32},
	{"optional_reward_id6", TYPE_INT32},
	{"optional_reward_level6", TYPE_INT32},
	{"optional_reward_quantity6", TYPE_INT32},
	{"forequest1", TYPE_INT32},
	{"forequest2", TYPE_INT32},
	{"forequest3", TYPE_INT32},
	{"or_flag", TYPE_INT8},
	{"script_start_text", TYPE_VARCHAR_STR, MAKEINDEXEDVAR(0, 512)},
	{"script_end_text", TYPE_VARCHAR_STR, MAKEINDEXEDVAR(0, 512)},
	{"script_text", TYPE_VARCHAR_STR, MAKEINDEXEDVAR(0, 512)},
}

rdb.convertData = function (dst, mode, row, rowNum)
	if mode == DCT_Read and dst ~= DF_RDB then
		local id = row.id;

		row.limit_favor_group_id = 0
		row.favor_group_id = 999

		if id >= 3600 and id <= 3611 and id ~= 3610 then
			row.hate_group_id = 1
		else
			row.hate_group_id = 0
		end
	end
end

This is the table exported from SQL Studio:

 Spoiler

USE [Arcadia]
GO

/****** Object:  Table [dbo].[QuestResource]    Script Date: 3/7/2019 7:11:01 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[QuestResource](
	[id] [int] NOT NULL,
	[text_id_quest] [int] NOT NULL,
	[text_id_summary] [int] NOT NULL,
	[text_id_status] [int] NOT NULL,
	[limit_begin_time] [int] NOT NULL,
	[limit_end_time] [int] NOT NULL,
	[limit_level] [int] NOT NULL,
	[limit_job_level] [int] NOT NULL,
	[limit_max_level] [int] NOT NULL,
	[limit_max_job_level] [int] NOT NULL,
	[limit_deva] [char](1) NOT NULL,
	[limit_asura] [char](1) NOT NULL,
	[limit_gaia] [char](1) NOT NULL,
	[limit_fighter] [char](1) NOT NULL,
	[limit_hunter] [char](1) NOT NULL,
	[limit_magician] [char](1) NOT NULL,
	[limit_summoner] [char](1) NOT NULL,
	[limit_job] [int] NOT NULL,
	[limit_favor_group_id] [int] NOT NULL,
	[limit_favor] [int] NOT NULL,
	[repeatable] [char](1) NOT NULL,
	[invoke_condition] [int] NOT NULL,
	[invoke_value] [int] NOT NULL,
	[time_limit_type] [char](10) NOT NULL,
	[time_limit] [int] NOT NULL,
	[type] [int] NOT NULL,
	[value1] [int] NOT NULL,
	[value2] [int] NOT NULL,
	[value3] [int] NOT NULL,
	[value4] [int] NOT NULL,
	[value5] [int] NOT NULL,
	[value6] [int] NOT NULL,
	[value7] [int] NOT NULL,
	[value8] [int] NOT NULL,
	[value9] [int] NOT NULL,
	[value10] [int] NOT NULL,
	[value11] [int] NOT NULL,
	[value12] [int] NOT NULL,
	[drop_group_id] [int] NOT NULL,
	[quest_difficulty] [int] NOT NULL,
	[favor_group_id] [int] NOT NULL,
	[hate_group_id] [int] NOT NULL,
	[favor] [int] NOT NULL,
	[exp] [bigint] NOT NULL,
	[jp] [int] NOT NULL,
	[holicpoint] [int] NOT NULL,
	[gold] [int] NOT NULL,
	[default_reward_id] [int] NOT NULL,
	[default_reward_level] [int] NOT NULL,
	[default_reward_quantity] [int] NOT NULL,
	[optional_reward_id1] [int] NOT NULL,
	[optional_reward_level1] [int] NOT NULL,
	[optional_reward_quantity1] [int] NOT NULL,
	[optional_reward_id2] [int] NOT NULL,
	[optional_reward_level2] [int] NOT NULL,
	[optional_reward_quantity2] [int] NOT NULL,
	[optional_reward_id3] [int] NOT NULL,
	[optional_reward_level3] [int] NOT NULL,
	[optional_reward_quantity3] [int] NOT NULL,
	[optional_reward_id4] [int] NOT NULL,
	[optional_reward_level4] [int] NOT NULL,
	[optional_reward_quantity4] [int] NOT NULL,
	[optional_reward_id5] [int] NOT NULL,
	[optional_reward_level5] [int] NOT NULL,
	[optional_reward_quantity5] [int] NOT NULL,
	[optional_reward_id6] [int] NOT NULL,
	[optional_reward_level6] [int] NOT NULL,
	[optional_reward_quantity6] [int] NOT NULL,
	[forequest1] [int] NOT NULL,
	[forequest2] [int] NOT NULL,
	[forequest3] [int] NOT NULL,
	[or_flag] [char](1) NOT NULL,
	[script_start_text] [varchar](512) NULL,
	[script_end_text] [varchar](512) NULL,
	[script_text] [varchar](512) NULL
) ON [PRIMARY]
GO

I use Revo 7.2 files.

If there were error messages I might be able to get it to work myself, but unfortunately it does not show any errors, so I need some help here.

Thanks.

[karatt0]

sie

[thefear511]

check logs and provide them here. glandu's tool will give you logs when errors occur