5.92 fatal filter issue for ALL users in TV
Posted: 2020-11-19 17:55
Hi,
I have set a filter that has worked before and I did not change anything in the table where this occurs.
It throws an SQL error for the regular user.
Flyspeed SQL Query (I highly recommend that tool) tells me
For me as super admin the error is more specific (I changed all fieldnames for privacy) - but I guess there is something mixed up internally (this IS the SQL produced by AG!):
Olaf
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