Support

Admin Tools

#9720 Database table prefix editor - not working as intended?

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, 21 December 2010 02:08 CST

user20478
I just upgraded my admin tools pro to 1.1, and I'm having some problems with changing my database prefix.

I tried to change it on a site which had the standard jos_ prefix, changed it to asdf_, clicked the button "Change my prefix", and I get this error:

Parse error: syntax error, unexpected '"' in /home/blabla/configuration.php on line 52

On every page of my site that's all I get. So I checked my configuration.php file, like 52 is the password line. That's weird I thought, but then I realised what the problem was. All the ' had been replaced with ". So I did a search and replace from " to ', and everything worked fine again. Turns out the database prefix change also worked, as my prefix is now asdf_.

I honestly don't know why this happened, but at least it was an easy fix. However I would like to find out if this is normal behaviour, or perhaps I have some settings not configured properly somewhere?

Oh and also I was unable to update the admin tools straight from the backend, I had to go to akeebabackup and download it and then upload it, causing all my settings to reset :(.

Anyway the update problem is not much of an issue as I know how to configure the firewall and .htaccess easily from admin tools, but the database prefix problem is quite scary.

Any thoughts on what might have happened?

Thanks in advance,

nicholas
Akeeba Staff
Manager
I have only one idea about this issue. Please go to your site's back-end, click on the Help, System Info menu items and then click on the PHP Information tab. Look for the "magic_quotes_runtime" header in the "PHP Core" table. Is it On or Off? This will allow me to try replicating this issue.

Regarding the live update, if your server doesn't support downloading files from remote servers using cURL or fopen() URL wrappers, it won't really work. Downloading the installation archive from our site and installing it on top of the existing component is the alternative upgrade path.

Regarding the overwritten configuration, it happened because I had to change the way .htaccess Maker's settings are stored in the database. With the previous method most servers would automatically reset the configuration values as soon as you tried entering custom .htaccess code in the .htaccess Maker page. This version permanently fixes this issue and I don't think that settings will be lost again when updating Admin Tools.

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!

user20478
Hi, thanks for replying so quickly.

The magic_quotes_runtime is Off on both Local and Master Values.

nicholas
Akeeba Staff
Manager
OK, so we have the same environment. That's strange. There is no substitution of double with single quotes anywhere in the code. This seems something very specific to your host. If you'd like me to debug this, you can send me the URL and Super Administrator login details to your site by means of a direct Personal Message. I am user "nicholas". This will allow me to debug this issue directly on your server.

VERY IMPORTANT: Please include a link back to this post, otherwise it's impossible for me to know why you're sending me the PM.

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!