[Vtigercrm-developers] WebService - Cannot Create DocumentFolders

[joe at tsolucio.com]

Hi,

Execute these two queries in your database:

UPDATE vtiger_ws_entity_fieldtype SET fieldtype = 'owner' WHERE 
table_name = 'vtiger_attachmentsfolder' and field_name='createdby'

that will convert the createdby field into a user field and will permit 
you to assign a user to it

ALTER TABLE `vtiger_attachmentsfolder` CHANGE `sequence` `sequence` 
INT(19) NOT NULL

this one will make sequence mandatory which is necessary if you are 
working in MySQL Strict mode (which you should be doing)

HTH
Joe
TSolucio



El 2018-07-03 17:53, Martin Allen escribió:
> We're trying to create DocumentFolders using the WebService but
> 'createdby' is a mandatory field, but we don't know what value to pass
> it?
> 
> By the name we presumed it was a reference to a User so passed '19x1'
> but got an invalid reference error. When running a Describe operation
> on DocumentFolders, it says the createdby field is of type =
> reference, but doesnt specify what module it refers to (shows an empty
> Array where usually we would see an array of modules that can be
> referenced)?
> 
> Any ideas?
> 
> We've resorted to trying random values but no luck!!!
> 
> Martin Allen
> Clystnet Ltd
> _______________________________________________
> http://www.vtiger.com/