519324 - "Unexpected error has occurred" trying to load RSS feed for solved forum post

Status: VERIFIED FIXED

(support.mozilla.org :: Forum, task)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

STR:

While logged out, load http://support-stage.mozilla.org/tiki-forum_rss.php?locale=en-US&forumId=1&comments_parentId=446820

Expected:

RSS feed of forum posts for http://support-stage.mozilla.org/en-US/forum/1/446820

Actual:

"Error

An unexpected error has occurred!"

Comment 1

[Paul Craciunoiu [:paulc]]

This happens only when logged out. I've seen this bug and I thought I fixed it but I guess not. Taking.

Comment 2

[Paul Craciunoiu [:paulc]]

Attachment: patch, v1

Thanks to jsocol for debriefing me about insert ignore, this is a really simple fix. Additionally, the uniqueid column is limited to 30 (!!) characters, so the previous construction was too long. I changed it to something shorter.

Comment 3

[James Socol [:jsocol, :james]]

Comment on attachment 403519 [details] [diff] [review]
patch, v1

WFM.

Did notice a new bug, though, bug 519569.

Comment 4

[Paul Craciunoiu [:paulc]]

r52584 / r52585

Fennec is out of date, so I didn't commit there. We'll do a merge later, as discussed in the SUMOdev meeting today.

Comment 5

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED on http://support-stage.mozilla.org/tiki-forum_rss.php?locale=en-US&forumId=1&comments_parentId=446820, logged out and in.

Comment 6

[David Tenser [:djst]]

Is this something that should be upstreamed to Tiki?

Comment 7

[Paul Craciunoiu [:paulc]]

It is a problem, although not too big. This arose from table database columns being restricted too short and me not being careful about it. So, it's not really a problem for Tiki I suppose.

Comment 8

[Louis-Philippe Huberdeau]

Could not reproduce in trunk. Might already be fixed.