Jump to content


Photo

Changing Hosts


  • Please log in to reply
7 replies to this topic

#1 unkn0wndj

unkn0wndj
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 08 March 2006 - 10:54 PM

My site was running fine until i switched hosts now its displaying

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 12

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 17
query failed : select count(*) as online from login_online where status=1 and last_visit > subdate(now(), Interval 30 MINUTE) order by last_visit desc

Here is line 12 and 17

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

Please help

#2 corbin

corbin
  • Staff Alumni
  • Advanced Member
  • 8,129 posts

Posted 08 March 2006 - 11:28 PM

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.
Why doesn't anyone ever say hi, hey, or whad up world?

#3 unkn0wndj

unkn0wndj
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 09 March 2006 - 03:57 AM

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.

#4 txmedic03

txmedic03
  • Members
  • PipPipPip
  • Advanced Member
  • 313 posts
  • LocationCall, TX, USA

Posted 09 March 2006 - 07:06 AM

lol I'll do what I can to help if you let me know what the situation is.

SEMPER FIDELIS!

I can't stop you from doing something silly, but at least I can help you do it right.


#5 unkn0wndj

unkn0wndj
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 09 March 2006 - 11:28 PM

[!--quoteo(post=353172:date=Mar 9 2006, 02:06 AM:name=txmedic03)--][div class=\'quotetop\']QUOTE(txmedic03 @ Mar 9 2006, 02:06 AM) View Post[/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

#6 unkn0wndj

unkn0wndj
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 10 March 2006 - 03:52 AM

bump

#7 AV1611

AV1611
  • Members
  • PipPipPip
  • Advanced Member
  • 997 posts

Posted 10 March 2006 - 05:53 PM

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 8

Warning: 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???

#8 unkn0wndj

unkn0wndj
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 10 March 2006 - 09:28 PM

[!--quoteo(post=353669:date=Mar 10 2006, 12:53 PM:name=AV1611)--][div class=\'quotetop\']QUOTE(AV1611 @ Mar 10 2006, 12:53 PM) View Post[/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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users