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

CommentFileSizeAuthor
#3 tables_curly_brackets-1270736-1.patch1.84 KBgibus

Comments

brigitte’s picture

brigitte commented

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.

gibus’s picture

gibus commented
Status: Active » Postponed (maintainer needs more info)

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?

gibus’s picture

gibus commented
StatusFileSize
new tables_curly_brackets-1270736-1.patch1.84 KB

Can you test the patch attached?

nouriassafi’s picture

nouriassafi commented

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']);
}
}
?>
gibus’s picture

gibus commented
Status: Postponed (maintainer needs more info) » Fixed

Thanks just commited in Release 6.x-2.20

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.