jobberBase Community

Welcome to jobberBase Developer Community!

You are not logged in.

Announcement

Announcement for new users: in order to combat the ever increasing spam, we no longer allow new users to post links in the message body. This limitation is automatically lifted once a new user has a specific number of 'valid' posts.

You can post links like google.com which will be rendered as text but you will not be able to post messages that contain complete URLs like www.google.com

Thank you for your understanding!

Pages: 1

#1 2012-02-02 02:27:35

rustymetty
Member
Registered: 2012-02-02
Posts: 3

Install Help

Hi I'm getting the following error on my remote Bluehost install:


Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'root'@'localhost' (using password: NO) in /home2/thecoves/public_html/gigbees/_includes/class.Db.php on line 20

Warning: mysqli::query() [mysqli.query]: Couldn't fetch Db in /home2/thecoves/public_html/gigbees/_includes/class.Db.php on line 72

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in /home2/thecoves/public_html/gigbees/_includes/class.Db.php on line 73

Warning: mysqli::query() [mysqli.query]: Couldn't fetch Db in /home2/thecoves/public_html/gigbees/_includes/class.Db.php on line 31

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in /home2/thecoves/public_html/gigbees/_includes/class.Db.php on line 32

Fatal error: Call to a member function fetch_assoc() on a non-object in /home2/thecoves/public_html/gigbees/_includes/class.JobberSettings.php on line 23



It's sub URL. Also, the following is my Config.envs.php:



<?php

/**

* Define environments

*

*/



// local (http://localhost/jobberbase/public)

$__instances['live'] = array(

    // should be a unique part of the url (or the entire url if you wish)

    'prefix' => 'www.gigbees.com',

    // mysql credentials

    'db_host' => '66.147.244.161',

    'db_port' => 3306,

    'db_user' => '***********',

    'db_password' => '***********',

    'db_name' => 'jobberbase',

    'db_prefix' => 'gigbees.com',

    // your site's full url

    'app_url' => 'http://www.gigbees.com/',

    // error reporting

    'ini_error_reporting' => E_ALL,

    'ini_display_errors' => 'On',

    // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment)

    'location' => 'online',

    // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online')

    'environment' => 'prod',

    //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite'

    'rewrite_mode' => 'apache_mod_rewrite'

);



// live (http://www.gigbees.com)

$__instances['live'] = array(

    'prefix' => 'gigbees.com',

    'db_host' => 'remote',

    'db_port' => 3306,

    'db_user' => '***********',

    'db_password' => '***********',

    'db_name' => 'jobberbase',

    'db_prefix' => 'gigbees.com',

    'app_url' => 'www.gigbees.com/',

    'ini_error_reporting' => E_ALL,

    'ini_display_errors' => 'On',

    'location' => 'online',

    'environment' => 'prod',

    'rewrite_mode' => 'apache_mod_rewrite'

);





// setup current instance

foreach ($__instances as $__instance)

{

    // http requests

    if (isset($_SERVER['HTTP_HOST']))

    {

        $_compare_to = $_SERVER['HTTP_HOST'];

    }



    if (strstr($_compare_to, $__instance['prefix']))

    {

        define('DB_HOST', $__instance['db_host']);

        define('DB_PORT', $__instance['db_port']);

        define('DB_USER', $__instance['db_user']);

        define('DB_PASS', $__instance['db_password']);

        define('DB_NAME', $__instance['db_name']);

        define('DB_PREFIX', $__instance['db_prefix']);



        // values kind of redundant, they indicate wether this is a live/production or dev/testing environment

        define('LOCATION', $__instance['location']);

        define('ENVIRONMENT', $__instance['environment']);

       

        // base url of the app

        define('APP_URL', $__instance['app_url']);

        define('REWRITE_MODE', $__instance['rewrite_mode']);

        // error reporting

        ini_set('error_reporting', $__instance['ini_error_reporting']);

        ini_set('display_errors', $__instance['ini_display_errors']);

       

        break;

    }

}

?>

Appreciate any help very much.

Thanks!

Offline

#2 2012-02-02 23:08:18

rustymetty
Member
Registered: 2012-02-02
Posts: 3

Re: Install Help

okay, now just one error:

Fatal error: Call to a member function fetch_assoc() on a non-object in /home2/thecoves/public_html/gigbees/_includes/class.JobberSettings.php on line 23

Offline

#3 2012-02-03 01:48:09

rustymetty
Member
Registered: 2012-02-02
Posts: 3

Re: Install Help

...aaaaand now a blank page....nothing

Offline

#4 2012-02-03 12:19:27

hobo
Member
Registered: 2009-03-01
Posts: 447

Re: Install Help

Try changing:

'db_prefix' => 'gigbees.com',  to:    'db_prefix' => '',
'app_url' => 'www.gigbees.com/',  to:  'app_url' => 'http://gigbees.com/',

...and it is important to find your real database host name instead of using:    'db_host' => 'remote',

100% Free Job Listings Canada
Get it now! Free Job Listings Template for jobberBase
Check it out: Job Listings Template demo

Offline

#5 2012-02-05 22:09:19

putypuruty
Administrator
From: Oradea, Romania
Registered: 2008-08-20
Posts: 1,042

Re: Install Help

@rustymetty

I've sent you a private mail, I hope you received it.

Offline

#6 2012-06-19 10:43:07

maingockhuong89
Member
Registered: 2012-06-18
Posts: 4

Re: Install Help

Hi all, plz help me. I still get the error messages:
"Fatal error: Call to a member function fetch_assoc() on a non-object in /home/khuong/public_html/_includes/class.JobberSettings.php on line 23"

My domain: softtoday.net

My config :



<?php
/**
* Define environments
*
*/

// local (http://localhost/jobberbase/public)
$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'jobberbase',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => '****',
    'db_password' => '****',
    'db_name' => '****',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://jobberbase/',
    // error reporting
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'On',
    // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment)
    'location' => 'local',
    // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online')
    'environment' => 'dev',
    //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite'
    'rewrite_mode' => 'apache_mod_rewrite'
);

// live (http://www.softtoday.net)
$__instances['live'] = array(
    'prefix' => 'softtoday.net',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => '****',
    'db_password' => '****',
    'db_name' => '****',
    'db_prefix' => '',
    'app_url' => 'http://softtoday.net/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'on',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);


// setup current instance
foreach ($__instances as $__instance)
{
    // http requests
    if (isset($_SERVER['HTTP_HOST']))
    {
        $_compare_to = $_SERVER['HTTP_HOST'];
    }

    if (strstr($_compare_to, $__instance['prefix']))
    {
        define('DB_HOST', $__instance['db_host']);
        define('DB_PORT', $__instance['db_port']);
        define('DB_USER', $__instance['db_user']);
        define('DB_PASS', $__instance['db_password']);
        define('DB_NAME', $__instance['db_name']);
        define('DB_PREFIX', $__instance['db_prefix']);

        // values kind of redundant, they indicate wether this is a live/production or dev/testing environment
        define('LOCATION', $__instance['location']);
        define('ENVIRONMENT', $__instance['environment']);
       
        // base url of the app
        define('APP_URL', $__instance['app_url']);
        define('REWRITE_MODE', $__instance['rewrite_mode']);
        // error reporting
        ini_set('error_reporting', $__instance['ini_error_reporting']);
        ini_set('display_errors', $__instance['ini_display_errors']);
       
        break;
    }
}
?>

Last edited by maingockhuong89 (2012-06-19 10:44:12)

Offline

#7 2012-06-27 13:51:16

dvtservices
DV Tech Services works for jobeerbas custamisation
From: Bangalore, India
Registered: 2011-09-01
Posts: 151
Website

Re: Install Help

it looks  to be your data base empty. please  upload the jobberbase.sql file correctly to your databse

Thanks &Regards
DV Tech Services Pvt Ltd
Email: venkat@dvtservices.com;   www.dvtservices.com  Bangalore. India
                             We are Ready to Resolve your problems ..... And Ready to work for jobber base customizations

Offline

Pages: 1

Board footer

Powered by FluxBB