Closed ghost closed 1 year ago
This issue seems to occur when installing the crm on a UTC computer and then using the system with an America timezone.
I was able to manually fix this issue by installing a fresh copy and using a computer with an America timezone, then copying the public_html folder into the old system. The copied folder was from 6.5.
π bug report
βοΈ Describe the bug
Weekday labels in month view are incorrect when using the following timezones, America/New_York, America/Los_Angeles, America/Vancouver. These are the timezones I have tried, however it seems this issue affects time zones to the left (geographically) of UTC
European time zones seem to work fine
π₯ How to trigger the error
π Actual Behavior
OS Time: America/New_York
π Expected Behavior
OS Time: UTC
π· Testing
I unsure if issue persists in gitstable or gitdeveloper, I have tested from my end and it seems to not be the case.
π· Screenshot of configuration
This is on a freshly installed instance but the issue persists on production server
π PHP/Apache/Nginx/Browser/CRM Logs
2023-11-03 11:07:10.2286 [info][[yii\db\Connection::open]] - Opening DB connection: mysql:host=localhost;dbname=yfprod;port=3306 2023-11-03 11:07:10.2291 [info][[yii\db\Command::query]] - SELECT EXISTS(SELECT FROM
vtiger_users
WHERE (id
=1) AND ((status
='Active') AND (deleted
=0))) 2023-11-03 11:07:10.2293 [info][[yii\db\Command::query]] - SELECT EXISTS(SELECT FROMvtiger_users
WHEREid
=1) 2023-11-03 11:07:10.2336 [info][[yii\db\Command::query]] - SELECT FROMvtiger_tab
2023-11-03 11:07:10.2348 [info][[yii\db\Command::query]] - SELECT FROMvtiger_entityname
2023-11-03 11:07:10.2359 [trace][] - Entering getColumnFields(Calendar) method ... 2023-11-03 11:07:10.236 [info][[yii\db\Command::query]] - SELECT FROMvtiger_field
LEFT JOINs_yf_fields_anonymization
ON vtiger_field.fieldid = s_yf_fields_anonymization.field_id WHEREtabid
=9 2023-11-03 11:07:10.2365 [trace][] - Exiting getColumnFields method ... 2023-11-03 11:07:10.2366 [info][[yii\db\Command::query]] - SELECTvtiger_field
.,s_yf_fields_anonymization
. FROMvtiger_field
LEFT JOINvtiger_blocks
ON vtiger_field.block = vtiger_blocks.blockid LEFT JOINs_yf_fields_anonymization
ON vtiger_field.fieldid = s_yf_fields_anonymization.field_id WHEREvtiger_field
.tabid
=9 ORDER BYvtiger_blocks
.sequence
,vtiger_field
.sequence
2023-11-03 11:07:10.2376 [info][[yii\db\Command::query]] - SELECT FROMvtiger_blocks
WHEREblockid
=19 LIMIT 1 2023-11-03 11:07:10.238 [info][[yii\db\Command::query]] - SELECT FROMvtiger_blocks
WHEREblockid
=20 LIMIT 1 2023-11-03 11:07:10.2382 [info][[yii\db\Command::query]] - SELECT FROMvtiger_blocks
WHEREblockid
=40 LIMIT 1 2023-11-03 11:07:10.2385 [info][[yii\db\Command::query]] - SELECT FROMvtiger_blocks
WHEREblockid
=117 LIMIT 1 2023-11-03 11:07:10.2387 [info][[yii\db\Command::query]] - SELECT FROMvtiger_blocks
WHEREblockid
=87 LIMIT 1 2023-11-03 11:07:10.2392 [info][[yii\db\Command::query]] - SELECT FROMvtiger_ws_fieldtype
2023-11-03 11:07:10.2395 [trace][] - Entering isPermitted(Accounts,,,) method ... 2023-11-03 11:07:10.2395 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(Leads,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(Vendors,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(Partners,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(Project,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(HelpDesk,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(FInvoice,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(SQuotes,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(SSingleOrders,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(ProjectTask,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2396 [trace][] - Entering isPermitted(Contacts,,,) method ... 2023-11-03 11:07:10.2396 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2397 [info][[yii\db\Command::query]] - SELECTrelmodule
ASmodule
FROMvtiger_fieldmodulerel
INNER JOINvtiger_tab
ON vtiger_tab.name = vtiger_fieldmodulerel.relmodule WHERE (fieldid
=1762) AND (vtiger_tab
.presence
<> 1) ORDER BYsequence
2023-11-03 11:07:10.24 [trace][] - Entering isPermitted(Calendar,,,) method ... 2023-11-03 11:07:10.24 [trace][] - Exiting isPermitted method ... - SEC_USER_IS_ADMIN 2023-11-03 11:07:10.2402 [info][[yii\db\Command::query]] - SELECTactivitystatusid
,activitystatus
FROMvtiger_activitystatus
ORDER BYsortorderid
2023-11-03 11:07:10.2405 [trace][] - Entering to operatorE in App\Conditions\QueryFields\BaseField 2023-11-03 11:07:10.2405 [trace][] - Start DateTimeField::convertTimeZone(2023-10-30, America/New_York, America/Los_Angeles) 2023-11-03 11:07:10.2405 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2406 [trace][] - Start DateTimeField::convertTimeZone(2023-12-09, America/New_York, America/Los_Angeles) 2023-11-03 11:07:10.2406 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2409 [info][[yii\db\Command::query]] - SELECTvtiger_activity
.subject
ASsubject
,vtiger_crmentity
.smownerid
ASassigned_user_id
,vtiger_activity
.date_start
ASdate_start
,vtiger_activity
.time_start
AStime_start
,vtiger_activity
.time_end
AStime_end
,vtiger_activity
.due_date
ASdue_date
,vtiger_crmentity
.shownerid
ASshownerid
,vtiger_activity
.status
ASactivitystatus
,vtiger_activity
.priority
AStaskpriority
,vtiger_activity
.sendnotification
ASsendnotification
,vtiger_crmentity
.modifiedtime
ASmodifiedtime
,vtiger_crmentity
.createdtime
AScreatedtime
,vtiger_crmentity
.smcreatorid
AScreated_user_id
,vtiger_activity
.activitytype
ASactivitytype
,vtiger_activity
.visibility
ASvisibility
,vtiger_activity
.duration_hours
ASduration_hours
,vtiger_crmentity
.was_read
ASwas_read
,vtiger_activity
.duration_minutes
ASduration_minutes
,vtiger_activity
.location
ASlocation
,vtiger_activity
.state
ASstate
,vtiger_activity
.notime
ASnotime
,vtiger_crmentity
.modifiedby
ASmodifiedby
,vtiger_activity
.allday
ASallday
,vtiger_crmentity
.private
ASprivate
,vtiger_activity
.meeting_url
ASmeeting_url
,vtiger_crmentity
.description
ASdescription
,vtiger_activity_reminder
.reminder_time
ASreminder_time
,vtiger_activity
.reapeat
ASreapeat
,vtiger_activity
.recurrence
ASrecurrence
,vtiger_activity
.link
ASlink
,vtiger_activity
.process
ASprocess
,vtiger_activity
.subprocess
ASsubprocess
,vtiger_activity
.followup
ASfollowup
,vtiger_activity
.linkextend
ASlinkextend
,vtiger_activity
.subprocess_sl
ASsubprocess_sl
,vtiger_activity
.activityid
ASid
FROMvtiger_activity
INNER JOINvtiger_crmentity
ON vtiger_activity.activityid = vtiger_crmentity.crmid LEFT JOINvtiger_activity_reminder
ON vtiger_activity.activityid = vtiger_activity_reminder.activity_id WHERE (vtiger_crmentity
.deleted
=0) AND ((vtiger_activity
.status
IN ('PLL_PLANNED', 'PLL_IN_REALIZATION', 'PLL_OVERDUE')) AND (((CONCAT(date_start, ' ', time_start) >= '2023-10-29 21:00:00') AND (CONCAT(date_start, ' ', time_start) <= '2023-12-08 21:00:00')) OR ((CONCAT(due_date, ' ', time_end) >= '2023-10-29 21:00:00') AND (CONCAT(due_date, ' ', time_end) <= '2023-12-08 21:00:00')) OR ((date_start
< '2023-10-29') AND (due_date
> '2023-12-08')))) AND ((vtiger_crmentity
.smownerid
='1') OR (vtiger_crmentity
.crmid
IN (SELECTcrmid
FROMu_yf_crmentity_showners
WHEREuserid
='1'))) ORDER BYvtiger_activity
.date_start
,vtiger_activity
.time_start
2023-11-03 11:07:10.2416 [info][[yii\db\Command::query]] - SELECT FROMvtiger_activitytype
ORDER BYsortorderid
2023-11-03 11:07:10.2418 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 08:30:00) method ... 2023-11-03 11:07:10.2418 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 08:30:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.2419 [trace][] - Entering getDisplayTime(2023-11-03 08:30:00) method ... 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 08:30:00) method ... 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 08:30:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2419 [trace][] - Exiting getDisplayTime method ... 2023-11-03 11:07:10.2419 [trace][] - DateTimeField::getDisplayDateTimeValue 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 08:30:00) method ... 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 08:30:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 08:30:00) method ... 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 08:30:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2419 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 08:30:00) method ... 2023-11-03 11:07:10.2419 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 08:30:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 09:00:00) method ... 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 09:00:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.242 [trace][] - Entering getDisplayTime(2023-11-03 09:00:00) method ... 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 09:00:00) method ... 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 09:00:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.242 [trace][] - Exiting getDisplayTime method ... 2023-11-03 11:07:10.242 [trace][] - DateTimeField::getDisplayDateTimeValue 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 09:00:00) method ... 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 09:00:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.242 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 09:00:00) method ... 2023-11-03 11:07:10.242 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 09:00:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 11:05:00) method ... 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 11:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.2421 [trace][] - Entering getDisplayTime(2023-11-03 11:05:00) method ... 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 11:05:00) method ... 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 11:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2421 [trace][] - Exiting getDisplayTime method ... 2023-11-03 11:07:10.2421 [trace][] - DateTimeField::getDisplayDateTimeValue 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 11:05:00) method ... 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 11:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.2421 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 11:05:00) method ... 2023-11-03 11:07:10.2421 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 11:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 11:05:00) method ... 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 11:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 12:05:00) method ... 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 12:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.2422 [trace][] - Entering getDisplayTime(2023-11-03 12:05:00) method ... 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 12:05:00) method ... 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 12:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2422 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2422 [trace][] - Exiting getDisplayTime method ... 2023-11-03 11:07:10.2422 [trace][] - DateTimeField::getDisplayDateTimeValue 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 12:05:00) method ... 2023-11-03 11:07:10.2422 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 12:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2423 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2423 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2423 [trace][] - Start DateTimeField::convertToUserFormat s:10:"2023-11-03"; | yyyy-mm-dd 2023-11-03 11:07:10.2423 [trace][] - End DateTimeField::convertToUserFormat 2023-11-03 11:07:10.2423 [trace][] - Start DateTimeField::convertToUserTimeZone(2023-11-03 12:05:00) method ... 2023-11-03 11:07:10.2423 [trace][] - Start DateTimeField::convertTimeZone(2023-11-03 12:05:00, America/Los_Angeles, America/New_York) 2023-11-03 11:07:10.2423 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2423 [trace][] - End DateTimeField::convertToUserTimeZone 2023-11-03 11:07:10.2424 [trace][] - Start DateTimeField::convertTimeZone(2023-10-30, America/New_York, America/Los_Angeles) 2023-11-03 11:07:10.2424 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2424 [trace][] - Start DateTimeField::convertTimeZone(2023-12-09, America/New_York, America/Los_Angeles) 2023-11-03 11:07:10.2424 [trace][] - End DateTimeField::convertTimeZone 2023-11-03 11:07:10.2425 [info][[yii\db\Command::query]] - SELECT * FROMvtiger_publicholiday
WHEREholidaydate
BETWEEN '2023-10-29' AND '2023-12-08' ORDER BYholidaydate
2023-11-03 11:07:10.1557 [info][[application]] - 1699034829','module'=>'Calendar','action'=>'Calendar','mode'=>'getEvents','start'=>'2023-10-30','end'=>'2023-12-09','user'=>['selectedIds'=>['1']],'emptyFilters'=>'false','time'=>'current','history'=>'true','historyUrl'=>'index.php?module=Calendar&view=Calendar&history=true&viewType=dayGridMonth&start=2023-10-30&end=2023-12-09&user={"selectedIds":["1"],"excludedIds":[]}&time=current&cvid=undefined&hiddenDays=0,6']π Your Environment
β Additional context
Add any other context about the problem here.
The correct week day is listed under aria-label however I could not find the tpl file to correct this issue
I have tried changing the calendar language variables which hasn't seemed to work.
I have tried changing the work days in settings.
βοΈ Inform the community if you solve the problem