Results 1 to 2 of 2

Thread: Error exporting ProjectTask:

  1. #1
    robbrandt is offline Member
    Join Date
    Dec 2008
    Posts
    9

    Default Error exporting ProjectTask:

    I am getting this error when I try and export my project tasks:

    Error exporting ProjectTask:
    .SELECT project_task.*, users.user_name as assigned_user_name ,project_task_cstm.component_c FROM project_task LEFT JOIN project_task_cstm ON project_task.id = project_task_cstm.id_c LEFT JOIN users ON project_task.assigned_user_id=users.id where ((project.name like 'my project%')) AND project_task.deleted=0 Query Failed:SELECT project_task.*, users.user_name as assigned_user_name ,project_task_cstm.component_c FROM project_task LEFT JOIN project_task_cstm ON project_task.id = project_task_cstm.id_c LEFT JOIN users ON project_task.assigned_user_id=users.id where ((project.name like 'my project%')) AND project_task.deleted=0 ::MySQL error 1109: Unknown table 'project' in where clause

    Unfortunately there's no file/line number reference so I don't even have the slightest idea where to start looking for a problem. Any ideas?

  2. #2
    robbrandt is offline Member
    Join Date
    Dec 2008
    Posts
    9

    Default Re: Error exporting ProjectTask:

    OK, so nobody knows the specific answer.

    I would really appreciate it if

    1) Someone could at least confirm that theirs works. I am using v5.2.0. If it works for others, then I know there's something about my own installation that's wrong. If it doesn't then I know it's likely a bug that will eventually be fixed.

    2) If it works for others, some hints as to where to find this query in the code. I am a php developer but am not at all familiar with Sugar's architecture.

    Thanks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2008-10-19, 03:58 PM
  2. Excel exporting error
    By visucr in forum Help
    Replies: 0
    Last Post: 2008-08-26, 01:59 PM
  3. Replies: 0
    Last Post: 2008-07-16, 05:11 PM
  4. Error Exporting Custom Fields
    By hkommin in forum Help
    Replies: 0
    Last Post: 2006-04-18, 09:53 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
  •