Support

Admin Tools

#14131 Mixed table prefixes in table - Can't amend jos_

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 Thursday, 22 November 2012 07:17 CST

user68469

Mandatory information about my setup:

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.8
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Admin Tools version: Latest

Description of my issue:

When I look at my MySQL database related to my Joomla site, it has tables prefixed with the prefix I chose (let's make one up for here, say mt7). But there are also a whole load of tables in the same database prefixed with jos_

Admin Tools gives me the option to update only the ones prefixed by my own prefix like mt7 and not those beginning jos_. The field showing the prefix to be changed shows a no-entry sign when you hover over it, so there is no way of changing the jos_tables.

Should they be there? And if not, how can I change them?

Thanks

nicholas
Akeeba Staff
Manager

Your site only uses the database prefix which is found in the configuration.php file and which you can easily see by going to Global Configuration and clicking on the Server tab. The current prefix can be found in the top right corner, next to the "Database Tables Prefix" label. This is the one and only one prefix this particular site recognises as its own. As a result, it's the one and  O N L Y   O N E  prefix Admin Tools should ever touch. If it did touch a table with another prefix it would be an immense bug.

Where the other tables come from? I have absolutely no idea. You should know. An older Joomla! installation you forgot to clean up its tables before installing / restoring your new site? Another Joomla! site sharing its database with your site? You manually restored a database backup and used the wrong prefix? I can't answer that. I can only tell you that what Admin Tools is doing is what it is supposed to do. What you want to do it would be a huge bug and should never, ever be attempted.

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!

user68469

Thanks Nicholas,

Just to explain...

This is the first Joomla site I have ever created, and the first time I've used your software or anyone else's to secure it, and the first time I've ever used phpMyAdmin to look at the database.

So it was confusing to me that your software did not amend what seemed to me relevant - particularly when my web host replied to me - when I asked a similar question - that Joomla needs the jos_files to run. I guessed that was not correct at the time but I needed some clarification.

Thank you for the suggestions as to what might have caused this, and for the confirmation that Admin Tools would deal with everything that was relevant. I can now look into the other issues myself.

But due to my naivety, could you please confirm one thing for me: that is that in a Joomla 2.5 site with my own custom prefix, no files, directories or other references should be there with a jos_ prefix?

Thanks

Β 

nicholas
Akeeba Staff
Manager

So it was confusing to me that your software did not amend what seemed to me relevant - particularly when my web host replied to me - when I asked a similar question - that Joomla needs the jos_files to run. I guessed that was not correct at the time but I needed some clarification.

Eek! Your host's information is two years old. Ever since Joomla! 1.7 the Joomla! installer started randomising the prefix of the database tables for security reasons (the same reasons which resulted in me adding that feature in Admin Tools about 2 1/2 years ago). So, no, the jos_ tables are not required unless your configured database table prefix is jos_. I told you how to check this. I'm under the impression that your prefix is mt7_ based on what you told me in your original post, but you'd better check this.

Thank you for the suggestions as to what might have caused this, and for the confirmation that Admin Tools would deal with everything that was relevant. I can now look into the other issues myself.

You're welcome!

But due to my naivety, could you please confirm one thing for me: that is that in a Joomla 2.5 site with my own custom prefix, no files, directories or other references should be there with a jos_ prefix?

Yes, I am 99.999% sure about that. I am leaving a 0.001% doubt just in case a braindead extension installs all of its tables with a hardcoded jos_ prefix. You know what? If you give me a list of all of your tables in your database I can quickly see if the jos_ tables are rubbish or if they fall into this 0.001% odditty.

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!

user68469

Thanks for the offer Nicholas, but I always like to look into things myself - that way you learn.

But thanks or the reassurance - 99.999% certainly warrants me looking into it earnestly.

Thanks again

Β 

nicholas
Akeeba Staff
Manager

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!