Oct 23, 2007
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?
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 http://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 http://www.mydomain.com/post/ but there isnt even a “post” directory, or when you click on jobs it tries going to http://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 http://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 http://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 http://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 http://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: http://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