Support

Admin Tools

#15106 Table Prefix

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, 21 February 2013 11:09 CST

digitologie

Hi, i have a seious probem with admin tools. after change the prefix, he doent change all tabels. so when i go than to make a backup with akeeba and reinstall on other server...no chance to get the joomla running there because there are now 3 different prefixxes in my db.... - is there any workaround or why it is in this case 3 different prefixes?

nicholas
Akeeba Staff
Manager

If Admin Tools did not change all of your tables' prefixes you would not be able to use your site. So there's something different going on.

If one of the prefixes you see is bak_ you can remove those tables. They are created when you choose "Backup" instead of "Drop" for old tables during restoration.

It would help me to know what are the other two prefixes you see, what is the prefix your site is currently using and if there is a table overlap, e.g. when you see abc_users and xyz_users it's overlap.

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!

digitologie

Hi, thx for the fast answer

there are now 3 in one and the same database...:

x8hds_
jos_
m7dem_

would this help u?

best regards from germany

nicholas
Akeeba Staff
Manager

jos_ seems to be a leftover from the olden days of Joomla! 1.5, 1.6 or 1.7. Regarding the other two, which one is currently in use by your site? You can figure that out by going to Global Configuration or by visiting Admin Tools' table prefix change page where the current prefix is stated above the textbox.

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!

digitologie

Hi, this is the from admin tools backend x8hds_ - so it means i can delete the old ones? the jos_ is used by activehelper and this component is still in use...

Frondend works fine...only i cant access the backend. when i change the prefix in config.php i get the backend work but...than many things are missing in the joomla backend. menus and extensions arent there. dont know... - its first time that i have tested the admin tools prefix change :-) so normal i would kick me in my own ass ;-) hahaha...

nicholas
Akeeba Staff
Manager

Hi, this is the from admin tools backend x8hds_ - so it means i can delete the old ones?

Yes, correct. Just in case, please do take a backup before deleting old tables.

the jos_ is used by activehelper and this component is still in use...

I would recommend not using that component. This is bad practise and should be avoided. Using the metaprefix (#__) in the code is the first thing a Joomla! developer learns.

Frondend works fine...only i cant access the backend. when i change the prefix in config.php i get the backend work but...than many things are missing in the joomla backend. menus and extensions arent there. dont know... - its first time that i have tested the admin tools prefix change :-) so normal i would kick me in my own ass ;-) hahaha...

This means that you have extensions which are either hardcoding the table prefix or they don't use the metaprefix (#__) correctly. In this case you can't change your prefix and you have to find out which extensions exhibit this behaviour and change them. Look, sometimes extensions can't do otherwise. For example if you are using a forum bridge component it usually has to cache the table name prefix and not allow you to change it. This is because it's interfacing with a non-Joomla! extension and most developers don't understand how easy it is to import and use Joomla!'s configuration.

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!

digitologie

nicholas, thank u so much...i will find out...and u are right! :-)

digitologie

nicholas, thank u so much...i will find out...and u are right! :-)

nicholas
Akeeba Staff
Manager

You're welcome, JΓΌrg!

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!