Support

Admin Tools

#38726 Error attempting update Joomla 4 version 7.3.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.8
PHP version
8.1.16
Admin Tools version
7.3.0

Latest post by jordand714 on Wednesday, 15 March 2023 04:28 CDT

jordand714

In attempting to update the Admin Tools package from 7.3.0 to 7.3.1 I receive the following error:

BIGINT UNSIGNED value is out of range in "deitelco_db'.'adaof_menu'.'level' - 1'

Package Update: There was an error installing an extension: com_admintools-pro.zip

This same error appears whether I try to use the install feature by downloading first or the update feature in my Joomla 4 site (screenshot attached)

Thanks for looking into this. Doug

tampe125
Akeeba Staff

Hello,

this message doesn't come from our code, it seems that something wrong happened while upgrading to Joomla 4.

Please get inside System - Maintenance - Database and check if Joomla is reporting anything to you. If so, please try to repair your database by clicking on the Fix button.

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!

jordand714

I checked... there does NOT appear to be any problem with the database. (see attached screenshot)

Before I go poking around like an amateur... any other ideas on where I should look... or what I should do?

Thanks.

 

jordand714

OK... I was running Joomla 4.2.8... looks like 4.2.9 was available... well I installed that newer version then tried to update Admin Tools to 7.3.1... AND IT WORKED!

So I'm good for now... except that there was a warning message relating to .htaccess

.htaccess Update Concerning Setting the Content-Encoding Header

Since version 4.2.9

Before 4.2.9 the default htaccess.txt file contained erroneous code for appending the "Content-Encoding" HTTP header. This could result in double encoding errors when Joomla is installed in a subdirectory and both this directory and its parent directory contain an .htaccess file with this code. You should manually apply the necessary changes to any existing .htaccess file, as this file can not be updated automatically.

The old code:

Header append Content-Encoding gzip

The new code:

Header set Content-Encoding gzip

Since I use the .htaccess maker in my Admin Tools Pro... does this message apply to me?

Again... thanks.

nicholas
Akeeba Staff
Manager

No, it does not. If you are using the .htaccess Maker you cannot have one site as a subfolder of another because the cascading of .htaccess will make it impossible for the nested site to work correctly. Therefore the trigger for this issue does not apply at all to you.

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!

jordand714

Thank you. Closing this ticket. Always appreciate your support.

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!