SQL query window & paste

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

SQL query window & paste

Postby stobal » 04. January 2014 14:32

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
stobal
 
Posts: 6
Joined: 24. December 2013 00:12
Operating System: Windows 7

Re: SQL query window & paste

Postby JJ_Tagy » 04. January 2014 15:42

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.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: SQL query window & paste

Postby stobal » 04. January 2014 17:52

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.
Last edited by stobal on 04. January 2014 18:03, edited 1 time in total.
stobal
 
Posts: 6
Joined: 24. December 2013 00:12
Operating System: Windows 7

Re: SQL query window & paste

Postby stobal » 04. January 2014 18:02

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
stobal
 
Posts: 6
Joined: 24. December 2013 00:12
Operating System: Windows 7

Re: SQL query window & paste

Postby JJ_Tagy » 04. January 2014 18:32

JQuery browser compatibility perhaps. You should bump to IE11 to fix some if those small hidden quirks in 10.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: SQL query window & paste

Postby Altrea » 04. January 2014 19:35

Could also be an charset encoding issue.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQL query window & paste

Postby stobal » 05. January 2014 01:21

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
stobal
 
Posts: 6
Joined: 24. December 2013 00:12
Operating System: Windows 7

Re: SQL query window & paste

Postby sunrisecc » 02. March 2014 22:44

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.
Seymour
sunrisecc
 
Posts: 13
Joined: 12. February 2012 02:23
Location: Toronto, Ontario
Operating System: Win 7/32

Re: SQL query window & paste

Postby sunrisecc » 09. June 2014 15:03

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>
Seymour
sunrisecc
 
Posts: 13
Joined: 12. February 2012 02:23
Location: Toronto, Ontario
Operating System: Win 7/32


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 9 guests