Closed imRezaAlie closed 2 years ago
hi dears, when i import users i retrieve below error how can i fix ? Thanks inadvance.
2022-06-19 05:33:38] local.ERROR: Failed importing object [Jone Care]. SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xFF\xD8\xFF\xE1\x00\x18...' for column dbtest.users.ldap_avatar at row 1 (SQL: insert into users (guid, domain, password, first_name, last_name, email, phone, ldap_avatar, job_level, employee_num, job_title, updated_at, created_at) values (f138721f-67fe-0000-bb57-9ff27c554b0a, default, ?, Jond, carr, ?, ?, ���� Exif II* �� Ducky F ��http://ns.adobe.com/xap/1.0/ <?xpacket begin="" id="W5M0MpCehiHzreSzNTczkc9d"?> </rdf:Description> </rdf:RDF> </x:xmpmeta> <?xpacket end="r"?>�� Adobe d� �� �
dbtest
users
ldap_avatar
guid
domain
password
first_name
last_name
email
phone
job_level
employee_num
job_title
updated_at
created_at
c�ωiP�e�ALc�W4�|������fH��� \���F˹����2V���<b����;� ���ۏ��Z�6�`n��32~���0�#ߎbz�;�<�r�7q�畤�� ���c�Ԍ2N��hY�r.�����8�=Y&�� y6g��ݴ ��Tן�!��ZY,���' ��#\�f� �U���"��#���u�2�Fdz���mL��|3� � j��_.<�{7%���4� ��A�6�\nZ�y$>�r[�-�vB�#mۄ���3�a� S= ������d������M�Gu � ��áY a�pڹ�e^�u3'��w���,Ж��md�ɷ�"��\J�5���[$�T�)��=�&�T�ă�2~ �"n�� �P���P�?�:z�.���0&��=,<z~ ������V:�Z#U�9����W���Q���eU��4�Q� su�.ɕȉ��Y�,��� Ai�n�47߱�0is'Q�� zb�&��6��s��1�X`��QC-�hE�W6�@ X��r -���Rd2I��}��Ա��?bۏYP���MAZ��X����@�Ӿ�,�J|�S>�\��BKC �K�^�\��S�8n� =FU�G���T u 8�b��fT�@�EU-U���f%2�rP� �p�Cg�q����kS�]3Ic=c�N��6+ls��Û���4�]�U�j��?���r�^Dd�j ��Z��O <B,�`��г=5=z�� ^K�� \��S���R�D��sH��, '0O��\Q���df� ZI�R|�Jb� �8;�x�1��i�R �۠M(=6 k����n+2D��i�3 �F���B��qi!�Ϊ�KFQ@��П?�bH=��VA������S��w��,.�m8:�UEE>Θ��F��6N�#)Ϩ$��O ^Ԓ���UԀ]>T�����V@V9@p�� S:o���vG�hu%Y�sZ�<��,l�`� =r(t�)O�����L&u<-��� �T._��1Ahe��A��Z�r f-���i���C%rםM=��G��9����>Z� CH�|L���Vb�[H@*(|dz���a�j�KG��JJ��놬J���X��YQs�R��烉� z?��, ?, AASS00,Manager : Technical, 2022-06-19 05:33:38, 2022-06-19 05:33:38))
���W���Q���eU��4�Q� su�.
hi dears, when i import users i retrieve below error how can i fix ? Thanks inadvance.
2022-06-19 05:33:38] local.ERROR: Failed importing object [Jone Care]. SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xFF\xD8\xFF\xE1\x00\x18...' for column
dbtest.users.ldap_avatarat row 1 (SQL: insert intousers(guid,domain,password,first_name,last_name,email,phone,ldap_avatar,job_level,employee_num,job_title,updated_at,created_at) values (f138721f-67fe-0000-bb57-9ff27c554b0a, default, ?, Jond, carr, ?, ?, ���� Exif II* �� Ducky F ��http://ns.adobe.com/xap/1.0/ <?xpacket begin="" id="W5M0MpCehiHzreSzNTczkc9d"?>c�ωiP�e�ALc�W4�|������fH��� \���F˹����2V���<b����;� ���ۏ��Z�6�`n��32~���0�#ߎbz�;�<�r�7q�畤�� ���c�Ԍ2N��hY�r.�����8�=Y&�� y6g��ݴ ��Tן�!��ZY,���' ��#\�f� �U���"��#���u�2�Fdz���mL��|3� � j��_.<�{7%���4� ��A�6�\nZ�y$>�r[�-�vB�#mۄ���3�a� S= ������d������M�Gu � ��áY a�pڹ�e^�u3'��w���,Ж��md�ɷ�"��\J�5���[$�T�)��=�&�T�ă�2~ �"n�� �P���P�?�:z�.���0&��=,<z~ ������V:�Z#U�9�
���W���Q���eU��4�Q� su�.ɕȉ��Y�,��� Ai�n�47߱�0is'Q�� zb�&��6��s��1�X`��QC-�hE�W6�@ X��r -���Rd2I��}��Ա��?bۏYP���MAZ��X����@�Ӿ�,�J|�S>�\��BKC �K�^�\��S�8n� =FU�G���T u 8�b��fT�@�EU-U���f%2�rP� �p�Cg�q����kS�]3Ic=c�N��6+ls��Û���4�]�U�j��?���r�^Dd�j ��Z��O <B,�`��г=5=z�� ^K�� \��S���R�D��sH��, '0O��\Q���df� ZI�R|�Jb� �8;�x�1��i�R �۠M(=6 k����n+2D��i�3 �F���B��qi!�Ϊ�KFQ@��П?�bH=��VA������S��w��,.�m8:�UEE>Θ��F��6N�#)Ϩ$��O ^Ԓ���UԀ]>T�����V@V9@p�� S:o���vG�hu%Y�sZ�<��,l�`� =r(t�)O�����L&u<-��� �T._��1Ahe��A��Z�r f-���i���C%rםM=��G��9����>Z� CH�|L���Vb�[H@*(|dz���a�j�KG��JJ��놬J���X��YQs�R��烉� z?��, ?, AASS00,Manager : Technical, 2022-06-19 05:33:38, 2022-06-19 05:33:38))