boardom Forum Index boardom
b2 message board
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

[SOLVED] Need Help! mysql_fetch_object(): ...

 
Post new topic   Reply to topic    boardom Forum Index -> Template help
View previous topic :: View next topic  
Author Message
SUp3rFM



Joined: 16 Jan 2005
Posts: 2
Location: Lisbon

PostPosted: Sun Jan 16, 2005 10:53 am    Post subject: [SOLVED] Need Help! mysql_fetch_object(): ... Reply with quote

I'm running b2 for quite some time now @ http://blog.magiaontour.com

Yesterday, out of the blue stopped to show up to my visitors. I can see all entries, edit then, create new posts with b2edit.php. Everything looks to be fine.

I've made a check of the mysql db and it came with no errors (using the mysql databases management of Cpanel X). I also looked at it with PHPMyAdmin and they seem clean, with no errors.

I've installed last week the blacklist, smiley hack and upload images. It all went great. Since yesterday, without me messing around or even place a post/comment it stopped to work. I'm getting the following error:

Code:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/magia86/public_html/blog/index.php on line 339


At line 314 of index.php I have this

Code:

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


(you can see the error by simply going to http://blog.magiaontour.com)

Is there a need to post here my index.php?

I've searched the forum for an answer I couldn't find one. Thanks in advance.
_________________
Magia on Tour


Last edited by SUp3rFM on Mon Jan 17, 2005 2:22 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
SUp3rFM



Joined: 16 Jan 2005
Posts: 2
Location: Lisbon

PostPosted: Mon Jan 17, 2005 2:19 pm    Post subject: Reply with quote

SOLVED!

Here's what happened. After reviewing everything, I got to this page about a problema related to comments not showing up... Well, what really helped me out was a link given by Sigg3 - http://www.sigg3.net/cafelog/files/b2_sep_dir.txt

Here's what I changed in b2config.php and REALLY, REALLY solved my problem. As I wrote, I've installed the smileys hack... I forgot something.

Code:

b2config.php - Line 211
$smilies_directory = 'http://mydomain.com/b2-img/smilies';


Change to:
$smilies_directory = 'http://mydomain.com/news/b2-img/smilies';


In my b2config.php I had this:

Code:

$smilies_directory = 'blog/b2-img/smilies';


and changed to

$smilies_directory = 'http://www.magiaontour.com/blog/b2-img/smilies';


That's it!

An incredible slash made me go nuts! Smile
_________________
Magia on Tour
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
Sigg3



Joined: 03 Jul 2003
Posts: 895
Location: Oslo, Norway

PostPosted: Mon Jan 17, 2005 10:50 pm    Post subject: Reply with quote

A slash is all it takes.
An empire for a slash!

(Sorry, I'm really spamming here. It's like a posting-high or something:)
_________________
Sigg3.net - You know you're worth it! | b2 Cafelog Resource Center | Fight my BattleImp!
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    boardom Forum Index -> Template help All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2 © 2001, 2002 phpBB Group