Support

Admin Tools

#15769 Missing Database

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 nicholas on Tuesday, 16 April 2013 04:57 CDT

Tuesday, 16 April 2013 03:56 CDT

ideatrade
Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.9
PHP version: 5.3.8
MySQL version: 5.1.36
Host: Webair
Admin Tools version: 2.5.3

Description of my issue:

I have been having issues with my admin area showing the following errors constantly.
Error loading component: com_users, 1
Registration is not working

I have been searching for a solution for a few days, and finally turned on Debug.
I'm not sure if this is the issue, but Admin Tools is throwing an error.

~~ Debug ~~
JDatabaseMySQLi::query: 1146 - Table '1788_andtrr.08732_admintools_ipautoban' doesn't exist SQL=SELECT * FROM `08732_admintools_ipautoban` WHERE `ip` = '72.173.107.138'

Return to Control Panel

Call stack
#	Function	Location
1	JAdministrator->initialise()	/usr/www/virtual/server/www.website.com/administrator/index.php:34
2	JApplication->initialise()	/usr/www/virtual/server/www.website.com/administrator/includes/application.php:81
3	JApplication->triggerEvent()	/usr/www/virtual/server/www.website.com/libraries/joomla/application/application.php:230
4	JDispatcher->trigger()	/usr/www/virtual/server/www.website.com/libraries/joomla/application/application.php:642
5	JEvent->update()	/usr/www/virtual/server/www.website.com/libraries/joomla/event/dispatcher.php:161
6	call_user_func_array()	/usr/www/virtual/server/www.website.com/libraries/joomla/event/event.php:71
7	plgSystemAdmintoolsPro->onAfterInitialise()	 
8	plgSystemAdmintoolsPro->AutoIPFiltering()	/usr/www/virtual/server/www.website.com/plugins/system/admintools/admintools/pro.php:94
9	JDatabase->loadObject()	/usr/www/virtual/server/www.website.com/plugins/system/admintools/admintools/pro.php:2314
10	JDatabaseMySQLi->execute()	/usr/www/virtual/server/www.website.com/libraries/joomla/database/database.php:1062
11	JError::raiseError()	/usr/www/virtual/server/www.website.com/libraries/joomla/database/database/mysqli.php:396
12	JError::raise()	/usr/www/virtual/server/www.website.com/libraries/joomla/error/error.php:251


I checked and there is no database table for admintools_ipautoban

I uninstalled Admin tools and reinstalled, but there was no change.

Tuesday, 16 April 2013 04:57 CDT

nicholas
Joomla! won't try to create missing tables on reinstallation. It's a "feature" of the Joomla! extensions installer. Unfortunately, you will have to uninstall and reinstall the component. By doing so you will lose all of your configuration and have to reenter it.

That said, I am curious how you ended up in such a situation. The only way this particular table can be missing is either the component not having been installed correctly (unlikely, you'd have noticed), you dropped the table (unlikely, you'd have known about it), your host did something to the database (unlikely, you'd have other problems in other areas of your site and/or missing information) or you were hacked (unlikely, you'd have noticed more problems). I'm very curious what happened there!

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!

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!