Forum Replies Created
-
AuthorPosts
-
chuck
MemberI installed the latest versions on MY local to test the error that had been reproted to me. The remote computer(as far as I know)has not had any upgrades and has been working fine… til now.
The versions I wrote about were between me(local) and the server. Not the computer that does the synching. And we're both having the same problems.
At first I did not think that the versions were causing the problems so I downloaded the latest version onto my computer to test the sync to the server.
I'll check the versions on the remote computer. I Should probly upgrade everything.
Thanks
MemberOn local I'm running Mysql 5.0 and SqlYog 5.0.16 (I just noticed in SqlYog in the help>about it says 4.04 but select version() returns 5.0.16), windows xp
Server is running Mysql 4.0 and SqlYog 4.0.13, windows 2000
The ID field is generated @ runtime. It's always number of rows +1. Kind of a pain to try and explain why I had to do this.
I made these tables in SqlYog so I'm not sure why it made int(100). I just named the column ID with the datatype of int…Yog did the rest.
The oddest thing about this is nothing has changed. no upgrades. same system for over a year with out any problems.
Now, I know what your going to say about no upgrades “you have the latest version of SqlYog”, true, but the person that brought this error to my attention is runing the same version of MySql and SqlYog as the server and is unable to sync. His computer is the important one. It is collecting data remotely(offline) and synchronizing when a connection is available.
I don't if this helps with the debuging but I tryed to copy from server – local and it worked fine. when I copy from Local – Server I get the Mysql syntax error saying that ENGINE=MyISAM DEFAULT CHARSET=latin1 is the wrong syntax
Do you think I should try upgrading all the systems?
…also thanks for all the help
-Chuck
Memberhappened again…damn 🙂
FmoDate` varchar(50) default NULL,
`FmoResults` varchar(50) default NULL,
`EmoDate` varchar(50) default NULL,
`EmoResults` varchar(50) default NULL,
`GEmoDate` varchar(50) default NULL,
`GEmoResults` varchar(50) default NULL,
`TreRemarks` varchar(50) default NULL,
`Surname` varchar(50) default NULL,
`RCat` varchar(50) default NULL,
`THmoDate` varchar(50) default NULL,
`THmoResults` varchar(50) default NULL,
`DistNam` varchar(50) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
MemberSorry about that. It did not post everything I wrote. I guess it was to long
end of create statement(server)
PRIMARY KEY (`ID`)
) TYPE=MyISAM
create statentet(localhost)
CREATE TABLE `amuriaregister` (
`ID` int(100) NOT NULL default '0',
`DistTBNum` varchar(50) default NULL,
`Name` varchar(50) default NULL,
`Contact` varchar(50) default NULL,
`Sex` varchar(50) default NULL,
`Age` decimal(3,0) default NULL,
`TreatStartDate` date default NULL,
`Regimen` varchar(50) default NULL,
`DiseaseClass` varchar(50) default NULL,
`PatientCat` varchar(50) default NULL,
`TransferIn` varchar(50) default NULL,
`TransferReason` varchar(50) default NULL,
`TreatStopDate` varchar(50) default NULL,
`TreatComplete` varchar(50) default NULL,
`TreatNotComplete` varchar(50) default NULL,
`Remarks` varchar(50) default NULL,
`RegisterDate` varchar(50) default NULL,
`DiagUnit` varchar(50) default NULL,
`DiagUnitNumber` varchar(50) default NULL,
`TreatUnit` varchar(50) default NULL,
`TreatUnitNumber` varchar(50) default NULL,
`HIVStatus` varchar(50) default NULL,
`DisTrans` varchar(50) default NULL,
`PTDate` varchar(50) default NULL,
`PTResults` varchar(50) default NULL,
`TmoDate` varchar(50) default NULL,
`TmoResults` varchar(50) default NULL,
`FmoDate` varchar(50) default NULL,
`FmoResults` varchar(50) default NULL,
`EmoDate` varchar(50) default NULL,
`EmoResults` varchar(50) default NULL,
`GEmoDate` varchar(50) default NULL,
`GEmoResults` varchar(50) default NULL,
`TreRemarks` varchar(50) default NULL,
`Surname` varchar(50) default NULL,
`RCat` varchar(50) default NULL,
`THmoDate` varchar(50) default NULL,
`THmoResults` varchar(50) default NULL,
MemberLocalhost and server have the same version of MySql and SqlYog. I've been using them together for almost a year.
Did I get you right that BOTH syncs were server >> local? And it succeeds first time but not second time? And the DB was empty both times ?
Yes, but on the local I started with an empty database. I synched two tables, one empty and one full. All the data came over the first time with no errors but, the second time, I got the errors on both tables with no data. Some fields were added recently and I took them out but no changes.
Yes, the column causing the problems is the first field and the pk
One thing I do notice in the create statement on the localhost is at the bottom it says CHARSET=latin1. It does not say that on the server. What I find weard about this is that sja created this table when it synched.
create statement(server):
CREATE TABLE `amuriaregister` (
`ID` int(100) NOT NULL default '0',
`DistTBNum` varchar(50) default NULL,
`Name` varchar(50) default NULL,
`Contact` varchar(50) default NULL,
`Sex` varchar(50) default NULL,
`Age` decimal(3,0) default NULL,
`TreatStartDate` date default NULL,
`Regimen` varchar(50) default NULL,
`DiseaseClass` varchar(50) default NULL,
`PatientCat` varchar(50) default NULL,
`TransferIn` varchar(50) default NULL,
`TransferReason` varchar(50) default NULL,
`TreatStopDate` varchar(50) default NULL,
`TreatComplete` varchar(50) default NULL,
`TreatNotComplete` varchar(50) default NULL,
`Remarks` varchar(50) default NULL,
`RegisterDate` varchar(50) default NULL,
`DiagUnit` varchar(50) default NULL,
`DiagUnitNumber` varchar(50) default NULL,
`TreatUnit` varchar(50) default NULL,
`TreatUnitNumber` varchar(50) default NULL,
`HIVStatus` varchar(50) default NULL,
`DisTrans` varchar(50) default NULL,
`PTDate` varchar(50) default NULL,
`PTResults` varchar(50) default NULL,
`TmoDate` varchar(50) default NULL,
`TmoResults` varchar(50) default NULL,
`FmoDate` varchar(50) default NULL,
`FmoResults` varchar(50) default NULL,
`EmoDate` varchar(50) default NULL,
`EmoResults` varchar(50) default NULL,
`GEmoDate` varchar(50) default NULL,
`GEmoResults` varchar(50) default NULL,
`TreRemarks` varchar(50) default NULL,
`Surname` varchar(50) default NULL,
`RCat` varchar(50) default NULL,
`THmoDate` varchar(50) default NULL,
`THmoResults` varchar(50) default NULL,
`DistNam` varchar(50) default NULL,
MemberThanks. Works perfect!
MemberI'm running sqlyog Enterprise. I have already made the XML files using the sja wizard. Where does the sja reside so that I can run it without having to open sqlyog and can this be run from the click of a link?
MemberI just need to know if i can connect to the MySQL service on the coldfusion server. I've been using access as my web database and it cannot do the synchronization i'm looking for. Thanks for the quick responce, I thought I would ask before I bought sqlyog.
Thanks
-Chuck
-
AuthorPosts
