No PRIMARY KEY bug?

[gh0st]

hey guys

im running mysql 4.1.10

i know that if there is no primary key synchronization is skipped, however, when doing a sync, sja tells me that 3 of my 6 tables do not have primary keys. Only one of my tables does not have a primary key.

`access` ****<---- only table that does not have a primary key Check sja.log for complete error details. `access` ****<---- only table that does not have a primary key Check sja.log for complete error details. `alias` 0 0 0 0 0 `alias` 0 0 0 0 0 `domain` 177 177 0 0 No change `domain` 177 177 0 0 No change `mailbox` 12842 12843 0 0 No change `mailbox` 12843 12842 1 0 No change `transport` Check sja.log for complete error details. `transport` Check sja.log for complete error details. `virtual` Check sja.log for complete error details. `virtual` Check sja.log for complete error details. the sja.log shows as follows No PRIMARY KEY defined in the table '`access`' No PRIMARY KEY defined in the table '`access`' No PRIMARY KEY defined in the table '`transport`' No PRIMARY KEY defined in the table '`transport`' No PRIMARY KEY defined in the table '`virtual`' No PRIMARY KEY defined in the table '`virtual`' please help!!

[Ritesh]

Please provide complete description of your setup. Versions of MySQL, SQLyog and whether you are using tunneling.

Can you send me a backup of your db?

[gh0st]

I am using two mysql servers version 4.1.10, both running on seperate servers running fedora core 2 linux

I am not using tunneling

I am using SQLyog job agent 4.0 on the primary sql server, running fedora core 2 linux

i cannot readily send a dump of our db as it contains passwords, i can send a dump of one of the tables which does infact have a primary key (in which sja reports that it does not)

if that would be enough, where would you like me to send the dump?

[Ritesh]

Quote:

i can send a dump of one of the tables which does infact have a primary key (in which sja reports that it does not)

Send to ritesh AT webyog DOT com

[Ritesh]

I received your SQL file. The table structure looks like:

CREATE TABLE `virtual` (

col1,

col2, col3,

UNIQUE KEY `col` (`col1`)

}

If you notice then the key is UNIQUE but not PRIMARY. You have to explicitly define PRIMARY KEY for the table. SQLyog does not support UNIQUE KEY as of now.

[gh0st]

so, its a feature then, not a bug

thanks 😉

[Author]

Posts