Cannot select Organization

Currently I'm away from my drupal installation but want to provide some information anyway: I had checked the filter settings, they looked OK to me.

I have an organization with definitely at least one project, but the organization is not displayed (I'm quite sure there is a task for that project, too, but I will check it tomorrow and post new information then).

You may change the category of this issue into a bug.

I did everything as user 1. So permissions should not be an issue.

I checked my environment with the following result:
- I have 2 organizations
- I have 2 projects for onoe of the organizations
- I have several tasks for the two projects
- I have 1 ticket for one of the projects
- I do not see organizations anyway (I attached a hardcopy showing the two projects in the middle, but there is no organisation to be selected).

I added another project and another task for the second organisation but it did not help, too.

Sorry for the delay. I tried with all filter criteria selected, but no organisation is being displayed. See attached hardcopy.

1) Is your user Webmaster the user 1 in Drupal?

YES

2) Have you clicked on "Fliter" after selecting all the filters?

YES

3) Have you already created any organizations?

YES, 2 (I can click on the organizations link in front of the drop down, both are shown)

4) Do your organizations have any projects/tasks/tickets?

YES, every organization has at least one project, one task and one ticket (most of them more than one)

5) Are you using the latest dev-release?

YES (2009-11-15, meanwhile), meanwhile but it had no effect on this issue

6) Are there any error messages in watchdog?
7) Are there any messages in your server log?
8) Any messages in the database log?

NO (/admin/reports/dblog), if there are others please let me know. (I also didn't find a watchdog module). The only other issue I know about my installation is that cron has a problem with the 'update' task (but I see no storm parts of cron).

9) What version of the Storm module are you using?

V6.x-1.26

10) What are the permissions settings look like?

As I'm user 1 they should not matter. The user also has a role that has all strom permissions. I can also see everything in storm if not using the dashboard.

=======
Can it be that there is an issue with translated attributes (just an idea about what might be different in my installation, I'm not a programmer)?

After applying the patch I got the following errors:
=============
* warning: include_once(./sites/all/modules/storm_dashboard/storm_dashboard.module) [function.include-once]: failed to open stream: Permission denied in C:\xampp\htdocs\includes\bootstrap.inc on line 617.
* warning: include_once() [function.include]: Failed opening './sites/all/modules/storm_dashboard/storm_dashboard.module' for inclusion (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\includes\bootstrap.inc on line 617.
* warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'storm_dashboard_dashboard' was given in C:\xampp\htdocs\includes\menu.inc on line 348.
* warning: include_once(./sites/all/modules/storm_dashboard/storm_dashboard.module) [function.include-once]: failed to open stream: Permission denied in C:\xampp\htdocs\includes\bootstrap.inc on line 617.
* warning: include_once() [function.include]: Failed opening './sites/all/modules/storm_dashboard/storm_dashboard.module' for inclusion (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\includes\bootstrap.inc on line 617.
=============

I also can't open the storm dashboard any more (there is just a white screen).

After a reboot the errors

* warning: include_once(./sites/all/modules/storm_dashboard/storm_dashboard.module) [function.include-once]: failed to open stream: Permission denied in C:\xampp\htdocs\includes\bootstrap.inc on line 617.
* warning: include_once() [function.include]: Failed opening './sites/all/modules/storm_dashboard/storm_dashboard.module' for inclusion (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\includes\bootstrap.inc on line 617.

remain. Also, the storm dashboard displays a white screen (with no delay, so it is not a WSOD).

It looks like patching using cygwin changed the permissions. I fixed that but the error stays the same. Looking at dblog I see

Array ( [0] => SELECT n.*, sor.* FROM {node} AS n INNER JOIN {stormorganization} AS sor ON n.vid=sor.vid INNER JOIN {stormproject} AS spr ON n.vid=spr.organization_nid WHERE ('storm_access'='storm_access') AND ( n.status=1 AND n.type='stormorganization' AND spr.projectstatus IN ('inserted','in progress','on hold','completed') ) ORDER BY n.title [1] => SELECT n.*, sor.* FROM {node} AS n INNER JOIN {stormorganization} AS sor ON n.vid=sor.vid INNER JOIN {stormtask} AS sta ON n.vid=sta.organization_nid WHERE ('storm_access'='storm_access') AND ( n.status=1 AND n.type='stormorganization' AND sta.taskstatus IN ('inserted','in progress','on hold','completed') ) ORDER BY n.title [2] => SELECT n.*, sor.* FROM {node} AS n INNER JOIN {stormorganization} AS sor ON n.vid=sor.vid INNER JOIN {stormticket} AS sti ON n.vid=sti.organization_nid WHERE ('storm_access'='storm_access') AND ( n.status=1 AND n.type='stormorganization' AND sti.ticketstatus IN ('inserted','in progress','on hold','completed') ) ORDER BY n.title ) 

.

I'm not an SQL specialist (to read this), if I you need to no the content of same database tables please let me know (I only need to know the tables an the expected content, nothing else). If there are other places of log files to look for, I would need to know, too.

I also updated to Storm 6.x-1.27 with no effect, too.

Both organizations are published. I've attached the exported tables, will send you the password via contact form.

I'm not to deep in the internals of drupal, but it sounds like Revisioning might cause this. The latest patch you provided solved the issue.

Thanks, also for your patience!

Well, your STORM dashboard makes working with STORM much better, so it's worth working on it.

Unfortunately the problem has arised again while switching to the latest dev of storm timetracking (I had the Nov-05 release and could not select an organization after clicking on the symbol left of 'currently not tracking time', at least I'm quite sure). After updating to the latest dev of STORM timetracking I can select an organization there, but no longer in the STORM dashboard (Dec-01) itself.

I added this here because both modules are 'yours' and I can't decide where the error is.

Sorry for any inconvenienve: I had resetted the filters to - no filter - causing no organization to appear. Selecting every status of the filters solved the 'problem'. I'm still confused, in my eyes 'no filter' should finally show every organization!?