Problem with scheduling travel

[sekhar123]

Hi everybody,

This is sekhar. Im entirely new to SugarCRM. My problem is when I try schedule a travel in my site it is showing some error like below.

Error running count query for Travel List: Query Failed SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c AND jt0.deleted=0 where contacts.deleted=0 )::MySQL error 1054:

I serached for the solution ,But I didint get the solution anywhere. Please solve my problem.

And Im using a system which has these configurations

Apache--2.2.6
PHP--5.2.5
MySQL--5.0.45
sugarcrm---5.0.0e

Im awiting for ur valuable advises. Thanks in advance

Sekhar

[mikesolomon]

Hi everybody,

This is sekhar. Im entirely new to SugarCRM. My problem is when I try schedule a travel in my site it is showing some error like below.

Error running count query for Travel List: Query Failed SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c AND jt0.deleted=0 where contacts.deleted=0 )::MySQL error 1054:

I serached for the solution ,But I didint get the solution anywhere. Please solve my problem.

And Im using a system which has these configurations

Apache--2.2.6
PHP--5.2.5
MySQL--5.0.45
sugarcrm---5.0.0e

Im awiting for ur valuable advises. Thanks in advance

Sekhar

I don't know if this helps but the problem in the query is AND jt0.deleted=0

[sekhar123]

Hi Mikesolomon,

Thanks for ur response. Please tell me where can I change this query. Thanks in advance

[sekhar123]

Hi friends,
At last I got the solution. Whether it is a correct way or not I dont know. Actually I have one more instance of my site. In that scheduling travel is working. I replaced the "cache" folder of not woking site with working site's "cache" folder. Now it is working. It is the correct process or not I dont know. Now my site is working perfectly. Please let me know if I have done any wrong.

[mikesolomon]

Hi friends,
At last I got the solution. Whether it is a correct way or not I dont know. Actually I have one more instance of my site. In that scheduling travel is working. I replaced the "cache" folder of not woking site with working site's "cache" folder. Now it is working. It is the correct process or not I dont know. Now my site is working perfectly. Please let me know if I have done any wrong.

probably not the best way but if it works thats great

I have had problems like this that moving the cache then moving it back fix

The ways of sugar are mysterious