Ask not what osTicket community can do for you - ask what you can do for osTicket community

Go Back   osTicket Forums > Project Tools > osTicket Bug Tracker > Bug

Issue Type Bug   Project osTicket Bug Tracker
typo
won't show any tickets when clicking ie 'view open', only when using advanced search
Category Unknown
Affected Version 1.6.0 rc3
Priority Unknown
Status Fixed
Fixed Version 1.6 rc4
Submitted 01-30-2008
Assigned Users (none) Tags (none)

issueid=48 01-30-2008 08:57 AM
Junior Member
typo
won't show any tickets when clicking ie 'view open', only when using advanced search

Problem:
When logging in, no tickets are shown, not after clicking 'View open', 'View closed' or whatever. Only when doing a blank advanced search.

Solution:
Change all occurrences of 'Open' to 'open' (lower case) in include/staff/tickets.inc.php. This did the trick for me (status column in ost_tickets table is of type enum('open', 'closed'), not enum('Open','Closed').

nb; it might be a specific problem for my mysql server version (5.0.27), don't know how mysql normally handles cases.

hope it's helpfull
Reply

01-30-2008 09:22 AM
Issue Changed by giorgio
  • summary changed from won't show any tickets when clicking ie 'view open', only when using adanced search to won't show any tickets when clicking ie 'view open', only when using advanced search
01-30-2008 10:37 AM
Issue Changed by peter
  • Status changed from Unconfirmed to Fixed
  • Issue marked as addressed

Issue Tools
Subscribe to this issue

All times are GMT -4. The time now is 08:38 AM.