db_prefix

tomhung - July 28, 2008 - 19:39
Project:Hostmaster
Version:5.x-0.1-alpha3
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

here are a couple problems if you installed the site with a db_prefix

"site/hosting_site.module" line 53
was->

$result = db_query("SELECT nid FROM hosting_site WHERE platform=%d AND (status & %d)", $platform, $status);

is->
$result = db_query("SELECT nid FROM {hosting_site} WHERE platform=%d AND (status & %d)", $platform, $status);

"task/hosting_task.module" line 418
was ->

  $nid = db_result(db_query("SELECT nid FROM hosting_task t WHERE t.task_type='%s' and t.rid=%d ORDER BY executed DESC limit 1", $type, $rid));

is ->
  $nid = db_result(db_query("SELECT nid FROM {hosting_task} WHERE task_type='%s' and rid=%d ORDER BY executed DESC limit 1", $type, $rid));

#1

anarcat - August 22, 2008 - 17:58
Status:active» fixed

I just committed a fix, thanks. In the future, providing a proper patch will make sure that your fix is committed quickly. See http://drupal.org/patch/create

#2

Anonymous (not verified) - September 5, 2008 - 18:02
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.