Forum Replies Created
-
AuthorPosts
-
RiteshMember
😀
I guess I need to call up the MySQL developers.
RiteshMemberIn 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?
RiteshMemberI have forwarded the issue to my development team.
I will revert back soon.
RiteshMember😀 😀
RiteshMemberSJA 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.
RiteshMemberHave 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.
RiteshMemberQuote: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.
RiteshMemberQuote: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.
RiteshMemberCan you send me your schema file?
Sample table and data will be appreciated.
RiteshMemberYou 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?
RiteshMemberQuote: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.
RiteshMemberThanks for your suggestion.
We already have plans to improve the logging details in v4.1.
RiteshMemberQuote: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%'RiteshMemberCan you tell me more about your setup?
Sample data to reproduce the error will be very helpful.
RiteshMemberYes.
-
AuthorPosts