| re: phpBB Pagination Error - Help!
"Stephen" <retorq@digitalhijinx.com> wrote in message
news:pan.2004.02.15.00.53.45.183408@digitalhijinx. com...[color=blue]
> 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.[/color]
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
[color=blue]
> On Sat, 14 Feb 2004 12:29:51 +0000, Somerset Bob wrote:
>[color=green]
> > I've got pagination errors in a phpBB board. Some forums are showing[/color][/color]
"page 1[color=blue][color=green]
> > 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![/color][/color]
I've[color=blue][color=green]
> > tried copying and pasting the uncommented lines into the "queries" box[/color][/color]
in[color=blue][color=green]
> > phpMyAdmin, but I get syntax error messages back which I can't fathom.[/color][/color]
(I'm[color=blue][color=green]
> > 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[/color][/color]
be[color=blue][color=green]
> > most grateful. I've been trying since the middle of December to fix it!
> >
> > Thanks in advance[/color]
>[/color]
| 
