unkn0wndj Posted March 8, 2006 Share Posted March 8, 2006 My site was running fine until i switched hosts now its displaying [code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 12Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 17query failed : select count(*) as online from login_online where status=1 and last_visit > subdate(now(), Interval 30 MINUTE) order by last_visit desc[/code]Here is line 12 and 17[code] Line 12$countnew = mysql_num_rows(mysql_query("select * from members where adv_approved=0")); Line 17$result = mysql_query("select adv_picture,adv_approved,adv_rejectreason,adv_picture2,adv_picture3,adv_picture4,adv_picture5,adv_picture6,adv_picture7,suspend from members where mem_userid='$Sess_UserId'");$pic = mysql_fetch_row($result); [/code]Please help Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/ Share on other sites More sharing options...
corbin Posted March 8, 2006 Share Posted March 8, 2006 You transfered all you MySQL tables over and stuff didnt you? Same names and everything? Dont forget to change the MySQL host/username/pass to match your new ones. Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-15602 Share on other sites More sharing options...
unkn0wndj Posted March 9, 2006 Author Share Posted March 9, 2006 yea now that problem is fixed but theres a few other little ones from transferring.. can anyone help me lol Ill give you a godaddy domain for some help. Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-15660 Share on other sites More sharing options...
txmedic03 Posted March 9, 2006 Share Posted March 9, 2006 lol I'll do what I can to help if you let me know what the situation is. Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-15699 Share on other sites More sharing options...
unkn0wndj Posted March 9, 2006 Author Share Posted March 9, 2006 [!--quoteo(post=353172:date=Mar 9 2006, 02:06 AM:name=txmedic03)--][div class=\'quotetop\']QUOTE(txmedic03 @ Mar 9 2006, 02:06 AM) [snapback]353172[/snapback][/div][div class=\'quotemain\'][!--quotec--]lol I'll do what I can to help if you let me know what the situation is.[/quote]check out [a href=\"http://nowiby.com\" target=\"_blank\"]http://nowiby.com[/a] .. there are a few errors here and there Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-15947 Share on other sites More sharing options...
unkn0wndj Posted March 10, 2006 Author Share Posted March 10, 2006 bump Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-16030 Share on other sites More sharing options...
AV1611 Posted March 10, 2006 Share Posted March 10, 2006 Question 1:Did you just move from a Windows based server to a Linux based server?If you did, you will find that Windows doesn't care about CaPiToLs in URL's, but Linux DOES!I had to convert a TON of scripts when I made the switch recently.It also look like when you got to the formums, you get this message:[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: main(includes/queries.php): failed to open stream: No such file or directory in /home/vhosts/www.nowiby.com/forums/index.php on line 8Warning: main(): Failed opening 'includes/queries.php' for inclusion (include_path='.:/usr/share/pear') in /home/vhosts/www.nowiby.com/forums/index.php on line 8[/quote]which I take as you have not properly corrected you URL mappings in your scripts to match your new server URL's...If I could see a couple of lines of code, maybe includes/queries.php and index.php??? Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-16176 Share on other sites More sharing options...
unkn0wndj Posted March 10, 2006 Author Share Posted March 10, 2006 [!--quoteo(post=353669:date=Mar 10 2006, 12:53 PM:name=AV1611)--][div class=\'quotetop\']QUOTE(AV1611 @ Mar 10 2006, 12:53 PM) [snapback]353669[/snapback][/div][div class=\'quotemain\'][!--quotec--]Question 1:Did you just move from a Windows based server to a Linux based server?If you did, you will find that Windows doesn't care about CaPiToLs in URL's, but Linux DOES!I had to convert a TON of scripts when I made the switch recently.It also look like when you got to the formums, you get this message:which I take as you have not properly corrected you URL mappings in your scripts to match your new server URL's...If I could see a couple of lines of code, maybe includes/queries.php and index.php???[/quote] Sure do you have an IM program for us to talk? Quote Link to comment https://forums.phpfreaks.com/topic/4479-changing-hosts/#findComment-16233 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.