Count query error in SugarCRM

February 15, 2006

While viewing any of the data in SuagarCRM which is stored in the database, it could be a problem that at the footer of the application you can get the error message which says

Error running count query for Email List: Query Failed:( SELECT
count(*) FROM contacts INNER JOIN emails_contacts ON
(contacts.id=emails_contacts.contact_id AND
emails_contacts.email_id='53f160c0-6933-3322-4b53-43f16edeef5c') where
( emails_contacts.deleted=0 AND contacts.deleted=0) AND
contacts.deleted=0 )::MySQL error 1064: You have an error in your SQL
syntax near '( SELECT count(*) FROM contacts INNER JOIN emails_contacts
ON (contacts.id=emai' at line 1
Actaully this error message comes if the version of MySQL is below 4.0.x. Upgrade your MySQL with the version 4.0.x to get rid of this error message.

The reason for this error is that the MySQL version below 4.0.x is not able to run the query INNER JOIN.

SuagrCRM

Advertisements

Configuring Inbound Email Feature in SugarCRM 4.0.1

February 10, 2006

The Inbound Mail feature in Sugar Suite version 4.0.1 gives more
flexibility to the Sugar users to check their mails without switching
over from the application. You can configure your SugarCRM to get your mails in SugarCRM inbox.

The Administrator can configure Inbound Mail setup from the admin
control panel. Follow the steps below to configure Inbound Mail setup:

Login as administrator in the application. Click on the Admin link on the top right of the page. It will take you to the Admin Home where you can see several control blocks like System, Studio, Bug Tracker, Email-Campaign Management and at bottom is the Inbound Email. In Inbound Email block click on the Manage Mailboxes link. On the left side you can see the Shortcuts block in which links like All Mailboxes, Monitor New Mailbox and Scheduler.

Read the rest of this entry »


Moodle adoption numbers

February 1, 2006

Many of the Institutions, Universities and the Companies are using Moodle based architecture to use the technology to deliver their valuable course content to the learner. Currently there are more than 8000 sites from 146 countries which are based on Moodle.

The universities and secondary schools have adopted Moodle as their strategic platform to attain more students in different learning programs. This graph shows the rapid rise in growth rate of Moodle adoption.

Moodle