Webmastersite.net
Register Log In

wsn links not installing
v4.1

Comments on wsn links not installing

PurpleCow
Internet Evangelist

Usergroup: Customer
Joined: Oct 19, 2003

Total Topics: 43
Total Comments: 103
Posted Sep 19, 2007 - 8:08 AM:

Hi,

I am installing v4.1, but getting warning messages.

Check the url http://www.hostwhois.com for the exact warning message.

Here is the warning message...


Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /path/to/databases/mysqli.php on line 21

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /path/to/databases/mysqli.php on line 18

Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /path/to/databases/mysqli.php on line 21
Cannot extract data from the database.
It seems that although we established a database connection we aren't able to access the database itself. It could be that the database is down (ask your web host about this), or that the mysql user doesn't have proper permissions to acces the database. MySQL returns this error: Table 'hostwhoi_locate.wsnlinks410_membergroups' doesn't exist

WSN Links 4.1.0


Pls help
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 19, 2007 - 12:08 PM:

This means the MySQL user you created isn't allowed access to the database you created. You need to give it 'all' permissions.
PurpleCow
Internet Evangelist

Usergroup: Customer
Joined: Oct 19, 2003

Total Topics: 43
Total Comments: 103
Posted Sep 20, 2007 - 2:16 AM:

Paul... the db user has all privileges to the db.
But i am still getting the same problem?

Thanks for any help.
nelgin


Usergroup: Customer
Joined: Jul 17, 2003

Total Topics: 39
Total Comments: 100
nelgin
Posted Sep 20, 2007 - 1:45 PM:

Do you have other scripts that access the mysql database correctly? Not sure if wsnlinks only uses the network method, if so check /etc/my.cnf and comment out

skip-networking

and restart mysql.


PurpleCow
Internet Evangelist

Usergroup: Customer
Joined: Oct 19, 2003

Total Topics: 43
Total Comments: 103
Posted Sep 20, 2007 - 11:40 PM:

Okay, it's working fine now. I have installed it and testing out the various features and wills tart customisation in a few days time.

Well, while installing, i should have pointed to setup.php, but instead, just pointed to my root '/' which caused those errors.

Thanks everyone who helped me here.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 21, 2007 - 9:26 AM:

That means you already had a config.php file somehow.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.