phpBB Pagination Error - Help!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Somerset Bob
    #1

    phpBB Pagination Error - Help!

    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=$co unt 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=$co unt 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



    Tags: None
    • Stephen
      #2
      Re: phpBB Pagination Error - Help!

      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:
      [color=blue]
      > 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=$co unt 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=$co unt 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[/color]

        Comment

        • Somerset Bob
          #3
          Re: phpBB Pagination Error - Help!

          "Stephen" <retorq@digital hijinx.com> wrote in message
          news:pan.2004.0 2.15.00.53.45.1 83408@digitalhi jinx.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=$co unt 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=$co unt 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]


            Comment

            Previous template Next
            Working...