osTicket Community Forums

email case sensitive? Results in 404 server error

Hello,

I recently had a customer create a new ticket. He enter his email address in upper case. When he returned to check the status of his ticket, he entered his email as lower case, and got a 404 server error. I tried it myself and found that you must enter your email in the same case in order to have success.

I know PHP and would like to put a patch in myself until this gets fixed. Can someone just point me the PHP module I need to work on?

Thanks,
Tony Zampini

the characters of the email should be set to low letters before saving and checking with database.

I added the following lines to the class.pop3.php file, function create ticket immediately before the return:

// clean up all tickets for lower case email, upper case name and subject
$sql='update ost_ticket set email = lower(email), name = upper(name), subject = upper(subject) ';
db_query($sql);


this standardizes all tickets in my system regardless of what is entered via the user then.

In my case, this affects all new tickets when an email ticket is entered which is the most frequent place in mine to process them. You could just as easily put this on the tickets page (part of the tickets.inc.php up in the query section to ensure it's called more often) but I think it would affect page load speed. Since the pop3 function calls are offline (via the cron job), and only if the ticket link is pressed on the ticket's page, it's works well enough for me.