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

Table Data Tab Limits Setting

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Table Data Tab Limits Setting

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • March 8, 2013 at 7:54 pm #12943
      WilandTech
      Member

      Hi,

      We encountered an issue with being able to set the result limits when clicking the Table Data Tab. We created a table the other day with 1200 rows and un-checked the limit rows box to view them all. Now that table has 7 million rows and we are no longer able to reset the limit rows box. Every time we click upon the tab the application will just spin like it is processing, then report an error that it couldn't create a mysql dump, then SQLyog will become unresponsive and inform that it can close the program or search online for a solution.

      We have tried setting the limits to 1000 in the Tools -> Preferences pane but it appears that this table is still holding its settings in place. Is there any way to change the limits back without having to re install SQLYog or wipe the sqlyog.ini file?

      Included is a seperate test showing the table data tab working fine, then it causing a crash.

      This has occurred in Enterprise Versions 9.33 and in 10.42 as well.

      The server is running CENTOS 6.3 and Mysql 5.6.10

    • March 11, 2013 at 4:32 am #34223
      sathish
      Member

      Hello,

      Quote:
      We created a table the other day with 1200 rows and un-checked the limit rows box to view them all. Now that table has 7 million rows and we are no longer able to reset the limit rows box.

      The application will wait until the data is being loaded in table data tab. You can stop and change the settings.There is a stop icon in the table data tab when the data is being loaded. You can click on the stop icon and check the limit rows option. Please find the screenshot attached.

      Regards,

      Sathish

    • March 11, 2013 at 6:00 pm #34224
      WilandTech
      Member

      That resolves our issue with 10.42, But is there the same capability in 9.33? I was unable to find a stop button.

    • March 12, 2013 at 4:57 am #34225
      sathish
      Member

      There is stop button in table data tab in 9.33 as well. Please find the screen shot attached.

    • March 13, 2013 at 4:02 pm #34226
      WilandTech
      Member

      The stop query button does not work for us. We use SSL certificates for connecting into our database and receive an error 1045 message back whenever we click on it.

      I am going to try and just kill the query from a second session as soon as it launches. Thank you.

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