Dawn of Light

Verry good Merec Thank you for all this job.

I have find a bug on the editor, each time an item is loaded in the editor for create a new item,
when you hit the export button you can see the case ItemTemplate_ID is the same than the loaded base item.
It's not really a problem if you don't have to reload this item in the editor.

The problem come when you want to modify it and save it.

just want to provide a little fix for this errors for all of this affected:

Code: Select all

update itemtemplate set itemtemplate_id = id_nb;

Always a pleasure to see this still going, thanks Merec!

I still use this tool and very much love it! I am no longer working on Genesis but working on my own project that will be launching in some months to come, The tool worked great on Genesis - now on my new project (Vivien) I am having issues and hope to get some pointers.

I have 2 issues (Which I will place in separate posts for clarity).....

1. On launch of the tool I connect fine. But when I try to open an item (spell.... so on and so forth) I get the error listed in the attached file cs_open_error_2-7-15.txt. It will present the same error a 2nd time on attempt and then on the 3rd attempt work correctly. The tool then works correctly so long as I am active, meaning that if I take a 5 minute break and attempt to use it again I get the same error 2 times and then it works on the 3rd.

I am running MySQL version 5.6.21. I have used MySQL Workbench and checked the DB performance and tuned it to some degree with no change (I am not a DB Admin really).

I am using Creator Suite 1.2.1

Any direction of pointers would be helpful

The 2nd issue.....


1. I can create an item (spell... and so on...) using the tool, but when I attempt to save it it fails. Initially it reports that the item is valid and the save to database option becomes available. Then when I click on the save to database option I get the error shown in the attached file cs_save_error_2-7-15.jpg. The tool reports that it is unable to load from the database the item I attempted to save out.

This confuses me as I am creating a new item and not asking it to load one. The user I connect the tool to the DB with has full rights to create. alter and so on in the DB.

Again I am running MySQL 5.6.21 and this same tool worked for me on Genesis. I suspect that something is amiss in my itemtemplate table - perhaps I am missing a field in the table?

I am using Creator Suite 1.2.1

Any guidance would be greatly appreciated.

TIA
Walzin

Welcome to my nightmare old man

Thanks for the feedback! I will take a look as soon as possible.

One question, are you using the svn version of dol? Or is it a specific commit?

UPDATE -

issue 2 is resolved.....

A 10 minute conversation with my DOL WB mentor (THANKS Argo!!) and we determined that I had a field in my Itemtemplate table that CS did not like. The field was not being used... removed the field from the table - updated and now item create works.

What was the name and the type of the field? Maybe I forgot to escape something.

it was a custom field (text) that one of our people added for later use. So it was nothing from your (The program side). Its was called ALTNAme and was text type.

Hey Merec,

it is this field here:

Code: Select all

CREATE TABLE dummy ( `FRName` VARCHAR(255) NOT NULL DEFAULT '' )

since i am working on Genesis, it would be of great help to me if you could add it to the creatorsuite, if anyhow possible.

BTW. i am using the latest version, whatever version it may be

thx m8

Argo

Hey all,

I found the bug and will update the CS within the next days. I have also updated the DOLCore to the latest version, so all new fields will be available.

One thing I will also add, is a vice-versa-version of the missing-fields section. Currently, CS is looking in the DOL-Code, if there are fields that are not handeled. I want a feature, that checks also the Dataabase, if there are fields that are not handeled.

Nice

thumbs up

New version 1.3.0 available, please test it!
For changelog, see first post.