[Marc]

Ritesh wrote on Apr 24 2006, 03:17 PM:

1.) Are you working as a non-admin user?

2.) Can you open up the sqlyog.ini from the SQLyog installation folder and set AutoComplete=0 under [GENERALPREF] section and try again?

3.) Were some existing Personal folder files were present from the old installation?

Hi, I got it running now.

First i'm working as an admin user. But the second point got me to solve this problem:

When I opened sqlyog.ini I found it was empty (0 byte size). I don't know how it was after installing it with an old version still installes because I removed the old version and reinstalled the new one before. Since there was nothing in sqlyog.ini and it seemed to me there should be something in, I removed (better I renamed) the ini file. And after that Version 5.11 worked and is now asking for specifying a connection on start up.

Maybe this is the same with some others here who have this problem.

[Marc]

I just upgraded to 5.11 Enterprise and i get the same problem now too. When starting, a window is opened but closed instantly again. That's it. No error message or anything.

I removed it completly and reinstalled (even to a different drive/folder) but the error is still there.

[Marc]

Ritesh wrote on Aug 16 2005, 09:25 AM:

BTW, is there any special reason to use tinyint instead of char(1)?

The special reason is, that 0/1 is the most common way to represent boolean values. And mysql itself represents boolean values as 0 or 1. Only Access sees it as Y/N. That was the main reason i decided to change it to tinyint.

And all of that was done before i dicovered that i can use SQLyog for importing. We bought SQLyog for another reason first 😉

EDIT:

And by the way, i found a way to do that now. I already had the database on a test server. Just the data there is not the current data. We now have a server that shall be the final server soon and i wanted to test it and import the current data there. I now used the structur synchronistion to get the structure from the other server and am now importing the data. This way the boolean fields seem to be interpreted correctly.

[Author]

Posts