#4174 cannot display Bookmarked SQL query

4.0.10
works-for-me
None
1
2013-12-22
2013-12-10
freeman
No

when i click to view Bookmarked SQL query
i got Uncaught TypeError: Cannot call method 'split' of null
worked before

Discussion

  • Marc Delisle

    Marc Delisle - 2013-12-10

    "Before", meaning in a previous phpMyAdmin version? if so, which one?

     
  • freeman

    freeman - 2013-12-11

    i'm not sure
    didn't use it long time
    it worked in 3.x

     
  • Marc Delisle

    Marc Delisle - 2013-12-14

    You mean, you open a table, click on SQL, then pick a bookmark from the bookmark selector, tick "View only" and click on Go?

    Which browser and platform are you using?

     
    • freeman

      freeman - 2013-12-15

      Yes
      chrome windows 8

       
  • Marc Delisle

    Marc Delisle - 2013-12-14
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2013-12-20

    The current stable version is 4.1.1, can you try with it and report your findings?

     
  • Marc Delisle

    Marc Delisle - 2013-12-20
    • status: open --> pending
     
  • freeman

    freeman - 2013-12-20

    no still broken

    {
        "exception": {
            "mode": "onerror",
            "message": "Uncaught TypeError: Cannot call method 'split' of null",
            "stack": [
                {
                    "line": 5483,
                    "func": "?",
                    "context": [
                        "        result.push(line);",
                        "        pos = nl + 1;",
                        "      }",
                        "    }",
                        "    return result;",
                        "  } : function(string){return string.split(/\\r\\n?|\\n/);};",
                        "  CodeMirror.splitLines = splitLines;",
                        "",
                        "  var hasSelection = window.getSelection ? function(te) {",
                        "    try { return te.selectionStart != te.selectionEnd; }",
                        "    catch(e) { return false; }"
                    ],
                    "filename": "codemirror/lib/codemirror.js"
                }
            ],
            "useragent": "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36",
            "uri": "tbl_sql.php?target="
        },
        "script_name": "tbl_sql.php",
        "pma_version": "4.1.1",
        "browser_name": "CHROME",
        "browser_version": "31.0.1650.63",
        "user_os": "Win",
        "server_software": "Apache",
        "user_agent_string": "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36",
        "locale": "en",
        "configuration_storage": "enabled",
        "php_version": "5.4.17-1~dotdeb.1",
        "microhistory": {
            "pages": [
                {
                    "hash": "index.php?db=&table=&server=1&target=&token=47cda40c1b310fcaee668982ae065799"
                },
                {
                    "hash": "sql.php?db=gps&table=sql_errors&server=1&target=&token=47cda40c1b310fcaee668982ae065799",
                    "params": {
                        "opendb_url": "db_structure.php",
                        "safari_browser": "0",
                        "querywindow_height": "400",
                        "querywindow_width": "600",
                        "collation_connection": "utf8mb4_slovak_ci",
                        "lang": "en",
                        "server": "1",
                        "text_dir": "ltr",
                        "pma_text_default_tab": "Browse",
                        "pma_text_left_default_tab": "Structure",
                        "confirm": "true"
                    }
                },
                {
                    "hash": "tbl_sql.php?db=gps&table=sql_errors&server=1&target=&token=47cda40c1b310fcaee668982ae065799",
                    "params": {
                        "opendb_url": "db_structure.php",
                        "safari_browser": "0",
                        "querywindow_height": "400",
                        "querywindow_width": "600",
                        "collation_connection": "utf8mb4_slovak_ci",
                        "lang": "en",
                        "server": "1",
                        "text_dir": "ltr",
                        "pma_text_default_tab": "Browse",
                        "pma_text_left_default_tab": "Structure",
                        "confirm": "true"
                    }
                }
            ],
            "current_index": "3"
        }
    }
    

    tried to submit error report but it said it failed to send :)
    also for some reason, i can't change server collation on main page

     
  • Marc Delisle

    Marc Delisle - 2013-12-20

    Are you using Safari or Chrome?

     
  • freeman

    freeman - 2013-12-20

    Chrome
    "browser_name": "CHROME",
    "browser_version": "31.0.1650.63",
    "user_os": "Win",

     
  • Marc Delisle

    Marc Delisle - 2013-12-21

    I cannot reproduce. I tested under Windows 8 with the same Chrome version as yours. I open a database, click on SQL, go to "Bookmarked SQL query", select a bookmark, click on "View only" then on Go. The bookmark appears correctly.

    Does it happen with all of your bookmarks? Did you try after removing all of your Chrome extensions?

     
  • freeman

    freeman - 2013-12-21

    i tried more queries
    maybe it happens when query is very long

     
    • Marc Delisle

      Marc Delisle - 2013-12-21

      Freeman,
      could you answer my two questions? plus this one: please give an example of a failing long query.

       
  • freeman

    freeman - 2013-12-21

    Most bookmarks work fine
    Yes, don't use any extension now

    DELETE FROM `sql_errors` WHERE `query` LIKE '%Too many downloads running%' OR `query` LIKE '%Old unit query used%' OR `backtrace` LIKE '%Cache write err%' OR `backtrace` LIKE '%/var/www/core/%' OR query LIKE '%/eagri.cz/public%' OR query LIKE '%Unknown plugin: -%' OR `backtrace` LIKE '%gps.cz%' or `backtrace` LIKE '%Votýpka Jara%' OR `backtrace` LIKE '%Buchta Roman%' or `query` like '%ME not reachable%' or `query` like '%No old data%' or `query` like '%Missing imei%' OR backtrace LIKE '%plugin: gps_dashboard action: view%' OR `backtrace` LIKE '%User ID: 0 Neznámý%' OR `backtrace` LIKE '%data_gsensor%' OR `query` LIKE 'Nedostatek kreditu ve skupine' OR `query` LIKE 'Fuelomat%' OR `query` LIKE '%SHOW COLUMNS IN `gps_`.`ride`%' OR `query` LIKE 'SHOW COLUMNS IN `gps_`.`ride`' OR `query` LIKE '%Unable to move file%' OR `query` LIKE '%parseCompletedFiles %' OR `query` LIKE '%Unable to move%' OR `query` LIKE '%Unable to read from gz%' OR `query` LIKE '%Missing ride time from or to%' OR `query` LIKE '%Duplicate entry%' OR `query` LIKE '%gpsdata/points%'
    
     
  • Marc Delisle

    Marc Delisle - 2013-12-22

    Freeman,
    I cannot reproduce this problem with your sample query saved as a bookmark, using the scenario I described above.

     
  • Marc Delisle

    Marc Delisle - 2013-12-22
    • status: pending --> works-for-me
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2013-12-22

    Got an idea: can you delete your bookmark and recreate it under phpMyAdmin 4.1.1l, to see what happens when you try to view it?

     
  • freeman

    freeman - 2013-12-22

    that worked for some reason, strange
    no error now thanks
    do you know why error submition failed? from the red bar on bottom