Admin Tools

#37630 Data too long for column 'data' at row 1

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

4.2.1

PHP version

8.0.22

Admin Tools version

7.1.10

Latest post by nicholas on Saturday, 18 February 2023 06:47 CST

Tuesday, 30 August 2022 13:38 CDT

incolor

I'm trying to complete a PHP security scan, but I quickly get this error:

Data too long for column 'data' at row 1

Is there a way around this?

Oh, BTW, the search feature for the Akeeba forums doesn't work correctly

Wednesday, 31 August 2022 03:07 CDT

nicholas

Go to Components, Admin Tools for Joomla, Control Panel, Options, File Scanner and set “Calculate diffs when scanning” to No.

There is a file in Joomla 4.2.1 which generates a difference view (diff) larger than the maximum space we have allocated for diff's in the database. It happened to me on 4.2.1-RC2 and my wife confirmed it on one of her clients' site upon upgrade to 4.2.1. Trying to identify and fix this is on my to-do list for today.

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!

Friday, 17 February 2023 15:18 CST

incolor

This just happened now after my update to Joomla 4.2.8. I'm using Admin Tools Professional 7.2.3.

Saturday, 18 February 2023 06:47 CST

nicholas

Version 4.2.8 is newer than 4.2.1. The file in question started existing SINCE version 4.2.1 (which was the latest version when we last had this discussion in August), therefore it still exists in version 4.2.8.

The solution is exactly the same as what I gave you in August.