I get the following errormessage on

  • admin/case/casetracker_case_priority/edit
  • admin/case/casetracker_case_status/edit
  • admin/case/casetracker_case_type/edit

* user warning: Table 'usr_web2_3.casetracker_case_priority' doesn't exist query: SELECT * FROM casetracker_case_priority in /srv/www/htdocs/web2/html/jugendgruppen/nord/drupal/includes/database.mysql.inc on line 120.
* warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web2/html/jugendgruppen/nord/drupal/modules/casetracker/casetracker.module on line 1099.
* warning: Invalid argument supplied for foreach() in /srv/www/htdocs/web2/html/jugendgruppen/nord/drupal/includes/form.inc on line 575.

the table is called jf_casetracker_case_priority and settings.php is configured properly.

sidequestion for all german speaking people:
How would you translate "Case Tracker"?
"Projektmanager", "Projektverwalter", better Ideas?

CommentFileSizeAuthor
#1 casetracker-prefixtable.patch2.41 KBerdemkose

Comments

erdemkose’s picture

erdemkose commented
StatusFileSize
new casetracker-prefixtable.patch2.41 KB

There was a patch for this problem but it was missing 3 statement.

Lines:
1098
1160
1190

These lines contains {} but in a wrong way. Braces contains a variable such that {$table} so PHP erases {} before submitting to db_query function.

Line 1098 should be:
$result = db_query("SELECT * FROM {".$table."}");

Line 1160 should be:
$result = db_query("UPDATE {".$form_values[casetracker_table_name]."} SET $fields[1] = '%s' WHERE $fields[0] = %d ", $form_values['casetracker_new_values'], $form_values['casetracker_old_values']);

Line 1190 should be:
$result = db_query("DELETE FROM {".$form_values['casetracker_table_name']."} WHERE $fields[0] = %d ", $form_values['casetracker_old_values']);

I could not find any other errors.

Attached patch should correct them.

erdemkose’s picture

erdemkose commented
Status: Active » Needs review

changed status

sanjeev gupta’s picture

sanjeev gupta commented
Status: Needs review » Active

The patch has been applied.

sanjeev gupta’s picture

sanjeev gupta commented
Status: Active » Fixed
Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)