Query Failed: AND users.id = '1'::MySQL error 1064:

[mfleeger]

Funny timing, but I was working on a customer's plesk instance today and had the exact same problem!

I am not convinced that is it specific to plesk, but it is permissions related.

My best recommendation is that you enable write access by the web server user, particularly on /cache/ and /custom/...

To do this, issue some permutation or variation of the following command examples:

chown -R www sugarcrm
chmod ug+rw sugarcrm

Etc, etc...

Thanks!

[adamreiser]

Query Failed: AND users.id = '1'::MySQL error 1064:\
I am running plesk also ...

I have paid for a Sugar network event ...

As soon as we get this identified and fixed I will post the fix from the engineers

Adam

[kpit]

I have had it run successful under plesk in the past under Godaddy Virtual dedicated host. I did this for one of my clients. So I do know it is possible. I had to create some apache configuration overrides under the user overrides in the user directory and php overrides as well.. SugarCRM needs some things that that other applications do not normally need. Check out the SugarWiki for more info on php and apache settings. Most notable is the memory allowed in php.ini needs to be higher about 64M.

[tonythemediaguy]

OK, since my last post I upgraded my godaddy virtual dedicated to cpanel from plesk. I had to recompile apache/php with mbstring enabled to use Sugar. After I did that, I was able to get Sugar working just fine. This is under php 5 and mysql 5.

So probably a permissions thing with Plesk.

[arshad]

Hi Everybody,
Finally I could fix this problem.

I was facing the same problem as everybody else. I installed sugarCRM 4.5.1h under the PHP Version 5.0.4 and mysql 4.1.20. After facing the problem I installed it again in another server with same php/mysql version. But its working fine.

At last I can figure out the problem that my old sever php safe_mode is set to ON, which is need to be OFF.

So, Just change your php safe_mode to Off, then as my assumption, it will work fine.

Good, luck
Arshad

[jdd]

I'm not on plesk, but, am using a godaddy dedicated server... getting the same error message "Query Failed: AND users.id = '1'::MySQL error 1064:" as well as errors with file() and require_once()... I had to chmod everything with 777 to even get it installed, wouldn't work with the perscribed 766.

I am also running with safe_mode = Off and mbstring enabled, as was recommended by others in this thread, and still nothing... lets me login, but then throws the fatal error.

[jdd]

Originally Posted by jdd

I'm not on plesk, but, am using a godaddy dedicated server... getting the same error message "Query Failed: AND users.id = '1'::MySQL error 1064:" as well as errors with file() and require_once()... I had to chmod everything with 777 to even get it installed, wouldn't work with the perscribed 766.

I am also running with safe_mode = Off and mbstring enabled, as was recommended by others in this thread, and still nothing... lets me login, but then throws the fatal error.

Cause, seemed to be a permissions problem on my end... up and running now.

[skalla]

Hi, I have the same problem here.
Sugar 5.0.0a
php 5 with mbstring and safe_mode = off
mysql 5
last part of sugarcrm.log:

Tue Feb 5 11:10:23 2008,122 [15910] FATAL SugarCRM - Error fetching relationship from cache calls_contacts
Tue Feb 5 11:10:33 2008,546 [16026] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Tue Feb 5 11:10:33 2008,547 [16026] FATAL SugarCRM - MySQL error 1064:

When I tried to login and see the error message I can press the back button and then I am logged in.
However some functionallity throws the same error message, e.g. 'Home':
Query Failed: AND users.id = '3b7d60ba-92f6-a46e-30ca-477b6d8b979f'::MySQL error 1064:

_Every_ single permission under the sugarcrm directory is set to 777.
The db is exported from a working installation of 5.0.0 under windows with the FastStack Mysql package. There it works fine.

Any ideas? It's sadly not usable this way

[stueckmann]

Same to me, did you get it running ???

Plesk with Sugar 5.0.0a
...

Originally Posted by skalla

Hi, I have the same problem here.
Sugar 5.0.0a
php 5 with mbstring and safe_mode = off
mysql 5
last part of sugarcrm.log:


When I tried to login and see the error message I can press the back button and then I am logged in.
However some functionallity throws the same error message, e.g. 'Home':
Query Failed: AND users.id = '3b7d60ba-92f6-a46e-30ca-477b6d8b979f'::MySQL error 1064:

_Every_ single permission under the sugarcrm directory is set to 777.
The db is exported from a working installation of 5.0.0 under windows with the FastStack Mysql package. There it works fine.

Any ideas? It's sadly not usable this way

[skalla]

Nope, still waiting for help here.

Could someone at least explain me howto enable real error messages, so I can see in which file/line this sql is build?

Or howto enable a log of the sql queries?