I have set a filter that has worked before and I did not change anything in the table where this occurs.
Code: Select all
http://localhost/mytable_view.php?SortField=12%20desc,13&SortDirection=desc&FilterAnd[1]=and&FilterField[1]=10&FilterOperator[1]=equal-to&FilterValue[1]=7*X1
Flyspeed SQL Query (I highly recommend that tool) tells me
It's the first brace here (the last in this code section), almost at the end of the SQL, the second ) left to the order keyword.Invalid SELECT statement. Unecpected token ")" at line 1, pos 2805
Code: Select all
/* ox.bx*rx */ <=> '7*X1' )
Code: Select all
SELECT `x_cx`.`ID_cxNum` AS 'ID_cxNum', if(CHAR_LENGTH(`x_cx`.`ccode`)>11, concat(left(`x_cx`.`ccode`,11),' ...'), `x_cx`.`ccode`) AS 'ccode', IF( CHAR_LENGTH(`x_lx1`.`lx_atx`), CONCAT_WS('', `x_lx1`.`lx_atx`), '') /* Platz */ AS 'ID_lx', IF( CHAR_LENGTH(`x_stx1`.`stx`), CONCAT_WS('', `x_stx1`.`stx`), '') /* stx */ AS 'ID_vxstyxstxstx', IF( CHAR_LENGTH(`x_pxe1`.`pxbezx`), CONCAT_WS('', `x_pxe1`.`pxbezx`), '') /* px */ AS 'ID_pxe', IF( CHAR_LENGTH(`x_pxezx1`.`pxezx`), CONCAT_WS('', `x_pxezx1`.`pxezx`), '') /* pxzx */ AS 'ID_pxezx', `x_cx`.`Kunde` AS 'Kunde', `x_cx`.`bex` AS 'bex', IF( CHAR_LENGTH(`x_ax1`.`ax`), CONCAT_WS('', `x_ax1`.`ax`), '') /* ax */ AS 'ID_ax', IF( CHAR_LENGTH(`x_bxe1`.`bx`), CONCAT_WS('', `x_bxe1`.`bx`), '') /* bx */ AS 'ID_bxe', IF( CHAR_LENGTH(`x_lx1`.`oxbxrx_atx`), CONCAT_WS('', `x_lx1`.`oxbxrx_atx`), '') /* ox.bx*rx */ AS 'oxbxrx_atx', IF( CHAR_LENGTH(`xllby1`.`IDllbY`), CONCAT_WS('', `xllby1`.`IDllbY`), '') /* Tiefe */ AS 'IDllbY', IF( CHAR_LENGTH(`xllbz1`.`IDllbZ`), CONCAT_WS('', `xllbz1`.`IDllbZ`), '') /* Ebene */ AS 'IDllbZ', IF( CHAR_LENGTH(`x_vxstyx1`.`vxstyx`), CONCAT_WS('', `x_vxstyx1`.`vxstyx`), '') /* vxstyx */ AS 'ID_vxstyx', IF( CHAR_LENGTH(`x_cxtyxen1`.`cxtyx_Kurz`), CONCAT_WS('', `x_cxtyxen1`.`cxtyx_Kurz`), '') /* tyx */ AS 'ID_cxtyxen', IF( CHAR_LENGTH(`x_cxbax1`.`cxbax_Kurz`), CONCAT_WS('', `x_cxbax1`.`cxbax_Kurz`), '') /* bax */ AS 'ID_cxbax', IF( CHAR_LENGTH(`x_colx1`.`Farbe`), CONCAT_WS('', `x_colx1`.`Farbe`), '') /* Farbe */ AS 'ID_colxNum', `x_cx`.`lez` AS 'lez', `x_cx`.`llb` AS 'llb', `x_cx`.`bex_2` AS 'bex_2', COALESCE(`x_cx`.`ID_cxNum`) AS 'x_cx.ID_cxNum' FROM `x_cx` LEFT JOIN `x_lx` as x_lx1 ON `x_lx1`.`ID_lxNum`=`x_cx`.`ID_lx` LEFT JOIN `x_vxstyxstx` as x_vxstyxstx1 ON `x_vxstyxstx1`.`ID_vxstyxstx`=`x_cx`.`ID_vxstyxstxstx` LEFT JOIN `x_stx` as x_stx1 ON `x_stx1`.`ID_stxNum`=`x_vxstyxstx1`.`ID_stx` LEFT JOIN `x_pxe` as x_pxe1 ON `x_pxe1`.`ID_pxe`=`x_cx`.`ID_pxe` LEFT JOIN `x_pxezx` as x_pxezx1 ON `x_pxezx1`.`ID_pxezx`=`x_cx`.`ID_pxezx` LEFT JOIN `x_ax` as x_ax1 ON `x_ax1`.`ID_axNum`=`x_cx`.`ID_ax` LEFT JOIN `x_vxstyx` as x_vxstyx1 ON `x_vxstyx1`.`ID_vxstyx`=`x_cx`.`ID_vxstyx` LEFT JOIN `x_cxtyxen` as x_cxtyxen1 ON `x_cxtyxen1`.`ID_cxtyxenNum`=`x_cx`.`ID_cxtyxen` LEFT JOIN `x_cxbax` as x_cxbax1 ON `x_cxbax1`.`ID_cxbaxNum`=`x_cx`.`ID_cxbax` LEFT JOIN `x_colx` as x_colx1 ON `x_colx1`.`ID_colxNum`=`x_cx`.`ID_colxNum` LEFT JOIN `x_bxe` as x_bxe1 ON `x_bxe1`.`ID_bxeNum`=`x_lx1`.`ID_bxe` LEFT JOIN `xllby` as xllby1 ON `xllby1`.`IDllbY`=`x_lx1`.`IDllbY` LEFT JOIN `xllbz` as xllbz1 ON `xllbz1`.`IDllbZ`=`x_lx1`.`IDllbZ` WHERE 1=1 and ( IF( CHAR_LENGTH(`x_lx1`.`oxbxrx_atx`), CONCAT_WS('', `x_lx1`.`oxbxrx_atx`), '') /* ox.bx*rx */ <=> '7*X1' ) ) order by 12 desc,13 desc LIMIT 0, 15
Olaf