Support

Akeeba Ticket System

#40471 Remove and reinstall - what remains

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
4.4.3
PHP version
8.1.2
Akeeba Ticket System version
5.3.5

Latest post by tampe125 on Thursday, 21 March 2024 10:36 CDT

MOLEDesign

Hi

I created a brand new site- for internal use and one of the users has modified various pieces of code from the old joomla3 versions of software and ATS is partially shafted

It works fully backend, and tickets can be logged but any front end function that 'lists tickets' is utterly shafted

 

Akeeba Ticket System - An unhandled Exception has been detected 500 The number of variables must match the number of parameters in the prepared statement

 

I assumed it was a bogus override but even after these have been removed, error still persists. Sadly this individual is on leave but i am guessing he has changed some core views and fields.

No backup
No version control
Just someone who 'thinks he knows what he is doing'

I would like to remove and reinstall ATS which seems ideal, however there are a LOT of custom fields which will take hours to recreate

If i remove ATS, will the fields and categories disappear or stay and be picked up by the new ATS?

tampe125
Akeeba Staff

Hello,

no, I think you just hit a bug in PHP database driver. Inside Joomla Global Configuration can you please switch the database driver from MySQLi to MYSQL (PDO) (or viceversa, can't remember what's the affected driver)?

That should fix your issue.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

MOLEDesign

Actually we tracked this error down.

Anyone who is a SUPER USER who uses the front end, Akeeba works perfectly fine

Anyone who is a NORMAL user gets the error when doing anything related to listing tickets - they can raise tickets - just they get this error when looking at 'My Tickets'. Got to assume its somehow a permissions issue - but i will look into your fix as well

MOLEDesign

Urgh - yeah permissions

 

I just gave REGISTERED allowed for EVERYTHING in ATS and the pages now work.. 

 

Must have a config wrong, but i can work that through - as it stands this ticket is likely 'done' as it was error at our end,

tampe125
Akeeba Staff

mhm... I suspect the problem has been just avoided with the change of permissions. Please try the suggested solution, we already had some reports about that and switching the driver fixed it.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

MOLEDesign

Next time i listen to you and wait patiently for your super fast replies

 

I put permissions back and then switched to PDO - and all good

 

Many thanks!

tampe125
Akeeba Staff

You're welcome!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!