AnsweredAssumed Answered

Problem with SynoField Photo By Synolia in SugarCRM CE

Question asked by Daniel Monsalve on Jan 14, 2016
Latest reply on Jan 15, 2016 by Daniel Monsalve

Hey there,

 

Best regards,

 

Recently I joined the community to ask a question about how to properly use the image field type SugarCRM CE, getting no reply, I was looking and I found this module ...

 

SynoField Photo By Synolia ericshao/SugarCRM-PhotoField-UpYun - PHP - GitHub

 

After having some installation problems and solve them, I managed to have a successful installation (at least that's the message that SugarCRM told me)

 

The problem is that when trying to create the type field "photo" is the functionality that adds this new addon, SugarCRM shows me the following message: "problem with the database, please check sugarcrm.log"

 

By going to review the file sugarcrm.log I find the following:

 

Thu Jan 14 12:21:22 2016 [10084][1][FATAL] Cannot create column Query Failed: ALTER TABLE notes_cstm add COLUMN foto_c photo  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 'photo  NULL' at line 1

 

Can anyone help me solve this problem?

What should I do?

 

I would be very grateful to those who help solve this.

 

Beforehand thank you very much.

 

Sincerely,

 

Daniel M.

Outcomes