From: <tones
Date: January 13 2005 9:26pm
Subject: FW: Eventum - Error found! - 01/13/2005 01:52:01
List-Archive: http://lists.mysql.com/eventum-users/733
Message-Id: <3AF6C39D31ABE040B58665012EC2C1E738653F@cclrsrv2.cclr.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Has anyone received this error before?  This happens when the cron
checks the a pop3 account and auto-creates a new issue.
It seems to create the issue but I always get this error found report.

Tony


An error was found at 01/13/2005 01:52:01 (1105609921) on line '305' of
script
'/usr/vips/subdomain.domain.com/docs/tickets/include/class.link_filter.p
hp'.

The error message passed to us was:

'DB Error: syntax error'

A more detailed error message follows:

'SELECT
                        lfi_pattern,
                        lfi_replacement
                    FROM
                        ticketsDB.tickets_link_filter,
                        ticketsDB.tickets_project_link_filter
                    WHERE
                        lfi_id =3D plf_lfi_id AND
                        lfi_usr_role <  AND
                        plf_prj_id =3D=20
                    ORDER BY
                        lfi_id [nativecode=3D1064 ** 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 'AND
                        plf_prj_id =3D=20
                   ]'

That happened on page '' from IP Address '' coming from the page
(referrer) ''.

The user agent given was ''.

Sincerely yours,
Automated Error_Handler Class

A backtrace is available:

array(6) {
  [0]=3D>
  array(6) {
    ["file"]=3D>
    string(77)
"/usr/vips/subdomain.domain.com/docs/tickets/include/class.link_filter.p
hp"
    ["line"]=3D>
    int(267)
    ["function"]=3D>
    string(10) "getfilters"
    ["class"]=3D>
    string(11) "link_filter"
    ["type"]=3D>
    string(2) "::"
    ["args"]=3D>
    array(0) {
    }
  }
  [1]=3D>
  array(6) {
    ["file"]=3D>
    string(71)
"/usr/vips/subdomain.domain.com/docs/tickets/include/class.issue.php"
    ["line"]=3D>
    int(2677)
    ["function"]=3D>
    string(11) "processtext"
    ["class"]=3D>
    string(11) "link_filter"
    ["type"]=3D>
    string(2) "::"
    ["args"]=3D>
    array(1) {
      [0]=3D>
      &string(0) ""
    }
  }
  [2]=3D>
  array(6) {
    ["file"]=3D>
    string(78)
"/usr/vips/subdomain.domain.com/docs/tickets/include/class.notification.
php"
    ["line"]=3D>
    int(899)
    ["function"]=3D>
    string(10) "getdetails"
    ["class"]=3D>
    string(5) "issue"
    ["type"]=3D>
    string(2) "::"
    ["args"]=3D>
    array(1) {
      [0]=3D>
      &int(5)
    }
  }
  [3]=3D>
  array(6) {
    ["file"]=3D>
    string(71)
"/usr/vips/subdomain.domain.com/docs/tickets/include/class.issue.php"
    ["line"]=3D>
    int(1534)
    ["function"]=3D>
    string(22) "notifyautocreatedissue"
    ["class"]=3D>
    string(12) "notification"
    ["type"]=3D>
    string(2) "::"
    ["args"]=3D>
    array(5) {
      [0]=3D>
      &string(1) "1"
      [1]=3D>
      &int(5)
      [2]=3D>
      &string(38) "Aaron Mitchell <aaronm@stripped>"
      [3]=3D>
      &string(19) "2005-01-13 09:56:57"
      [4]=3D>
      &string(4) "test"
    }
  }
  [4]=3D>
  array(6) {
    ["file"]=3D>
    string(73)
"/usr/vips/subdomain.domain.com/docs/tickets/include/class.support.php"
    ["line"]=3D>
    int(560)
    ["function"]=3D>
    string(15) "createfromemail"
    ["class"]=3D>
    string(5) "issue"
    ["type"]=3D>
    string(2) "::"
    ["args"]=3D>
    array(9) {
      [0]=3D>
      &string(1) "1"
      [1]=3D>
      &int(1)
      [2]=3D>
      &string(38) "Aaron Mitchell <aaronm@stripped>"
      [3]=3D>
      &string(4) "test"
      [4]=3D>
      &string(6) "test
"
      [5]=3D>
      &string(1) "3"
      [6]=3D>
      &string(1) "5"
      [7]=3D>
      &NULL
      [8]=3D>
      &string(19) "2005-01-13 09:56:57"
    }
  }
  [5]=3D>
  array(6) {
    ["file"]=3D>
    string(72)
"/usr/vips/subdomain.domain.com/docs/tickets/misc/download_emails.php"
    ["line"]=3D>
    int(97)
    ["function"]=3D>
    string(12) "getemailinfo"
    ["class"]=3D>
    string(7) "support"
    ["type"]=3D>
    string(2) "::"
    ["args"]=3D>
    array(3) {
      [0]=3D>
      &resource(234) of type (imap)
      [1]=3D>
      &array(12) {
        ["ema_id"]=3D>
        string(1) "1"
        ["ema_prj_id"]=3D>
        string(1) "1"
        ["ema_type"]=3D>
        string(4) "pop3"
        ["ema_folder"]=3D>
        string(0) ""
        ["ema_hostname"]=3D>
        string(17) "mailserver.domain.com"
        ["ema_port"]=3D>
        string(3) "110"
        ["ema_username"]=3D>
        string(8) "supptest"
        ["ema_password"]=3D>
        string(8) "password"
        ["ema_get_only_new"]=3D>
        string(1) "0"
        ["ema_leave_copy"]=3D>
        string(1) "0"
        ["ema_issue_auto_creation"]=3D>
        string(7) "enabled"
        ["ema_issue_auto_creation_options"]=3D>
        array(3) {
          ["only_known_customers"]=3D>
          string(2) "no"
          ["category"]=3D>
          string(1) "3"
          ["priority"]=3D>
          string(1) "5"
        }
      }
      [2]=3D>
      &int(1)
    }
  }
}