Ticket not showed if the elaborated email is an email forwarded: Page 2

Ticket not showed if the elaborated email is an email forwarded

PeopleInside

KevinTheJedi Hi,
the forwarded was created by a Gmail filter.

Now i removed the forward and I use Gmail labels just the Gmail filter for move some incoming email to the right label and archive... seems the ticket are visible.

Sorry, i don't think t's a database issue because i had this issue on two completely different OsTicket installations and one of this was a completely new installation.

In al case seems i was able to resolve.

PeopleInside

KevinTheJedi Hi, I still have this issue and now as the example in this topic was with custom query from you, I'm unable to fix.

I have two ticket empty cannot see so again the issue of duplicates in the database

How i can solve this?

SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 1 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 2 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 6 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 9 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 3 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 7 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 10 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 4 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 5 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 11 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 8 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 12 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 13 AND A1.`staff_id` = 1int(1) SELECT A1.* FROM `ostnh_queue_config` A1 WHERE A1.`queue_id` = 14 AND A1.`staff_id` = 1int(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1) SELECT A1.`id`, A1.`parent_id`, A1.`columns_id`, A1.`sort_id`, A1.`flags`, A1.`staff_id`, A1.`sort`, A1.`title`, A1.`config`, A1.`filter`, A1.`root`, A1.`path`, A1.`created`, A1.`updated`, A2.`id`, A2.`parent_id`, A2.`columns_id`, A2.`sort_id`, A2.`flags`, A2.`staff_id`, A2.`sort`, A2.`title`, A2.`config`, A2.`filter`, A2.`root`, A2.`path`, A2.`created`, A2.`updated`, A3.`id`, A3.`root`, A3.`name`, A3.`columns`, A3.`updated` FROM `ostnh_queue` A1 LEFT JOIN `ostnh_queue` A2 ON (A1.`parent_id` = A2.`id`) LEFT JOIN `ostnh_queue_sort` A3 ON (A1.`sort_id` = A3.`id`) WHERE A1.`id` = 0 ORDER BY A1.`sort` ASCint(1)
SELECT A1.* FROM `ostnh_queue_sort` A1 WHERE A1.`id` = 1 ORDER BY A1.`name` ASCint(1) SELECT A1.* FROM `ostnh_queue_sort` A1 WHERE A1.`id` = 2 ORDER BY A1.`name` ASCint(1) SELECT A1.* FROM `ostnh_queue_sort` A1 WHERE A1.`id` = 3 ORDER BY A1.`name` ASCint(1) SELECT A1.* FROM `ostnh_queue_sort` A1 WHERE A1.`id` = 4 ORDER BY A1.`name` ASCint(1) SELECT A1.* FROM `ostnh_queue_sort` A1 WHERE A1.`id` = 6 ORDER BY A1.`name` ASCint(1) SELECT A1.* FROM `ostnh_queue_sort` A1 WHERE A1.`id` = 7 ORDER BY A1.`name` ASCint(1)
[Avanzata]
Open
SELECT A1.* FROM `ostnh_list` A1 WHERE A1.`type` = 'ticket-status' ORDER BY A1.`name` ASCint(1)

PeopleInside

I need to find another solution as OsTicket still have this issue and made me loosing ticket, unable to manage in the interface even in a new install. I opened a bug because I'm sure something wrong.

Now I have no idea of what other ticket software free I can use.
I think I will try to find a solution asap as I have a broken ticket system installed some months ago from zero with a lot of work for resolve this issue but still have.

https://github.com/osTicket/osTicket/issues/5639

« Previous Page