Download & Extend

user warning : table doesn't exist query

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

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?

#3

Can you test the patch attached?

AttachmentSize
tables_curly_brackets-1270736-1.patch 1.84 KB

#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

Status:postponed (maintainer needs more info)» fixed

Thanks just commited in Release 6.x-2.20

#6

Status:fixed» closed (fixed)

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

nobody click here