wsn links not installing: WSN Support

Version: 4.1
Example URL: http://www.hostwhois.com

wsn links not installing

PurpleCow
Internet Evangelist

Usergroup: Customer
Joined: Oct 18, 2003
Total Topics: 37
Total Posts: 92

Posted 09/19/07 - 05:08 AM:	#1
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
HostBubble : Web hosting and domain names marketplace Hostology : Articles, Guides, News and more for web hosting industry HumanNodes \| Windows9x \| DeepCrawl \| AdBubble

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6312

Posted 09/19/07 - 09:08 AM:	#2
This means the MySQL user you created isn't allowed access to the database you created. You need to give it 'all' permissions.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

PurpleCow
Internet Evangelist

Usergroup: Customer
Joined: Oct 18, 2003
Total Topics: 37
Total Posts: 92

Posted 09/19/07 - 11:16 PM:	#3
Paul... the db user has all privileges to the db. But i am still getting the same problem? Thanks for any help.
HostBubble : Web hosting and domain names marketplace Hostology : Articles, Guides, News and more for web hosting industry HumanNodes \| Windows9x \| DeepCrawl \| AdBubble

nelgin
Experienced

Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 28
Total Posts: 70

Posted 09/20/07 - 10:45 AM:	#4
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 18, 2003
Total Topics: 37
Total Posts: 92

Posted 09/20/07 - 08:40 PM:	#5
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.
HostBubble : Web hosting and domain names marketplace Hostology : Articles, Guides, News and more for web hosting industry HumanNodes \| Windows9x \| DeepCrawl \| AdBubble

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6312

Posted 09/21/07 - 06:26 AM:	#6
That means you already had a config.php file somehow.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.