? ? Pending
Pull Request for # 29287

User tests: Successful: Unsuccessful:

avatar SharkyKZ
SharkyKZ
31 May 2020

Pull Request for Issue #29287.

Summary of Changes

Fixes query error on PostgreSQL, current version not being marked and versions not being displayed in frontend.

Testing Instructions

  1. On PostgreSQL, create some articles and view their versions.
  2. On any DB, edit an article and check its versions.
  3. On any DB, view article versions from frontend.

Expected result

  1. Works.
  2. Current version marked with a star.
  3. Versions displayed.

Actual result

  1. 22P02, 7, ERROR: invalid input syntax for integer: "6." LINE 3: WHERE "type_id" = '6.' ^

  2. Current version not marked with a star.
  3. No versions are displayed.

Documentation Changes Required

No.

avatar SharkyKZ SharkyKZ - open - 31 May 2020
avatar SharkyKZ SharkyKZ - change - 31 May 2020
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 31 May 2020
Category Administration com_content com_contenthistory Libraries
avatar SharkyKZ SharkyKZ - change - 31 May 2020
Rel_Number 29287
Relation Type Pull Request for
Labels Added: ?
avatar wilsonge wilsonge - test_item - 31 May 2020 - Tested successfully
avatar wilsonge
wilsonge - comment - 31 May 2020

I have tested this item successfully on 420d306

Tested items 2 and 3. Didn't test the postgres fix


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/29326.

avatar richard67 richard67 - test_item - 31 May 2020 - Tested successfully
avatar richard67
richard67 - comment - 31 May 2020

I have tested this item successfully on 420d306

Tested all 3 tests with database types "PostgreSQL (PDO") and "MySQLi".


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/29326.

avatar richard67 richard67 - change - 31 May 2020
Status Pending Ready to Commit
avatar richard67
richard67 - comment - 31 May 2020

RTC


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/29326.

avatar wilsonge wilsonge - change - 31 May 2020
Status Ready to Commit Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2020-05-31 23:11:33
Closed_By wilsonge
Labels Added: ?
avatar wilsonge wilsonge - close - 31 May 2020
avatar wilsonge wilsonge - merge - 31 May 2020
avatar wilsonge
wilsonge - comment - 31 May 2020

Thanks!

Add a Comment

Login with GitHub to post a comment