[peterlaursen]

I've uploadedd your pic to my private homepage, so that anyone can see ..

http://www.deepeter.dk/ErrEdit.GIF

I just repeat that I can edit the last/third row as wel with your data.

As I wrote the application crashed for me once, and that's all.

[peterlaursen]

Thanks .. I too had your sample data and imported them successfully.

I also managed to change data in the “log_time” field several times forth and back!.

I don't understand what you mean by “doubleclick”.

I too managed to get the “application error” once, but don't really know how … but it involved quite a lot of (panicked-style)”clicking around”.

I think the problem here is a problem with the system response-time. If you click on “log_time” it's like it takes some time for the system to be able “receive” the next click. By “doubleclicking” when the system is not ready for mouse input you may trigger an unhandled exception – or in windows terminology en “application error”.

I don't think double-clicking is defined for that function at all, but the functionalaity is rather:

1st (single)click will highlight the cell

2nd (single)click wil highlight the data in the cell

3rd (single)click will position the cursor inside the data

… actually it's just like a mouse works with a spreadsheet aplication, I think!

…and NOTE: 2nd and 3rd step can only be done when the system is ready for the input.

My point is that at best click's are ignored if the system is not ready – at worst it causes an error.

The problems probably involves the OS, the mouse driver the sqlyog application and maybe the mysql server as well. And I don't know if the peopele at sqlyog have a chance to do something about it! Although I think they can and should.

Try to perform 3 single clicks and wait a couple of seconds in between. Especially between 1st and 2nd click.

By the way:

What kind of mouse are you using ? If you use something “smart” try changing it to the most simple ps2-mouse that you can imagine! (I'm serious about this. Especially drivers for Logitech and the like wireless mouse could create a lot of problems with the system in my experience …). If your mouse does not use a standard driver, you may try if you can find a driver upgrade (or downgrade!). Maybe changed mouse settings will help. And I ahve also experienced a lot of problems with mouse when the built-in contact set is worn out (and burned surfaces on the contacts can cause a lot of “prelling” i.e. multiple signals for each click …) I can't explain how buffers for the mouse work with the system and the driver, but it's a practical experience of mine that a bad mose makes the whole system sick! I change them every ½ year and buy the cheapest!

[peterlaursen]

I can't reproduce!

I have a recently created music datatabase and I also happen to have an old base created some months ago. But they contain a lot of identical records. So this should be very close to your situation

so this sql:

select * from old_mp3_files a, mp3_files b where a.filename = b.filename;

… finds matching records and I can edit all fields (bigint's, varchar's, and double's) following the procedure that you describe, and I'll get no error. You are sure that the field word_no is a number(of some kind)-field and not a text(of some kind)-field ?

Besides it seems to be a new problem here (after they removed the dependancy on PK's for update) that the history pane truncates long sql statements …

[peterlaursen]

Also try something like

SELECT * from tablename_1 where word_nr = 5.

You should find the same record then. Are you able to change from 5 to 6 now ? And what does the sql now look like ?

[peterlaursen]

I've searched the Mysql documentation. Error 1064 is described as a “parsing error”.

Could you copy the sql from the history tab ?

[peterlaursen]

have you looked back in the forum ?

The important thing is that you understand how Sqlyog uses the “Primary Key” of the table for syncronization.

Please read through this (long) thread and come back with more questons then:

http://www.webyog.com/forums/index.php?act…=ST&f=10&t=1199

[peterlaursen]

No mapping of keyboard shortcuts is not user accessible with sqlyog.

I think it is a planned feature but I don't know for when!

Since introduction of sqlyog version 4.05 and have the same functionality, as far as I can see. If it is true that is a de facto standard in the “MySQL world” I think this one could be implemented with the same function. But is it that kind of big hurdle … ?

[peterlaursen]

Agreed.

There should be a button name somthing like “Hex view”.

When data makes sence as text the BLOB-viewer should open in “text-mode”. When data make sense as graphics it should open in “pic mode”. And when neither is true is it should open i “Hex-mode”. In case data is “misinterpreted” as text by the viewer you should be able to switch to hex-mode manually,

But still I think the possibility of launching an external apllication could be very useful in some cases (for instance sound, video, proces data).

[peterlaursen]

By the way …

In the long run I'd like the BLOB viewer to support more pic formats.

I believe there are GDK's (Graphical Devolpment Kits) available – among those the one use by the GIMP. I think it should be an option to have such a GDK working as as a plugin to the BLOB-viewer when it's installed on the system. There is another GDK availble from http://www.xnview.com (but I don't think this one is C-ready).

[peterlaursen]

I just can add that display of data in Ultraedit and Textpad is very similar!

[peterlaursen]

No

Hugues must ANSWER for himself … 😮

[peterlaursen]

Hugues must ask for himself!

But I don't know AXE.

But have a look at Textpad http://www.textpad.com.

[peterlaursen]

I believe this is a very reasonable request. After all binary data is first of all binary data!

But per tradition BLOB fields are mostly used for text and pic's but of course it can be anything! Multimedia (small sound and video clips for instance – or just pic formats not supported by yog), binary data sampled at industrial equipment, communication equipment etc, .. and you name it!

Ideally it should also be able to edit and/or launch an external application for editing and save changes transparently back to the base. A couple af user-definable buttons that can be assigned to external applications could maybe be done ????

But probably users with needs like this are relatively few.

[peterlaursen]

I want to be fair, so with the latest “Mysql Adminstrator” (1.0.20) user management works !

[peterlaursen]

this error message:

“You don't have permission to access /tunnel/SQLyogTunnel.php on this server”

is a typical apache error message when a server directive restricts some kind of access.

Server directives are typically found in the server configuration file (“httpd.conf”), a virtual host's configuration file or in a “.htaccess”-file.

It could be that the ISP has restricted execution of server-side scripts to certain directories.

Do you have a “htaccess”file that's under your control or is there a “control panel” available where you can configure things ?

Are you able to use other php.fies (just try rename any .htm or .html-file to php and try open it!). You could also try copying the SQLyogTunnel.php -file to the webroot. Also try running a simple php-file with a simple “echo” statement …

[Author]

Posts