- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Topic: Errors after install
I have followed the install instruction and uploaded the Jobbercase script to www.studentbemanning.no. I then got two errors I can`t manage to fix:
Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'stianf'@'localhost' (using password: YES) in /home/studeofx/public_html/_includes/class.Db.php(22) : eval()'d code on line 1
Fatal error: Call to a member function fetch_assoc() on a non-object in /home/studeofx/public_html/_includes/class.Job.php on line 1042
Both are described as comon errors at the bottom of the install guide and should be relatet to database name, user, password etc. But I`we been throug all this several times, but still no fix.
Is there anyone that can see where the problem is?
- Title: rawkstar wannabe
- Status: Offline
- Registered: 2009-01-16
- Posts: 362
Re: Errors after install
i have done more than 10 different installs on diff servers and never had this issue. did u try intalling locally on your pc and get it to work?
will host your job board for you at minimal cost! read more:
http://mim.io/acb992
- Title: Senior Contributor
- Status: Offline
- Registered: 2008-11-13
- Posts: 244
Re: Errors after install
Since it's saying 'Access denied', it's most likely something wrong with the login data you supplied.
I can only suggest to check (or ask) the:
- Database server hostname (not neccesarily localhost)
- Database name (you need to have created a DB or at least uploaded the SQL info at one
- Database login and password
Member of Jobberbase Development Team - Implementation and Coding
Visit my Blog:
ChronoScripts (JobberBase scripts, support and freelance)
JobBoards:
Telefonisch Werk and
Top Bijbaan
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
Thanks for replies.....but still no fix!
I have not tried local install, only on my ISP`s hosting service.
I have (again) checked hostmame, its localhost.
I have also checked my DB, DB login and password, and all ok!
-stianf
- Title: Senior Contributor
- Status: Offline
- Registered: 2008-11-13
- Posts: 244
Re: Errors after install
Hm. Maybe it has to do with using mysqli.. let's try connecting to the database outside of JobberBase. Paste the following code in a new PHP file (and adjust login data) and load it in your browser.
Code:<?php
$username = "";
$password = "";
$hostname = "";
$database = "";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db($database,$dbh)
or die("Could not select database");
mysql_close($dbh);
?>
Also check both your MySQL and PHP version. If those are outdated, they might cause it as well.
Member of Jobberbase Development Team - Implementation and Coding
Visit my Blog:
ChronoScripts (JobberBase scripts, support and freelance)
JobBoards:
Telefonisch Werk and
Top Bijbaan
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
Hi again
Trying this gives me no errors, but the following message:
Connected to MySQL
Could not select database
I guess this means that the DB name, user and password is correct!
I have checked my MySQL and PHP version and they are ok.
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
In my phpMyAdmin I find two databases:
information_schema (17)
studeofx_studentbemanning (13)
I have only made one of these (studeofx_studentbemanning)
My hosting package supports only one database.
Is the DB information_schema related to JobberBase?
Could this be the thing that makes tings wrong?
- Title: Administrator
- Status: Offline
- From: Oradea, Romania
- Registered: 2008-08-20
- Posts: 966
Re: Errors after install
Hi.
Do you have 'studeofx_studentbemanning' in the DB_NAME configuration?
The information_schema database is a mysql internal thing, it has nothing to do with your problem.
Last edited by putypuruty (2009-04-30 08:15:55)
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
Hi
Yes, my DB name is studeofx_studentbemanning and that is what I have in the DB_NAME configuration.
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
When I created the DB I named it studentbemanning and my username xxxxx. But the "system" renames the DB to studeofx_studentbemanning and my user to studeofx_xxxxx, where the studeofx is my hosting username. I guess I`m then supposed to use studeofx_studentbemanning and my user to studeofx_xxxxx in my config file (not only studentbemanning and xxxxx) ?
- Title: Administrator
- Status: Offline
- From: Oradea, Romania
- Registered: 2008-08-20
- Posts: 966
Re: Errors after install
You get the same error message no matter if you use xxxxx/studentbemanning or studeofx_xxxxx/studeofx_studentbemanning? Did you try studeofx/studentbemanning or studeofx/studeofx_studentbemanning?
Could you also post here where are you hosting your site - maybe someone on the forum has experience with them.
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
I have now tired different combinations like studeofx/studentbemanning or studeofx/studeofx_studentbemanning, still the same errors.
My hosting company is www.proisp.no (a Norwegian company / site)
- Title: Administrator
- Status: Offline
- Registered: 2008-08-20
- Posts: 234
Re: Errors after install
Hi,
Are you by any chance using cpanel? If it's so, it's not enough to just create the user and the database, you have to go to Databases-> MySQL Databases, scoll down and you have a section Add User To Database with two dropdowns. You have to choose your user and DB and click add and on the next page you'll have a list of rights to choose for that user.
Hope it helps!
- Title: New member
- Status: Offline
- Registered: 2009-04-28
- Posts: 9
Re: Errors after install
Problem is now solved, thanks to all replies!
I`am using cpanel, and the solution was what "links" suggested.
Posts [ 14 ]
Guest posting is disabled. You must login or register to post a reply.