Announcement

Collapse
No announcement yet.

Fields are set to null when saving

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Fields are set to null when saving

    Hi,

    I created a new custom entity, but when I fill out the fields and hit save, the fields are saved, but gives a bad server response. The data log says:

    Code:
    [2019-03-20 17:21:01] Espo.ERROR: Display Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=', Code: HY000 URL: /EspoCRM/api/v1/TestEntity/5c9275fdd8b0831dd [] []
    So I went into phpmyadmin and change the collation of the table from utf8_unicode_ci to utf8_general_ci. When I fill out the fields again, the bad server response message is gone, but the fields do not save properly.

    To give an example, the name field always reverts back to None when the entity is saved. What can I do to save the fields properly?
Working...
X