Results 1 to 2 of 2

Thread: MySQL Query Failed error after 4.5.0c patch

  1. #1
    hypo.jb is offline Junior Member
    Join Date
    Sep 2006
    Posts
    3

    Default MySQL Query Failed error after 4.5.0c patch

    Hi peeps.

    I upgraded from 4.5.0b to 4.5.0c today running on WAMP:

    Windows XP SP2
    Apache 2.2.3
    MySQL 5.0
    PHP 5.1.6

    And now am getting this MySQL error:

    Query Failed:INSERT into notes set id='7ee1e2d4-487b-7820-07ea-451db146b377', date_entered='09/29/2006 07:01pm', date_modified='2006-09-29 23:52:11', modified_user_id='59889a8a-a5f4-2e4c-9756-4509ecbcb05a', created_by='59889a8a-a5f4-2e4c-9756-4509ecbcb05a', name='Introduction Letter', filename='introduction.pdf', file_mime_type='application/pdf', parent_type='Emails', parent_id='7a13bd0b-e3f1-a521-98e9-451db1fb3b79', contact_id=null, portal_flag='0', description='Generic Introduction Letter', deleted='0'::MySQL error 1292: Incorrect datetime value: '09/29/2006 07:01pm' for column 'date_entered' at row 1

    A regular email works fine. A Marketing email set attached to a Campaign works fine. This error occurs when I try to use an email template with an attached Sugar Document from 'Compose Email'.

    Thanks in advance.

  2. #2
    jcarlos is offline Junior Member
    Join Date
    Nov 2006
    Posts
    1

    Default Re: MySQL Query Failed error after 4.5.0c patch

    Hello,

    I got the same error message when I sent a email using a template with a attached doc.

    Query Failed:INSERT into notes set id='53d3d25c-597f-6e08-79cc-455c6fdcecdb', date_entered='16/11/2006 11:18', date_modified='2006-11-16 14:04:05', modified_user_id='6c484826-912c-e13e-0628-43d515aaa5a2', created_by='6c484826-912c-e13e-0628-43d515aaa5a2', name='Anexo do E-mail: Grupo Bridge.pps', filename='Grupo Bridge.pps', file_mime_type='application/vnd.ms-powerpoint', parent_type='Emails', parent_id='491c1824-4ec1-08d5-7c6b-455c6f0c62b5', contact_id=null, portal_flag='0', description=null, deleted='0'::MySQL error 1292: Incorrect datetime value: '16/11/2006 11:18' for column 'date_entered' at row 1

    I could not find the PHP file to try to correct this problem.
    If anyone has a tip, please send us!

    Thanks
    JC

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •