Results 1 to 2 of 2

Thread: Cannot import notes - Sugar 5.1

  1. #1
    audiopleb is offline Sugar Community Member
    Join Date
    Apr 2006
    Posts
    40

    Default Cannot import notes - Sugar SQL Error - Sugar 5.1

    Trying to import notes i get this error:

    Import Errors Occurred
    NOTICE: [8] Undefined index: table on line 410 in file /var/www/html/crm/modules/Import/ImportFieldSanitize.php
    Want only a single row Query Failed:SELECT id FROM WHERE last_name = 'Murray' AND deleted != 1 LIMIT 0,1::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 'WHERE last_name = 'Murray' AND deleted != 1 LIMI' at line 3

    I upgraded from 5.0.0 if that's any help!

    My system is:

    Apache 2
    CentOS 5.2
    PHP 5.16
    MYSQL 5
    Last edited by audiopleb; 2008-09-09 at 01:21 PM. Reason: Make title more relevant

  2. #2
    audiopleb is offline Sugar Community Member
    Join Date
    Apr 2006
    Posts
    40

    Default Re: Cannot import notes - Sugar 5.1

    This may seem obvious but it seems this variable isn't being passed properly (hence the table name missing in the sql)

    Code:
    {vardef['table']}
    I have tried a new install of just 5.1 instead of the upgrade and it is the same problem.

    Should i be posting this into a bug tracker as well as the forum?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. What's new in Sugar 5.1 for developers
    By clint in forum Developer Help
    Replies: 1
    Last Post: 2011-10-11, 08:47 PM
  2. Mass import of notes
    By daveb1 in forum Help
    Replies: 2
    Last Post: 2008-01-24, 09:56 AM
  3. Sugar Import?
    By Danielg42 in forum Help
    Replies: 5
    Last Post: 2007-09-20, 07:28 PM

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
  •