[peterlaursen]

It also has to do with the workings of SQLyog

for instance, with this table

Code:

CREATE TABLE `tt` (                        
         `id` bigint(20) NOT NULL auto_increment,  
         `t` varchar(50) NOT NULL,                
         `n` bigint(20) NOT NULL,                  
         PRIMARY KEY  (`id`)                      
       ) ENGINE=MyISAM DEFAULT CHARSET=latin1      

SQLyog wil generate this SQL

Code:

insert into `test`.`tt` ( `id`, `t`, `n` ) values (  '',  'yy',  '' )

when inserting the singe value 'yy' in field `t` from the data-pane.

Now '' (empty string) is a legal string value, but not a legal numerical value!

It is a problem that the grid view of DATA and RESULT panes do not distinguish between NULL's and empty strings. I know it is on the TODO.

[peterlaursen]

in 'non-strict' mode the server inserts 0 (zero) for a undefined numerical and '' (empty string) for an undefined string, 0000-00-00 for an undefined date etc.

in 'strict mode' an error ” out of range value …” occurs.

We have been discussing 'strict mode' a few times recently!

Strict mode is new with SQL version 5. With earlier version stric mode is not available.

You can go through:

http://www.webyog.com/forums/index.php?act…ite=strict+mode

You will find link to the MySQL docs explaining in those threads ….

And a FAQ entry:

http://www.webyog.com/faq/28_72_en.html

[peterlaursen]

You and the company can upgrade to version 5, I think.

Version 5 will need to be registered with a new code anyway.

[peterlaursen]

@gobi

could you possibly find that link again?

It could be of interest for our FAQ!

[peterlaursen]

It's in the FAQ too:

http://www.webyog.com/faq/29_51_en.html

[peterlaursen]

edit: I believe I wrote some nonsence! so away with it! 🙁

But the problem is that the WAMP server setup win2003-Apache-php-MySQL can be done in so incredibly many different ways.

[peterlaursen]

nevertheless:

http://support.microsoft.com/?id=309508

It look like the configuration of the IIS lockdown tool is the cause

http://www.microsoft.com/downloads/details…61-FD755D23CDEC

But somewhat confusing – the lockdown tool is really a “patch” for insecurities of various MS server software. I found somewhere that Win2003 does not need it. Maybe it is integrated ?

[peterlaursen]

Another “trick” as I wrote in the BLOGS:

Quote:

I few days ago I came across this report in the MySQL bug reporting system:

http://bugs.mysql.com/bug.php?id=12702

well .. it's not really a bug. But I guess we have all experienced that long running query on 'localhost' “kills” everything so that the computer can't be used for anything else. Reason is that the query proces has a priority of “high” or in numerical terms “8”. Normal priority is “6”. Only very critical system tasks have “9” .

There is a simple setting to give a query proces “normal” priority, as described in the bug report. The setting can be set from “MySQL Administrator” .. Startup variables .. Advanced

I have changed my setting!

[peterlaursen]

Quote:

The handle is in the wrong state for the requested operation

I have been googling on that error message and it seems to be related to MS IIS webserver (and not Apache). Can you confirm that your webserver is an IIS server ?

There are also some 'hits' referring to Exchange Server. Do you use notifications ? If yes, please try not to!

[peterlaursen]

Or you can use “MySQL Administrator” from MySQL.

[peterlaursen]

What you can do is to work from the RESULT pane. When you SELECT data then don't select the timestamp field!

[peterlaursen]

I know they are hardcoded! I can see that! 😀

[peterlaursen]

Quote:

I get an error suggesting duplicate keys

No – you get an error suggesting dublicate ENTRIES for a key! The error message is a MySQL error and not a SQLyog error. Line no. 1352 must have a dataset that is allready in the database as referred to by “key 1” (probably a PK)

Do you LOAD into an empty table? (EDIT: file >> table)

Another reason could be some mismatch occurring due to existence of some special character like ' ” % or _ in the dataset and incorrect use of escaping within strings.

You might find some useful hints here:

http://www.webyog.com/faq/28_73_en.html

For further help we will need to see

1) that line 1352 and your DELIMITED, ENCLOSED and ESCAPED settings with the LOAD DATA INFILE statement.

2) create statement for the table – expecially how that 'key 1' is defined

[peterlaursen]

… just for your info:

The Enterprise version runs as a demo with full functionality for a month.

[peterlaursen]

Quote:

plink.exe isn't in the windows process list

It should be and it is here! If your screen resolution is big enough try open task manager and SQLyog at the same time. When you click 'test connection' plink.exe occurs in task manger. It goes away again when you click 'OK'

Next try 'Connect'. Do you see any 'flickering' in the task manager indicating that plink.exe is started, but then killed immidiately ?

[Author]

Posts