RecordCreator helps you create a related record from any module and define which fields should be copied over to the newly created related record. For example, if a user is on a Ticket record the use could create an Invoice record from that Ticket and copy over information such as the contact information or address.
#3883 - Does Not Save
I am running SuiteCRM Version 7.11.20 and have loaded your module successfully. I have entered the license key. When I go to create I can select the source and target module. I give it a name and click nect. I select the fields for mapping and click Save. The screen refreshes and nothing has been saved. I have installed this module on both my dev and production systems and same problem. I have checked the tables in the SQL Server and they are empty so not sure why record is not being saved. No error message shown.
afcmasteruser
3 years ago
Found error and solution. I am running Microsoft SQL Server for the database.
Error below. Solution is on this Line [deleted] TINYINT DEFAULT '0' change it to [deleted] [TINYINT] DEFAULT '0' remove the (1) as you do not need to define the length for this field.
Thu Sep 30 14:57:04 2021 [3868][1][FATAL] Query Failed:IF NOT EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'dbo.[vi_related_record_creator]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE [dbo].[vi_related_record_creator]( [relatedrecordcreator_id] CHAR PRIMARY KEY, [source_module] VARCHAR, [target_module] VARCHAR, [target_module_view] VARCHAR, [display_text] VARCHAR, [deleted] TINYINT DEFAULT '0' ) END::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column, parameter, or variable #6: Cannot specify a column width on data type tinyint. Thu Sep 30 14:57:04 2021 [3868][1][FATAL] Query Failed:IF NOT EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'dbo.[vi_related_record_creator_field_mapping]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE [dbo].[vi_related_record_creator_field_mapping]( [field_mapping_id] CHAR PRIMARY KEY, [relatedrecordcreator_id] VARCHAR, [primary_field] VARCHAR, [target_field] VARCHAR, [deleted] TINYINT DEFAULT '0' ) END::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column, parameter, or variable #5: Cannot specify a column width on data type tinyint.
3 years ago
Hello,
Apologies for the problem you're facing.
Still you're facing the problem or you have fix the problem?
Regards, Variance Infotech PVT LTD
a year ago
Hello
Thanks for your valuable support and being our customer. We've not received any response from your side so for now, We're closing the ticket but if you've any questions or concern feel free to email us on techsupport@varianceinfotech.com or generate new ticket.
Regards,
Support Team Variance InfoTech Pvt Ltd