phpMyEdit - Viewing Bug Advanced Details			[ Go Back ]
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
206	documentation	minor	always	2004-03-25 17:35	2004-11-01 21:21
Reporter:	milos	Platform:	All
Assigned To:		OS:	All
Priority:	normal	Version:	All
Status:	feedback	Product Version:	5.4 (stable)
Product Build:		Resolution:	open
Projection:	none	Duplicate ID:
ETA:	none
Summary:	'sql' option can crash PME
Description:	If 'sql' option for field using column name wich is the same as field name in lookup table will crash application.
Steps To Reproduce:
Additional Information / Solution:	Solution: To use for field name in 'sql' expression PMEtable0.NAME instead of just NAME. Maybe there is some other "more legal" way, but it is not documented, and in that case this is bug in documentation.
Attached Files:

Bug Notes
milos    2004-03-25 21:36	Actualy it is not only the case with 'sql' it is a case with 'filters' option too.
milos    2004-03-26 16:37	This bug is almost the sam as bug #0000028, and it is NOT fixed in 5.4! :(
nepto    2004-03-26 17:10	What do you mean with "crash"? This is low-priority issue, because you can avoid this bug by specifying proper "sql" or "filters". However it has to be certainly fixed.
milos    2004-03-26 20:09	Not exactly "crash", but you'll got error message instead of result. Now I see that it should be changed to lower "priority", but I am not able to do that. edited on: 2004-03-26 20:15
hbernard    2004-03-29 17:26	This is related with #0000134 isn't it ?
nepto    2004-03-31 18:10	Yes, this is related to #134 what is currently being fixed in CVS. Bug #28 was related to documentation, where is this issue properly explained. http://platon.sk/projects/doc.php/phpMyEdit/html/configuration.filters.html
hbernard    2004-11-01 21:21	this is a documentation issue.