Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Disk Usage does not work

Help
2005-08-17
2013-06-04
  • Keith Bawden
    Keith Bawden
    2005-08-17

    Hello,

    I have been using MM1.1.1 for around three months now and it is excllent :-)

    I'm currently testing MM2 on another box and have found that disk usage does not work. I read n the changelog that there was an issue with disk usage returning an error if there were no tickets.

    I have 22 test tickets in there so this would not be the case. Unless of course disk usage only shws the size of a ZODB, which would not help with a pqsql back end..

    Here is the error message thrown:
    ##############
    Site Error

    An error was encountered while publishing this resource.

    Error Type: TypeError
    Error Value: int() argument must be a string or a number
    ##############

    Regards, Bawdo2001

     
    • Kevin Campbell
      Kevin Campbell
      2005-08-17

      Hi there,

      I believe the disk usage problems you are experiencing are due to the existance of NULL values in either the body or html_body fields of certain messages in the database. The following SQL query should identify if this is the problem

      SELECT id FROM <schema.>mm_message WHERE body IS NULL or html_body IS NULL;

      If any rows are returned, this is likely the issue. There should be a fix for this in one of the later releases. What version are you currently running?

      Regards,
      Kevin
      --
      Kevin Campbell
      Software Engineer
      Logical Progression Ltd
      GPG Key: F480EC23

       
    • Keith Bawden
      Keith Bawden
      2005-08-17

      Hello,

      Thanks for the quick reply.

      I will run the query against the DB later on (I'm off to bed) and let you know the results.

      I'm running the latest version downloaded two days ago from sourceforge. MailManager-2.0.tar.gz

      Regards, Keith

       
    • Keith Bawden
      Keith Bawden
      2005-08-18

      Hello,

      I ran the query mentioned above and zero rows were returned.

      Is there any other information I can provide that will help identify teh cause of this?

      Regards, Bawdo2001