6.0.0-alpha14
6/24/25

[#1071] Tasks created in database, but never found
Summary Tasks created in database, but never found
Queue Nag
Queue Version HEAD
Type Bug
State Resolved
Priority 2. Medium
Owners
Requester darren (at) shelbrook (dot) com
Created 01/04/2005 (7476 days ago)
Due
Updated 06/13/2005 (7316 days ago)
Assigned 01/04/2005 (7476 days ago)
Resolved 01/06/2005 (7474 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
06/13/2005 12:27:04 AM jnicol (at) backnine (dot) org Comment #16 Reply to this comment
I also cannot get nag to work. I'm using 2.1-CVS. Tasks are saved into 
the database, but they never display in the application. What's the 
problem here? How can this be resolved?
05/19/2005 06:49:06 PM sami (dot) lehtimaki (at) noam (dot) fi Comment #15 Reply to this comment
I have this same problem with Nag H3 2.0.1. I have not found any ways 
to work-around. I have used our Horde 3.0.4/Nag with Firefox 1.0.3 and 
tested it with Lin Netscape 7.X, Konqueror X and Win 2000 IE.

     By any means, I can't get tasks to be found from db. In develop 
environment, we do not use HTTPS, so SSL probably doesn't matter here. 
We did have caching on in Horde, but it's disabled now.



Any clues how we could get Nag to find these tasks? Or do we have to 
wait for some other version?
02/08/2005 09:11:32 AM javier (dot) prieto (dot) exts (at) juntadeandalucia (dot) es Comment #14 Reply to this comment
Arg... after testing and testing and a little more testing, I've 
discovered the problem whas the Firefox client that's instaled in the 
Fedora distribubuiton by default. With the one that's installed in my 
XP workstation, everything works fine.



So, I suppose the problem is related with cookie management, as Darren stated.
02/07/2005 05:00:16 PM dmartz (at) shelbrook (dot) com Comment #13 Reply to this comment
We found horde to be *extremely* sensitive to external elements such 
as SSL and code caches. In our situation we had both.



Removing SSL from the situation partially resolved the situation, but 
left other parts disabled/non-functional. Then we removed the "PECL" 
code cache things started to work.



Today we have SSL working again (after carefully reviewing my 
configuration), but IE still craps out on occasion and the session 
fails.



Keep in mind that when this happens you will likely never see an error 
in your logs... that includes apache, php, and horde. In close 
investigation you may find that reading the form/cookie data on a 
random page fails cause the data simply disappeared. Without warning 
it will exit the page rendering or move on and fail later.



So the weakness is that Horde does not appear to have enough defensive 
code around form/cookie data. The outcome is undetected failures. The 
cause appears to be external corruption from code caches and 
encryption protocols.
02/07/2005 12:52:33 PM javier (dot) prieto (dot) exts (at) juntadeandalucia (dot) es Comment #12 Reply to this comment
Sorry for creating a duplicate ticket, I thought it was the procedure 
when the other ticket was closed.



Here's the aditional information I wrote about the problem:



________________________



I can add tasks in Nag, or items in Kronolith, but they are not 
displayed afterwards, although the database seems to be updated.



The weird thing is that I can see the items perfectly if I set 
"data-tree-system" to "none" in Horde configuration. When I change it 
back to my SQL database, Nag and Kronolith items dissapear again.
02/07/2005 11:38:17 AM javier (dot) prieto (dot) exts (at) juntadeandalucia (dot) es Comment #11 Reply to this comment
I have the exact same problem in "nag-h3-2.0.1" version.

Should I upgrade or downgrade to anther version?

Could you please tell me what's your exact version number?
01/06/2005 09:10:47 PM Chuck Hagenbuch State ⇒ Resolved
 
01/06/2005 09:04:59 PM darren (at) shelbrook (dot) com Comment #10 Reply to this comment
Very strange... it's working now?!?



I made two changes:

1) moved back to released code from head

2) changed from self-signed ssl to an instantssl cert



I am positive the problem remained after moving back to the NAG_2_0 
tag, but I just installed my cert and did a check and it's working.


01/06/2005 07:51:05 PM Chuck Hagenbuch Comment #9 Reply to this comment
Okay. Next step is for you to start digging into Nag::listTasks() in 
nag/lib/Nag.php. Make sure that $GLOBALS['display_tasklists'] contains 
your tasklists. Then go from there.



Oh, and I didn't repond to this earlier:
I should note that unlike kronolith, there is no plus sign showing 
up next to the
tasklists. I don't recall if the pre-release had that or not.
The UI is a little different than Kronolith, but you should see an 
asterisk next to the tasklists you've chosen. If you don't, that's 
your problem. Perhaps you don't have a working/permanent prefs 
backend, perhaps there's something else off.
01/05/2005 10:18:42 PM darren (at) shelbrook (dot) com Comment #8 Reply to this comment
I should add that both queries looked fine and reported data relevant 
to the user, but a third query to show the tasks themselves never 
occurred.


01/05/2005 10:16:08 PM darren (at) shelbrook (dot) com Comment #7 Reply to this comment
There are two queries run, the first identifies the user from a login 
name to a uid. The second identifies the tasklists the user owns. 
That's it, nothing else is logged.



I also noticed the following error in the log



Jan 05 14:09:38 HORDE [debug] [nag] Could not call function 
_horde_hook_share_init in application horde. [on line 1394 of 
"/usr/lib/php/Horde.php"]




01/05/2005 03:33:06 PM Chuck Hagenbuch Comment #6 Reply to this comment
Okay. Turn logging up to PEAR_LOG_DEBUG, and find the query that is 
sent to the database when you load the task list page. Compare that to 
what's actually in the database (perhaps run it manually too) and let 
me know what you find.
01/05/2005 12:50:12 AM darren (at) shelbrook (dot) com Comment #5 Reply to this comment
Yes Chuck, I selected to show tasklists. The module doesn't have too 
many options/settings.



Just to be clear... you mean select from the drop-down on the right 
and press "show". No change.



I should note that unlike kronolith, there is no plus sign showing up 
next to the tasklists. I don't recall if the pre-release had that or 
not.
01/04/2005 10:46:30 PM Chuck Hagenbuch Comment #4 Reply to this comment
You still didn't say if you've selected tasklists to be *shown*.
01/04/2005 10:18:41 PM darren (at) shelbrook (dot) com Comment #3 Reply to this comment
No matter what I try I cannot see any tasks.



- search shows nothing

- all tasks, incomplete tasks, and complete tasks show nothing 
regardless of the "show tasks list value"

- the database table has 3 records in it created by Nag



This behavior is consistent with primary and secondary task lists, 
shared or private.
01/04/2005 09:55:04 PM Chuck Hagenbuch Comment #2
State ⇒ Feedback
Priority ⇒ 2. Medium
Reply to this comment
the uid and owner are both right. the task is being saved to a shared 
tasklist - has the user actually elected to *view* tasks from that 
tasklist? See the dropdown in the upper right.
01/04/2005 09:40:51 PM darren (at) shelbrook (dot) com Comment #1
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ Tasks created in database, but never found
Queue ⇒ Nag
State ⇒ Unconfirmed
Reply to this comment
Horde Authentication: IMP/CourierImap

Nag storage: mysql

Frequency: always

Workaround: none found



I suspect the value in the task_uid field should be the email address 
used during horde login. Instead the value is something like 
"20050104102658.3rt6v7t80aas@prefix.domain.tld". The task owner is 
essentially a large hex value as well.



Creating a task works, but the author cannot list, view, or edit the 
task. It exists in the database but cannot be accessed.



I will gladly provide more details if it will help.


Saved Queries