Support

Admin Tools

#10885 500 - An error has occurred.

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 Monday, 30 January 2012 11:52 CST

user54778
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting? yes
Have I searched the tickets before posting? yes
Have I read the documentation before posting? yes
Joomla! version: 2.5.0
PHP version: 5.2.12
MySQL version: 5.0.45
Host: iPower
Admin Tools version: 2.2.a3

Description of my issue:
After runing Admin Tools to upgrade my Joomla! 1.7.3 site to 2.5.0. the following error message was displayed when trying to view users or add a new one. The table name was deleted from this post for security reasons. The prefix was replaces with '[deleted]'.

500 - An error has occurred.
Table '[deleted]_user_notes' doesn't exist SQL=SELECT n.user_id, COUNT(n.id) As note_count FROM [deleted]_user_notes AS n WHERE n.user_id IN (44,42,34,45,46,51,43,47,48,49,50) AND n.state >= 0 GROUP BY n.user_id

Return to Control Panel

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

nicholas
Akeeba Staff
Manager
Go to Extensions, Database. It will find some errors. Click on the Fix button at the bottom of the list of errors. If this still doesn't work, please ask your host to grant ALTER TABLE privileges to your database user and retry the aforementioned procedure.

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!

user54778
Perfect 100% solution.

Thanks

nicholas
Akeeba Staff
Manager
Awesome! You're welcome :)

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!