Some wiki syntax crashes page, with error message: Not unique table/alias: 'ts'
- Status
- Open
- Subject
- Some wiki syntax crashes page, with error message: Not unique table/alias: 'ts'
- Version
- 13.x
13.x Regression
9.x - Category
- Error
- Feature
- Wiki Syntax (text area, parser, external wiki, etc)
- Resolution status
- New
- Submitted by
- Marc Laporte
- Volunteered to solve
- manivannans
- Lastmod by
- Marc Laporte
- Rating
- Description
See 9.x:
https://profiles.tiki.org/AdminStill a problem in trunk:
http://nextprofiles.tiki.org/AdminThis is the commit that caused it:
https://profiles.tiki.org/tiki-pagehistory.php?page=Admin&compare=Compare&newver=14&oldver=13- Solution
I had fixed this issue.
Please check this commit id:48820
Also backported to 9.x
9.x -> r48823
@Mani: https://profiles.tiki.org/Admin is still crashing
sorry I forget to inform.This is the description given below in sort option,
"Sort ascending or descending on any field in the tiki_pages table. Syntax is field name followed by _asc or _desc. Example: lastModif_desc or pageName_asc".
So we can not use PageNameID as sort field. instead we can use pageName or page_id to sort.
After changing this it will work.
@Mani: Can we have a more graceful error message?
Hi Marc,I had checked this error message. After 9.x+ branch, showing the proper error message like
. But when I tried to upgrade 8.x to 9.x, still shows an old error message like https://profiles.tiki.org/Admin. But 9.x+ version has proper message. where I need to fix this error, I mean 8.x or 9.x. I think it's maybe a prefs. Because when I use 9.x DB, it's showing proper MSG. But upgraded 8.x to 9.x has old message. Please suggest to proceed.
- Importance
- 5
- Easy to solve?
- 9
- Priority
- 45
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 4932
- Created
- Saturday 16 November, 2013 22:11:00 UTC
by Marc Laporte - LastModif
- Wednesday 30 July, 2014 02:58:39 UTC