tatesjourney

Topic: I really just want to pay someone to install this for me

I have been at this installation for 12 hours plus trying different things and nothing is working. my installation is in a subfolder called "jobs" and my config.evns.php looks like this:

// live (http://www.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'example.com',
    'db_host' => 'www.tatesjourney.com',
    'db_port' => 3306,
    'db_user' => 'XXXX',
    'db_password' => 'XXXX',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    'app_url' => 'http://www.tatesjourney.com/jobs/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'on',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'apache_mod_rewrite'
);

but I keep getting the error messages:

Warning: mysqli::mysqli() expects parameter 5 to be long, string given in /hermes/bosweb/web281/b2810/sl.moses3815/public_html/jobs/_includes/class.Db.php on line 20

Warning: mysqli::query() [mysqli.query]: Couldn't fetch Db in /hermes/bosweb/web281/b2810/sl.moses3815/public_html/jobs/_includes/class.Db.php on line 72

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in /hermes/bosweb/web281/b2810/sl.moses3815/public_html/jobs/_includes/class.Db.php on line 73

Warning: mysqli::query() [mysqli.query]: Couldn't fetch Db in /hermes/bosweb/web281/b2810/sl.moses3815/public_html/jobs/_includes/class.Db.php on line 31

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in /hermes/bosweb/web281/b2810/sl.moses3815/public_html/jobs/_includes/class.Db.php on line 32

Fatal error: Call to a member function fetch_assoc() on a non-object in /hermes/bosweb/web281/b2810/sl.moses3815/public_html/jobs/_includes/class.JobberSettings.php on line 23
what am doing wrong? I would really appreciate some help. Thanks in advance.

filipcte

Re: I really just want to pay someone to install this for me

'prefix' should match a part of your actual domain name. in this case, I recommend you set:
'prefix' => 'tatesjourney.com'

Original jobberBase author
www.filipcte.com

tatesjourney

Re: I really just want to pay someone to install this for me

thanks filipcte, but I tried that and it didn't work either. How much would it cost to have this installed for me? I just really want this up and running as soon as possible. I have uploaded all the files as instructed, I am just stuck at this error message which I cannot figure out.  thanks

putypuruty

Re: I really just want to pay someone to install this for me

I see you've fixed the problem meanwhile - if you want, you can post here the solution as it might help other users.

tatesjourney

Re: I really just want to pay someone to install this for me

Ok, I contacted my host and got more information about my server. That was the issue. I had the wrong input at:  'db_host' => 'www.tatesjourney.com', instead of the db_host name of my actual server which is something like yoursername.hostingcompanymysql.com  that was the issue preventing me from accessing the site at: tatesjourney.com/jobs but I cannot access the admin page to make any changes to the layout etc. I am getting a 404 error message when I try to access tatesjourney.com/jobs/admin. can someone help please?

putypuruty

Re: I really just want to pay someone to install this for me

I think that your problem is .htaccess related. Open the admin .htaccess and add the line

Code:
RewriteBase /jobs/admin

I think it should work now.

tatesjourney

Re: I really just want to pay someone to install this for me

putypuruty, thanks, I tried that but it didn't work. My .htaccess file looks like this:

RewriteEngine on
Options +FollowSymlinks

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . index.php [L]
RewriteBase /jobs/admin

ErrorDocument 404 /page-unavailable/

putypuruty

Re: I really just want to pay someone to install this for me

Are you absolutely sure that the .htaccess file got uploaded into the admin folder? Sometimes, Filezilla and similar applications mess things up and they don't actually upload the .htaccess file.

If you did upload the file, I'd need access to the code running on your site so that I can debug the problem. If you think that you can grant me temporary FTP access, then just write me an email from here http://www.jobberbase.com/forum/email19.html

tatesjourney

Re: I really just want to pay someone to install this for me

Putypuruty,

thanks. yes, I double checked to make sure the file was there via core-ft and can also access it through dreamweaver so it's there. I am sending you my ftp info for temp access so you can see for yourself. thanks

putypuruty

Re: I really just want to pay someone to install this for me

Fixed offline - the problem was caused by the fact that the admin folder had a 777 permission and I assume that Apache did not serve it for security reasons. Setting the folder permission to 755 fixed the problem.

tatesjourney

Re: I really just want to pay someone to install this for me

Thank you Putypuruty for taking the time out of your day to fix that for me. I cannot thank you enough. I will configure it and hopefully have the job section of my page running soon: http://www.tatesjourney.com. P.S is there a way to make people have to pay a small fee to post jobs?

netvalue

Re: I really just want to pay someone to install this for me

Hi

Greetings. I have installed jobberbase but getting error:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'DB_HOST' (1) in /home/content/24/7346824/html/_includes/class.Db.MySql.php on line 31

Fatal error: Uncaught exception 'Exception' with message 'Cannot connect' in /home/content/24/7346824/html/_includes/class.Db.MySql.php:42 Stack trace: #0 /home/content/24/7346824/html/_config/config.php(61): Db->__construct('DB_HOST', 'DB_USER', 'DB_PASS', 'DB_NAME', 'DB_PORT') #1 /home/content/24/7346824/html/index.php(16): require_once('/home/content/2...') #2 {main} thrown in /home/content/24/7346824/html/_includes/class.Db.MySql.php on line 42

These 2 errors. Appreciate if you have any quick fix or small bugs out there to be corrected. Actually I have installed it but getting the errors like the above which needs to be fixed.

Thanks

links

Re: I really just want to pay someone to install this for me

@netvalue

Could you paste here the $__instances['live'] values from your config/config.envs.php file? Don't forget to remove the DB password wink

netvalue

Re: I really just want to pay someone to install this for me

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'mydbname.db.7346824.hostedresource.com' (1) in /home/ftpusername/public_html/_includes/class.Db.MySql.php on line 31

Fatal error: Uncaught exception 'Exception' with message 'Cannot connect' in /home/ftpusername/public_html/_includes/class.Db.MySql.php:42 Stack trace: #0 /home/ftpusername/public_html/_config/config.php(61): Db->__construct('db name....', 'myusername', 'mypassword', 'mydbname', 3306) #1 /home/myhostusername/public_html/index.php(16): require_once('/home/ftpusername/...') #2 {main} thrown in /home/myhostusername/public_html/_includes/class.Db.MySql.php on line 42

I'm getting the above error after migrating to a different host. Actually the code was perfectly working earlier on my previous host. Just if you can help me out, I will keep trying to fix these bugs soon.

Thanks

Last edited by netvalue (2011-03-20 18:21:42)

putypuruty

Re: I really just want to pay someone to install this for me

You must change the db_host to the correct one for your new hosting because I assume that 'mydbname.db.7346824.hostedresource.com' is your old host.