Support

Admin Tools

#36597 Error SQL Data truncated for column 'reason' at row 711

Posted in ‘Admin Tools 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
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by formfranska on Thursday, 10 February 2022 03:13 CST

Wednesday, 09 February 2022 11:50 CST

formfranska

On 7 different Joomla sites I get this error when trying to update Admin Tools Pro 7.0.10 to 7.1.0
They all have the same Joomla version and PHP version. It's on two different hosts.

What is really weird is that I made the update successfully on two subdomains of one of the sites where the update failed (alsosame Joomla version and PHP version).

The error message I got in the Joomla backend when trying to update:

---
JInstaller: :Install: Error SQL Data truncated for column 'reason' at row 711
Extension installation aborted.
Package Update: There was an error installing an extension: com_admintools-pro.zip

---

Please help

Edited by on 2022-03-11 20:45 CST

Thursday, 10 February 2022 01:30 CST

nicholas

We know why this happens. We will release a new version today to address this. Meanwhile try this workaround.

Go to Components, Admin Tools, Web Application Firewall, Blocked Requests Log. 

Delete all of the log entries.

Go to System, Maintenance, Database.

Select Admin Tools.

Click on the Update Schema button in the toolbar.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 10 February 2022 03:13 CST

formfranska

OK, Super! Thank you Nicholas! Your workaround fixed it 😊

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!