SQLEditor - JavaScript Issue

(11 posts) (2 voices)
  • Started by Saravanan_Kandasamy
  • Latest reply from myDBR Team

Tags:

No tags yet.

  1. myDBR Team, Key Master

    The SQL Editor not loadin on IE is usually a cache issue where IE is agressively caching the old version where it should not. You can try to use another browser to see that your installation is working and then try to clear the IE's cache again.

    --
    myDBR Team

  2. Saravanan_Kandasamy, Blocked

    Tried with IE8 & Firefox 7.x after clearing the browser cache & temp memory, but still no result. Can you guide me to fix this issue?

    Thanks.

  3. Saravanan_Kandasamy, Blocked

    FYI - complete page load log with Error message:

    [09:41:00.461] GET http://localhost:8080/mydbr/index.php?a=editor&m=1 [HTTP/1.1 200 OK 1560ms]
    [09:41:02.047] GET http://localhost:8080/mydbr/lib/external/jquery/css/smoothness/jquery-ui-1.8.6.custom.css?v=1461 [HTTP/1.1 304 Not Modified 0ms]
    [09:41:02.051] GET http://localhost:8080/mydbr/interface/pager.css?v=1461 [HTTP/1.1 304 Not Modified 0ms]
    [09:41:02.052] GET http://localhost:8080/mydbr/interface/sqleditor.css?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.054] GET http://localhost:8080/mydbr/interface/style.css?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.055] GET http://localhost:8080/mydbr/interface/normal.css?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.057] GET http://localhost:8080/mydbr/interface/themes/taikala.css?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.058] GET http://localhost:8080/mydbr/interface/winmoz.css?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.060] GET http://localhost:8080/mydbr/user/userstyle.css?1335759061&v=1461 [HTTP/1.1 200 OK 16ms]
    [09:41:02.062] GET http://localhost:8080/mydbr/lib/external/jquery/js/jquery-1.7.2.min.js?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.064] GET http://localhost:8080/mydbr/lib/external/jquery/js/jquery-ui-1.8.16.custom.min.js?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.066] GET http://localhost:8080/mydbr/lib/external/jquery/js/jquery-ui-timepicker-addon.js?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.067] GET http://localhost:8080/mydbr/lib/javascript/common.js?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.069] GET http://localhost:8080/mydbr/lib/external/jquery/js/jquery.json-2.2.min.js?v=1461 [HTTP/1.1 304 Not Modified 16ms]
    [09:41:02.070] GET http://localhost:8080/mydbr/lib/external/editarea/edit_area/edit_area_compressor.php?plugins&v=1461 [undefined 3666ms]
    [09:41:02.072] GET http://localhost:8080/mydbr/lib/javascript/procEditor.js?v=1461 [HTTP/1.1 304 Not Modified 1030ms]
    [09:41:02.102] Error in parsing value for 'filter'. Declaration dropped. @ http://localhost:8080/mydbr/lib/external/jquery/css/smoothness/jquery-ui-1.8.6.custom.css?v=1461:22
    [09:41:02.110] Unknown property 'zoom'. Declaration dropped. @ http://localhost:8080/mydbr/lib/external/jquery/css/smoothness/jquery-ui-1.8.6.custom.css?v=1461:335
    [09:41:02.120] Unknown property 'background-position-x'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.122] Unknown property 'background-position-y'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.124] Error in parsing value for 'box-shadow'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.125] Error in parsing value for '-moz-box-shadow'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.127] Unknown property 'user-select'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.131] Unknown property 'border-radius-topright'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.133] Unknown property 'border-radius-topleft'. Declaration dropped. @ http://localhost:8080/mydbr/interface/style.css?v=1461:1
    [09:41:02.135] Error in parsing value for 'background'. Declaration dropped. @ http://localhost:8080/mydbr/interface/normal.css?v=1461:1
    [09:41:02.137] Error in parsing value for 'background-image'. Declaration dropped. @ http://localhost:8080/mydbr/interface/normal.css?v=1461:1
    [09:41:02.141] Unknown property 'background-images'. Declaration dropped. @ http://localhost:8080/mydbr/interface/themes/taikala.css?v=1461:5
    [09:41:02.143] Error in parsing value for 'border-top'. Declaration dropped. @ http://localhost:8080/mydbr/interface/themes/taikala.css?v=1461:153
    [09:41:02.152] GET http://localhost:8080/mydbr/user/css/desktop.css [HTTP/1.1 304 Not Modified 936ms]
    [09:41:02.154] GET http://localhost:8080/mydbr/interface/moz.css [HTTP/1.1 304 Not Modified 920ms]
    --
    [09:41:09.321] GET http://localhost:8080/mydbr/images/find.gif [HTTP/1.1 304 Not Modified 1279ms]
    [09:41:09.325] editAreaLoader is not defined @ [b][/b]http://localhost:8080/mydbr/lib/javascript/procEditor.js?v=1461:1
    [09:41:09.328] GET http://localhost:8080/mydbr/interface/images/graySliding.gif [HTTP/1.1 304 Not Modified 1264ms]
    [09:41:09.331] GET http://localhost:8080/mydbr/interface/images/localize.png [HTTP/1.1 304 Not Modified 1264ms]
    [09:41:09.333] GET http://localhost:8080/mydbr/interface/images/help_16.png [HTTP/1.1 304 Not Modified 1264ms]

  4. myDBR Team, Key Master

    Nothing new in the output. The editAreaLoader object not being defined comes from the fact that the edit_area_compressor.php call fails. Most common cause of this is that IE is caching the old version. So, make sure you'r cache is cleared.

    Please do following:

    1) Try with another browser so you'll see if your server setup is ok. If it works with another browser, you will know it is your IE.
    2) If the problem is only in IE, try to clear the cache.
    3) If that does not help, delete the file mydbr/lib/external/editarea/edit_area/edit_area_full_with_plugins.gz (myDBR will recreate it nect time you will access the SQL Editor.

    --
    myDBR Team

  5. Saravanan_Kandasamy, Blocked

    as per suggestions, i did all 3 below steps but still my issue is not resolved

    1. cleared the IE cache
    2. tried accessing the Mydbr in FireFox
    3. deleted mydbr/lib/external/editarea/edit_area/edit_area_full_with_plugins.gz

    And also, the "edit_area_full_with_plugins.gz" is not getting created when I access of SQL Editor again, this could be a cause for this issue? please advise. thanks.

  6. myDBR Team, Key Master

    1. cleared the IE cache

    OK. This should cause IE to fetch the code from the server.

    2. tried accessing the Mydbr in FireFox

    Did you try the SQL Editor with FireFox? What was the outcome?

    3. deleted mydbr/lib/external/editarea/edit_area/edit_area_full_with_plugins.gz

    If the file is not re-created, the web server does not have privileges to do so, or your browser is caching the request so the server never sees the request.

    --
    myDBR Team

  7. Saravanan_Kandasamy, Blocked

    Both IE & Firefox gives same issue when accessing SQL Editor - clearing cache didn't help as well.

    There is no permission issue - becuase first time it creates the .gz file. & also verified apache has full permission to installed mydbr folder.

    And I observerd that when I access this URL "http://localhost:8080/mydbr/lib/external/editarea/edit_area/edit_area_compressor.php?plugins&v=1461", my web server is getting restarted.

    [I am running mydbr in windows 7 with 4GB RAM and Apache http 2.2 Web server & ioncube_loaders_win_vc9_x86_ipf(Version 4.0.14 for PHP 5.3)]

    what is the cause for this issue?

    Thanks.

  8. myDBR Team, Key Master

    You might want to take a look at the error logs what is causing your web server to crash. That should not happen. Also, the edit_area_compressor.php should deliver valid JavaScript to you.

    The edit_area_compressor.php compresses the SQL Editor code and delivers a gz version to the browser. There is something in your environment that causes this to fail.

    If you cannot find the cause of the problem, you can disable the gzip compression and use of cache file by changing the settings in EditArea settings. Open the mydbr/lib/external/editarea/edit_area/edit_area_compressor.php and change the settings for use_disk_cache and use_gzip. Please do understand that this should be done as "last resort" and you should first check what is causing the problem with the compression.

    --
    myDBR Team

  9. Saravanan_Kandasamy, Blocked

    Thanks a lot for the support, disabling compress to false in edit_area_compressor.php finally resolves the issue.
    Thanks.

  10. myDBR Team, Key Master

    You should still see what was causing the original problem. The compress option will be overwritten in each update and the uncompressed version may cause problems with Google Chrome's Javascript engine.

    --
    myDBR Team


Reply

You must log in to post.