Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Reordering Columns Throws A 1064 Error

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Reordering Columns Throws A 1064 Error

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • January 7, 2007 at 2:05 am #10117
      mtoboll
      Member

      I've just started learning to use SQLyog, and I've got Community Version 5.21 stable installed. The MySQL version I'm connecting to is 4.1.21

      Whenever I try to reorder columns on any table, I get an error 1064 telling me my SQL syntax is incorrect.

      I took the SQL from the history tab and tried to execute it in phpMyAdmin SQL window and get the same result.

      After I tried a wide variety of things, I finally found that on all integer columns, there is a COLLATE NULL in the statement. If I remove the COLLATE NULL from all the integer statements, the query executes fine.

      I read in the SQLyog revision history a while back there was a bug-fix regarding column reordering when connected to a 4.1.x database, but it says that was fixed and I'm on the latest version 5.21. I tried using 5.22 beta but that has the same problem…

      Is this a resurfacing bug?

    • January 8, 2007 at 5:05 am #23198
      peterlaursen
      Participant

      Verified as describe with 5.21 and 5.22 RC4 (integer columns only).

      I do not know aboaut the old discussion, but this will be fixed in 5.22 FINAL of course.

    • January 8, 2007 at 1:47 pm #23199
      mtoboll
      Member
      peterlaursen wrote on Jan 7 2007, 11:05 PM:
      Verified as describe with 5.21 and 5.22 RC4 (integer columns only).

      I do not know aboaut the old discussion, but this will be fixed in 5.22 FINAL of course.

      Cool, I thought maybe it was just me…

      The revision history wasn't specific, just said “bug reordering columns when connected to MySql 4.x” so, that was possibly something different.

      Great product BTW!

      -Thanks,

      Mark

    • January 8, 2007 at 1:51 pm #23200
      peterlaursen
      Participant

      Right now we are preparing for the release of 5.22 Final with the fix.

      After 1/2 hours more of testing we will start uploading, announcing etc …

    • January 9, 2007 at 1:59 am #23201
      mtoboll
      Member

      Most Awesome! 😀

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.