[peterlaursen]

We are researching on it, and have posted a question in the Nullsoft Forums for details.

Could you explain a little WHY you want to do this?

[peterlaursen]

Sqlyog installer is not an InstallShield script but a NSIS installer script.

Does this help:

http://webyog.com/faq/31_87_en.html

I think the uninstaller would work with the /S switch too.

[peterlaursen]

I am sorry .. but I am now being informed that you did create a ticket.

However a TAG file with a corresponding structure-only dump would be most useful!

[peterlaursen]

Hello!

We received your mail, but that will be like searching a needle in a haystack with all the connections you have here! We will also need to manually create databases structures identical to yours from the info in the .db file.

Could I ask you to do this:

1) rename the TAGS folder (once again).

2) open a single connection, and wait for the new tag file to be built.

3) reproduce the problem with the '('

4) now zip the new TAGS folder and send in with a structure-only dump of everything this connection shows.

When sending in, please create a ticket and attach it here, as it will show up to all of us promptly then!

[peterlaursen]

I think the easiest way would be to export the database, 'search and replace all' in an editor and import!

It must be a text editor not a word processor! If the file is too big for Notepad, PSpad is a good free one.

But you will of course have to be sure that every instance of that character shall be changed!

BTW: you should update SQLyog!

[peterlaursen]

got it and working on it!

[peterlaursen]

.. my Tables entries have double quotes around them..

… likely that happened in CSV-import.

Data in your .csv file was quoted but you did not select (optiomally) enclosed by in the SQLyog CSV import dialogue.

A FAQ on CSV-import:

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

[peterlaursen]

“I get noting returned” not even an error message?

HOW do you I attempt to use the query:

SELECT UserName FROM tUser WHERE (Password =”password”)

try:

SELECT UserName FROM dbname.tUser WHERE Password = 'password';

(standard quotes in MySQL are ” ' ” – paranthesis'es are not needed – and this adds the database name

– but yours hould work as well!)

It is not a LETTERCASE mismatch?

I really cannot figure out here what 'you are missing'

… is there a RESULT tab showing up in the DATA area ?

Of course such query would work!!

Also what do you mean by “Read in and populated tables” ?

Are you sure that there any data in the table at all?

Expand the database in the Object Borwser (left) – click the table and select DATA tab in the DATA area.

[peterlaursen]

Please try…

Close SQLyog, delete or rename the TAGS -folder in the installation folder, start SQLyog and a new TAG -folder with SQLite .db files will be built.

It looks like a corruption of those files! Actually the now() -function is in the 'keywords.db' file. But I do not know in what order the TAGS -files and the 'keywords.db' file are searched!

@Ritesh@Manoj: Did we ever update the SQLite libray code with the latest available stable version (june 6th)?

[peterlaursen]

Best of all:

Export both databases as 'structure-only'. Zip the two files into a .zip archive.

Attach the file here or create a ticket if you do not want to expose things in public.

[peterlaursen]

We have this faq:

http://www.webyog.com/faq/34_102_en.html

I think the problems is the charset_connection.

When importing you must use 'utf8' as the charset for the connection in the wizard.

When connecting with SQLyog GUI you must use a korean non-unicode character set. 'koi8*'

The charset for the connection is available from the dropdown in the connection manager.

[peterlaursen]

Fixed in 5.16 beta12

[peterlaursen]

You can enable logging on the server side.

insert

log = path_tomylog.log

in the [mysqld] section of the my.ini file, restart and the MySQL 'general log' will log everything.

Some ideas why this could happen:

1)

Are you sue that you do not use te > operator weher it should be >= or vice versa in your algorithm? TIMESTAMPs sare not very accurate in MySQL (do not know about MS SQL). But consider i there are records with identical TIMESTAMPs that cause this?!

2)

if you convert a TIMESTAMP to an integer, then note that an 'ordinary' (2 byte) integer is not long enough. You will need a 4-byte inger if not data shall be truncated in one end.

[peterlaursen]

<_< I absolutely do not find anything wrong in your details. I wish I did. I also do not think permission is the only issue with the scheduler. I think it could be a Registry corruption issue or something similar. Could I ask you to do one experiment? Create a new user with the same priv's as your current user and try creating the sja.exe -job and run as this new user. Both when logged on as this user and as not logged on as him.

I won't make much sense if I do the same, because I do not have this issue with SJA. I have had with other programs before …

[peterlaursen]

We can implement this in the 5.16 tree. Most likely in next beta. Keep an eye on the 'News' section of this Forums for announcement.

[Author]

Posts