Ever since upgrading to 4.4, and most recently in 4.4.2, CodeMirror syntax highlighting and auto-complete is not working. The CodeMirror JS appears to load correctly but there is no syntax highlighting. This is what the request looks like that loads JS:
CodeMirror is enabled.
Hi @Owen,
I've tested the pMA 4.4.2 version and everything works as expected, can't reproduce that error.
What is your pMA configuration?
Since it's a frontend error, something breaks or the file is not loaded, could you please control your browser console log to see if you have any errors?
Below you can see the url request to load the .js files:
http://phpmyadmin.dev/js/get_scripts.js.php?scripts%5B%5D=jquery/jquery-1.11.1.min.js&scripts%5B%5D=sprintf.js&scripts%5B%5D=ajax.js&scripts%5B%5D=keyhandler.js&scripts%5B%5D=jquery/jquery-ui-1.11.2.min.js&scripts%5B%5D=jquery/jquery.cookie.js&scripts%5B%5D=jquery/jquery.mousewheel.js&scripts%5B%5D=jquery/jquery.event.drag-2.2.js&scripts%5B%5D=jquery/jquery-ui-timepicker-addon.js&scripts%5B%5D=jquery/jquery.ba-hashchange-1.3.js&scripts%5B%5D=jquery/jquery.debounce-1.0.5.js&scripts%5B%5D=menu-resizer.js&scripts%5B%5D=cross_framing_protection.js&scripts%5B%5D=rte.js&scripts%5B%5D=tracekit/tracekit.js&scripts%5B%5D=error_report.js&scripts%5B%5D=doclinks.js&scripts%5B%5D=functions.js&scripts%5B%5D=navigation.js&scripts%5B%5D=indexes.js&scripts%5B%5D=common.js&scripts%5B%5D=makegrid.js&scripts%5B%5D=jquery/jquery.uitablefilter.js&scripts%5B%5D=sql.js&scripts%5B%5D=codemirror/lib/codemirror.js&scripts%5B%5D=codemirror/mode/sql/sql.js&scripts%5B%5D=codemirror/addon/runmode/runmode.js&scripts%5B%5D=codemirror/addon/hint/show-hint.js&scripts%5B%5D=codemirror/addon/hint/sql-hint.js&scripts%5B%5D=console.js
@Owen Did you try on http://demo.phpmyadmin.net? Which browser are you using?
This has been reproduced in Chrome, IE, and Firefox. I don't see any client side errors in Chrome Dev Tools.
I do have $cfg['CodemirrorEnable'] = true; in my config.inc.php
Are there other salient configuration directives?
It would really help if you could reply at my question above: "Did you try on http://demo.phpmyadmin.net" ?
Last edit: Marc Delisle 2015-04-14
Oops, sorry Marc. I did try on the demo site and the syntax highlighting worked as expected.
Great. Any chance that the config.inc.php you are looking at is not the one used by phpMyAdmin?
No, it is the only one.
Can you prove that by introducing a syntax error in it?
Sure. I won't have a chance until tomorrow morning though.
Another thing: via Settings > SQL queries > SQL queries, Code mirror can be disabled. This is part of user preferences (phpMyAdmin configuration storage).
Code Mirror is enabled.
I introduced an syntax error in config.inc.php and as expected, my install broke so, I can prove that it is the only config.inc.php file.
Can you try downloading the phpMyAdmin package again and overwrite current files with the freshly downloaded ones?
Make sure to backup any configuration files before doing this (they should not be overwritten anyway).
Last edit: Dan Ungureanu 2015-04-18
I have the same issue with the freshly downloaded 4.4.3 package.