jobberBase Installation Guide
- Download the latest version from jobberBase.com and decompress it.
- Make sure you have PHP 5+ (with mysqli extension enabled) and MySQL 4.1+ installed on your server. Also, Apache module mod_rewrite has to be enabled and overriding default settings with .htaccess need to be allowed.
- Can you see the .htaccess file in your downloaded files? Make sure it’s there.
- Create a new database and import __db/jobberbase.sql into it.
- Following directories need write permissions:
- /uploads (uploaded resumes are temporary stored here)
- /_templates/_cache (smarty cache)
- Open config.php and update the following constants so they suit your environment:
- DB_HOST
- DB_USER
- DB_PASS
- DB_NAME
- JOBBER_URL
- _APP_MAIN_DIR
- NOTIFY_EMAIL
- ADMIN_EMAIL
- SITE_NAME
- If you can’t see the .htaccess file or actually don’t have it, rename htaccess.txt into .htaccess.
- If your host doesn’t offer the mysqli PHP extension (find out from phpinfo()), you can use a mysql wrapper instead.
Open config.php and just replacerequire_once '_includes/class.Db.php'withrequire_once '_includes/class.Db.MySql.php'(thanks to Emil Sirbu for this). - That’s it, open up a browser and type in the URL (e.g. http://localhost/jobberbase/)!
Does this work for you?
Do you have a special environment that needed extra tweaking? Would you like to share?
comments
76 Responses to “jobberBase Installation Guide”
Leave a Reply
Hi, I have a small bug here: http://jobs.designcreme.com
Fatal error: Class ‘mysql’ not found in /home/design/public_html/jobs/_includes/class.Db.php on line 16
My host has php 5+ and mySQL 5+ ..
That’s actually ‘mysqli’ you don’t have installed. Check out your phpinfo() and see if you have the mysqli extension installed ;).
My host said they won’t install the extension on reseller/vps packages. Is there anyway to make this work without the mysqli extension?
I see. As a long-term advice, I recommend you change your hosting company. The mysqli extension stands for “mysql improved” extension… and any hosting company should comply.
But yes, you can get away without it, by editing _includes/class.Db.php. Replace all mysqli_ functions with their mysql_ correspondents. This class is merely a wrapper on the basic mysql functions, with a few extra helpers.
Unfortunately, still exists many companies which don’t offer mysqli extension.
Filip, to make jobber to work with mysql required some supplementary modification not only replace mysqli with mysql because you use into code $result->fetchAssoc, so, query must to be rewritten to return an object which have this method.
I work on this, I hope that in 1-2 hours I’ll make a wrapper for mysql.
carco, you’re right. Thanks!
Ok, i put here ( emil.topweb.ro/4jobber/class.Db.MySql.ph_ ) first version.
Save as _includes/4jobber/class.Db.MySql.php and replace change config.php
//require_once ‘_includes/class.Db.php’;
require_once ‘_includes/class.Db.MySql.php’;
Source is emil.topweb.ro/4jobber/class.Db.MySql.phps
Beautiful!
I’ve already updated the distribution, so new users will get class.Db.MySql.php right away.
Please change line 58 with
throw new QueryException(mysql_error($this->link), mysql_errno($this->link));
(instead of throw new QueryException(mysql_error($this), mysql_errno($this)); )
or redownload (sorry for mistake).
[…] impresii, instalarea se face foarte uşor (aveţi aici un articol ce explică cum se instalează), am avut câteva probleme dar s-au rezolvat imediat […]
Anyone else get this error when retrieving the RSS feed?
Fatal error: Call to a member function fetch_assoc() on a non-object in /home/dev/public_html/jb/_includes/class.Job.php on line 221
Sorry but i have error “function query()”
message:
Fatal error: Call to a member function query() on a non-object in /home/pedja/www/job/_includes/class.Job.php on line 706
Can you help me?
Pierre,
please report this on the forum, but don’t forget to copy/paste he code on that line (maybe 5-10 lines before and after, as well).
When visiting www.sidtarason.com/amateursportsnetwork/ I get the following error.
Fatal error: Call to a member function fetch_assoc() on a non-object in /home/content/s/i/d/sidtarason/html/amateursportsnetwork/_includes/class.Job.php on line 707
Here is the code. I have ***’d line 707
public function CountJobs($categ = false)
{
global $db;
if ($categ)
{
if (!is_numeric($categ))
{
$categ_id = $this->GetCategId($categ);
}
else
{
$categ_id = $categ;
}
$condition = ‘AND category_id = ‘ . $categ_id;
}
else
{
$condition = ”;
}
$sql = ‘SELECT COUNT(id) AS total FROM jobs WHERE is_temp = 0 AND is_active = 1 ‘ . $condition;
$result = $db->query($sql);
******** $row = $result->fetch_assoc(); *****
return $row[’total’];
}
I appreciate all the help!
Sid,
it seems your database connection is not correctly configured. Please check the settings in config.php.
Im getting the following error:
Parse error, unexpected { on line 102 of config.php
I dont get it?? lol
You didn’t read the requirements carefully: you need PHP 5+
I have PHP 5+ AND MYSQL 5+ - Im hosted with Simply.com
Still no working!
Please create a new script, with the following code, the run it:
< ?php phpinfo(); ?>
Maybe PHP 5 is not active.
Ahhh, i done this and it shows PHP Version 4.4.6
But my host says i have PHP version 5????
My hosts are telling me i must rename all PHP files to .PHP5 —- IS THIS GOING TO AFFECT THE RUNNING OF THE SITE?
Also i managed to get it working on another server, but when i click on anything it just goes to page not found, because its trying to go to www.mydomain.com/post/ but there isnt even a “post” directory, or when you click on jobs it tries going to www.mydomain.com/jobs/ but there is no jobs directory, i hope this makes sense.
Simon,
Renaming .php to .php5 is not enough. You’ll also need to dive into the code and change the extension there, for the included scripts.
Regarding the other server, it’s already been discussed either here on the blog or on the community forum. It’s a .htaccess issue.
Hi, ive changed everything including source code to PHP5 and it works ok, the only problem im having now is the .htaccess issue. When i click on anything i just get 404 not found, ive tried both versions of the .htaccess and it still doesnt work…. any clues? my site is at www.contineo.co.uk
thank you!
had enough of trying, tried all combinations of .htaccess, and either get 403 error or 404 error, installed hundreds of sites.scripts and developments and never had so much messing around. good work on the script but there is clearly a flaw in the development somewhere along the line.
Simon,
Have you downloaded the script in the past 3 days or earlier? There have been some updates and config.php has been improved a lot. Try it if you haven’t already.
Else… the script is working fine for a lot of people, in a lot of environments.
It’s most likely your problem lies in config.php, in the way you set up the directories…
ahhhhh, i may have found the problem. in config.php i see main dir as jobberbase/app but ive been running just under my public_html folder……. me try this now, i really want this board i think its brilliant, and will donate once i get it up and runnin.
can i just ask, do i have to create the /post/ and /contact/ directories myself, etc etc, for everything, cos its trying to access www.mydomain.com/post/ but the directories doesnt even exist in the downloaded release.
SO ANNOYING!!! Works perfectly on my free web hosting, and on the hosting i pay £10 a month for it just wont work!! grrrr
I am having the same problem as Simon. I installed the jobber on a subdomain. The main page shows properly but the links bring error not found message.
—–
As per those people that don’t have php 5.x here is the fix:
Just put the following line in your .htaccess file (I belevie the .htaccess file in the main directory of the site):
AddType x-mapp-php5 .php
AddHandler x-mapp-php5 .php
How Do You Send Mail Using SMTP Authentication in Jobber Base..??
You mess with /_includes/class.Postman.php (that’s where all the e-mails are being sent from).
phpmailer is also included, so it should be fairly easy to go with SMTP.
Hi Filip
I am trying to install jobber locally and having a problem with it.
When i am trying to access the main page I get the “index of/jobber”
Does it has something to do with configuration of
JOBBER_URL
_APP_MAIN_DIR
I didn’t change those setting in the configure file.
What if you try /jobber/app/ ?
I sent you an email…
Hi very nice script but I have a problem with sub directories. I put the files in www.mydomaine.com/job but the links seem to be broken. Any ideas?
I run PHP 5.1.2 on my site : http://test.2803.com/job/
Thanks a lot
henri
Henri,
1. Do you have apache mod_rewrite module active?
2. If you do, there may be a conflict between your main site’s .htaccess and jobberBase’s .htaccess.
Hi Filip, Yes the mod_rewrite module is active. On the main dir I have a wordpress blog with a .htaccess file. I remove the .htaccess of jobberbase of th job dir and put its content inside the main htaccess file but still not working…
just to test it, try removing the main .htaccess and leave only the .htaccess inside jobberBase. this should work, so the fix would be to somehow edit wordpress’ .htaccess…
[…] that, you can follow installation / setup guide on JobberBase Official site to setup own job based website for your own or commercial recruitment […]
is it compatible with windows
It runs on Apache server, with PHP 5 and MySQL 4.1+. It runs on any operating system.
filip i remove the htaccess of the wordpress dir and tweak a bit the htaccess of jobberbase but I still have some problem with url when I clic on a job, the other links work (widget, post a job…) quite strage
here is my htaccess :
RewriteEngine On
Options +FollowSymlinks
RewriteBase /job/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . index.php [L]
ErrorDocument 404 /page-unavailable/
finnaly it works on another subfolder
http://jobs.2803.com/
While i try run the site then i fetch the following message
“The server encountered an internal error or misconfiguration and was unable to complete your request.”
i am using the Apache Version Apache/2.2.4 (Win32) PHP/5.2.2
and
MysqlI Support enabled.
Is mod_rewrite enabled, also do you have the .htaccess in place?
I think there was someone else with this problem, try browsing the forums.
i am getting the same error
Parse error, unexpected { on line 102 of config.php
i try to put the code
AddType x-mapp-php5 .php
AddHandler x-mapp-php5 .php
but not work
any ideas
Ik get this error:
Fatal error: Call to undefined function date_default_timezone_set() in /var/www/vhosts/jobjournaal.nl/httpdocs/config.php on line 15
Hahaha…. i got it. I also try to install in my foder ‘job’.(like henri did)
So the address for this jobber is www.noelabs.com/job.
I think somehow this leads to confusing the config.php or constants inside the program.
So, i change my folder from ‘job’ to ‘jobber’ …… now its running perfectly.
Maybe you Filip, always assume that everyone will install this software in the root or sub-domain. That’s why henri suddenly be able to run this jobber.
Any comment?
The problem with /job is that is already a special case defined in index.php (mod_rewrite)…
I still have problem. Can u help me Filip? I cannot access admin page. Still url isue i think. The main index.php of my jobber is in my folder of my domain.
The page always unvailable.
Can u please check it: www.noelabs.com/jobber/admin.
what should i do with admin’s config.php? I already tried some combinations.
I also try to search in forum and there is somebody who mentioned there is an issue with jQuery . But i don;t have knowledge for this.
And last please give me clue about displaying the stat. I also kinda lost somewhere about this.
Thanx
I have found a little bug in config.php.
I use Windows as my dev webserver. In Windows this:
define(’_APP_MAIN_DIR’,rtrim(dirname($_SERVER[’SCRIPT_NAME’]),’/'));
will return (on the root of virtual host) value ‘\’ and your system won’t work.
So this code must be like:
if (preg_match(”/win/i”, $_ENV[’OS’])) {
define(’_APP_MAIN_DIR’,rtrim(dirname($_SERVER[’SCRIPT_NAME’]),’\\’));
} else {
define(’_APP_MAIN_DIR’,rtrim(dirname($_SERVER[’SCRIPT_NAME’]),’/'));
}
Or if somebody install this scripts on root of VHost you can write:
define(’_APP_MAIN_DIR’,”);
BR
Thanks, Eugene!
Good luck!
Error 500
localhost
02/21/08 19:58:43
Apache/2.0.55 (Win32) mod_ssl/2.0.55 OpenSSL/0.9.8a PHP/5.0.5 mod_autoindex_color
i don’t know what it means.
this in in my browser if i try to start. i installed it as shown in the guide on xampp 1.5.0
Yes @ Eugene.
I still cannot make admin work. (ver 1.3 and 1.4)
Do I have to change the config.php from the admin folder or also with config.php ini root?
Yes i install this jobber in sub-folder of my VH.
www.noelabs.com/jobber
What about the stas? Where is the EXT_PARAM setting ?
@Filip
I think your version 1.4 update stil need a lot of work.
Like not every aspect is covered in translations.ini (e.g. the very top menu, contact form)
And also the CSS is somehow acting strange. The jobber display is not as expected. Im gonna check the CSS lines 1 by 1.
What is the function of the API? Do you want to monitor the jobber instalation?
Thanks
@setiaji,
By the “very top menu” do you mean the job categories tabs? You manage those from the admin panel.
The API allows others to insert a javascript badge on their site and show latest jobs from your site. You can see it in action on “my site”:http://www.filipcte.ro/, right column, first box (”ultimele anunturi de pe jobber”).
This error msg come up after doing everything in install guide;
Parse error: syntax error, unexpected ‘{’ in /home/gabe/domains/have1.com/public_html/dev/werkboard.com/config.php on line 104
Tried the obious with the unexpected ‘{’, but didn’t make a difference
Mike,
This means that PHP 5 is not active on your server.
You should have read all the previous comments, as the problem has already been covered. Also on the forums.
Fatal error: Call to a member function query() on a non-object in /home/stanleys/public_html/job/_includes/class.Job.php on line 851
Help
Hi, I don’t suppose they have an earlier version that works with php 4.4.8 and sql 4.1.22? I can’t migrate right now. Or at least point me in another direction for another possible solution. thanks
Stanley, there seems to be a problem with the database connection. If not and if you’ve emptied the jobs table, also empty job_applications table ;).
Mike, PHP 4 is not supported. You should *really* change your hosting provider… PHP 4 is *so* 2004!
there seems to be a problem with the database connection. If not and if you’ve emptied the jobs table, also empty job_applications table ;).
“how to empty job_applications table?”
phpmyadmin or other database administration tool, of course.
I installed jobbercase and there was no rquest for admin info. When I tried to log on to Admin panel, it asks for username and password; how do I get that? Any help will be appreciated.
I found the answer. It’s default=username: admin. password: admin.
I have the same problem as Stanley, error:
Fatal error: Call to a member function query() on a non-object in /home/.thumper/telemichus/shivantech.com/jobber/_includes/class.Job.php on line 851
Server spec:
PHP5.2.x
No mysqli installed (already replaced the require_once line in config)
Any ideea what it could be wrong ?
Thanks.
[…] kas sniedz augstākminētās prasības, tad ielūkojies JobberBase oficiālajā saitā, un apskati instalācijas un uzstādīšanas […]
[…] kas sniedz augstākminētās prasības, tad ielūkojies JobberBase oficiālajā saitā, un apskati instalācijas un uzstādīšanas […]
I cant log in to the admin section. The script is uploaded correctly and i had to change my .htaccess to get the links to work:
#RewriteEngine on
#Options +FollowSymlinks
#RewriteCond %{REQUEST_FILENAME} !-f
#RewriteCond %{REQUEST_FILENAME} !-d
#RewriteRule . index.php [L]
#ErrorDocument 404 /page-unavailable/
# Alternative .htaccess
# only use if original doesn’t seem to work for you
RewriteEngine On
RewriteBase /jobs/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !index.php
#RewriteRule !\.(js|ico|gif|jpg|png|css|flv|swf)$ index.php
#RewriteRule (.*) /index.php/$1 [L]
RewriteRule !\.(js|css)$ /index.php/$1 [L]
ErrorDocument 404 /page-unavailable/
But i still cant log into the admin section. It says the page is unavailable
Thx
Well, first of all, you can’t have ‘jobs’ as a real folder. Rename it to something else. Or else, you need to go into index.php, find “case ‘jobs’” and change that to something else - then all the references to /jobs/ in the templates… makes any sense?
lol well iv’e changed rewrite base to “RewriteBase /”. But it still says the admin page is unavailble when i try to log in. Hmm it could be a host problem.
I’ve also changed the .htaccess in admin to the same code as above with RewriteBase set to /
I installed the script correctly so it must be a server problem or maybe the .htaccess code is wrong. My host is 000webhost and my website is:
http://footinthedoor.890m.com
I’m trying to test to see if the job board is working for our organisation. The front end works flawlessly, but once you try to go further, ther are problems.
First of all, I can’t see the jobs. It’s linking to a file that doesn’t exist (404 error). I get the same thing when I’m trying to post a job. And I can’t seem to log into the Admin area, even with the login ID above.
What have I missed?
Oh, and is there a way of removing the “Post a Job” button from the front page, and only limit it to the admin area? Or is that not possible?
Thanks in advance.
Nathan
Right, I’ve found my problem, but (in true idiot form) where do I find the Apache settings? I’m using Zymic as a testing ground. I’ve got PHP5, PHPMyAdmin2 and MySQL active, but no idea where to find the Apache settings.
Hello
I would like to report a bug in windows. For I don’t know why, when I extract the downloaded archive jobberbase14.zip with winzip utility I obtain a file named _cache under app/_templates but this should be a FOLDER not a FILE.
Yours,
Amine
Weird… I wonder if others stumpled upon this, too.
Yes filip, i had the same problem with _cache’s folder