CMDBuild Forum

Bug in logging of creation the simple class

Old Versions
#1

Dear team, 

In the cmdbuild_dd_sql.log there is a bug in the row logging creation of the simple class. In the argument value list of cm_create_class function there is on the second position (inherits from) value 'null' instead of null (it has to be written without apostrophes). 
Best regards,
Jiří
#2

Bugs are also in logging of cm_modify_attribute: 

SELECT * FROM cm_modify_attribute('"ModelInOperation"'::regclass,'BeginDate','timestamp','now()',true,false,'['BASEDSP: false', 'DESCR: BeginDate', 'GROUP: ', 'MODE: hidden', 'FIELDMODE: hidden']');
 
There are unescaped apostrophes in the string, no key word ARRAY... I have not investigated the right version of this statement yet.
 
I need to apply the SQL log to my production instance and it does not work - many errors :-(
 
Jiří 
#3

So, the right version of the statement is:

SELECT * FROM cm_modify_attribute('"ModelInOperation"'::regclass,'BeginDate','timestamp','now()',true,false,ARRAY['BASEDSP: false', 'DESCR: BeginDate', 'GROUP: ', 'MODE: hidden', 'FIELDMODE: hidden']::TEXT[],ARRAY[]::text[]);
 
Jiří
#4
Dear Jiří,
 
thank you for your submission, we'll fix it for the upcoming version.
 
Best regards.
 
-- CMDBuild Team
 
Previously Jiří wrote:
Dear team, 
In the cmdbuild_dd_sql.log there is a bug in the row logging creation of the simple class. In the argument value list of cm_create_class function there is on the second position (inherits from) value 'null' instead of null (it has to be written without apostrophes). 
Best regards,
Jiří

 

#5
Dear Jiří
 
thank you for your submission, this issue has already been fixed and it will included in the upcoming version.
 
Best regards.
 
-- CMDBuild Team
 
Previously Jiří wrote:
Bugs are also in logging of cm_modify_attribute: 
SELECT * FROM cm_modify_attribute('"ModelInOperation"'::regclass,'BeginDate','timestamp','now()',true,false,'['BASEDSP: false', 'DESCR: BeginDate', 'GROUP: ', 'MODE: hidden', 'FIELDMODE: hidden']');
 
There are unescaped apostrophes in the string, no key word ARRAY... I have not investigated the right version of this statement yet.
 
I need to apply the SQL log to my production instance and it does not work - many errors :-(
 
Jiří