November 28, 2008

SugarCRM Errors Out (MySQL Error 1064) After Installation

After a fresh installation of SugarCRM on a test CentOS 5 box, I received the following error with a blank white screen typical of a PHP or die() statement.

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

To fix it, simply turn off PHP Safe Mode in the php.ini file that is usually located in the /etc directory. Issue a service httpd restart and you should be good to go.

2 Comments »

  1. [...] SugarCRM Errors Out (MySQL Error 1064) After Installation Query Failed: AND users.id = %26#39;1%26#39;::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 %26#39;AND users.id = %26#39;1%26#39;%26#39; at line 1 … [...]

    Pingback by server errors | IBM.COM IBM - United States — November 29, 2008 @ 9:21 pm

  2. MySQL Tutorials…

    If you use MySQL and design databases for MySQL, then this is the tool for you. This is a free download that you can download from MySQL’ s website and use it. With this tool you can design your database, tables, relationships, triggers etc.. And you…

    Trackback by MySQL Tutorials — April 8, 2009 @ 5:02 am

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.