Welcome, Guest
Please Login or Register.    Lost Password?

I think I have found a BUG in Aditional Condition
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottomPage: 1
TOPIC: I think I have found a BUG in Aditional Condition
#170
I think I have found a BUG in Aditional Condition 6 Months, 1 Week ago Karma: 0
When I add condition created_by = '@user_id' it work fine when showing data.
But when i searching with "All fields" condition (Just only "All fields" condition that issued wrong result)
Component showing incorrect data because OR condition

This is MySQL Front end that I print.

SELECT id, created_by, title, hits FROM jos_content WHERE created_by = '62' AND UPPER(id) LIKE ('%0%') OR UPPER(created_by) LIKE ('%0%') OR UPPER(title) LIKE ('%0%') OR UPPER(hits) LIKE ('%0%') ORDER BY id asc LIMIT 0, 20

It's incorrect. The QUERY MUST HAVE bracket "( )" after Aditionnal Condition
The correct QUERY IS

SELECT id, created_by, title, hits FROM jos_content WHERE created_by = '62' AND ( UPPER(id) LIKE ('%0%') OR UPPER(created_by) LIKE ('%0%') OR UPPER(title) LIKE ('%0%') OR UPPER(hits) LIKE ('%0%') ) ORDER BY id asc LIMIT 0, 20

Im' try to fixs this .but Im' not find the place to add my bracket yet

Im' try to fixs this .but Im' not find the place to add my bracket yet
sospixs
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#171
Re: I think I have found a BUG in Aditional Condition 6 Months, 1 Week ago Karma: 0
Hello Sospixs,

Thank you for reporting this bug. A new version of TableJX will be released today, having this bug fixed. New version will also include some additional features like linkable columns, etc...

Existing customers will be able to download this version for free in Customer area. You can expect it to be published within an hour.

Best regards,
Bostjan
Bostjan
Senior Boarder
Posts: 45
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#172
Re: I think I have found a BUG in Aditional Condition 6 Months, 1 Week ago Karma: 0
WOW
Thanks for quickly response.
Im waiting for download.
sospixs
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting