Query Failed AND userid ='1':: MySQL error 1064:

[susserj]

Hi

I am getting the following error message when I try and add a new contact.

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

I am running the software by loading the ISO sugarcrm-os-4[1].2.1a-x86-disc1.iso into a vmware virtual machine. The machine has 512 meg assigned to it.

[Barakanooz]

I get the same error at the same spot (only with the contact section too) with the ISO. I had evrything working on the 4[1].2.0 ISO.. Haven't been able to figure it out yet. Im running without any VM software.

[Barakanooz]

If you can check your sugarcrm.log file if there are any errors in it. (might have to change ownership/group on it to apache)
The error I get is :

[2011] FATAL SugarCRM - Error fetching relationship from cache contacts_users
[2011] 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

[Barakanooz]

I ran the newest ISO install 4[1].2.1b seemed to work fine then I added my own custom module and after fixing the code below in the php files in my custom module everything seems to work.
PHP Code:
if(empty($GLOBALS['sugarEntry'])) die('Not A Valid Entry Point');

And replace it by:
PHP Code:
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');


Just a few minor things to work on like the name of my module not showing up in the tab and displaying the subpanels on the Contacts DetailView (which I think is one of the new addtions in the 4.2.1 version(s)).

[nathanbthomas]

This was an issue with the 4.2.1a release of the appliance. Now fixed in 4.2.1b, as described here:

http://www.sugarforge.org/forum/foru...9&forum_id=681

Nathan