Forum Replies Created
-
AuthorPosts
-
Ritesh
Member😀
I guess I need to call up the MySQL developers.
Ritesh
MemberIn the tunnel tab you need to provide SSH local port on which SQLyog will listen to correctly port forward MySQL requests.
Are you sure it is not same as the port on which your local MySQL server is listening?
Ritesh
MemberI have forwarded the issue to my development team.
I will revert back soon.
Ritesh
Member😀 😀
Ritesh
MemberSJA uses concat_ws() to generate checksums. The behaviour of concat_ws() seems to be different across multiple MySQL versions.
Just run a test sync for your setup and see if it works.
Ritesh
MemberHave you executed the same query from the MySQL command line tool?
I believe its a bug with MySQL as under no circumstances should MySQL server crash.
Ritesh
MemberQuote:Error No. 1130 Host '192.168.1.23' is not allowed to connect to this MySQL serverYou dont have the correct permission to connect to your MySQL server. You have to use either SSH or HTTP Tunneling to work with your MySQL server.
For more information press F1 in the connection window.
Ritesh
MemberQuote:However, I think the synchronization still should not crash in this way :-).It should not crash under any circumstances. It means that there is a bug in SJA which needs to addressed. Can you tell me your sync setup? Sample table structure and data to reproduce the bug will be appreciated.
Ritesh
MemberCan you send me your schema file?
Sample table and data will be appreciated.
Ritesh
MemberYou have to provide 24.11.231.50 and not http://24.11.231.50 in the MySQL host address field when you are using direct connection.
Can you post screenshots of your connection window for both Server and Tunnel tab?
Ritesh
MemberQuote:The second is used when a record is found to be different and the target is to be updated. Instead of updating the entire record, update only the columns specified in this list.Thanks for the suggestion.
I have forwarded your issue to my development team.
Ritesh
MemberThanks for your suggestion.
We already have plans to improve the logging details in v4.1.
Ritesh
MemberQuote:But only on 'Alter Table' window, japanese characters will be collapse.In an active cell, I mean edit mode cell, I can see them correctly and I can edit them.
I am not sure if I understood your problem.
Can you cut-n-paste the result of the following query?
Code:show variables like '%char%'Ritesh
MemberCan you tell me more about your setup?
Sample data to reproduce the error will be very helpful.
Ritesh
MemberYes.
-
AuthorPosts