phpMyEdit - Viewing Bug Advanced Details			[ Go Back ]
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
581	website / homepage	major	always	2008-10-26 12:21	2008-10-26 12:21
Reporter:	anonymous	Platform:	LAMP
Assigned To:		OS:	CentOS
Priority:	normal	Version:	4.7
Status:	new	Product Version:	5.7.1 (stable)
Product Build:		Resolution:	open
Projection:	none	Duplicate ID:
ETA:	none
Summary:	The ['values']['orderby'] field is not enclosed between sd and ed
Description:	// code extract : $opts['fdd']['Numéro compte-rendu'] = array( 'name' => 'Numéro compte rendu', 'select' => 'D', 'maxlen' => 11, 'sort' => true ); $opts['fdd']['Numéro compte-rendu']['help'] = 'Lien avec la table des comptes-rendus'; //PR $opts['fdd']['Numéro compte-rendu']['values']['table'] = 'Comptes-rendus-PH'; $opts['fdd']['Numéro compte-rendu']['values']['column'] = 'Numéro compte-rendu'; $opts['fdd']['Numéro compte-rendu']['values']['orderby'] = 'Date de saisie'; gives: MySQL query at line 487 SELECT DISTINCT `Comptes-rendus-PH`.`Numéro compte-rendu` FROM `TESTSITAVOBE`.`Comptes-rendus-PH` ORDER BY Date de saisie --------------------- MySQL error 1064
Steps To Reproduce:	Use a filed name containing spaces as a values/orderby field. Workaround: set ['orderby'] = '`field name`';
Additional Information / Solution:	Modify phpMyEdit.class.php function set_values_from_table, but I do not know where :-)
Attached Files:

There are no notes attached to this bug.