Posted by simon147 on June 24, 2011 at 7:45am
4 followers
Jump to:
| Project: | Dynamic Dashboard for Storm (Project Management) |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | major |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Issue Summary
First tried with the stable version and then with 6.x-2.x, but in both cases get I get the following error message:
user warning: Table 'hubvd_drupal.drp_stormticket' doesn't exist query: SELECT n.*, sor.* FROM drp_node AS n INNER JOIN drp_stormorganization AS sor ON n.vid=sor.vid INNER JOIN drp_stormticket AS sti ON n.nid=sti.organization_nid WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( ('storm_access'='storm_access') AND ( n.status=1 AND n.type='stormorganization' AND sti.ticketstatus IN ('in progress') ) )ORDER BY n.title in /home/hubvd/public_html/sites/all/modules/contrib/storm_dashboard/storm_dashboard.module on line 448.
user warning: Table 'hubvd_drupal.drp_stormticket' doesn't exist query: SELECT n.*, spr.* FROM drp_node AS n INNER JOIN drp_stormproject AS spr ON n.vid=spr.vid INNER JOIN drp_stormticket AS sti ON n.nid=sti.project_nid WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( ('storm_access'='storm_access') AND ( n.status=1 AND n.type='stormproject' AND sti.ticketstatus IN ('in progress') AND spr.organization_nid=69) ) in /home/hubvd/public_html/sites/all/modules/contrib/storm_dashboard/storm_dashboard.module on line 448.
user warning: Table 'hubvd_drupal.drp_stormticket' doesn't exist query: SELECT n.*, sta.* FROM drp_node AS n INNER JOIN drp_stormtask AS sta ON n.vid=sta.vid INNER JOIN drp_stormticket AS sti ON n.nid=sti.task_nid WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( ('storm_access'='storm_access') AND ( n.status=1 AND n.type='stormtask' AND sti.ticketstatus IN ('in progress') AND sta.organization_nid=69 AND sta.project_nid=0 AND sta.parent_nid=0 ) )ORDER BY taskpriority DESC in /home/hubvd/public_html/sites/all/modules/contrib/storm_dashboard/storm_dashboard.module on line 448.
Comments
#1
Seems that the bug only appears in 6.x-1.36 and not in 6.x-2.x
#2
The bug seems to be coming from the Storm Dashboard module rather than Storm. It may be that Storm Dashboard is only compatible with certain versions of Storm.
#3
@simon147, can you please provide some more background information, as we can't reproduce that problem:
1) Which version of storm_dashboard are you using? The reason I'm asking is that there is nothing at line 448 in storm_dashboard.module that would want to access any database table. And not even close to that line 448.
2) Have you got Stormticket enabled?
3) Is your database prefix defined as "drp"?
#4
I too have just experienced this problem on a fresh install.
Installed Drupal 6.x.22
Installed 6.x-2.0-beta3 Storm and enabled several, but not all components.
Installed 6.x-2.x-dev branch of dashboard
I am not using a database prefix.
Then you get this warning in red at the top of the content area.
It appears that Dashboard is dependent upon stormticket being enabled, something I don't need.
If it is dependent, then this could be added to the module info.
When I enable stormticket, presumably the missing tables are built, and the warning goes away.
-dave
#5
Thanks for the info.
I will check, if we could make stormticket optional or if stormticket should be added as a dependancy.