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

Script Stop Working!

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Script Stop Working!

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 9, 2009 at 5:01 pm #29312
      peterlaursen
      Participant

      It simply looks like the query returns an empty resultset! We cannot comment more as we do not have the data.

      I do not understand 'preinstalling Windows' .. do you mean 'reinstalling Windows'? The only think I can think of is lattercase problems with databasenames and tablenames. Maybe the 'lower_case_table_names' variable has changed?

      (read http://dev.mysql.com/doc/refman/5.0/en/ide…nsitivity.html).

      I think you will need to 'break down' the query: first try one join, next another and next both.

    • July 21, 2009 at 9:25 am #29313
      angel_scream
      Member
      peterlaursen wrote on Jul 9 2009, 05:01 PM:
      It simply looks like the query returns an empty resultset! We cannot comment more as we do not have the data.

      I do not understand 'preinstalling Windows' .. do you mean 'reinstalling Windows'? The only think I can think of is lattercase problems with databasenames and tablenames. Maybe the 'lower_case_table_names' variable has changed?

      (read http://dev.mysql.com/doc/refman/5.0/en/ide…nsitivity.html).

      I think you will need to 'break down' the query: first try one join, next another and next both.

      Hi! And thanks a lot for the reply!

      Yes it is about 'reinstalling Windows'. But I rewrote the query with 3 JOINS,the way you told me, and it worked, I got the rezult from my 3 tables!

      I'm going to write you again if there arised any problems in similar case!

      Regards,

      Ina

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.