Maybe it's just me....

[orionsat]

G'Day guys!I've had a horrendous time getting this setup on IIS6, however, I seem to be almost there!!! EEK!

The ONLY thing that I can see is wrong with my install is the fact that POP3 will only retreive the top message (first one) in the mailbox. It also leaves the mail in there once it has created the ticket!Am I doing something wrong?

If you need any info to help you out, please let me know!


Cheers,

Dave

[orionsat]

EDIT: I'm also getting some dodgy error when running cron/index.php?_t=parser:
PHP has encountered an Access Violation at 03567BF0Total Messages in Inbox: 2
Fetching Msg Num: 1
Account is POP3
Fetching Msg UID: 1

And sometimes, I get this error (1 in 5):

PHP has encountered an Access Violation at 03567BF0Total Messages in Inbox: 2
Fetching Msg Num: 1
Account is POP3
Fetching Msg UID: 1
Invalid SQL: INSERT INTO `swauditlogs` (`ticketid`, `staffid`, `departmentid`, `userid`, `dateline`, `logtype`, `actiontype`, `actionmsg`) VALUES ('15', '', '1', '6', '1187332001', '5', '14','Setting due time to: 18 Aug 2007 07:26 AM'),('15', '', '1', '6', '1187332001', '2', '11','New ticket created by Dave Forster'); (Incorrect integer value: '' for column 'staffid' at row 1)


Hope this helps! :S
Dave

[netFusion]

These errors sound like you have a problem with your PHP install or the PHP DLL's.

The reason you are only getting one message out of the POP3 account is because PHP is crashing when trying to process the POP3 calls.

First place I would suggest to look is at your PHP installation and verify that all of the PHP_*.DLL's that are being loaded are of the same version that your PHP is.

Also you might enable logging in the PHP.INI file and see if the errors that show up in your log can point you in a more helpful direction.

Good luck!

[Mahesh Slaria]

Hi,
This error occure in our previous builds if your SQL_MODE is set to "NO_AUTO_VALUE_ON_ZERO".

It is fixed in our upcoming CVS build. You can also fix this error by removing "NO_AUTO_VALUE_ON_ZERO" from your SQL_MODE.

Thanks.

Regards,

[orionsat]

Originally Posted by Mahesh Slaria

It is fixed in our upcoming CVS build. You can also fix this error by removing "NO_AUTO_VALUE_ON_ZERO" from your SQL_MODE.

Where do I change this value???

[blaforce]

I remarked out sql-mode (#sql-mode=.....) in my.ini and restarted mysql. It worked for me. Seems like they are still using old sql commands that do an auto conversion.
Brian

[supportskins]

Originally Posted by orionsat

Where do I change this value???

You can find this in the my.cnf file (incase of Windows server it will be my.ini file)

[dim01dim01]

I restarted IIS and it worked.