#3833 (ok 4.0.0-beta2) Undefined variable: sql_limit_to_append


I'm a little unsure of what's going on here. Sometimes I get the error message

Notice in ./sql.php#1225
Undefined variable: sql_limit_to_append


./import.php#569: include(./sql.php)

when executing a manual SQL query. It doesn't happen every time, though.

On the demo server, I have done this:

  • From the main page, click the SQL tab
  • Submit "use sakila; show tables;"
  • From the results page, click the SQL tab
  • The error is displayed at the bottom of the page
  • Run the same query a second time
  • The error continues to be displayed at the bottom of the page

Then I clicked the "Home" icon from the navigation frame (not a frame anymore, but you know what I mean) and tried again, using the query "use information_scheme; show tables;" with the same result: I saw the error message.

I then tried the same sequence with a third query: "use sakila; select * from actor". I did NOT see the error message.

I wondered if it was related to this message:

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Which appears at the top of the first two queries and not on the third. So I duplicated the actor table, dropped the two indexes, and tried to recreate. It does not seem to be related, as I was still unable to recreate the error message even without any unique key/index.

Any ideas what's going on here?


  • Marc Delisle

    Marc Delisle - 2013-02-20
    • assigned_to: Marc Delisle
  • Dieter Adriaenssens

    • status: open --> pending-fixed
  • Dieter Adriaenssens

    Fixed in latest git. Can you confirm it is fixed?

  • Isaac Bennetch

    Isaac Bennetch - 2013-03-06

    Sorry for the delay; I simply forgot to reply. Yes, this seems to have fixed the problem.

  • Marc Delisle

    Marc Delisle - 2013-03-06
    • summary: Undefined variable: sql_limit_to_append --> (ok 4.0.0-beta2) Undefined variable: sql_limit_to_append
    • status: pending-fixed --> open-fixed
  • Marc Delisle

    Marc Delisle - 2013-03-17
    • Status: open-fixed --> closed-fixed
  • Michal Čihař

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