boardom

prolific · Joined: 28 Sep 2004 Posts: 29

I woke up this morning to find this error on my site. All my hostees have this error but on a different line. I don't understand what could be wrong with it. I tried restoring back ups and that didn't work and I also tried to restore the index.php file and that didn't work either. I also tried looking on here and found a post similar to mine, but that didn't help. Sad

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/addickt/public_html/b2/index.php on line 54

prolific · Joined: 28 Sep 2004 Posts: 29

This is my index.php code.

<?php /* Don't remove this line, it calls the b2 function files ! */ $blog=1; include ("blog.header.php"); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>


<LINK REL=stylesheet HREF="http://addickt3d.net/b2/style.css" TYPE="text/css">

<style type="text/css">
html {
scrollbar-track-color: #694501;
scrollbar-face-color: #694501;
scrollbar-highlight-color: #FFFFFF;
scrollbar-3dlight-color: #694501;
scrollbar-darkshadow-color: #694501;
scrollbar-shadow-color: #FFFFFF;
scrollbar-arrow-color: #986601;
}


</style>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="reply-to" content="<?php bloginfo('admin_email'); ?>" />
<meta http-equiv="imagetoolbar" content="no" />
<meta content="TRUE" name="MSSmartTagsPreventParsing" />

<style type="text/css" media="screen">
@import url( style.css );
</style>
<link rel="stylesheet" type="text/css" media="print" href="print.css" />
<link rel="alternate" type="application/rdf+xml" title="RDF" href="<?php bloginfo('rdf_url'); ?>" />
<link rel="alternate" type="application/rss+xml" title="RSS" href="<?php bloginfo('rss2_url'); ?>" />
<link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />
<?php comments_popup_script() ?>

</head>

<body style="background: transparent">
<body>
<div id="content">


<?php while($row = mysql_fetch_object($result)) { start_b2(); ?>
<br>
<br>

<?php the_date("","<h2>","</h2>"); ?>
<?php permalink_anchor(); ?>
<br>
<div class="storyTitle"><?php the_title(); ?>
</div>
<br>
<div class="storyContent">
<?php the_content(); ?>
<br>
<br>
<span class="storyAuthor"><?php the_author() ?> - @ <?php the_time() ?></a>
<br>
<div class="rightFlush">
<?php link_pages("<br />Pages: ","<br />","number") ?>
<?php comments_popup_link("get hooked? (0)", " fiends(1)", " can't get enough(%)") ?>

<?php trackback_rdf() ?>


<?php include ("b2comments.php"); ?>

</div>

</div>

<!-- // this is just the end of the motor - don't touch that line either Smile

-->
<?php } ?>

</div>

<div align="right">[powered by <a href="http://cafelog.com" target="_blank"><b>b2</b></a>.]<br />

</body>
</html>

Sigg3 · Joined: 03 Jul 2003 Posts: 898 Location: Oslo, Norway

Might have to do with your double body:
<body style="background: transparent">
<body>

...not sure, tho. Seems like a db issue.
_________________
Sigg3.net - You know you're worth it! | b2 Cafelog Resource Center | Fight my BattleImp!

prolific · Joined: 28 Sep 2004 Posts: 29

prolific · Joined: 28 Sep 2004 Posts: 29

I removed the body code but that still didn't help, but thanks for the suggestion.

Sigg3 · Joined: 03 Jul 2003 Posts: 898 Location: Oslo, Norway

Stevem, you have any idea?
_________________
Sigg3.net - You know you're worth it! | b2 Cafelog Resource Center | Fight my BattleImp!

sh0ck · Joined: 02 May 2004 Posts: 50 Location: Norway

is blog.header.php in the same folder as index.php? This has nothing to do with HTML code, but PHP (prolly the b2 engine).
_________________
http://www.licklinux.com

stevem · Joined: 15 Mar 2003 Posts: 365

Given that nothing else has changed I would look at the databases as the warning tells you PHP is not getting any information from them. Have they got corrupted - use phpMyAdmin to look at them and it should tell you if there any errors. If it's a corrupted form then use

prolific · Joined: 28 Sep 2004 Posts: 29

Thanks to everyone that replied.

stevem's solution did help me. Very Happy

quiet-storm · Joined: 09 Aug 2004 Posts: 10

i'm getting the same type error:

Sigg3 · Joined: 03 Jul 2003 Posts: 898 Location: Oslo, Norway

You have seperate table prefixes, I imagine?
_________________
Sigg3.net - You know you're worth it! | b2 Cafelog Resource Center | Fight my BattleImp!

quiet-storm · Joined: 09 Aug 2004 Posts: 10

yes i do. i've had 2 running on 1 database for at least a month now with no problem.