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

Email date not set by notification service

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Email date not set by notification service

  • This topic is empty.
Viewing 8 reply threads
  • Author
    Posts
    • October 13, 2004 at 6:57 am #8611
      gplatt
      Member

      My scheduled queries are running fine, but the from date is showing as 1970-01-01 (the 0001-01-01 value in MySql if I remember correctly) . Waht do I need to do in order to get a valid from date?

      thanks

      Guy

    • October 13, 2004 at 7:59 am #16408
      Ritesh
      Member

      Do you mean *from date* in the email?

    • October 15, 2004 at 5:25 pm #16409
      gplatt
      Member

      Exactly, the “from date” of the sent email.

      thanks

      Guy

    • October 16, 2004 at 7:57 am #16410
      Ritesh
      Member

      Can you paste the XML schema?

    • October 16, 2004 at 9:50 am #16411
      gplatt
      Member

      I guess I'm being a little dumb here, but I don't know what XML schema I should paste.

      I use the SQLyog Notifcation Services Wizard to run a query and to email the results to me on a daily schedule. When the email arrives I have the correct results, but the sent time of the email (as displayed in my email client) is wrong.

      Since the SQLyog Notifcation Services Wizard actually sends the email I presume that either I have not configured the wizard correctly or I have a bug. Can you tell me where I might start looking to solve this?

      thanks

      Guy

    • October 17, 2004 at 4:13 am #16412
      Ritesh
      Member

      SJA, the command line tool used by SQLyog to send notifications takes a XML schema as input. This schema contains all the information required by SJA i.e. source database informations, smtp server informations etc.

      The wizard in SQLyog generates this schema temporarily and deletes it after SJA has completed its job. You can ask the wizard to save this schema in the second last page where it asks you – “What do you want to do with the job?”. The wizard will save the schema in the filename specified by you in the last page of the wizard.

      With the schema file we will be in a better position to find and solve the bugs (if there are any). You can mail them to me at [email protected]

    • October 17, 2004 at 8:37 pm #16413
      Shadow
      Member

      It's an XML data file and not a schema file. Starts like …

    • October 18, 2004 at 7:52 pm #16414
      Ritesh
      Member

      Hello Shadow,

      Are you able to reproduce the error?

    • October 19, 2004 at 11:57 am #16415
      Shadow
      Member

      Didn't have time to test it. Perhaps this weekend! 🙁

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