Results 1 to 3 of 3

Thread: no server statistic image and mysql errors

  1. #1
    Join Date
    Dec 2006
    Location
    Melbourne, VIC, Australia
    Posts
    120
    Rep Power
    8

    Default no server statistic image and mysql errors

    Hi guys,
    I don't get any image in server statistics and I checked the crontab for user zimbra.

    When I try to run "/opt/zimbra/libexec/zmdailyreport | /opt/zimbra/postfix/sbin/sendmail root"
    I get this error:

    DBD::mysql::st execute failed: 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 'sdieters'' at line 1 at /opt/zimbra/libexec/zmdailyreport line 511.
    /opt/zimbra/libexec/zmdailyreport sql execute failed: 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 'sdieters'' at line 1
    DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /opt/zimbra/libexec/zmdailyreport line 515.

    I assume that this could be the reason, does anyone know how to fix it?

    System: Ubuntu 6.06.1 LTS
    Zimbra: where can I find the version information?

    Cheers
    Andre

  2. #2
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    There's a known issue with single quotes in message id's with 4.0.x releases. This is fixed in the 4.5.0_BETA1 release and later.

    You can find zimbra version with zmcontrol -version
    or in the help section of the Admin UI.
    Last edited by brian; 12-29-2006 at 06:30 PM.

  3. #3
    Join Date
    Dec 2006
    Location
    Melbourne, VIC, Australia
    Posts
    120
    Rep Power
    8

    Default

    Quote Originally Posted by brian View Post
    There's a known issue with single quotes in message id's with 4.0.x releases. This is fixed in the 4.5.0_BETA1 release and later.

    You can find zimbra version with zmcontrol -version
    or in the help section of the Admin UI.
    Thanks,

    upgraded to 4.5 - now it's working fine

    happy new year

    Andre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •