kaz Posted August 7, 2005 Share Posted August 7, 2005 Its a script that displays all referers and all people who have visited your site from where, including search engines, its miles better than the awfull 300 latest visitors that cpanel gives, it displays them in simple format, and it takes 10 seconds to install one mysql table, the problem is, that I cant install it, can someone do this? Ive attached the file Refer.zip Quote Link to comment Share on other sites More sharing options...
TCH-Thomas Posted August 7, 2005 Share Posted August 7, 2005 There seems to be some installation instructions a bit down on this page. Have you tried them? Quote Link to comment Share on other sites More sharing options...
TCH-Rob Posted August 8, 2005 Share Posted August 8, 2005 I installed it following the instructions on the page Thomas gave the link to. What problems are you having when trying to install it? Quote Link to comment Share on other sites More sharing options...
carbonize Posted August 8, 2005 Share Posted August 8, 2005 I stopped paying attention to referers that much due to the fact that spammers are sending fake referers in requests to sites in the hope that the site is showing a list of referers somewhere. Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 I installed it following the instructions on the page Thomas gave the link to. What problems are you having when trying to install it? <{POST_SNAPBACK}> Please can you do it for me? The problem is I get a MySQL error when trying to install it Very Strange as my details are correct ive doubled and trebble checked I stopped paying attention to referers that much due to the fact that spammers are sending fake referers in requests to sites in the hope that the site is showing a list of referers somewhere. <{POST_SNAPBACK}> Erm .. say what? Quote Link to comment Share on other sites More sharing options...
marie b. Posted August 9, 2005 Share Posted August 9, 2005 What is the error? That script should only take a couple seconds to install. Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 What is the error? That script should only take a couple seconds to install. <{POST_SNAPBACK}> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/deathea/public_html/setupdb.php on line 48 Warning: in_array(): Wrong datatype for second argument in /home/deathea/public_html/setupdb.php on line 52 could not create table refer2 Quote Link to comment Share on other sites More sharing options...
marie b. Posted August 9, 2005 Share Posted August 9, 2005 Are you sure that your database information (including permissions) is correct and correctly entered in refer.php? I just set this up on another of my domains in the last few minutes, and it works perfectly. Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 All details I have entered are correct, permissions? There should be nothing to do with permissions im the webmaster I have permission over everything. I used a MySQL creation database from CPanel Quote Link to comment Share on other sites More sharing options...
marie b. Posted August 9, 2005 Share Posted August 9, 2005 You must add permissions for each user when you create a new database. You should have a user and a database, with permissions (usually 'ALL') set between the two. Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 Dont know what you mean nor how to do this Quote Link to comment Share on other sites More sharing options...
marie b. Posted August 9, 2005 Share Posted August 9, 2005 Go to the place where you created your MySQL databse. At the bottom, there's a place to create a user ID and to assign permissions to a database. Select the User ID and the database, then click the ALL box. Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 I created a new user with permissions to all on the refer database and updated my config but still get Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/deathea/public_html/setupdb.php on line 48 Warning: in_array(): Wrong datatype for second argument in /home/deathea/public_html/setupdb.php on line 52 could not create table refer1 Quote Link to comment Share on other sites More sharing options...
carbonize Posted August 9, 2005 Share Posted August 9, 2005 Please can you do it for me? The problem is I get a MySQL error when trying to install it Very Strange as my details are correct ive doubled and trebble checkedErm .. say what? <{POST_SNAPBACK}> What I mean is that spammers are sending requests to your site for webpages and putting in a fake referer in the hope that you have a publically available list of refers Quote Link to comment Share on other sites More sharing options...
marie b. Posted August 9, 2005 Share Posted August 9, 2005 I'm trying everything to see if I can re-create that error, and I'm just not getting anything. I've no idea. Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted August 9, 2005 Share Posted August 9, 2005 When you enter the database name and database user are you entering it as: yourcpanelname_databasename and yourcpanelname_username? Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 (edited) When you enter the database name and database user are you entering it as: yourcpanelname_databasename and yourcpanelname_username? <{POST_SNAPBACK}> Yes, my cpanel name is "deathea" My code is (for the file refer.php) Never mind done it!!!!!!! thanks everyone the problem was I had $dbname='somethinghere '; and I had a space after the name, it should be "dbname" not "dbname " Edited August 9, 2005 by kaz Quote Link to comment Share on other sites More sharing options...
kaz Posted August 9, 2005 Author Share Posted August 9, 2005 Wait Im getting this error in refer.php Fatal error: Cannot redeclare rcfg() (previously declared in /home/deathea/public_html/refer.php:22) in /home/deathea/public_html/refer.php on line 17 Line 17 Reads function rcfg() and line 22 reads >[I]$rcfg['usr'] = 'deathea_superman'; [/I] //line 22 $rcfg['pw'] = 'xxxxxxxxx'; $rcfg['host'] = 'localhost'; $rcfg['db'] = 'deathea_oicaracta'; $rcfg['table'] = 'referdata'; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.