[peterlaursen]

If you already have a table the simplest way to create a “view of a table in sqlyog” is CREATE VIEW viewname AS SELECT * fRM tablename;”.  But why would you want to do this?

 

Besdies a VIEW is a server-side and not a cleint-side object.  Maybe I don’t understand what you mean? 

[peterlaursen]

OK .. if the job flie specfies a single table only it could be selected in the GUI. Valid point IMO.

[peterlaursen]

Please try to:

 

1) reboot Windows if youd id not already

2) temporarily disable what AV/security sotware you have. 

 

If no luck then try to disable ‘session restore’. so that we can see if this is related. 

[peterlaursen]

We are communicating on mail now. 

[peterlaursen]

No, but it is probably a memory issue.  Have you tried to reboot WIndows?

[peterlaursen]

Please try 12.13. Have you restarted Windows, BTW? 

[peterlaursen]

Actually I am not able to explain right now why the error message in SQLyog is different from Notepad, for instance.  We will look into it.

[peterlaursen]

I have already told that the sqlyog.err file records internal SQLyog errors only and not MySQL/server errors. Teherver logs its errors 8and optionally warnings) in its own error log – refer https://dev.mysql.com/doc/refman/5.6/en/error-log.html 

[peterlaursen]

It is a problem with the specific file name “paid subs, start/end”. The “/” character causes the problem and it is the same on Win7 and Win10. Every ‘favorite’ in SQLyog is saved as a file. 

 

Refer https://kb.acronis.com/content/39790 ” The following characters are invalid as file or folder names on Windows using NTFS: / ? : * | ” and any character you can type with the Ctrl key“. Just try to save any file from any program (Notepad, whatever) with such character in the filename, and you will an “invalid filename” or similar error message. The error message as you see it in SQLyog is returned from the Windows API and not from our code. 

[peterlaursen]

Already had a reply in the last bug report.

 

Please see https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_error_count

 

.. and execute “SHOW  VARIABLES LIKE ‘max_error_count’;”. What does this return? 

[peterlaursen]

This looks extremely stange. No constants in the INSERT statement. This is not from an SQL dump but from a script of some(other) kind. Are you sure that you are not mismatching files (or maybe had overwritten a dump/backup with a script)?

[peterlaursen]

I now also posted this http://bugs.mysql.com/bug.php?id=77902

[peterlaursen]

1) If SHOW WARNING truncates it seems like it is the server that does. It probably has a fixed length buffer. We wll check this

 

2) I also noticed yesterday that ‘warning_count’ always seems to return “0”. I posted to bugs.mysql.com about this already http://bugs.mysql.com/bug.php?id=77883

[peterlaursen]

@Menon .. Let us continue here http://forums.webyog.com/index.php?showtopic=7892

 

(and I was wrong when i wrote I have replied. Seems that I did not hit the “post” botton)

[peterlaursen]

And now I am moving this to SQLog category. 

[Author]

Posts