Support

Admin Tools

#31949 Error after update

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 on Friday, 13 December 2019 17:17 CST

Friday, 01 November 2019 08:17 CDT

Spaargids
Hello,
I have updated my admintools installation from 5.3.4 to 5.4.0 and I get this message:
We have detected that one or more tables with the j25_admintools_ prefix are broken. Admin Tools will not work properly. Please ask your host to repair these tables and then click here to let Admin Tools update its database tables.
When I press the "click here" I get this error:
Unknown column 'tag' in 'j25_admintools_scans' SQL=ALTER TABLE `j25_admintools_scans` ADD COLUMN `backupid` varchar(255) DEFAULT NULL AFTER `tag`

Could you tell me how to solve it?
Regards,
Manolis

Friday, 01 November 2019 09:02 CDT

nicholas
The table j25_admintools_scans seems to be genuinely broken. Delete the table j25_admintools_scans from your database and visit Admin Tools again. The table will be replaced with the correct one. Please note that this will remove all your previous PHP File Change Scanner scan reports.

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!

Monday, 11 November 2019 07:38 CST

Spaargids
Hello,
I have deleted the table but I see that it creates it again without this column and the error is the same.
What to check next?

Regards,
Manolis

Tuesday, 12 November 2019 00:48 CST

nicholas
Can you please try installing this development preview release? I think I know what's going on and this version addresses it but I'd appreciate your feedback on that.

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!

Tuesday, 12 November 2019 03:46 CST

Spaargids
Hello,
When I tried to install it it got:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'run'',MODIFY COLUMN `origin` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_g' at line 1 SQL=ALTER TABLE `j25_admintools_scans` MODIFY COLUMN `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL ,MODIFY COLUMN `status` enum('run','fail','complete') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''run'',MODIFY COLUMN `origin` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''backend'' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

But after pressing the button to fix the table, now it has no errors.
Could I use it for live site or you will update the stable?

Regards,
Manolis

Wednesday, 13 November 2019 06:05 CST

nicholas
I cannot reproduce your issue. To be clear, I installed Admin Tools 5.3.4 on a Joomla 3.9.11 site and upgraded it to the same dev release I told you to download. No problem.

Moreover, I created a new Joomla 3.9.11 site where I installed Admin Tools 5.3.4. I deleted the admintools_scans table as I told you to do and installed the Admin Tools dev release. Again, no problem.

Also, to be sure that I've covered all bases I created yet another new Joomla 3.9.11 site where I installed the dev release of Admin Tools (fresh install, not an upgrade). No problem either.

Furthermore, the SQL query that you have a problem with is not something that happens during installation of our software. Are you getting this problem when you do something else, after you have installed our software? If so, exactly what? I don't even know which "button to fix the table" you are referring to.

I think that you are describing your interpretation of what is going on, not what is actually going on. Please be very specific about what you do. Use screenshots if you cannot put it into words.

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, 13 December 2019 17:17 CST

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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!