Advertisement
Table Prefix not applied during install
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
- dagroupinc
- Joomla! Intern
- Posts: 87
- Joined: Tue Apr 06, 2010 6:09 pm
Table Prefix not applied during install
We are working on a development copy of an existing J4.4.5 website which was created from a backup copy of the live website. However, during the installation process the table prefix shown during the installation process in Joomla wasn't applied to the database for some reason so now all our tables exist without a table prefix. This is causing some issues.
Fixing this is a little out of my realm and was hoping someone here might provide instructions on how to correct this.
Can I easily add the prefix in mySQL and then modify Joomla and the config file to recognize the database with the new prefix?
Thanks in advance.
Fixing this is a little out of my realm and was hoping someone here might provide instructions on how to correct this.
Can I easily add the prefix in mySQL and then modify Joomla and the config file to recognize the database with the new prefix?
Thanks in advance.
Advertisement
-
- Joomla! Champion
- Posts: 6408
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Table Prefix not applied during install
You can add it in phpmyadmin.
https://gadsolutions.biz Electrical services
https://electrical-testing-safety.co.uk Testing services
https://electrical-testing-safety.co.uk Testing services
- Webdongle
- Joomla! Master
- Posts: 44695
- Joined: Sat Apr 05, 2008 9:58 pm
Re: Table Prefix not applied during install
Try https://docs.joomla.org/Copying_a_Jooml ... _Method.29 to make a copy of the site.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
- ceford
- Joomla! Hero
- Posts: 2878
- Joined: Mon Feb 24, 2014 10:38 pm
- Location: Edinburgh, Scotland
- Contact:
Re: Table Prefix not applied during install
In phpMyAdmin, select your database. Below the list of tables select the Check All check box. The With Selected list has items including Add Prefix. A popup prompts for the prefix to add.
- dagroupinc
- Joomla! Intern
- Posts: 87
- Joined: Tue Apr 06, 2010 6:09 pm
Re: Table Prefix not applied during install
added the table prefix using phpMyAdmin however I'm curious to learn why it wasn't added when it was specified during the install. One of the world's great mysteries ;-)
- Webdongle
- Joomla! Master
- Posts: 44695
- Joined: Sat Apr 05, 2008 9:58 pm
Re: Table Prefix not applied during install
You originally said that you "are working on a development copy of an existing J4.4.5 website which was created from a backup copy of the live website". If you did not use https://docs.joomla.org/Copying_a_Jooml ... _Method.29 to copy the site then you might have used the wrong database. Or the live database has two sets of prefixes. Without knowing how you created the copy it is difficult to accurately asses what went wrong.dagroupinc wrote: ↑Mon Sep 23, 2024 4:36 pm added the table prefix using phpMyAdmin however I'm curious to learn why it wasn't added when it was specified during the install. One of the world's great mysteries ;-)
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
- dagroupinc
- Joomla! Intern
- Posts: 87
- Joined: Tue Apr 06, 2010 6:09 pm
Re: Table Prefix not applied during install
We used an Akeeba back up of the entire website, created a new database, and performed a clean installation including the prefix. We've done this many times without any issues — except this time. It's been resolved, just a bump we've never experienced.
-
- Joomla! Champion
- Posts: 6408
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Table Prefix not applied during install
FYI, you don't have to create a database with akeeba as it creates it for you.
https://gadsolutions.biz Electrical services
https://electrical-testing-safety.co.uk Testing services
https://electrical-testing-safety.co.uk Testing services
- Webdongle
- Joomla! Master
- Posts: 44695
- Joined: Sat Apr 05, 2008 9:58 pm
Re: Table Prefix not applied during install
On Windows OS with wamp(or similar) localhost. Not sure if it does on a pc running Linux OS or on a mac
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
Advertisement