Joomla! Issue Tracker - Patch Tester

Download
Launch
Feeling Lucky

[#305] - patchtester does not work on Postgres: patchtester_pulls_labels does not exist LINE 2

avatar VladimirAus
VladimirAus
17 Oct 2020

Steps to reproduce the issue

Expected result

  • com_patchtester page

Actual result

Error: 42P01, 7, ERROR: relation "io5nw_patchtester_pulls_labels" does not exist LINE 2: FROM "io5nw_patchtester_pulls_labels" ^

Screen Shot 2020-10-17 at 6 36 22 pm

System information (as much as possible)

Additional comments

Tested on latest mysql:5.6 container and it works.

avatar VladimirAus VladimirAus - open - 17 Oct 2020
avatar richard67
richard67 - comment - 17 Oct 2020

@VladimirAus That can happen sometimes, also on MySQL.

Could you check following?

  • Uninstall the patchtester wia "System - Manage - Extensions".
  • Install the patchtester again.

After that, it should work.

Questions:

  • Have you used latest Patchtester 4.0.0 final release?
  • You wrote you have installed Joomla, but you haven't installed patchtester? How did that work?
Steps to reproduce the issue
- Install Joomla on postgres 12
- Go to /administrator/index.php?option=com_patchtester
avatar VladimirAus VladimirAus - change - 17 Oct 2020
The description was changed
avatar VladimirAus VladimirAus - edited - 17 Oct 2020
avatar VladimirAus
VladimirAus - comment - 17 Oct 2020

Cheers @richard67.
Updated steps with patch tester.
Testing your suggestion now.

avatar VladimirAus
VladimirAus - comment - 17 Oct 2020

Uninstalling and installing did the job.
Thanks @richard67

avatar VladimirAus VladimirAus - close - 17 Oct 2020
avatar VladimirAus VladimirAus - close - 17 Oct 2020
avatar VladimirAus VladimirAus - change - 17 Oct 2020
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2020-10-17 10:27:51
Closed_By ⇒ VladimirAus
avatar richard67
richard67 - comment - 17 Oct 2020

@roland-d This issue is exactly that edge case where the right update SQL script would help to work around it which we discussed on Glip.

avatar roland-d
roland-d - comment - 17 Oct 2020

Check if you have the folder api/components/com_patchtester. Joomla has a bug where this folder is not removed on uninstall. Later installing patch tester again will do an update install of an install because of that. Do an uninstall and remove that folder and then do an install. That should work.

Add a Comment

Login with GitHub to post a comment