| Index
» Projects
» phpMyEdit
» Bug list
» Bug #581 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000581 |
website / homepage |
major |
always |
2008-10-26 12:21 |
2008-10-26 12:21 |
|
|
|
Reporter |
anonymous |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
LAMP |
|
Status |
new |
Duplicate ID |
|
OS |
CentOS |
|
Projection |
none |
|
Version |
4.7 |
|
ETA |
none |
|
Product Version |
5.7.1 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
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. |
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2008-10-26 12:21 |
anonymous |
New Bug |
|
|
|
Login
Registration
Slovak
