Cannot add contact (mysql error)

[rdbeamer]

Am unable to add a new contact. I get the following mysql error:
Query Failed: AND users.id = '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 'AND users.id = '1'' at line 1

while searching the forums, I ran across this
link
but i didn't see any resolution. Was this ever resolved, and if so how?

Thanks in advance

[kbrill]

You would need to post your sugarcrm.log file for us to look at and see what the whole SQL statement was.

[MilSp3c]

Also,
We need to know what system this is running on, and what version of SugarCRM you are currently using.

Best Regards,
MilSp3c
Shawn Campbell

[pblag]

Hi!

Looks like that mysql query wasn't completed.

If you want you can email me and we will debug your code.
Feel free to contact us.

[rdbeamer]

Sorry it took so long to reply, but I had to earn my keep. Here is the log file for the last little bit. I should mention that after posting last nite I was trying to trest some of the other settings, and was getting the empty query error. After reading up on the forums, I thought I had it fixed, but evidently not. Anyway, here is a snippet of the logs that should show the errors. Thanks for your help

06-20 18:44:45'
Wed Jun 20 13:44:45 2007,187 [2399] INFO SugarCRM - Query Execution Time:0.001132
Wed Jun 20 13:44:45 2007,188 [2399] DEBUG SugarCRM - including headers
Wed Jun 20 13:44:45 2007,213 [2399] INFO SugarCRM - Query:SELECT placement,name,id,url from iframes WHERE deleted=0 AND status=1 AND (placement='tab' OR placement='all') AND (type='global' OR (type='personal' AND created_by='1')) ORDER BY iframes.name
Wed Jun 20 13:44:45 2007,214 [2399] INFO SugarCRM - Query Execution Time:0.00081100000000001
Wed Jun 20 13:44:45 2007,228 [2399] DEBUG SugarCRM - About to retrieve list: SELECT tracker.* from tracker WHERE user_id='1' ORDER BY id DESC
Wed Jun 20 13:44:45 2007,228 [2399] DEBUG SugarCRM - Limit Query:SELECT tracker.* from tracker WHERE user_id='1' ORDER BY id DESC Start: 0 count: 10
Wed Jun 20 13:44:45 2007,228 [2399] INFO SugarCRM - Query:SELECT tracker.* from tracker WHERE user_id='1' ORDER BY id DESC LIMIT 0,10
Wed Jun 20 13:44:45 2007,230 [2399] INFO SugarCRM - Query Execution Time:0.00085100000000002
Wed Jun 20 13:44:45 2007,637 [2399] INFO SugarCRM - Query:SELECT category, name, value FROM config
Wed Jun 20 13:44:45 2007,639 [2399] INFO SugarCRM - Query Execution Time:0.00090100000000004
Wed Jun 20 13:44:45 2007,643 [2399] DEBUG SugarCRM - ---------> BEGING INCLUDING REQUESTED PAGE: [modules/Configurator/SugarCubed_LogView.php] <------------
Wed Jun 20 13:44:45 2007,861 [2399] DEBUG SugarCRM - ---------> END INCLUDING REQUESTED PAGE: [modules/Configurator/SugarCubed_LogView.php] <------------
Wed Jun 20 13:44:45 2007,868 [2399] INFO SugarCRM - Found extended language file: en_us.lang.ext.php
Wed Jun 20 13:44:52 2007,399 [2396] FATAL SugarCRM - Error fetching relationship from cache accounts_contacts
Wed Jun 20 13:44:52 2007,403 [2396] ERROR SugarCRM - MySQL error 1054: Unknown column 'accounts.name' in 'field list'
Wed Jun 20 13:45:31 2007,697 [2398] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Wed Jun 20 13:45:32 2007,139 [2395] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Wed Jun 20 13:45:32 2007,141 [2395] FATAL SugarCRM - 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 'AND users.id = '1'' at line 1
Wed Jun 20 13:46:38 2007,555 [2398] FATAL SugarCRM - Error fetching relationship from cache emails_leads_rel
Wed Jun 20 13:46:38 2007,567 [2398] FATAL SugarCRM - MySQL error 1065: Query was empty
Wed Jun 20 14:32:37 2007,548 [2401] FATAL SugarCRM - Error fetching relationship from cache emails_leads_rel
Wed Jun 20 14:32:37 2007,560 [2401] FATAL SugarCRM - MySQL error 1065: Query was empty
Wed Jun 20 14:32:44 2007,367 [2394] FATAL SugarCRM - Error fetching relationship from cache accounts_contacts
Wed Jun 20 14:32:44 2007,370 [2394] ERROR SugarCRM - MySQL error 1054: Unknown column 'accounts.name' in 'field list'
Wed Jun 20 14:33:06 2007,402 [2399] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Wed Jun 20 14:33:06 2007,774 [2396] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Wed Jun 20 14:33:06 2007,776 [2396] FATAL SugarCRM - 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 'AND users.id = '1'' at line 1
Wed Jun 20 14:33:35 2007,423 [2395] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Wed Jun 20 14:33:35 2007,793 [2401] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Wed Jun 20 14:33:35 2007,795 [2401] FATAL SugarCRM - 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 'AND users.id = '1'' at line 1
Wed Jun 20 14:34:54 2007,416 [2401] FATAL SugarCRM - Error fetching relationship from cache emails_leads_rel
Wed Jun 20 14:34:54 2007,428 [2401] FATAL SugarCRM - MySQL error 1065: Query was empty

[rdbeamer]

forgot to add I'm running the rpath sugarcrm appliance patched to 4.5.1d (build 1273)
Thanks again