Results 1 to 4 of 4

Thread: Activities/MySQL error message?

  1. #1
    KACP is offline Senior Member
    Join Date
    Aug 2008
    Posts
    21

    Question Activities/MySQL error message?

    I'm seeing an error message within the Activities console of Sugar after trying to import Contacts to Accounts. No Activities are now shown. Attached is the screen shot received during import and the error message received afterwards.

    Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from accounts where id = '#BO6 4U6&\'::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''#BO6 4U6&\'' at line 1

    CE 5.2.0i
    The version of MySQL is 5.1.22.
    PHP 5.2.5
    Apache 1.339

    Any ideas how to fix?
    Attached Images Attached Images  
    Last edited by KACP; 2009-09-15 at 04:51 PM.

  2. #2
    KACP is offline Senior Member
    Join Date
    Aug 2008
    Posts
    21

    Question Re: Activities/MySQL error message?

    Any ideas?

  3. #3
    KACP is offline Senior Member
    Join Date
    Aug 2008
    Posts
    21

    Default Re: Activities/MySQL error message?

    I created a log file after finding that no sugarcrm.log existed, even though it shows created in logger settings. Anyway, I'm now able to import Activities but the same error (below) is still viewable in the Activities search page when attempting a full query.

    <<Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from accounts where id = '#BO6 4U6&\'::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''#BO6 4U6&\'' at line 1>>

    Which table is this tied to in the db?

  4. #4
    KACP is offline Senior Member
    Join Date
    Aug 2008
    Posts
    21

    Angry Re: Activities/MySQL error message?

    Can anyone offer any clues as to which table is this tied to in the db?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MySQL error message on install
    By avb3 in forum Installation and Upgrade Help
    Replies: 4
    Last Post: 2007-03-21, 04:25 PM
  2. Replies: 1
    Last Post: 2006-04-17, 01:57 PM
  3. Replies: 6
    Last Post: 2005-10-08, 04:36 PM
  4. error message on activities page
    By kenisha in forum Help
    Replies: 0
    Last Post: 2005-08-03, 11:48 AM

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
  •