Popup not working on daynotes when username have an dot(.)

Description

Thanks for a great utility!
Our Company with 80 users have been using it daily since 2004
My former colleague installed and modified it then, and now 15 years later I have gone through the painstaking task of "updating" it to the latest version since the code it getting very old and I fair we will get some issues down the line.
Basically I have done a new installation and only transferred the users since so much have changed and been added.
I have also translated most part of the userinterface to Swedish.

Anyway I have been able to get everything to work accept the daynote and user popup information.
This is due to the fact that we are using a dot(.) in the user name for intace mickey.mouse.
I know this is not allowed but we have it in everywhere other system and it worked in the old old version too.
Everything else works so i suspect that it is "simple" fix somewhere deep in your php code.
I have tried to solve it on my own but haven't been able to crack it, so I was hoping that you where able to help me out
I have done a new clean installation that I have played around with.
I have found that its the Tipsy javascript that is used for the popup in conjunction with jQuery.
I have updated jQuery to 2.1.3 but the problem remain.
There is no new version of the Tipsy script.
However I´m now convinced that the problem isn't the javascript instead it seems to fail to get the information from MySQL when there is a dot.
It works for instance with underscore (_)
I suspect that somewhere there should be backticks (`) instead of (') when calling on username
I have found 55 hits in 21 files (see below) for 'username' in the TC Pro code so I was kind of hoping that you where able to find the right one...
The old version we had wasn't using Tipsy so it worked before.

Below is a couple of other things that I have noticed when playing around and trying to solve the problem which might be helpful for you to know.
This is tested on a clean installation of 3.6.17 with the sample data.

  • Popup is not showing if you have a letter as absence, for instance S for sick. It only works if its an icon. (I solved it by creating icons with the letters...)
    This seems to work in the year view but not in the main month calender.

  • my_tc_absences is missing the bgtransparent table in row 7 in the sample data, so there is an error when trying to change and/or save. Works fine when its added.
    -There is some issues with the sorting when using other letters than A-Z, the Swedish alphabet have ÅÄÖ at the end. I know its a pain but still and issue that worked in the old version. For instance names like Pelle Jöns gest sorted as an o instead of ö. Worse is if the first letter in the last name is Å,Ä or Ö. For instance Pelle Örn is placed first at the very top when is should be last. Difficult to figure out if is php and or MySQL or the code itself that is causing these problems.

  • I noticed that you have added the possible to easily change moth when you edit a user calender, it would be absolutely great to have that function in the main view

Again thanks for a great utility and I really hope that you are able to share some light on the daynote issue that would be extremely helpful if we could get it to work again.

Is it possibly somewhere in these line something goes wrong when reading the daynotes when the username have an dot(.) ?

Status

Assignee

Daniel Eklund

Reporter

Daniel Eklund

Labels

None

Confluence Version

None

Original poster

nobrell

Applies to Demo

Yes

Components

Affects versions

Priority

High
Configure