Loading...
 
Skip to main content

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
(0)
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 :

  1. 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.

  2. 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 manner

3- 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



Solution
Workaround
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
3148
Created
Thursday 29 April, 2010 01:08:07 UTC
by Bernard TREMBLAY
LastModif
Monday 01 June, 2026 21:44:03 UTC


Show PHP error messages