? Success

User tests: Successful: Unsuccessful:

avatar wilsonge
wilsonge
19 Oct 2014

Executive Summary

The similar tags module throws an uncaught SQL exception in postgres breaking any page it's loaded on

Testing Instructions

Install the testing dataset on postgres. The main home page will throw an SQL error. Apply the patch. This error will disappear and the page will render normally.

Things to note

There's an issue with the fact the same page is shown 3 times still in the module - but until I can work out errors with saving articles with tags treat this as a known issue. The fact that mysql with the same articles and associated tags shows 0 articles is just as concerning :P So let's just allow people to navigate on their site first!

Votes

# of Users Experiencing Issue
3/3
Average Importance Score
4.33

avatar wilsonge wilsonge - open - 19 Oct 2014
avatar jissues-bot jissues-bot - change - 19 Oct 2014
Labels Added: ?
avatar wilsonge wilsonge - change - 19 Oct 2014
Priority Medium Critical
avatar wilsonge
wilsonge - comment - 19 Oct 2014

I'm escalating this to critical as it stops you viewing any frontend page with this module on in postgres.

avatar ketchupmonki
ketchupmonki - comment - 19 Oct 2014

Tested and it successfully removes SQL message!

avatar ketchupmonki ketchupmonki - test_item - 19 Oct 2014 - Tested successfully
avatar alikon alikon - test_item - 19 Oct 2014 - Tested successfully
avatar alikon
alikon - comment - 19 Oct 2014

@test
success

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

avatar wilsonge wilsonge - change - 19 Oct 2014
Status Pending Ready to Commit
avatar wilsonge
wilsonge - comment - 19 Oct 2014

RTC - thanks guys!

avatar sovainfo
sovainfo - comment - 19 Oct 2014

Very confusing! Haven't been able to find any documentation on the priority in issues! Old documentation for JC doesn't match. Where can I find the new documentation?

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

avatar wilsonge
wilsonge - comment - 19 Oct 2014
avatar wilsonge wilsonge - change - 19 Oct 2014
Category Postgresql
avatar sovainfo
sovainfo - comment - 19 Oct 2014

In that case the correct priority would be low instead of critical. Not being able to use that module doesn't make it critical. I understand the urgency for your situation, but that doesn't make it critical.

From an application point of view I would like the modules to deal with db errors properly and don't consider that an error for the user. It should be logged as an error for the webmaster. But for the user it should present it as nothing found. It definitely shouldn't break the page. Repairing the software bug itself is fine, but with these kind of bugs it shouldn't break your site.

avatar jissues-bot jissues-bot - change - 19 Oct 2014
Labels Added: ?
avatar wilsonge
wilsonge - comment - 19 Oct 2014

Guys can we retest this please? @Bakual has managed to fix the issues in the module itself (postgres would show the same article multiple times if it had more than one duplicate tags)

avatar Bakual Bakual - alter_testresult - 19 Oct 2014 - alikon: Not tested
avatar Bakual Bakual - alter_testresult - 19 Oct 2014 - ketchupmonki: Not tested
avatar Bakual Bakual - change - 19 Oct 2014
Status Ready to Commit Pending
avatar Bakual Bakual - change - 19 Oct 2014
Labels Removed: ?
avatar ketchupmonki
ketchupmonki - comment - 19 Oct 2014

Re-tested successfully, no longer showing multiple results.

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

avatar ketchupmonki ketchupmonki - test_item - 19 Oct 2014 - Tested successfully
avatar brianteeman brianteeman - change - 20 Oct 2014
Priority Critical Medium
avatar wilsonge
wilsonge - comment - 21 Oct 2014

@sovainfo would you have the time to test this again please? Would be really nice to get this merged. Btw my situation isn't that urgent as I don't use postgres for production websites. However I just want all these bugs fixed :)

avatar sovainfo
sovainfo - comment - 21 Oct 2014

Sorry, tried to but failed. Started again from scratch on j336 but to many things failed. Like applying patch with com_patchtester and adding tags. Too tired now, giving up for today.

avatar wilsonge
wilsonge - comment - 21 Oct 2014

Adding tags fails again :/ I thought we'd got all that merged into staging :'(

avatar sovainfo
sovainfo - comment - 22 Oct 2014

@test Ok Issue reproduced. Applied PR with com_patchtester. PR resolves the issue

@wilsonge Sorry for the confusion. Add tags ofcourse failed in j336, Works when updated to 337-dev.

avatar Bakual
Bakual - comment - 22 Oct 2014

Merged into staging. Thanks all for coding and testing!

avatar Bakual Bakual - close - 22 Oct 2014
avatar Bakual Bakual - change - 22 Oct 2014
Status Pending Closed
Closed_Date 0000-00-00 00:00:00 2014-10-22 09:30:30

Add a Comment

Login with GitHub to post a comment