Jump to content

Archived

This topic is now archived and is closed to further replies.

unkn0wndj

Changing Hosts

Recommended Posts

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 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[/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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
lol I'll do what I can to help if you let me know what the situation is.

Share this post


Link to post
Share on other sites
[!--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

Share this post


Link to post
Share on other sites
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???

Share this post


Link to post
Share on other sites
[!--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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.