stianf

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?

redjumpsuit

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

Chronos

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

stianf

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

Chronos

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

stianf

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.

stianf

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?

putypuruty

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)

stianf

Re: Errors after install

Hi

Yes, my DB name is studeofx_studentbemanning and that is what I have in the DB_NAME configuration.

stianf

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) ?

putypuruty

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.

stianf

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)

links

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!

stianf

Re: Errors after install

Problem is now solved, thanks to all replies!
I`am using cpanel, and the solution was what "links" suggested.