[Ritesh]

Quote:

As of MySQL 5.0.3, a BIT data type is available for storing bit-field values. (Before 5.0.3, MySQL interprets BIT as TINYINT(1)

Probably he was using MySQL version < 5.0.3 😀

[Ritesh]

Never heard this error before 😮

SQLyog logs all the queries in History tab. Can you check and tell me if there is any bug with the query generated?

Can you insert data by executing INSERT INTO… SQL command from the query window?

[Ritesh]

Bug fixed in v4.07 development tree.

[Ritesh]

Check http://dev.mysql.com/doc/mysql/en/insert.html for more details.

[Ritesh]

Thats very strange.

Are you using the same version of SJA?

[Ritesh]

Quote:

now i'm updating the table.

So is it working or not?

[Ritesh]

This bug affects CREATE TABLE option too.

Both the bugs have been fixed in v4.07 development tree.

[Ritesh]

Bug solved in the v4.07 development tree.

[Ritesh]

We have never tried the viewer with 48-bit and 96-bit PNGs.

[Ritesh]

In MySQL, tinyint(1) is a synonym for BOOL.

Check http://dev.mysql.com/doc/mysql/en/numeric-types.html for more details.

[Ritesh]

SQLyog's BLOB Viewer only supports JPEG/GIF. PNG and TIFF are not supported as of now.

Quote:

Clicking on the save button sometimes will cause SQLyog to start consuming 100 % of CPU time and hang.

This is a known issue in Win 2K. It will be fixed in v4.07.

[Ritesh]

Please send a mail to [email protected] with your info.

[Ritesh]

More information on the MySQL privilege system can be found at http://dev.mysql.com/doc/mysql/en/privileg…ege-system.html

[Ritesh]

I believe he does not have permission for the other databases.

[Ritesh]

Quote:

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 5fc810cf62601df84b7923b9964c53e6 |

+

---

+

1 row in set (0.00 sec)

On server (A) [webserver with red hat]

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 9d5ed678fe57bcca610140957afab571 |

+

---

+

1 row in set (0.01 sec)

As you can see the results are different.

SJA will not work between those two MySQL versions. It is due to the fact that MySQL returns different result for concat_ws() function across multiple MySQL versions.

This is the reason that SJA is not syncing the data correctly.

[Author]

Posts