Little help needed.
I've been working on a site with prefixes and now I have hit a snag as I'm getting parse errors which after 2 uninstalls and reinstalls I've come to the conclusion is due to the table prefixes that are set up on this site. In order to test my theory and also to make everything work as it should do I need to drop the prefixes from the whole database.
I've taken a backup and am in the process of going through and doing this manually. Of course this is taking ages. I've been at it for 2 hours already and am not even 50% of the way through it.
Is there an easier way? Preferably one that I can just run as a query to modify the tables and drop the prefixes. I would like to keep the current tables intact though just in case I'm wrong.
(PS I know I need to remove the prefix from config.php too but I'll do that at the end.)
All help appreciated as always.
Kerry-Anne
I've been working on a site with prefixes and now I have hit a snag as I'm getting parse errors which after 2 uninstalls and reinstalls I've come to the conclusion is due to the table prefixes that are set up on this site. In order to test my theory and also to make everything work as it should do I need to drop the prefixes from the whole database.
I've taken a backup and am in the process of going through and doing this manually. Of course this is taking ages. I've been at it for 2 hours already and am not even 50% of the way through it.
Is there an easier way? Preferably one that I can just run as a query to modify the tables and drop the prefixes. I would like to keep the current tables intact though just in case I'm wrong.
(PS I know I need to remove the prefix from config.php too but I'll do that at the end.)
All help appreciated as always.
Kerry-Anne
Comment