Issue with database table structure

Need help upgrading your Joomla! website or converting to Joomla! 4.x?

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
mountainsman
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Sat Dec 14, 2019 9:04 pm

Issue with database table structure

Post by mountainsman » Thu Sep 21, 2023 2:17 am

Hi folks, i'd like to update to latest joomla but getting this database message. went through process & it says database structure up to date, any ideas how proceed?
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Sat Sep 23, 2023 10:56 pm, edited 1 time in total.
Reason: mod note: moved from 4.x Installation, retitled

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

Re: database issue

Post by ceford » Fri Sep 22, 2023 7:32 am

Joomla CMS should be in the list. Why is it not there?

mountainsman
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Sat Dec 14, 2019 9:04 pm

Re: database issue

Post by mountainsman » Sat Sep 23, 2023 9:36 pm

No idea.

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

Re: Issue with database table structure

Post by ceford » Sun Sep 24, 2023 7:52 am

This is unfamiliar territory for me - but here are some suggestions. Try this query in phpMyAdmin with your database selected:

Code: Select all

SELECT `extensions`.`client_id`,`extensions`.`element`,`extensions`.`extension_id`,`extensions`.`folder`,`extensions`.`manifest_cache`,`extensions`.`name`,`extensions`.`type`,`schemas`.`version_id`
FROM `xxxxx_schemas` AS `schemas`
INNER JOIN `xxxx_extensions` AS `extensions` ON `schemas`.`extension_id` = `extensions`.`extension_id`
Change xxxxx to your own table prefix. You should get one row for each extension, including:

Code: Select all

0 	joomla 	212 		{"name":"files_joomla","type":"file","creationDate... 	files_joomla 	file 	4.3.2-2023-05-20
Then look in the schemas table and the extensions table to see whether the extension ids match.

mountainsman
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Sat Dec 14, 2019 9:04 pm

Re: Issue with database table structure

Post by mountainsman » Mon Sep 25, 2023 11:56 pm

thanks. I'm not very familiar with the phpmyadmin

i have 6 databases, pretty sure only 1 works, others I created trying to get site to work.

in my screenshot you'll see I added one where xxxxx's where. when I submited query there was no response.

thanks for your guidance
You do not have the required permissions to view the files attached to this post.

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

Re: Issue with database table structure

Post by ceford » Tue Sep 26, 2023 3:25 am

Open your configuration.php with a text editor - you will find an entry for the database you are actually using. That will help you to select the correct database in phpMyAdmin.

In phpMyAdmin use the SQL button at the top to open a form where you paste the query. Then click the Go button at the bottom of the form.


Post Reply

Return to “Migrating and Upgrading to Joomla! 4.x”