possible bug

[Eric Frazier]

Hi,

Great debugging output! It looks like there was a problem with this insert 
when [only_known_customers] => no is set. The iss_usr_id is missing.

Thanks,

Eric




Hello,

An error was found at 04/07/2005 14:01:01 (1112882461) on line '1487' of 
script '/usr/home/eventum/public_html/include/class.issue.php'.

The error message passed to us was:

'DB Error: syntax error'

A more detailed error message follows:

'INSERT INTO
eventum.e_issue
(
iss_prj_id,
iss_prc_id,
iss_pri_id,
iss_usr_id,iss_sta_id,
iss_created_date,
iss_last_public_action_date,
iss_last_public_action_type,
iss_summary,
iss_description
) VALUES (
2,
4,
7,
,1,
'2005-04-07 14:01:01',
'2005-04-07 14:01:01',
'created',
'auto create issue??',
'test auto create issue\r\n\r\n\r\nLead Programmer\r\nD.M. Contact 
Management\r\n250.383.8267 ext 229 \r\n\r\n\r\n'
) [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 '1,
'2005-04-07 14:01:01',
'2005-04-07 ' at line 17]'

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

The user agent given was ''.

Sincerely yours,
Automated Error_Handler Class

A backtrace is available:

Array
(
[0] => Array
(
[file] => /usr/home/eventum/public_html/include/class.support.php
[line] => 632
[function] => createfromemail
[class] => issue
[type] => ::
[args] => Array
(
[0] => 2
[1] => 1
[2] => Eric <ef@stripped>
[3] => auto create issue??
[4] => test auto create issue


Lead Programmer
D.M. Contact Management
250.383.8267 ext 229



[5] => 4
[6] => 7
[7] => Array
(
[0] => 3
)

[8] => 2005-04-07 19:56:00
)

)

[1] => Array
(
[file] => /usr/home/eventum/public_html/include/class.support.php
[line] => 520
[function] => createissuefromemail
[class] => support
[type] => ::
[args] => Array
(
[0] => Array
(
[ema_id] => 2
[ema_prj_id] => 2
[ema_type] => pop3/notls
[ema_folder] =>
[ema_hostname] => mail.server.com
[ema_port] => 110
[ema_username] => support%example.com
[ema_password] => tardislec
[ema_get_only_new] => 0
[ema_leave_copy] => 1
[ema_issue_auto_creation] => enabled
[ema_issue_auto_creation_options] => Array
(
[only_known_customers] => no
[category] => 4
[priority] => 7
[users] => Array
(
[0] => 3
)

)

)




[2] => test auto create issue






[3] => 2005-04-07 19:56:00
[4] => Eric <ef@stripped>
[5] => auto create issue??
)

)

[2] => Array
(
[file] => /usr/home/eventum/public_html/misc/download_emails.php
[line] => 133
[function] => getemailinfo
[class] => support
[type] => ::
[args] => Array
(
[0] => Resource id #246
[1] => Array
(
[ema_id] => 2
[ema_prj_id] => 2
[ema_type] => pop3/notls
[ema_folder] =>
[ema_hostname] => mail.server.com
[ema_port] => 110
[ema_username] => support%example.com
[ema_password] => password
[ema_get_only_new] => 0
[ema_leave_copy] => 1
[ema_issue_auto_creation] => enabled
[ema_issue_auto_creation_options] => Array
(
[only_known_customers] => no
[category] => 4
[priority] => 7
[users] => Array
(
[0] => 3
)

)

)

[2] => 4
)

)

)