Truice miss/ignore to add some fields into final SQL query.

[peycho]

Hello.

When you try to change something in quest template, like "End Text", "Reward Text" or "Completion Text", the values are not added into the final SQL. There may be other fields as well. I'll add them here if I notice something.

I'm using Truice 2.1.6. The setting of the program is set to DELETE/INSERT.

[Faq]

Can you point in what table are those fields?
for example "EndText" are no more in https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130261/quest+template

[peycho]

I don't really know what were the names of these columns. The table is quest_template.

[Faq]

i think those were dropped and not used anymore.

[peycho]

They are dropped but I think these are moved into other tables like:
quest_details
quest_greeting
quest_greeting_locale
quest_offer_reward
quest_offer_reward_locale
quest_poi
quest_poi_points
quest_pool_members
quest_pool_template
quest_request_items
quest_request_items_locale
...... and other tables like these

The Truice program may need some serious update to cover current state of trinitycore database.

[Faq]

If you can report that field with name X from db table Y is missing in Truice, would give me more specific info and easier to implement.
But take in consideration, that not all tables implemented in Truice, just some most used ones.

[Danmi100]

This problem also occurs for me, the fact is that the final SQL is not saved to the database in any columns, not only in quest.
Please note that Truice 2.1.2 does not have this problem, although this version partially conflicts with the database, but the items are saved correctly, without loss.

[Faq]

@Danmi100 give me some example query.