AnsweredAssumed Answered

MySQL error 1064 : Alter table while deploying module through module builder

Question asked by ananth k on Mar 7, 2016
Latest reply on Mar 9, 2016 by Alan Beam

I'm facing the following error.

 

ERROR:

03/07/16 11:44:34 [6152][1][FATAL] Executing repair query:  Query Failed: ALTER TABLE test_moduletest   add COLUMN fullname fullname  NULL: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fullname  NULL' at line 1

 

 

When i try to deploy a module with a field fullname & its datatype is "fullname", i'm getting this error. This field will be automatically get added to the module when we create a module with type as "person"

 

The following is the screen which display field "fullname" configuration

 

So once i deploy the module, then i'm getting the error, then the deployment is getting failed.

Outcomes