PatRaf
Joined: 26 Oct 2008
Posts: 2
Posted: 2008-10-26 12:26
Back to top
Reply with quote
|
Problem: in a ['values']['orderby'], I am using a field name containing spaces.
The routine set_values_from_table in phpMyEdit.class.php does not enclose the field name with $sd and $ed.
Hence an SQL error:
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
Workaround: enclose the field name in `` in the orderby clause:
['values']['orderby'] = '`field name`';
Second bug: impossible to file a bug report (memory allocated etc ...)
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
