By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,290 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,290 IT Pros & Developers. It's quick & easy.

phpBB Pagination Error - Help!

P: n/a
I've got pagination errors in a phpBB board. Some forums are showing "page 1
of 0". Previous enquiries both here and at the phpBB forum have given me
half-answers, the latest of which contained this advice:

For each forum in phpbb_forums:

-) Get the number of posts that belong to a forum from phpbb_posts
select count(*) as count from phpbb_posts where forum_id=$forum_id
update phpbb_forums set forum_posts=$count where forum_id=$forum_id
-) Get the number of topics that belong to a forum from phpbb_topics
select count(*) as count from phpbb_topics where forum_id=$forum_id
update phpbb_forums set forum_posts=$count where forum_id=$forum_id

I understand that I have to enter some of this code into phpMyAdmin to
correct the error in the MySQL database - but I don't understand how! I've
tried copying and pasting the uncommented lines into the "queries" box in
phpMyAdmin, but I get syntax error messages back which I can't fathom. (I'm
not even sure whether I'm entering them into the right place.)

I'm running:

phpBB 2.0.6
phpMyAdmin 2.5.4

My ISP is running:
MySQL 4.0.15a
php 4.3.2

If anyone can provide an "idiot's guide" to correcting this problem I'd be
most grateful. I've been trying since the middle of December to fix it!

Thanks in advance

Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sounds like you need to go back through your hacks and see which hacks
modified any of that post count routines. Also ask over at PHPBBHacks,
some of the guys at PHPBB are rude and don't want to admit problems with
their code.

On Sat, 14 Feb 2004 12:29:51 +0000, Somerset Bob wrote:
I've got pagination errors in a phpBB board. Some forums are showing "page 1
of 0". Previous enquiries both here and at the phpBB forum have given me
half-answers, the latest of which contained this advice:

For each forum in phpbb_forums:

-) Get the number of posts that belong to a forum from phpbb_posts
select count(*) as count from phpbb_posts where forum_id=$forum_id
update phpbb_forums set forum_posts=$count where forum_id=$forum_id
-) Get the number of topics that belong to a forum from phpbb_topics
select count(*) as count from phpbb_topics where forum_id=$forum_id
update phpbb_forums set forum_posts=$count where forum_id=$forum_id

I understand that I have to enter some of this code into phpMyAdmin to
correct the error in the MySQL database - but I don't understand how! I've
tried copying and pasting the uncommented lines into the "queries" box in
phpMyAdmin, but I get syntax error messages back which I can't fathom. (I'm
not even sure whether I'm entering them into the right place.)

I'm running:

phpBB 2.0.6
phpMyAdmin 2.5.4

My ISP is running:
MySQL 4.0.15a
php 4.3.2

If anyone can provide an "idiot's guide" to correcting this problem I'd be
most grateful. I've been trying since the middle of December to fix it!

Thanks in advance


Jul 17 '05 #2

P: n/a
"Stephen" <re****@digitalhijinx.com> wrote in message
news:pa****************************@digitalhijinx. com...
Sounds like you need to go back through your hacks and see which hacks
modified any of that post count routines. Also ask over at PHPBBHacks,
some of the guys at PHPBB are rude and don't want to admit problems with
their code.
Thanks, Stephen -

It was doing it since before I added any MODs. I've posted my query at the
phpBBHacks forum and the one reply so far has suggested I use the "Resynch"
option for each affected forum in the MCP - I'd already tried that right at
the start of the problem, but it didn't cure it. I tried it again today, and
it still has no effect.

I thought I might try moving the posts out of the affected forums, deleting
the forums, re-creating them and moving the posts back into them again. If I
don't get any help using the phpMyAdmin interface, I guess that'll be my
next (desperate) move.

Somerset Bob
On Sat, 14 Feb 2004 12:29:51 +0000, Somerset Bob wrote:
I've got pagination errors in a phpBB board. Some forums are showing "page 1 of 0". Previous enquiries both here and at the phpBB forum have given me
half-answers, the latest of which contained this advice:

For each forum in phpbb_forums:

-) Get the number of posts that belong to a forum from phpbb_posts
select count(*) as count from phpbb_posts where forum_id=$forum_id
update phpbb_forums set forum_posts=$count where forum_id=$forum_id
-) Get the number of topics that belong to a forum from phpbb_topics
select count(*) as count from phpbb_topics where forum_id=$forum_id
update phpbb_forums set forum_posts=$count where forum_id=$forum_id

I understand that I have to enter some of this code into phpMyAdmin to
correct the error in the MySQL database - but I don't understand how! I've tried copying and pasting the uncommented lines into the "queries" box in phpMyAdmin, but I get syntax error messages back which I can't fathom. (I'm not even sure whether I'm entering them into the right place.)

I'm running:

phpBB 2.0.6
phpMyAdmin 2.5.4

My ISP is running:
MySQL 4.0.15a
php 4.3.2

If anyone can provide an "idiot's guide" to correcting this problem I'd be most grateful. I've been trying since the middle of December to fix it!

Thanks in advance

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.