[peterlaursen]

@polkaforever

I believe that most likely the reason for the skipped rows is that some data do not match the columns definition. Such as inserting 'a' in a numerical field. The error could arise because of error in escaping.

You will have to find some sample rows yourself that don't import. Then if we get

* the data

* the LOAD DATA statement

* the create statement for the table

we might be able to get closer. But not with the information that you give her.

[peterlaursen]

Quote:

Now I've found out that ’ (ASCII #146) is a problem and not an usual “vertical” apostrophe

I would like to go a little deeper into this. Did you just find out for yourself or do you have some reference?

What is version and the localization of your Windows, the MySQL versions and the charset/collation used with the MySQL servers?

And what editor did you use?

[peterlaursen]

Quote:

This would allow you to roll new micro-versions without changing the release number on your web-site

I don't think the way that SQLyog is compliled makes it possible to roll out 'micro-versions' (or 'deltas' in Linux RPM-terminlogi) or any other sort of 'modular compilation'. After all the whole installer is only 5 MB, so a complete download is not a big deal. And the installation proces takes only about 10 seconds. So I don't think there is any need for any 'modular compilation' either.

A 'check for update' however would be nice. You often find it in the 'help'-menu. There is plenty of room for an icon too.

I would HATE an auto-update that is not optional !!

And I totally disagree that version number should not change. Even if ONE SINGLE BIT changes the version number should change! it could be like 5.0a and 5.0b then. That would be OK. I remeber once Ritesh posted a new version. There was a problem with the installer script. He fixed it and posted the fix with same version number a few hours later. That froze our relationship for a week 😆 .But I am serious about this. ANY version should be uniquely identified. If someone experiences problems with version x.y and another one does not, you MUST know that there is only ONE version x.y. If not support would be impossible.

[peterlaursen]

And if you use HTTP-tunnelling it also involves php-configuration.

[peterlaursen]

Actually I have requested too that 'Bulk Size' could be user settable.

[peterlaursen]

Indian boys should be sleeping now!

Let them look into it tomorrow!

There also was a problem with some of the beta's and the rc's that the help file did not launch. It could be the same problem.

[peterlaursen]

BTW: doesn't Windows exist in Hindi and Tamil and the other 200 languages of India? There should be lots of chances to test, even if it only exists in 20 of them!

[peterlaursen]

@ritesh

could it be a localsation issue?

The folder name 'Program Files' is translated in localised Windows versions for instance. In Danish is is 'Programmer'. The symbolic '%Programs%' is substituted with the real name and should be used. But you probably know!

I suspect that something went wrong when you coded the ability to write to 'Documents and Settings' (that for some strange reason is NOT localized!). If neither 'Program Files' nor 'Documents and Settings' exist then it could fail to read ini file, if it is hardcoded that way. And 'Program Files' does not exist in localised Windows and 'Documents and Settings' not in W98. But I have no W98 to test with.

Just my guess that it is something like this <_<

[peterlaursen]

@ritesh

It was Win2003 server 😛

[peterlaursen]

I think this is a problem with co-existence of programs. It could be a single bug with a driver that causes this. Any pop-up-killers and the like ??

[peterlaursen]

@SK Enigma

this is a very old discussion now! Nobody remembers details.

You must explain much more in detail. As if it was a new thread.

for instance:

Server version?

SQLyog version?

Create statment for the table?

Sample data

etc …

[peterlaursen]

well .. I can only say that it works for me on SUSE 10.

I don't know if there could be an issue with Read Hat 7.

[peterlaursen]

1) And you are PERFECTLY sure that the MySQL server is running?

2) Can you connect from command line client 'mysql' (probably in /usr/bin) -or anything else such as a php script – with the same credentials? You could also install SQLyog (for windows) with WINE on Linux.

I am not quite sure what you mean here

QUOTE

i also checked the port its working

How did you check?

You could also try the ip '127.0.0.1' instead of 'localhost'

[peterlaursen]

there are nore problems I believe

1) the beginning of the SQL-string concatenates to

QUOTE

SELECT tbl_MishapDatabase.*FROM tbl_MishapDatabaseWHERE tbl_MishapDatabase.Rank=' … etc

You must put in a blank before WHERE … but that's a problem more places in the code.

But this one generates the first eror (the one that you get). There is no table 'tbl_MishapDatabaseWHERE' I guess … 😛

2) This will give you problems too:

strSQL = = strSQL

It looks lik VB to me and I don't know it very well but it should probably only be

strSQL =

3) I doubt that all the quotes are put the right places! But it is impossible to judge in this layout. Use the CODE tage of the Forums system! But in general reading VB is hopeless …

You should write a program that prints the strSQL to a file and have a look at the SQL statement generated. And verify the that SQL itself runs and retursn as expected. SQLyog is very good for this. Also writing the strSQL to a messagebox while you are developing is a simple trick if you have no other and better debugger.

You can delete or comment-out the messagebox when you have verified it.

[peterlaursen]

Please check this: http://www.webyog.com/faq/6_26_en.html .

It says

Quote:

* Also a reproduceable test case is always much appreciated

You'll need to give every bit of information needed to reproduce the problem.

And a reproduceable test case is a test case – that is a simplified one with a few data rows and colums only and ALL relevant information. You are supposed to do most of the work yourself to solve your own problems and structure things so that others can help.

Sorry, but I have to say it that way. No one can use the messy printout in your first post for anything!

[Author]

Posts