Error executing query: "SELECT FROM accounts..."

[chad.hutchins]

Whenever I go to the "Home" module tab and click the "Sales Page" page tab, I receive the following error:

Error executing query Query Failed:SELECT FROM accounts WHERE accounts.deleted=0 ::MySQL error 1064:

For some reason, the query is not selecting any fields. The thread linked below is the only other instance I can find of someone having this problem.

http://www.sugarcrm.com/forums/showt...homepage+error

Once a user clicks on the "Sales Page" page tab, their login is hosed, because anytime you try to go back to the "Home" module tab, it defaults to view the last page you were looking at, so it throws the "Error executing query...." error and does not display the tabs.

The only way around the problem is to reset the user's homepage and tell them not to click on the "Sales Page" page tab. This is an unacceptable answer, because it resets all of the user's dashlets each time they do this.

This is happening on my production server, so any clues on why this is happening would be great! Thanks!

-chad

[chad.hutchins]

And for the record:
Apache 2.2.8
PHP 5.2.5
MySQL 5.0.51a
Sugar Enterprise 5.0c

[chad.hutchins]

For a temporary work-around, in modules/Home/index.php before "foreach($pages[$activePage]['columns'] as $colNum => $column) {" around line 303, I added $activePage = 0;

This way, even if a user clicks on the "Sales Page" page, they can just refresh the entire page and it will always show the first page on the home page by default instead of the last one looked at by the user.

I would still like to figure out what is causing this ill-formed query. Any ideas?

thanks again
-chad

[Phniux]

i also hava a similar problem
yes,it works fine
thanks