Custom Field Type Creation - BD Error

šŸ’¬ General Discussion
1

I tried following the create field type shown in the suiteCRM example. https://docs.suitecrm.com/blog/creating-custom-field-types/

I keep getting the same error.

[FATAL] Cannot create column Query Failed: ALTER TABLE ldz_leadz_cstm add COLUMN testing_field_c ColorPicker NULL : MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ā€˜ColorPicker NULLā€™ at line 1

It appears that it creates an incomplete SQL statement to create the column.

What am I missing?

2

Actually the error is due MySQL is trying to create a field whose type is ā€œColorPickerā€ which is not recognized by mysql server.
I suppose you are going to create the custom field template ā€œColorPickerā€ right?

Can you share the files you created for that purpose?

Regards

3

It was my own mistake. the File located in Fields was not prefaced with Template.