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/hrworksindia.com/majordomo/majordomo.cf -l it_team -hhrworksindia.com -f owner-it_team it_team-out@hrworksindia.com    generated by it_team@hrworksindia.com    local delivery failed Reporting-MTA: dns; india.drushti.net Action: failedFinal-Recipient: rfc822;|/etc/virtual/majordomo/wrapper resend -C /etc/virtual/hrworksindia.com/majordomo/majordomo.cf -l it_team -h hrworksindia.com -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 archive2.pl drwxr-xr-x 2 majordomo daemon  4096 Jan 29  2005 bin -rwxr-xr-x 1 …

directadmin distribution mail not going Read More »

Open chat