SugarCRM and Plesk - Solutions (Query Failed: AND users.id = '1'::MySQL error 1064:)

[kenzo.matuzawa]

Hello everyone,

After spending some time on SugarCRM 5.0d installation I finally made it through on a Plesk 8.3 install.

The problem was that after finishing the installation and selecting the timezone, SugarCRM crashed and gave a "Query Failed: AND users.id = '1'::MySQL error 1064:" error message.

After researching on Sugar forums I found a lot of possible solutions, but the only one that really worked was setting the permissions of all Sugar folders and files to 777 and making the user and group apache (apache:apache) owner of them.

If anyone has a better solution please feel free to share with us.

Best regards,
Kenzo

 

[lvalics]

mod_suphp then you do not need 777 and will be ftpusersacln, problem solved.

 

[Amin Taheri]

even if its already owned as ftpusersacln having it set to 777 would be the same thing as setting it to apache:apache and setting to 777

When the files and folders are 777 it really doesn't matter who the owner is at that point since its world writable.

 

[EhabH]

Problems with 777

The problem is that although the initial setup runs and works when you set 777 to the entire sugar directory, on any customization of fields in sugar or when you add extensions it will rewite these files, give them lesser permissions, write them as apache:apache and sugar starts to stop working.

 

[lvalics]

We have a server where is running around 10 Sugar CRM and we have no issue with it, BUT we use suphp, so this solve the issue.

 

[EhabH]

Can you show me the configuration of your suphp ( ofcoarse without the paths )

 

[lvalics]

Everythin is written here
http://www.grafxsoftware.com/faq.php/HOW-TO-Setup-a-PLESK-Dedicated-Server/1/4/