putypuruty

Topic: Common problems installing jobberbase 1.9

1. If you are getting an error similar to the following

Code:

Warning: mysqli::mysqli() expects parameter 5 to be long, string given in /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 in /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

then the problem is most likely caused by a wrong prefix in config.envs.php. If your site's URL is example.com or subdomain.example.com or even example.com/subfolder, then the prefix in the $__instances['live'] part must be set to example.com

2. If the site's layout seems to be broken, then be sure that the app_url inside the $__instances['live'] part is set correctly:

- if your site is www.example.com, then the app_url must be http://www.example.com/
- if your site is subdomain.example.com, then the app_url must be http://subdomain.example.com/
- if your site is www.example.com/subfolder, the the app_url must be http://www.example.com/subfolder/

jillian

Re: Common problems installing jobberbase 1.9

Beat my head against the wall with this error for a while until I realized that even if I'm using domain pointing I had to use the actual base domain in the config.

i.e. 
Files are actually located at mydomain.com/jillsjams

I kept putting jillsjams.com under the prefix field because I have multiple domains hosted from the same account and I was doing a stealth pointer to http://jillsjams.com and silly me, I thought it would redirect.  Duh.

Worked great after fixing that piece!

fboushra

Re: Common problems installing jobberbase 1.9

I have this problem but I tried every this and not working
the url for this script is www.egyselect.com/ch2betterlife/jobs Also I have subdomain www.jobs.ch2betterlife.com

And here is the file config


// 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' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'chtwobet_job',
    'db_password' => 'XXXXX',
    'db_name' => 'chtwobet_chjobs',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://jobs.ch2betterlife.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' => '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' => 'ch2betterlife.com',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'chtwobet_job',
    'db_password' => 'XXXXXX',
    'db_name' => 'chtwobet_chjobs',
    'db_prefix' => '',
    'app_url' => 'http://jobs.ch2betterlife.com/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'on',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);

fboushra

Re: Common problems installing jobberbase 1.9

Now it's work

benny

Re: Common problems installing jobberbase 1.9

hi im new on this site and with this sistem, im trying to install this scropt but something is wrong.

i follow all stpes but when y need try i see this error...

Warning: mysqli::mysqli() expects parameter 5 to be long, string given in /home/svegas/public_html/deempleo.net/_includes/class.Db.php on line 20

Warning: mysqli::query() [mysqli.query]: Couldn't fetch Db in /home/svegas/public_html/deempleo.net/_includes/class.Db.php on line 72

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

Warning: mysqli::query() [mysqli.query]: Couldn't fetch Db in /home/svegas/public_html/deempleo.net/_includes/class.Db.php on line 31

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in /home/svegas/public_html/deempleo.net/_includes/class.Db.php on line 32

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

any idea?

putypuruty

Re: Common problems installing jobberbase 1.9

@benny

Please open a new topic with your problem and also post there the $__instance blocks from config.envs.php, but take care not to post your db username and password wink

Navras

Re: Common problems installing jobberbase 1.9

Yeah!
It Works!

I had problem with "Couldn't fetch Db in"

What I made:

CHANGED THIS:

$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'localhost',

TO THIS:

$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'jobberbase',

AND CHANGED THIS:

    'app_url' => 'http://localhost/jobberbase/trunk/public/',

TO THIS:

    'app_url' => 'http://jobberbase/',

Hope it will be useful for you.

ben18285

Re: Common problems installing jobberbase 1.9

Hi,

I had the same issue. After changing the prefix as described above, the error message disappeared but my page is now blank... how is that possible?

my config:

$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'localhost',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'UXXXXXX',
    'db_password' => 'XXXXXXX',
    'db_name' => 'DB802584',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://www.business-solutions24.com/headhunt/',
    // 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.business-solutions24.com/headhunt/)
$__instances['live'] = array(
    'prefix' => 'business-solutions24.com',
    'db_host' => 'http://rdbms.strato.de',
    'db_port' => 3306,
    'db_user' => 'UXXXXXX,
    'db_password' => 'XXXXXXXX',
    'db_name' => 'DB802584',
    'db_prefix' => '',
    'app_url' => 'http://www.business-solutions24.com/headhunt/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'Off',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);

Thanks in advance

ben18285

Re: Common problems installing jobberbase 1.9

found it, it was the http:// at the db_host definition.

zack

Re: Common problems installing jobberbase 1.9

Thank you guys!

I just fixed this issue using the info you provided but one thing you forgot to mention is the prefix should be the subdomain ( that was my case with my hosting company - Hostgator)  so the prefix is subdomain.example.com and ofcourse I changed the ap url to http://subdomain.example.com

Thanks again for this great script! I have been looking around the internet for months !

quest

Re: Common problems installing jobberbase 1.9

Hi,I am quite new to jobberbase and I am  thankful  for the useful information. I was getting the similar issues as posted by some of the users. I could get rid of some issues by following the guidelines provided here. But I still face one issue where I am getting a BLANK PAGE when I hit the URL in the browser now ! Following is my config.envs.php settings :

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

Can someone correct me what went wrong in this ?

Thanks

Last edited by quest (2010-11-26 14:20:03)

putypuruty

Re: Common problems installing jobberbase 1.9

I assume that you are getting a 500 Internal server error and that's why you get a blank page. Do you think that you could give me the link to your site in a private mail (http://www.jobberbase.com/forum/email19.html) so that I can see the problem for myself?

quest

Re: Common problems installing jobberbase 1.9

Thanks. I solved the issue. I made the "'ini_display_errors' => 'on'," and found that the issue was due to DB USER. I did not ASSIGN the user to DB at all and I was trying to connect with the user ! I corrected it and it is working fine.

I am just beginning to create a site using jobberbase and the support is excellent.

nsdk

Re: Common problems installing jobberbase 1.9

Hi. Here is my config file, and following is the error I`m getting:
// live (http://www.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'originit.ca',
    'db_host' => 'originit.ca',
    'db_port' => 3306,
    'db_user' => 'origini1_admin',
    'db_password' => 'XXXX',
    'db_name' => 'origini1_jbase',
    'db_prefix' => '',
    'app_url' => 'http://jobs.originit.ca/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'On',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'

Error is:

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'origini1_admin'@'cx48.justhost.com' (using password: YES) in /home/origini1/public_html/jobs/_includes/class.Db.php on line 20

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

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

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

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

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

if I change db_host to 'localhost', then the error becomes:

Warning: Cannot modify header information - headers already sent by (output started at /home/origini1/public_html/jobs/_config/config.php:1) in /home/origini1/public_html/jobs/_config/config.php on line 135

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/origini1/public_html/jobs/_config/config.php:1) in /home/origini1/public_html/jobs/_config/config.php on line 136

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/origini1/public_html/jobs/_config/config.php:1) in /home/origini1/public_html/jobs/_config/config.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/origini1/public_html/jobs/_config/config.php:1) in /home/origini1/public_html/jobs/_includes/function.redirect_to.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at /home/origini1/public_html/jobs/_config/config.php:1) in /home/origini1/public_html/jobs/_includes/function.redirect_to.php on line 23

Any assistance is appreciated.

putypuruty

Re: Common problems installing jobberbase 1.9

To get rid of that warning, try this http://www.jobberbase.com/forum/post10059.html#p10059

I also see that the first warning line is fisp - did you add this text in order to debug your problem but then you forgot to remove it?

nsdk

Re: Common problems installing jobberbase 1.9

Hi,
Thanks for your help. its was the 'fisp' that was causing all the problem. It is apparently a typo left, possibly left by the host admin when they were trying to prove to me that mod_rewrite is enable.

Now it seems to work.

Thanks.

jekwumoore

Re: Common problems installing jobberbase 1.9

I am getting a blank page, so I decided to turn the ini on to see the error and the error is below

Fatal error: Smarty error: unable to write to $compile_dir '/home/jobarena/public_html/_templates/default/_cache'. Be sure $compile_dir is writable by the web server user. in /home/jobarena/public_html/_includes/smarty/libs/Smarty.class.php  on line 1093   

permission is set to 755

jekwumoore

Re: Common problems installing jobberbase 1.9

I changed the permission to 777 and it works but I am concerned about security cos it is not advisable to use 777

sipap

Re: Common problems installing jobberbase 1.9

hello i have the same problems when i install jobberbase. I have blank page. Please help i. this is my config.envs file:

$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'platon/',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'xxxxxx',
    'db_password' => 'xxxxxx',
    'db_name' => 'xxxxxxxx',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://platon/job1/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' => 'platon/',
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'xxxxx',
    'db_password' => 'xxxxx',
    'db_name' => 'xxxxxxx',
    'db_prefix' => '',
    'app_url' => 'http://platon/job1/public/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'Off',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);

Last edited by sipap (2010-12-29 09:14:36)

hobo

Re: Common problems installing jobberbase 1.9

@sipap
Are you using a domain name, or local network for testing?
For local testing your prefix should be:
'prefix' => 'localhost', 

and your app url should be:
'app_url' => 'http://localhost/job1/public/',

or     
'app_url' => 'http://localhost/platon/job1/public/',

If you are installing on live server than replace word localhost with your domain name  (do not forget the .com .org or whatever.

sipap

Re: Common problems installing jobberbase 1.9

Hello Hobo i try all this but it doesn't work. I use ovh server in a local network for testing. I don't why it doesn't work. I am sorry but i dont speak english very well. I speak french but i understand what you tell. I install it a first time and it work but after having a blems with the admin i change the config and i has a blank page i put the good code i had before and i had always a blank page. I re-install jobberbase and always i has blank page. Please help.

hobo

Re: Common problems installing jobberbase 1.9

Try reoplacing your local settings with following:

Code:
$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'localhost',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => '******',
    'db_password' => '*******',
    'db_name' => '******',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://localhost/job1/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' => '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'
);

sipap

Re: Common problems installing jobberbase 1.9

I do it but it doesn't work. I have this message :
Notice: Use of undefined constant DB_PREFIX - assumed 'DB_PREFIX' in /var/www/platon/job1/public/_includes/class.JobberSettings.php on line 18 Notice: Use of undefined constant ENVIRONMENT - assumed 'ENVIRONMENT' in /var/www/platon/job1/public/_includes/class.Db.MySql.php on line 63 Fatal error: Uncaught exception 'Exception' with message 'Database query error' in /var/www/platon/job1/public/_includes/class.Db.MySql.php:66 Stack trace: #0 /var/www/platon/job1/public/_includes/class.JobberSettings.php(19): Db->query('SELECT * FROM D...') #1 /var/www/platon/job1/public/_config/config.php(75): JobberSettings->__construct() #2 /var/www/platon/job1/public/index.php(16): require_once('/var/www/platon...') #3 {main} thrown in /var/www/platon/job1/public/_includes/class.Db.MySql.php on line 66.

In db_prefixe i has nothing. i has this : 'db_prefix' => '',

Last edited by sipap (2010-12-30 15:38:03)

hobo

Re: Common problems installing jobberbase 1.9

Ok, first make sure your app url is:
'app_url' => 'http://localhost/platon/job1/public/',

sipap

Re: Common problems installing jobberbase 1.9

it sure i try all things but it doesn't work