Introductory Questions

[adelaideit]

Hi there,

i'm having a few issues with sugar, i really want to keep using it but need these ironed out first, just wondering if anyone else is also having similar problems.

When assigning anything (call, note) Due dates are screwed, always seems to place date 2.5 years ahead. Shouldn't this choose todays date? I've checked all date settings global and for the user, and they are correct! The date created is right, but the start date is 2.5 years ahead?I cannot see where it picks up the weird dates 2010.

I have setup the external SMTP server as i was having issues with the other way. When i use the email feature and send an email to test this it works no problem and i recieved the email. However i, not anyone else is getting any job assigning emails. All users have email addresses assigned, the global email setting is set to external smtp, which i know works, and the local user settings is set to the same.

When i view the calendar, i click on a particular day, and it gives me options to schedule meeting or call, if you do so it adds the data to the relevant section, meetings or calls. I would like data to be represented in the actual calendar. Is this availaible with any release?

IS there a way a dashlet can show my projects, not my project tasks?

[andopes]

Hi, adelaide.

Two questions:
1. Which database are you using?
2. Which are your date format seetings in sugar?

Cheers

[adelaideit]

hi there,

we are using 12/23/2006 as the date format, set in my account section for the particular user.

By which database if you mean mysql? If so we are using MySQL 4.1.

If you mean which version of Sugar, i'm using the open source one for now and trying to get it running smoothly.

Does another version of more options in the calendar?

[andopes]

Hi, adelaide

Your configuration sounds good.
Do you have access to the database, perhaps through phpmyadmin?

Check how these date fields are being saved into database.
Let me know.

Best regards.

[adelaideit]

here is one of the date fields,
2011-10-29 02:15:00.

so looks like it's the software that is doing it, but why?

do you have any idea about the calendar question i posted? this is the one priority i have that i want to solve

[andopes]

Hi, Adelaide

The Calendar module is the same across the versions.
I´m trying to figure out this issue.
Did you customized the Sugar through code?
Honestly I don´t know which is causing this issue, but I´ll try to trigger some questions to clarify your scene.
Are you using the version 4.5 or 5.0?
Do the following:

Insert this code

 echo "<PRE>";
print_r($_REQUEST);
echo "</PRE>";
die(); 
  

Inside the script modules/Calls/Save.php, make sure you fill the field due date.
Check which value is assigned to due date. This will display the value come from form.
After that insert the code

 die($query); 
  

In data/SugarBean.php, line 1394 for SugarCRM CE 5.0.0d
This will print the query to be run into database.

Cheers