Plugin already installed, and is newer than the version available in the gallery.

[drfurtado]

How to do downgrade to the version that is available in the gallery. Right now the plugin is not working because I made a mistake and installed the newest version available here.

I am using:
OJS 3.3.0.13
Any help would be greatly appreciated.

[withanage]

@drfurtado
I have checked the version in the plugin gallery and the latest relased version. It is 1.1.3.12 for OJS 3.3.

It is helpful to know, how did you get the newer version in the database ?

https://github.com/pkp/orcidProfile/releases

https://github.com/pkp/plugin-gallery/blob/main/plugins.xml#L6713

[drfurtado]

@drfurtado I have checked the version in the plugin gallery and the latest relased version. It is 1.1.3.12 for OJS 3.3.

It is helpful to know, how did you get the newer version in the database ?

https://github.com/pkp/orcidProfile/releases

https://github.com/pkp/plugin-gallery/blob/main/plugins.xml#L6713

The orcidProfile plugin was not working for me back a few months ago. Then I visited the "releases page" and downloaded the the newest version, which I believe was newer than the one in the OJS Plugin Gallery.
I then uploaded via:

Since then, I have deleted the plugin in the server in an attempt to fix the problem by adding the plugin via the Plugin gallery. But then it says "Plugin already installed, and is newer than the version available in the gallery." even though I have deleted the plugin from the server.

I want to be able to install the plugin again via the Plugin Gallery, which now I understand is the recommended method.
Do I need to delete anything in the database for the message go away?

[drfurtado]

... in other words, I need to downgrade to 1.1.3.12 since the version that is currently installed does not work.

In cpanel, I went to file management and deleted the orcidProfile plugin. But I still get the message Plugin already installed, and is newer than the version available in the gallery.

Any help would be greatly appreciated.

[withanage]

Have you checked the mysql plugin_settings table to look if the entry of the old version is still there?

[drfurtado]

Have you checked the mysql plugin_settings table to look if the entry of the old version is still there?

This is what I see:

[withanage]

Sorry forgot the versions table must have an older version entry ?

[bozana]

I would also suggest looking into DB table versions and removing the orcid plugin versions higher than 1.1.3.12 there...

[drfurtado]

Now the message Plugin already installed, and is newer than the version available in the gallery is gone. After I restored the db to a previous version.

Now, another issue has emerged. After installing the plugin via the plugin gallery, the process never completes - please see gif below. I also tried via ftp (v1.1.3.12 and 13) but the issue is the same - when I go to Installed Plugins, the page keeps loading and the plugin does not work. When going to cpanel, the plugin is installed; deleting it manually causes the spinning to stop. Thank you!!!

*OJS 3.3.0.13

[drfurtado]

Sorry forgot the versions table must have an older version entry ?

[drfurtado]

I would also suggest looking into DB table versions and removing the orcid plugin versions higher than 1.1.3.12 there...

Thanks for the reply. I do not see the version in the versions table. Please, see screenshot above.

[bozana]

You need to see the column major, minor, revision, build. It seems your current version is 1.1.1.12...
What do you mean with "After I restored the db to a previous version."? After you deleted the higher version?
When you try to install the new version via plugin gallery, after you click on 'OK', do you get a notification that the plugin was installed successfully, or some other kind of notification (e.g. about a failure)? It could last longer, and a notification should come.
Can you also watch your server's PHP error log file when trying to install the new version from the plugin gallery, if any error occurs there?

[drfurtado]

You need to see the column major, minor, revision, build. It seems your current version is 1.1.1.12... What do you mean with "After I restored the db to a previous version."? After you deleted the higher version? When you try to install the new version via plugin gallery, after you click on 'OK', do you get a notification that the plugin was installed successfully, or some other kind of notification (e.g. about a failure)? It could last longer, and a notification should come. Can you also watch your server's PHP error log file when trying to install the new version from the plugin gallery, if any error occurs there?

Thanks for your prompt response.
Thanks for teaching me to read the sql table.
The option to upgrade/install the plugin via de gallery was not working. It used to say Plugin already installed, and is newer than the version available in the gallery and the plugin was not working. To be honest, I tried several things, including restoring the a previous version after playing with the sql.
The one you see above is the restored version.
As you can see in the gif above, nothing happens when I click OK. I'm not receiving any messages. The app seems to get stuck and there's no further progress. After leaving the page, I go in the cpanel and the plugin is installed. But, when I visit the frontend (installed plugins), it says Loading and nothing happens - see below. If I go to cpanel and manually delete the plugin, the loading message disappears.

[bozana]

Hmm... I am a little bit worried about "After I restored the db to a previous version." -- I do not know what that means but I hope you have the correct (and not corrupt) DB now.
The installation via plugin gallery should work. When you try it, when you press the OK button, do you see any errors in the server's PHP error log?

[withanage]

As @bozana mentions, when loading button is display, there should be error in the PHP-Code. or even an error in an another plugin. If you have apache, it should be somewhere like, /var/log/apache2/error.log

[drfurtado]

I do not know what that means but I hope you have the correct (and not corrupt) DB now.

I had experienced the same issue before restoring the the db. Please, see below the error produced in the error.log file.

Steps I took:

1. Because the loading issue reported above, I deleted the plugin manually. The loading issue was resolved, but the plugin still did not work.
2. Then, I went to the plugins gallery and tried to install the plugin again (did not change anything in the db)
3. When I click install > OK, nothing happens - no error on the frontend. To leave the page I need to click Cancel. As, as before, if I go to Installed Plugins I get the Loading message as shown above.
4. The error log after performing 1-3 is provided below.
5. Do I need to delete anything in db version table?
6. I show below what I current have in the db

[21-Mar-2024 21:13:28 UTC] ojs2: You are trying to downgrade the product "orcidProfile" from version [1.3.4.8] to version [1.1.3.12]. Downgrades are not supported. [21-Mar-2024 21:13:29 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:29 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:29 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:29 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:29 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:58 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:58 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:58 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:58 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:13:58 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:17 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:17 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:17 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:17 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:17 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:54 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:54 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:54 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:54 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:14:54 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:08 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:08 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:08 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:08 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:08 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:13 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:13 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:13 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:13 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:15:13 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:16:03 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:16:03 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:16:03 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:16:03 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:16:03 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:02 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:02 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:02 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:02 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:02 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:11 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:11 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:11 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:11 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:11 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:16 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:16 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:16 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:16 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:16 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:27 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:27 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:27 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:27 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:27 UTC] PHP Notice: Undefined index: certification in /home/wskworg/public_html/jkw/lib/pkp/classes/plugins/PluginGalleryDAO.inc.php on line 194 [21-Mar-2024 21:17:28 UTC] ojs2: You are trying to downgrade the product "orcidProfile" from version [1.3.4.8] to version [1.1.3.13]. Downgrades are not supported.

[bozana]

Hi @drfurtado,
Somehow the entries in your DB table versions do not correspond with the error message you provided -- the error message says that you have installed the version 1.3.4.8.... Hmmm....
Could you maybe also clean the caches -- as admin go to Administration > Clean Data + Template Caches -- and then try to install the plugin via plugin gallery again. Please watch the error log file after pressing OK (to install the plugin).