Menu

#11 Display xx records on the select page

fixed
None
5
2013-06-11
2001-05-15
No

On the select page (tbl_select.php3), when you you
suppress the 30 default value in the display xx
records per page (or put a non numeric value) then
click go, you've the following

sql error :
<------>
Error
SQL-query:

SELECT ... // sql request // ... where 1
MySQL said:
<------>

and nothing else ...

*********************************************

Proposed patch:
on file "tbl_select.php3", on line 115-116
(before "header("Header("Location ..."), add :

require("config.inc.php3"); // we need $cfgMaxRows ...
if (($sessionMaxRows += 0) == 0) { $sessionMaxRows =
$cfgMaxRows;}

*********************************************

Since I don't know if it might break something else,
would someone look at this ( and apply if safe ;-) ).

Discussion

  • Loïc Chapeaux

    Loïc Chapeaux - 2001-05-17
    • assigned_to: nobody --> loic1
     
  • Loïc Chapeaux

    Loïc Chapeaux - 2001-05-17

    Logged In: YES
    user_id=144058

    Hi Alain!

    I'll give a try to your patch and have a deeper look into
    the problem you're facing tonight.

    Thanks for the report,
    Loc

     
  • Loïc Chapeaux

    Loïc Chapeaux - 2001-05-18

    Logged In: YES
    user_id=144058

    Fixed in both the cvs trees.

     
  • Loïc Chapeaux

    Loïc Chapeaux - 2001-05-18
    • status: open --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed