Status variables documentation links to dev.mysql.com are invalid

[M393]

Describe the bug

In Status -> Variables clicking the blue question mark icon links to https://dev.mysql.com/doc/refman/5.7/en/open-tables.html
The link should be https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Open_tables

To Reproduce

Steps to reproduce the behavior:

1. Go to Status -> All status variables
2. Click on the question mark in the column Variable
3. See error

Expected behavior

Documentation links should be to the correct page.

Screenshots

Server configuration

• Database version: MySQL 5.7.44
• phpMyAdmin version: 5.2.2-dev+20240309.aaf7188717

[williamdes]

This is probably due to williamdes/mariadb-mysql-kbs#300

Or that the variable is not known https://github.com/search?q=repo%3Awilliamdes%2Fmariadb-mysql-kbs%20Open_tables&type=code

[M393]

williamdes/mariadb-mysql-kbs#300 is for MariaDB and they are working, just with additional redirects.

My links are to dev.mysql.com and no link I tried works. I guess MySQL changed their links, so it should be updated in phpMyAdmin.

[williamdes]

williamdes/mariadb-mysql-kbs#300 is for MariaDB and they are working, just with additional redirects.

My links are to dev.mysql.com and no link I tried works. I guess MySQL changed their links, so it should be updated in phpMyAdmin.

Hey,
This is my library, it is used for the generation of this link you are reporting.
I think the variable is not yet detected by my library

[M393]

All links for status variables I tested are broken. Also Open_tables exists in the file you linked:

[williamdes]

Okay, thanks for this info. I may have missed something. I will test on MySQL 5.7 and fix this

[williamdes]

All links for status variables I tested are broken. Also Open_tables exists in the file you linked:

Seems like they exist but only for MariaDB. So the links are not available on MySQL.
I implemented it for MySQL, I hope this will be okay: williamdes/mariadb-mysql-kbs@0b2a6ad
New data: williamdes/mariadb-mysql-kbs#342

PS: How to you have such variables, Com_xxx stuff is not showing in my list ?

[M393]

Looks like all status variables starting with com_ should link here.
See the status variable reference.

Thanks for working on this so quickly. I tested it and the link to Open_tables now takes me to the correct location.
Though it links to the MySQL 8.0 kb, not 5.7 (not sure if this is intentional or an oversight).

[williamdes]

Thank you for confirming, do you know how you did activate the Com_xxx variables?
On my end here is the list of variables I need to add williamdes/mariadb-mysql-kbs#343

Unfortunately the library does not handle different versions of MySQL in the way where it would send you to the version you are using. It has no knowledge of versions. Only variables.

Did you install the composer dev version?
Or replace with the download of my library in your vendor folder?
Let me know

[M393]

I did not do anything to enable these variables, it is just a standard installation of MySQL 5.7.

I change this in composer.json

-        "williamdes/mariadb-mysql-kbs": "^1.2"
+        "williamdes/mariadb-mysql-kbs": "dev-main"

[williamdes]

I did not do anything to enable these variables, it is just a standard installation of MySQL 5.7.

Okay, on the Docker version I do not see them :/

[M393]

They are available on the demo server if this helps you: