Issue with database table structure

[mountainsman]

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?

[ceford]

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

[mountainsman]

No idea.

[ceford]

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]

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

[ceford]

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.