Surgeon has kindly addressed your question in his comments below and I agree with his assessment.
Followup with your personal physician is essential.
This answer is not intended as and does not substitute for medical advice - the information presented is for patient education only. Please see your personal physician for further evaluation of your individual case.
I couldn't find the other post to which you referred: however, bubbles in the urine could suggest a connection between the urinary tract and the intestinal tract (entero-vesicle fistula, is one common name). Most commonly this occurs with diverticulitis, an infection starting in the colon. Other causes include crohn's disease, abscess (like from a ruptured appendix) and tumors. Not all fistulas can be seen when looking into or xraying the colon. Sometimes it's necessary to look inside the bladder. If the connection is above the bladder, in the ureter (rare)it may be even harder to confirm. Having pain in the right lower abdomen suggests a process that ought to be identifiable if there is indeed a fistula: some sort of mass or inflammation ought to be visible on a CAT scan. Bubbles in the urine, depending on what it is you are describing, might not represent a fistula, if you just mean frothy urine.
I wanted to post a question and hope for some help. I have the same symptoms as debera. However,I am male and have lower right abdomen pain between the right groin and belt line that is worse at night or when laying down. The doctor in my case felt it was slight prostrate enlargement retaining urine. He gave me flomax that helped but it has ran out and the symptoms are back even worse. My urine is frothy also.The pain is a dull but perstent ache and it runs into my hip as well. It is uncanny that the symptoms of debera and me can be so close and makes me wonder if not something else has to be happening. I feel run down with no energy also. debera if you see this and can give me some insight please forward to ***@****.
Any medical insight is welcome. This is very irritating. When it first began I thought it was a muscle pull and or a hernia. Apparently it is neither. I am not so sure the flomax was helping in so much as it was the prostrate at all but rather because it is a nerve pain blocker and relaxant.