Support

Hi,

I apologize in advance for posting this here but I couldn't find a public repository to submit a pull request.

This is a fix for ticket #40260 for Akeeba Ticket System: https://www.akeeba.com/support/akeebatickets/40260-my-tickets-menu-item-shows-the-application-has-stopped-responding-error-to-users.html

Edit file components/com_ats/src/Model/CategoryModel.php and update lines 286 - 292

from:

$query->extendWhere('AND', [ $db->quoteName('t.public') . ' = :public', $db->quoteName('t.created_by') . ' = :myUserId', $db->quoteName('i.user_id') . ' = :myUserId', ], 'OR') ->bind(':public', $public, ParameterType::INTEGER) ->bind(':myUserId', $myUserId, ParameterType::INTEGER);

to:

$query->extendWhere('AND', [ $db->quoteName('t.public') . ' = :public', $db->quoteName('t.created_by') . ' = :myUserId', $db->quoteName('i.user_id') . ' = :myUserId2', ], 'OR') ->bind(':public', $public, ParameterType::INTEGER) ->bind(':myUserId', $myUserId, ParameterType::INTEGER) ->bind(':myUserId2', $myUserId, ParameterType::INTEGER);

 

Regards

Hi Nicholas,

Long time indeed! I hope you are doing well!

I am using MySQLi. To be honest, I didn't troubleshoot this in depth, I just had the idea to pass a second parameter with the same value and it worked. So this is more a workaround than a fix.

I think that this is probably caused by prepareParameterKeyMapping as you pointed out.

 

Regards

 

You're welcome! I'm glad to hear you're doing great.

Good luck with Joomla's database driver.... If you need any further assistance, feel free to reach out.

Have a wonderful day as well!