- 07 Mar 2009, 22:14
#715
Hello,
I am seeking directions on changing the the helper.php to install the chasejobs backup on my site with 1and1.com i have tried making a lot of changes to this file however it is not working. I get the error
Fatal error: Call to undefined method: jexception->setquery() in /homepages/CATS/modules/mod_catsone/helper.php on line 46.
I have tried the following changes :
$options = array ( 'driver' => $driver, 'host' => $host, 'user' => $user, 'password' => $password, 'database' => 'dbname', 'prefix' => "jos_" );
*/
$host = $conf->getValue('config.host');
$driver = $conf->getValue('config.dbtype');
$options = array ( 'driver' => $driver, 'host' => $host, 'user' => 'dbusername', 'password' => '*Database*', 'database' => 'dbname', 'prefix' => "jos_" );
$db =& JDatabase::getInstance( $options );
$query = "Select joborder.*,extra_field.*,user.user_id,user.last_name,company.company_id,company.name from joborder,extra_field,user,company where extra_field.data_item_id = joborder.joborder_id and joborder.status = 'active' and joborder.entered_by = user.user_id and joborder.company_id = company.company_id ";
//echo $query;
$db->setQuery($query); - this is line 46
Is there something which i am missing. I am looking for help fixing this
I am seeking directions on changing the the helper.php to install the chasejobs backup on my site with 1and1.com i have tried making a lot of changes to this file however it is not working. I get the error
Fatal error: Call to undefined method: jexception->setquery() in /homepages/CATS/modules/mod_catsone/helper.php on line 46.
I have tried the following changes :
$options = array ( 'driver' => $driver, 'host' => $host, 'user' => $user, 'password' => $password, 'database' => 'dbname', 'prefix' => "jos_" );
*/
$host = $conf->getValue('config.host');
$driver = $conf->getValue('config.dbtype');
$options = array ( 'driver' => $driver, 'host' => $host, 'user' => 'dbusername', 'password' => '*Database*', 'database' => 'dbname', 'prefix' => "jos_" );
$db =& JDatabase::getInstance( $options );
$query = "Select joborder.*,extra_field.*,user.user_id,user.last_name,company.company_id,company.name from joborder,extra_field,user,company where extra_field.data_item_id = joborder.joborder_id and joborder.status = 'active' and joborder.entered_by = user.user_id and joborder.company_id = company.company_id ";
//echo $query;
$db->setQuery($query); - this is line 46
Is there something which i am missing. I am looking for help fixing this