Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantWith hindsight – I do not think this is an upgrade problem. Data Sync was completely rewirtten in 7.x. I think basically there is some specfic data type/server version combination we do not handle properly.
1) Please tell server versions involved!
2) Please provide a structure-dump. If server versions are different please do from both hosts.
peterlaursen
Participanthmmm …
looks like there are two issues:
1)
all SJA's released should be backwards compatible. But seems not to be the case here. Please attach a small dump of the table (probably a structure-only will do) raising this (you may create a ticket for privacy). Don't forget to ZIP …
2)
“SJA.EXE … resides in a different directory than SQLyog itself”. They should both be in installation folder! please copy SJA to there and delete/ rename the one where it is now. Actually one more user reported that SJA was in 'AppData' folder after install.
peterlaursen
ParticipantYes .. that is to the best of our knowledge fixed now.
peterlaursen
ParticipantI am sorry, but I did not notice that there was an old discussion above your latests post!
Actually I and not updated with Migration Tool status. We will revert to this tomorrow morning.
peterlaursen
ParticipantCould you possible link to the old discussion?
peterlaursen
ParticipantI have replied in your ticket.
Please create either a ticket or a Forums post – not both.
It is easiest if all discussion is in one place!
peterlaursen
ParticipantFix will be from 7.1 beta1. Please verify when avail (probably by Mon-Tue next week).
peterlaursen
Participantadded: http://code.google.com/p/sqlyog/issues/detail?id=826
.. and I forgot the image in my first post! Coming here:
[attachment=965:create_index.jpg]
peterlaursen
ParticipantWell .. basically only a column more is required in create/alter index dialogue and a little bit of code to generate ASC or DESC.
But even though mySQL write like that in the manual I would not be surprised if it will still not be implemented in 3 years! The main reason they added this is, I think, for compability with table definitions from other databases where it works (or just for formal compliance with SQL standards).
We will add this to our issue tracker, but not as a priority issue.
peterlaursen
Participantwe found this too:
http://www.microsoft.com/technet/prodtechn…8.mspx?mfr=true
Maybe some other program (like an indexing tool, a virus scanner) has locked the drive!
peterlaursen
ParticipantWe never hard about this before!
Please tell:
Are you exporting to are removable drive (like a USB stick)?
You are not exporting to a folder that is read-only?
Do the other export options (SQL, HTML, (non-Excel) XML) work OK with same settings?
Program version? Operating System?
peterlaursen
ParticipantPer .. this is a special service for you!
In recent versions there is a webcam coded in SQLyog, and when it sees it is you there, it will do like this .. just to make you feel important! 😉
peterlaursen
ParticipantIssue confirmed. This was introduced as a 'unwanted sideeffect' of the fix for another recently reported multimonitor issue. Will be fixed in next release.
peterlaursen
Participant“In previous versions, the name was taken from the first field that was added.”
This is some time ago now – almost a year I think – this was changed. It was in 6.1x (I tested that 6.16 behaves as recent versions)
This is a not something that was forgotten. It was changed deliberately/consciously.
You may refer to this report:
http://code.google.com/p/sqlyog/issues/detail?id=430
One more problem is that if you have two indexes specifying the first column they will be named identically unless changed by user.
If we should revert this back I think we should do it even better .. so that if 2 indexes are specified wiht same 1st_column, index names should be 1st_column_1 and 1st_column_2 respectively. And *IF* user has been writing his own name in the name field, we should not replace it! That was the issue!
We will discuss this again. I think we should try to find a better solution than *both* what it was before and what it is now!
peterlaursen
Participant1)
Also check the lines in sqlyog.ini like
Left=81
Top=34
Right=1408
Bottom=878
Does it open as described by those coordinates?
2)
Is your secondary monitor positioned left or right to the primary monitor? Was the relative position of the two defined in some driver utility?
-
AuthorPosts