Error (system ERROR on dev.tikiwiki.org by most of "filter" commands
- Status
- Closed
- Subject
- Error (system ERROR on dev.tikiwiki.org by most of "filter" commands
- Category
- Error
- Regression
- Dogfood on a *.tiki.org site
- Feature
- All / Undefined
- Resolution status
- Invalid
- Submitted by
- Bernard TREMBLAY
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
Hello,
This concerns the http://dev.tikiwiki.org/Search+Bugs and http://dev.tikiwiki.org/tiki-index.php?page=Search+Bugs
I have yet reported this bug, but because of three crossed bugs 3104 and the "not found ones" this had been yet reported but not reachable.
The three bugs are (were for the first) :
1- Report with no author
The registering of a "report a bug" was not always getting the author name. So, the report was, till ten days ago (diagnostic by chat and it seems repaired), treated as a not registered user (or logged in user ) writing.
The consequences are :
- No way to access them (no ticket displayed) and no access if found for the real author. Nota : if you have the ticket number (got from chat when submitted ) you can access it reacting the http query for this ticket.
- no way to manage them by the registered author
I have between ten and twenty report lost by this way.
And because of the second bug I can't find them back (just those submitted while I was chatting because the ticked is displayed on the chat.2- Filter crash :
the reason is the use of the "IN()" SQL clause which is not accepted by MYSQL
It is impossible to check the list in a right manner3- Crash on sort list
(click on column headers) for the same reason : use of "IN() clause into the SQL request
Problems and solutions
Repair the request generation - all
Getback the management of his ticket to the real author
It is a lot of job and not fair to rewrite all the reports lost (generates doubletons).The lonely solution seems to be that the author could submit to the manager (webmaster...) the list of the concerned reports (ticket number or title).
This needs to get a successful search (filter), implies that the 2d and 3td bug should be solved (I could not display an available list to find mines - I have sometimes made a local copy, so I have some dates, but at this dates or around I can't find my report, the list is always just a part of the full one)
Display the ticket number even the author is not known should be usefull
The mean of "any" in properties of report and display
Even this data means "any not defined" when you say "any" you mean actually : "only the marked - any - reports". So it is impossible without clicking individually all the checks "anyone" of this criteria.
The solution can be either :- on the filter a button : select all
- a data for filter names "anyone"
- both
- "select all" allow to unselect someones after
- "anyone" makes a more simple query allowing to forgot the criteria
__Without these solutions it is either awful or impossible to manage his "reports a bug"
__Trebly - 04/28/2010 - 3h.07 Paris
- No way to access them (no ticket displayed) and no access if found for the real author. Nota : if you have the ticket number (got from chat when submitted ) you can access it reacting the http query for this ticket.
- Solution
- Workaround
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- 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 not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3148
- Created
- Thursday 29 April, 2010 01:08:07 UTC
by Bernard TREMBLAY - LastModif
- Monday 01 June, 2026 21:44:03 UTC