Advertisement

Table Prefix not applied during install

Need help installing Joomla! 4.x? For all Joomla! 4.x installation issues please use this forum.

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
Post Reply
User avatar
dagroupinc
Joomla! Intern
Joomla! Intern
Posts: 83
Joined: Tue Apr 06, 2010 6:09 pm

Table Prefix not applied during install

Post by dagroupinc » Thu Aug 08, 2024 2:24 pm

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.

Advertisement
gws
Joomla! Champion
Joomla! Champion
Posts: 6398
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Table Prefix not applied during install

Post by gws » Thu Aug 08, 2024 2:50 pm

You can add it in phpmyadmin.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44649
Joined: Sat Apr 05, 2008 9:58 pm

Re: Table Prefix not applied during install

Post by Webdongle » Fri Aug 09, 2024 12:55 am

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".

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2869
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Table Prefix not applied during install

Post by ceford » Fri Aug 09, 2024 3:19 pm

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.

User avatar
dagroupinc
Joomla! Intern
Joomla! Intern
Posts: 83
Joined: Tue Apr 06, 2010 6:09 pm

Re: Table Prefix not applied during install

Post by dagroupinc » 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 ;-)

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44649
Joined: Sat Apr 05, 2008 9:58 pm

Re: Table Prefix not applied during install

Post by Webdongle » Mon Sep 23, 2024 4:51 pm

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 ;-)
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.
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".

User avatar
dagroupinc
Joomla! Intern
Joomla! Intern
Posts: 83
Joined: Tue Apr 06, 2010 6:09 pm

Re: Table Prefix not applied during install

Post by dagroupinc » Mon Sep 23, 2024 5:46 pm

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.

gws
Joomla! Champion
Joomla! Champion
Posts: 6398
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Table Prefix not applied during install

Post by gws » Mon Sep 23, 2024 5:56 pm

FYI, you don't have to create a database with akeeba as it creates it for you.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44649
Joined: Sat Apr 05, 2008 9:58 pm

Re: Table Prefix not applied during install

Post by Webdongle » Mon Sep 23, 2024 8:04 pm

gws wrote: Mon Sep 23, 2024 5:56 pm FYI, you don't have to create a database with akeeba as it creates it for you.
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".

Advertisement

Post Reply

Return to “Installation Joomla! 4.x”