Forum

[SOLVED] TODAY Scre...
 
Notifications
Clear all

[SOLVED] TODAY Screen issues

14 Posts
3 Users
0 Reactions
12.8 K Views
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 
[#1281]

i babynus,

i tried 3.3.2 before migration and i met a strange behaviour :

in today screen if à had a report à don't see the report but the waiting cursor.
If à print the today page in the print preview i see the report.

another thing :

when i click on today paraméters icons in the configuration windows i see this :

Strange name "unknown today scope"

i left the page and if i click once again on the parameter icon new "unknow today scope" element appears. like this :

i work on IE8 on Windows XP my server is in Windows server 2003.

thank's


 
Posted : 23 Jul 2013 10H51
Klaus
(@climb4fun)
Posts: 449
Contributor
 

Hi Iaurkano,

I had this issue some weeks ago as well. I remove this "unknown today scope" and then I was fine again. In my case it was due to migration tests backward and forward.

Hope this helps,

Regards,

Klaus


 
Posted : 23 Jul 2013 11H17
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

my problems is, i can't remove these. Each time i open the configuration screen these items re-appears.

if i open the configuration twice, i see 2 times more "unknown today scope" items, if third i see 3 times more "unknown today scope".

Very strange behaviour.

thank's


 
Posted : 23 Jul 2013 12H06
(@babynus)
Posts: 14952
Member Admin
 

Try this fix :
in /model/Today.php
replace function insertStaticItems() with this one :

  public static function insertStaticItems() {
  	$user=$_SESSION['user'];
  	$sort=0;
  	foreach (self::$staticList as $static) {
  		$crit=array('idUser'=>$user->id, 'scope'=>'static', 'staticSection'=>$static);
  		$sort+=1;
  		$item=SqlElement::getSingleSqlElementFromCriteria('Today', $crit);
  		if (!$item->id) {
  			$item->sortOrder=$sort;
  			$item->idle=0;
  			$item->scope='static';
  			$item->save();
  		}
  	}
  }

(one line added)

You should also clear all lines in table Today for which scope is not 'static' or 'report'.


 
Posted : 23 Jul 2013 14H47
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

ok i will try this and i'll keep you informed.

regards?


 
Posted : 23 Jul 2013 15H29
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

Hi babynus,

Your fix does not correct my issue.

in the DATABASE i have only records where field scope is 'static'.

regards.


 
Posted : 31 Jul 2013 17H02
(@babynus)
Posts: 14952
Member Admin
 

You should try V3.4.1


 
Posted : 31 Jul 2013 19H44
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

hi,
i had this issue in my previous 3.4.4 version, and with the new 4.2.2 version too.

here after the todays configuration screen.....

One more things i had these three tables in the the database :
today
todayParameter
and
todayparameter

is it normal ?

regards


 
Posted : 01 Apr 2014 19H05
(@babynus)
Posts: 14952
Member Admin
 

You should
- remove todayParameter
- empty todayparameter

Your issue may be due to running setup/upgrade several times.


 
Posted : 01 Apr 2014 19H38
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

all was done, but the problem still present.

one idea babynus ??


 
Posted : 03 Apr 2014 10H37
Klaus
(@climb4fun)
Posts: 449
Contributor
 

Hi Iaurkano,

maybe you can look into table "today", whether there are double entries for your user.

Regards,

Klaus


 
Posted : 08 Apr 2014 10H27
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

Ok,

So in fact, each time i open the "today configuration screen" 5 records are added in the today table, here below an extract of the today table (now there are 105 records for my user) :
the added records have the field "static section" set to NULL, like the last records below.

id idUser scope staticSection idReport sortOrder idle
1 1 static Projects (NULL) 1 1
20 1 static AssignedTasks (NULL) 2 1
39 1 static ResponsibleTasks (NULL) 3 1
58 1 static IssuerRequestorTasks (NULL) 4 1
77 1 static ProjectsTasks (NULL) 5 1
96 1 static Projects (NULL) 1 1
114 1 static AssignedTasks (NULL) 2 1
132 1 static ResponsibleTasks (NULL) 3 1
150 1 static IssuerRequestorTasks (NULL) 4 1
168 1 static ProjectsTasks (NULL) 5 1
186 1 static (NULL) (NULL) 1 1
187 1 static (NULL) (NULL) 2 1
188 1 static (NULL) (NULL) 3 1
189 1 static (NULL) (NULL) 4 1
190 1 static (NULL) (NULL) 5 1
191 1 static (NULL) (NULL) 1 1
192 1 static (NULL) (NULL) 2 1
193 1 static (NULL) (NULL) 3 1

 
Posted : 14 Apr 2014 18H08
Klaus
(@climb4fun)
Posts: 449
Contributor
 

Hi Iaurkano,

if you are familiar with SQL, then try to set one of your double entries "idle to 0". Then you should see, this item is out of today. If it works, then you can put all other duplicates to idle = 0 as well. Or you delete the records, but this is more risiky, because this could not be restored afterwards.

Anyhow, make a dump of your database before modifying anything.

Best regards,

Klaus


 
Posted : 15 Apr 2014 10H48
Iaurkano
(@iaurkano)
Posts: 104
Active Member
Topic starter
 

Hi all,

after lot's of investigation, i found the solution.

so : In the table today, I deleted all records where scope ="static" and staticSection=NULL and all records in double.

after that, today screen works perfectly.

Thank's.


 
Posted : 15 Apr 2014 13H41
Share:

Scroll to Top