Month: December 2019

Field ‘po_qnty’ doesn’t have a default value

As others said, this is caused by the STRICT_TRANS_TABLES SQL mode. To check whether STRICT_TRANS_TABLES mode is enabled: SHOW VARIABLES LIKE ‘sql_mode’; To disable strict mode: SET GLOBAL sql_mode=”; But the next time MySQL restarts, these settings are lost. It should be:[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES instead of [mysqld]sql_mode=”NO_ENGINE_SUBSTITUTION” then restart mysqld service.

directadmin distribution mail not going

This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of itsrecipients. This is a permanent error. The following address(es) failed:   pipe to |/etc/virtual/majordomo/wrapper resend -C/etc/virtual/ -l it_team -f owner-it_team    generated by    local delivery failed Reporting-MTA: dns; Action: failedFinal-Recipient: rfc822;|/etc/virtual/majordomo/wrapper resend -C /etc/virtual/ -l it_team -h -f owner-it_team it_team-out@hrworksindia.comStatus: 5.0.0 check  /etc/virtual/majordomo drwxr-x— 5 majordomo daemon  4096 Jul 29  2011 majordomo [root@india majordomo]# ll total 324 -rwxr-xr-x 1 majordomo daemon  5267 Jul 29  2011 drwxr-xr-x 2 majordomo daemon  4096 Jan 29  2005 bin -rwxr-xr-x 1 …

directadmin distribution mail not going Read More »

Open chat