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