Posted by brigitte on September 6, 2011 at 11:26am
4 followers
| Project: | Priorities |
| Version: | 6.x-2.19 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Hi,
Great module, thnak you !
It seems all is working but I've this message :
user warning: Table 'xxxxxx.priorities' doesn't exist query: SELECT count(*) AS cnt FROM priorities WHERE survey_name='priorities-dixhuitvingt' GROUP BY nid ORDER BY cnt DESC LIMIT 1
Comments
#1
Soory, you certainly need the full text : user warning: Table xxxxxx.priorities' doesn't exist query: SELECT count(*) AS cnt FROM priorities WHERE survey_name='priorities-dixhuitvingt' GROUP BY nid ORDER BY cnt DESC LIMIT 1 in /xxxxxxxx/modules/priorities/priorities.module on line 1473.
#2
Strange error, I cannot reproduce it. Have you had any pb. during installation of the module (that's where the tables are created)? Also, is it a fresh installation or an upgrade?
#3
Can you test the patch attached?
#4
Thanks for the great module. You need to modify the following hook for curly brackets as well.
function priorities_cron() {
// Check for surveys due to be closed (status = 0 or status = 1).
$time = time();
$sql = 'SELECT survey_name FROM {priorities_surveys} WHERE (starttime + duration) < '. $time .' AND (status = 0 OR status = 1) AND duration != 0';
$result = db_query($sql);
$surveys = array();
while ($r = db_fetch_array($result)) {
$surveys[$r['survey_name']] = $r;
}
foreach ($surveys as $survey_name => $survey) {
db_query("UPDATE {priorities_surveys} SET status = 2 WHERE survey_name = '%s'", $survey['survey_name']);
}
}
?>
#5
Thanks just commited in Release 6.x-2.20
#6
Automatically closed -- issue fixed for 2 weeks with no activity.