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,