Not showing all posts in forum

[ZeldaFan]

I'm having some problems with the script not showing all the posts in the forum. What I mean by this is that, example, I have 3 posts inside the specified forum (forum id 1), but the script only outputs 2 of them (the earliest 2). The script is set-up to show up to 10 posts, but continues to only show 2. It's not the cache, as that was set to 5 minutes, and I've also tried with no cache.

The URL is http://linkslegends.net/
I'm using phpBB 2.0.15, and the absolute path was detected automatically by the script (which is kinda weird, because the one detected by the script is different than some other scripts I use...nonetheless, I've tried both variances with no luck)
BTW, I did not create a subdirectory for the forum-news script, it's in the root (well...in public_html)

thx in advance!

[Patrick]

Have you tried placing newly generated code onto your page? This might fix the problem.

Also, are any of the posts that you made announcements (or similar) where they are in a special category altogether?

Did you put any post number in when generating the code to place on your site? If you leave that field blank, then the script will automatically use the default post number (rather than hard coding the number into the generated code, which can only be replaced by new generated code)?

Otherwise your only option is to give me FTP details so that I can take a look myself (just PM me if the above does not work). It is probably something fairly simple that we have overlooked.

[ZeldaFan]

Hmm...well, I don't know what happened, but it works now...
Unless u looked at it through my FTP...but according to PMs, u haven't recieved the message yet...I don't no, lol. Maybe the cache just took a long time? I have no clue

Edit: ok, this is screwed up...it's not working again

[Patrick]

I will take a look at it within the next 24 hours. I haven't looked at it yet.

[Patrick]

I need two more things:
1. Can you create another topic in that news category so that I can further debug what is happening.
2. Can you PM me mysql details, including a link to some kind of an administration tool (such as phpMyAdmin)?

[Patrick]

I am sorry, but I just simply cannot find the source of the error.

Here is what I do know:
1. The script is correctly forming the SQL query:

SELECT topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_first_post_id
FROM phpbb_topics
WHERE forum_id = '1'
ORDER BY topic_id DESC 
LIMIT 10

Go ahead and try it yourself, put that into phpMyAdmin as SQL and run it ... it will return the 4 posts that are in your news category.

2. PHP does not appear to be incrementing the internal counter correctly OR PHP is not receiving the correct data back from mysql. This is strange, as we can execute the query ourselves and see that it returns all 4 posts. But when PHP does it, php reports that only two posts are available.

I am unable to duplicate this error on a local machine as well. I tried on both a PHP 4.3.11 / MySQL 4.1 and a PHP 5.0.4 / MySQL 4.1 setup. You are currently running on a slightly older version of PHP and MySQL 4.0. Older versions *could* be your source of the problem, as could be come misconfiguration (not with the forum-news script but with PHP or MySQL).

I doesn't make any sense really. The query does not fail. The query returns only partial results, but the same query from command line or phpMyAdmin returns the correct results.

Maybe is has something to do with the remote host as well? That may be a thought. It is possible that whoever is hosting you has some mysql array setup and it is out of sync. I'll see if I can determine if this is the case.

[Patrick]

It was definitely a host conflict.

The host you were connecting to was out of sync with the host the your forum was on.

To fix the problem, I modified all of the information in the forum-news config file to reflect that of phpBB's config.


This was just a sloppy misconfiguration on the user end. Next time double check your configuration .

[ZeldaFan]

Thanks for everything!

What exactly was the misconfiguration?

[Patrick]

Wrong MySQL information.

[ZeldaFan]

O dang..now i understand XD...I recently switched servers (on the same hosting company [long story])...for some reason the forum was still running off the old database, and the script was running off the "new" one. I wonder how that could have happened, XD

Anyways...thanks again for everything