hobo

Re: Common problems installing jobberbase 1.9

Do tables in your biofarma_job have the prefix? You may have set it for database but not your tables.
Fill in the db prefix value to  'db_prefix' => 'biofarma_', or create a new database without prefix eg biofarma

er

Re: Common problems installing jobberbase 1.9

I don' know about the prefix. I can create a database w/o "biofarma_" because my shared hosting cPanel automatically adds "biofarma_" as the main domain min my host is biofarma.al
Anyway, I did added the "biofarma_" as prefix in the config.envs.php, but the same error appeared.

I have installed many scripts, but this one is too hard....

By the way, thanks for trying to help me!

hobo

Re: Common problems installing jobberbase 1.9

Another thing you may have forgotten to do before installing database (instead of jb_ use biofarma_):

F
rom jobbeBase wiki http://wiki.jobberbase.com/install/guid … e-hosting:

"Single database hosting

If you know that this is your case, then please follow these steps:

   1.You must decide for a string (you can use jb_, for example) which will be prepended to every jobberbase table name. You will have to set this string in the DB_PREFIX field that is described in step 3.
   2. Open jobberbase.sql in a text editor of your choice and use its find & replace feature, as follows (Hint: in the find & replace dialog, there's usually a button (Replace All, in case of Notepad) for replacing all the occurrences at once):
   3. Replace all occurrences of CREATE TABLE IF NOT EXISTS ` (note the ` char ) with CREATE TABLE IF NOT EXISTS `THE_STRING_THAT_YOU_DECIDED_ON (for example, CREATE TABLE IF NOT EXISTS `jb_).
   4. Replace all occurrences of INSERT INTO ` with INSERT INTO `THE_STRING_THAT_YOU_DECIDED_ON (for example, INSERT INTO `jb_).
   5. Save your changes and then open phpmyadmin, select your database and then import your jobberbase.sql file.
   6. Skip step "Multiple database hosting" and continue with "Environment Setup". ...

er

Re: Common problems installing jobberbase 1.9

You were right!
Now I installed the script, but I am having a problem indexing the admin panel.
Here is the message i get "The page isn't redirecting properly"
What might b a problem?

hobo

Re: Common problems installing jobberbase 1.9

You may be using server that does not read the .htaccess files correctly.
This is the page and links on it that may be helpful to understand what is going on if you are using nginx: http://serverfault.com/questions/24243/ … rom-apache

If you are indeed using nginx, I can not help you much as I have never used it, but you could try using the htaccess to nginx converter to convert your .htaccess files (in admin and root folders):
http://www.anilcetin.com/convert-apache … -to-nginx/

Last edited by hobo (2011-03-25 22:55:17)

pausep15

Re: Common problems installing jobberbase 1.9

HELP..... My site is blank.

This is my config.envs:

// local (http://localhost/jobberbase/public)
$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'onlinejobworker.tk',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'pausep',
    'db_password' => '****',
    'db_name' => 'pausep15_onlinepau',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://onlinejobworker.tk/',
    // 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.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'onlinejobworker.tk',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'pausep',
    'db_password' => '****',
    'db_name' => 'pausep15_onlinepau',
    'db_prefix' => '',
    'app_url' => 'http://www.onlinejobworker.tk/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'Off',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);

putypuruty

Re: Common problems installing jobberbase 1.9

Hi!

I visited your site and I see Index of / and underneath it a link for the cgi-bin folder. Are you sure that you've uploaded the files in the correct folder?

Also, I see that you have nginx as a web server so please have a look here http://www.jobberbase.com/forum/topic2566-nginx.html to see how to set up URL rewriting.

pausep15

Re: Common problems installing jobberbase 1.9

Ive uploaded the files to the parent directory first. Then that was a mistake, I uploaded it again to the correct folder which is public_html, but still didnt work. Can you tell me what to do? I have no knowledge with this.

hobo

Re: Common problems installing jobberbase 1.9

Find the folder on your server that contains the "cgi-bin" folder and upload the contents of the "public" folder there. You could also delete that cgi-bin folder, if you are not using it.
Before installing database tables make sure you do this: http://wiki.jobberbase.com/install/guid … se-hosting

Your
'db_prefix' => '',
should say
'db_prefix' => 'pausep15_'

And that link putypuruty posted will be useful.

xploitmachine

Re: Common problems installing jobberbase 1.9

Hello support team !

http://i.pictr.com/og5hwd3c2f.jpg

http://i.pictr.com/0an484pqpi.jpg

May i know whats the wrong? it cant seems to access the Jobberbase 1.9 which I have installed. Very hard and confusing as I have tried many methods .. sad

Please help thanks ! ..

"Genius Is One Percent Inspiration, Ninety-Nine Percent Perspiration" - Thomas Alva Edison

hobo

Re: Common problems installing jobberbase 1.9

What does your config.envs.php look like?
Have you installed database?

putypuruty

Re: Common problems installing jobberbase 1.9

From what I saw in your screenshot, you've entered the database related settings directly in the config.php file but this is not the correct way. You should configure the database access info in the config.envs.php file.

xploitmachine

Re: Common problems installing jobberbase 1.9

Hi, thanks for the fast response .. below is my "config.envs.php" data ..

// local (http://localhost/jobberbase/public)
$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'www.myurl.com',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'DBUSERNAME',
    'db_password' => 'DBPASSWORD',
    'db_name' => 'db1423328-main',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'www.myurl.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' => 'local',
    // 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.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'www.myurl.com',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'DBUSERNAME',
    'db_password' => 'DBPASSWORD',
    'db_name' => 'db1423328-main',
    'db_prefix' => '',
    'app_url' => 'www.myurl.com/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'On',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);

thanks

Last edited by xploitmachine (2011-05-13 04:04:08)

"Genius Is One Percent Inspiration, Ninety-Nine Percent Perspiration" - Thomas Alva Edison

xploitmachine

Re: Common problems installing jobberbase 1.9

I've also followed some guide from here http://www.jobberbase.com/forum/post10059.html#p10059

yes and the .SQL has been uploaded too .. but now I have this error ..

Fatal error: Smarty error: [in header.tpl line 3]: syntax error: mismatched tag {/if}. (Smarty_Compiler.class.php, line 2338) in /data/multiserv/users/575969/projects/1423328/www/_includes/smarty/libs/Smarty.class.php on line 1093

"Genius Is One Percent Inspiration, Ninety-Nine Percent Perspiration" - Thomas Alva Edison

xploitmachine

Re: Common problems installing jobberbase 1.9

Wow! .. crazy .. i accidently erased the header.tpl .. now managed the site to work as i replaced the original header.tpl..

smile

"Genius Is One Percent Inspiration, Ninety-Nine Percent Perspiration" - Thomas Alva Edison

saginaw

Re: Common problems installing jobberbase 1.9

hey everyone, how you all doing?

everything was going well, but the website is BLANK

http://www.extrastudent.com/home

i tried in the beginning to change some stuff on the DB before i install it, but an error messege showed up, so i tried again uploading it without changing anything within and it went successfully.

then i jumped to the next steps but its blank, can anyone think of a reason? my config info are:

Code:


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

// local (http://extrastudent.com)
$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'http://www.extrastudent.com/',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'extrastu_XXXX',
    'db_password' => 'XXXXX',
    'db_name' => 'extrastu_XXXXX',
    'db_prefix' => 'extrastu_',
    // your site's full url
    'app_url' => 'http://WWW.extrastudent.com/home/',
    // 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.extrastudent.com)
$__instances['live'] = array(
    'prefix' => 'http://www.extrastudent.com',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'extrastu_XXXX',
    'db_password' => 'XXXXX',
    'db_name' => 'extrastu_XXXXX',
    'db_prefix' => '',
    'app_url' => 'http://WWW.extrastudent.com/home',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'Off',
    '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;
    }
}
?>

getcm

Re: Common problems installing jobberbase 1.9

Hi I'm new here and i'm trying to install this script. I read the entire post and I tried everything, but I still get this problems:

Warning: mysqli::mysqli() [mysqli.mysqli]: (42000/1044): Access denied for user XXXXX to database /xxx/_includes/class.Db.php on line 20

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

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

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

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

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

Following is my config.envs.php settings :

// live (http://www.mysite.com)
$__instances['live'] = array(
    'prefix' => 'mysite.com',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'XXXXXX_XXXXX',
    'db_password' => 'XXXXXX',
    'db_name' => 'XXXXXX_XXXXX',
    'db_prefix' => '',
    'app_url' => 'http://mysite.com/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'On',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'

Can someone help me?

Thanks

putypuruty

Re: Common problems installing jobberbase 1.9

Hi, @getcm!

The problem is clearly on your side because you get the Access denied for user xxxx error message. Are you sure that you've associated that database user with your jobberbase database?

getcm

Re: Common problems installing jobberbase 1.9

Hi!

You were correct, it was my mistake! But i'm not sure why. I Tried a lot of things and my I was sure that I've associated the database user with the jobberbase database, so I created a new DB this morning and connected without difficulty and then created a new user in the same DB and connected without difficulty.

Now It works perfect!

Thanks!

oliver

Re: Common problems installing jobberbase 1.9

Hello!

i am stumped.

baffled.

Reading all of this i still can´t work our where Iam going wrong.  I just have a blank screen.

http://jobs.commercialdivingwork.com/

I am running php5 and have set up a php info scritp

http://jobs.commercialdivingwork.com/phpinfo.php

Here is my config file. Please help!

<?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' => 'localhost',
    // mysql credentials
    'db_host' => '94.126.44.120',
    'db_port' => 3306,
    'db_user' => 'XXXXXXXXX',
    'db_password' => 'XXXXXXXXXXXX',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://localhost/jobberbase/trunk/public/',
    // 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.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'jobs.commercialdivingwork.com/',
    'db_host' => '94.126.44.120',
    'db_port' => 3306,
    'db_user' => 'cdwjobdbadmin',
    'db_password' => 'brasilia',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    'app_url' => 'http://jobs.commercialdivingwork.com/',   //Incl
    '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;
    }
}
?>

putypuruty

Re: Common problems installing jobberbase 1.9

Hi!

Can you change 'environment' => 'prod' to 'environment' => 'dev' in the $__instances['live'] part and see what happens?

Also, please set the prefix only to commercialdivingwork.com

oliver

Re: Common problems installing jobberbase 1.9

hmm, still blank.

<?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' => 'http://commercialdivingwork.com',
    // mysql credentials
    'db_host' => '94.126.44.120',
    'db_port' => 3306,
    'db_user' => 'cdwjobdbadmin',
    'db_password' => 'brasilia',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://localhost/jobberbase/trunk/public/',
    // 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.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'commercialdivingwork.com/',
    'db_host' => '94.126.44.120',
    'db_port' => 3306,
    'db_user' => 'xxxxxxxxx',
    'db_password' => 'xxxxxxxx',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    'app_url' => 'http://jobs.commercialdivingwork.com/',   //Incl
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'on',
    'location' => 'online',
    'environment' => 'dev',
    '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;
    }
}
?>

putypuruty

Re: Common problems installing jobberbase 1.9

Hi!

The prefix in the live part should be commercialdivingwork.com without an ending slash.

oliver

Re: Common problems installing jobberbase 1.9

Thank you ! Thank you ! Thank you ! Thank you !

Problem resolved. really appreciated.

jobsrus

Re: Common problems installing jobberbase 1.9

hi guys

any help on this would be appreciated

have done setup as described - not sure whats going wrong.
may be a problem as i am installing on a subdomain www.jobs.jobsrus.ie

error message is
Fatal error: Smarty error: unable to write to $compile_dir '/usr/local/pem/vhosts/146512/webspace/httpdocs/_templates/default/_cache'. Be sure $compile_dir is writable by the web server user. in /usr/local/pem/vhosts/146512/webspace/httpdocs/_includes/smarty/libs/Smarty.class.php on line 1093
-----------------------------------------------------------------
config.envs.php is

<?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' => 'jobsrus.ie',
    // mysql credentials
    'db_host' => '172.16.3.92',
    'db_port' => 3306,
    'db_user' => 'XXXX',
    'db_password' => '*XXXX',
    'db_name' => 'xxxx',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://www.jobs.jobsrus.ie/',
    // 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.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'jobsrus.ie',
    'db_host' => '172.16.3.92',
    'db_port' => 3306,
    'db_user' => 'xxxx',
    'db_password' => 'xxxx',
    'db_name' => 'xxxx',
    'db_prefix' => '',
    'app_url' => 'http://www.jobs.jobsrus.ie/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'Off',
    '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;
    }
}
?>