[sathyaw]

appreciate if It is possible to know when this fix can be incorporated to a alpha or beta code, i mean the linux version.

[sathyaw]

so where can I download the 5.1 BETA ?

😛

[sathyaw]

oh man, you are great, really appreciate your help.

what we see here is that so called lines with duplicate time stamps being not updated. thing is that in my case target tabel is not getting updated at all.

Table Op Msg_type Msg_text

---

---

---

---

vobbnj22cpy.cards check status OK

Table Op Msg_type Msg_text

---

---

---

---

vobbnj22cpy.cards analyze status Table is already up to date

I will definetly get some definitive data. I am travelling at a customer location hence the slow response but will get it by the end of this week for sure.

again thanks a lot

[sathyaw]

actually unequeid is not uneque as it says, hence cant make it the only PK. SQL versions are both on 4.0.18.

if the data can be added to first table (in first server), why SJA cant add the same data to the second table (in the second server ) which was actually copied by SQLYOG GUI in the first place is puzzling me.

I have the option that I can do anything with the second table, is there anything that I can try only on the second table to get over with this problem ?

sorry, I thought I posted this last night, but was only previewing 😮

[sathyaw]

here is how the table is made;

/*Column Information For – vobbnj22cpy.tab1*/

---

Field Type Null Key Default Extra Privileges

---

---

---

---

---

---

---

ctime timestamp(14) YES PRI (NULL) select,insert,update

c_num varchar(40) YES (NULL) select,insert,update

did varchar(40) YES (NULL) select,insert,update

disposition varchar(20) YES (NULL) select,insert,update

billseconds int(11) YES (NULL) select,insert,update

rate int(11) YES (NULL) select,insert,update

billcost int(11) YES (NULL) select,insert,update

uniqueid varchar(40) PRI select,insert,update

/*Index Information For – vobbnj22cpy.tab1*/

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment

---

---

---

---

---

---

---

---

---

---

---

---

cdrs 0 PRIMARY 1 ctime A (NULL) (NULL) (NULL) BTREE

cdrs 0 PRIMARY 2 uniqueid A 11629 (NULL) (NULL) BTREE

/*DDL Information For – vobbnj22cpy.cdrs*/

---

Table Create Table

---

---

cdrs CREATE TABLE `cdrs` (

`ctime` timestamp(14) NOT NULL,

`c_num` varchar(40) default NULL,

`did` varchar(40) default NULL,

`disposition` varchar(20) default NULL,

`billseconds` int(11) default NULL,

`rate` int(11) default NULL,

`billcost` int(11) default NULL,

`uniqueid` varchar(40) NOT NULL default '',

PRIMARY KEY (`ctime`,`uniqueid`)

) TYPE=MyISAM

[Author]

Posts