Tickets Fixed Merging Tickets doesn't update user

[Alpha1]

A guest opened a ticket. Then registered and opened another ticket. I merged the tickets, but the new ticket only has the guest as the ticket owner. I am not sure if the member can reply.

If possible then please provide an urgent fix, because the ticket is very important to us.

 

[Naz]

Can you run this query and send me the results via PM:

select ticket.ticket_id, ticket.user_id,  ticket.username, ticket.user_name, ticket.user_email
from xf_nixfifty_ticket as ticket
where ticket.ticket_id = x

Replace X with the ticket ID. Please also provide the username of the registered account and its associated user ID. I can provide you a query after that to iron this out if the owner isn't the expected user.

 

[Alpha1]

#1054 - Unknown column 'xf_nixfifty_ticket.ticket_id' in 'where clause'

 

[Naz]

#1054 - Unknown column 'xf_nixfifty_ticket.ticket_id' in 'where clause'

Weird, does the ticket_id column exist in the xf_nixfifty_ticket table?

Try this one, though I'm not sure why the first wouldn't have worked if you're querying the right db and table:

select ticket_id, user_id,  username, user_name, user_email
from xf_nixfifty_ticket
where xf_nixfifty_ticket.ticket_id = 36

 

[Naz]

Fixed this up. It'll now attach to the first non-guest user from the batch of tickets getting merged (if the target ticket is a guest one).