Page 1 of 1

SQL query window & paste

PostPosted: 04. January 2014 14:32
by stobal
Hello dear community,

just installed xampp 1.8.3-2 on Win7 and to my surprise I cannot paste text into the phpMyadmin SQL query window, as I use to do in my previous (vvery old 2.11.0 phpMyadmin). That is, copy-paste of SQL queries doesn't work.

I have a weather station running abroad, the weather data I read with a script that produces and saves into a log file complete Mysql query strings to input them into my database. I use to sequentially copy-paste them into the SQL window and execute. Now this method doesn't work in the new phpMyadmin delivered with xampp. - Of course, the best way were to insert the data with the very same script directly, but unfortunately there is another perl mysql driver issue that prevents that for the time being. So I have to insert manually into the database until that problem is solved.

Tried to look in the php and js source files, but wasn't able to locate the obstruct.

Is there any good reason why paste is disabled into the SQL query window? I mean, typing all queries directly in the window is stupid.

Maybe someone has an idea?

regards and happy this newest year
stobal

Re: SQL query window & paste

PostPosted: 04. January 2014 15:42
by JJ_Tagy
Copy/paste seems to work fine. Perhaps it is your browser. You could also make sure you are using the latest phpMyAdmin (4.1.3) if you still feel it is a problem with the application.

Re: SQL query window & paste

PostPosted: 04. January 2014 17:52
by stobal
Oh! Thanks.
But... in the same browser in the very next tab I have the old phpMyAdmin open and I can paste there. The new phppMyAdmin where it doesn't work is 4.0.9 that was shipped with xampp 1.8.3-2, the newest edition.

I'm still wondering.

Re: SQL query window & paste

PostPosted: 04. January 2014 18:02
by stobal
Hey, 33_tagy you're right, it is the browser, IE 10. In FF copy/paste works fine.

But how come one phpMyAdmin page works & another not, would be ineresting to know.

Thank you

stobal

Re: SQL query window & paste

PostPosted: 04. January 2014 18:32
by JJ_Tagy
JQuery browser compatibility perhaps. You should bump to IE11 to fix some if those small hidden quirks in 10.

Re: SQL query window & paste

PostPosted: 04. January 2014 19:35
by Altrea
Could also be an charset encoding issue.

Re: SQL query window & paste

PostPosted: 05. January 2014 01:21
by stobal
The textbox for SQL query Input behaves under mouse pointer as if it were no input field at all. I.e the context menu is the one which appears anywhere on a web page, and not the one with a few edit commands, that we see ontop an Input field. Well, but on the same phpMyAdmin page, there is another text Input for the name of a query that is to save. And there the context menu is the normal small edit menu.

So I reduced the circle of suspects onto a context menu misbehaviour. Paste works ok over the Edit menu button's paste command but not over context menu call with right click.

I tend to think, it is whether JQ not charset encoding issue, cause it occurs only in one textbox Input and not in another text Input field on the very same page. Something with the source must be masking this texrbox out of context menu in IE.

Thank you all for the interest and suggestions. We'we found another small hidden quirk in IE 10.

Stobal

Re: SQL query window & paste

PostPosted: 02. March 2014 22:44
by sunrisecc
I have run into the same problem with IE 10 and now IE11.

My work-around is to use CTRL/V via keyboard in lieu of paste

I am on Win 7 32-bit. with XAMPP 182.4. I even updated phpMyAdmin to 4.1.8 with nary a change.

Re: SQL query window & paste

PostPosted: 09. June 2014 15:03
by sunrisecc
This morning I updated to 4.2.3 of phpMyAdmin and the right-click has started to work again. I am on IE11.

Now using 182.5 of XAMPP>