I cannot close the tickets from the web and I want to know in which table I can perform a query to close them
@Norvingc
I would think it'd be more beneficial to figure out why you can't close the tickets, but to each their own. You can find this info in the %TABLE_PREFIX%ticket table. The column is called status_id.
%TABLE_PREFIX%ticket
status_id
Cheers.