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

6.14 Structure Sync – Buttons Stay Greyed Out/disabled

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › 6.14 Structure Sync – Buttons Stay Greyed Out/disabled

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • November 25, 2007 at 2:56 am #10663
      ken
      Member

      I try a structure synch in 6.13, then 6.14, and the error

      Error Number : 1146

      Error Message: Table 'mysql.proc' doesn't exist

      pops up twice.

      The lists of database objects show up fine, and I see that there are many subtle differences in fields, like Default '0' in one table, but not the other, and there is one table that exists in one db and not the other. Anyway, it looks like the tool is working just as it should….EXCEPT…the buttons at the bottom never become active, so I am unable to select objects, or save/paste SQL, etc.

      db #1 is: organic_civicrm19, utf8_general_ci, Innodb

      db #2 is: organic_civicrm19_oa, utf8_unicode_ci, Innodb, except for the new zipcodes table, which is MyISAM, and also latin1_swedish_ci.

      It appears to relate to this issue: http://bugs.mysql.com/bug.php?id=9496, but I am still unclear on what to do to fix my problem.

      Thanks,

      Ken

    • November 25, 2007 at 10:09 am #25437
      peterlaursen
      Participant

      1)

      Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

      I will have to know the exact server version if I should detail more .. but what is the exact server version?

      2)

      So you have an option to try another server installation (best of all a 'fresh install')?

    • November 25, 2007 at 10:11 am #25438
      peterlaursen
      Participant

      1)

      Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

      I will have to know the exact server version if I should detail more .. but what is the exact server version?

      2)

      So you have an option to try another server installation (best of all a 'fresh install')?

    • November 25, 2007 at 10:17 am #25439
      peterlaursen
      Participant

      1)

      Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

      I will have to know the exact server version if I should detail more .. but what is the exact server version?

      2)

      So you have an option to try another server installation (best of all a 'fresh install')?

    • November 25, 2007 at 10:26 am #25440
      peterlaursen
      Participant

      1)

      Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

      I will have to know the exact server version if I should detail more .. but what is the exact server version?

      2)

      Do you have an option to try another server installation (best of all a 'fresh install')?

      Maybe buttons becoming greyed out is not the most intuitive way of responding to this situation. But we would not be able to sync anyway if the server(s) do not send the information needed!

    • November 25, 2007 at 5:51 pm #25441
      ken
      Member

      The server is MySQL – 5.0.48

      I found that deleting the single MyISAM table was not the simple fix that had naively hoped that it would be.

      I am going to have to check with my hosting company about doing the reinstall, I think…

      Thanks, Peter, as I realize that my server problems are actually out of the scope of your software.

      Buttons grayed out is fine, I agree. Maybe one little error message like : “Sync can not proceed. Server A/Server B did not provide XYZ information” would be nice.

      I will report back…

      Ken

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