Take a look at the CSS classes rowodd and roweven

2,702

(5 replies, posted in PunBB 1.2 troubleshooting)

Don't use the directions on the wiki, they also are very inefficent

DanKelly: this topic is from 2004, before the current version of PunBB ever came out. Thus, all the styles being discussed aren't relevant wink

2,704

(5 replies, posted in PunBB 1.2 troubleshooting)

Nope, I'm from the US wink

2,705

(5 replies, posted in PunBB 1.2 troubleshooting)

index.php
FIND

<?php echo $forum_field."\n".$moderators ?>

REPLACE WITH

<?php echo $forum_field ?>

I'm unsure: it could be, potentially

I don't know what to tell you, posts don't randomly shift their topics. smile

Not directly
http://punbb.org/docs/faq.html#faq3_4

2,709

(30 replies, posted in PunBB 1.2 discussion)

You might want to look at this
http://us2.php.net/manual/en/function.gethostbyaddr.php

Where were those posts originally?

I still think the plugin, if done properly, is the way to go, since it removes the chance of human error (and is less work) smile

http://punbb.org/forums/viewtopic.php?id=9146

The search indexing errors are usually caused by an incomplete conversion to UTF-8. I would search the forums and see if anyone mentions something you may have missed.

I saw the issue in one forum, but me making a post/deleting it fixed it
I think your issue is that when you make a post and get the search indexing error, update_forum isn't called.

Hmm, could you link to your forum?

Are you making topics/posts through post.php?

2,717

(9 replies, posted in PunBB 1.2 troubleshooting)

I would run an EXPLAIN on the query and see if anything looks wrong with it. If not, I would guess that the issue is with the MySQL server

Well, you would just run the queries that are inserts to the posts table for this user's posts.

With the post count, do you mean that the count itself is simply incorrect and that their actual posts all still remain in tact?

Yes, the count is not calculated every time based on the number of posts in the database. It is simply incremented when a user makes a post. Since your backup is somewhat old, the users have whatever post count they had when the backup was taken

Added back the two missing users. Interestingly, on the face of it, their old posts (going back to when the forum first went live) and their most recent all appear to be there, yet their post count would reflect otherwise, so it would seem that some posts have gone missing - but this doesnt worry me too much.

Their post count is stored in the users table, so what you see of it reflects how old the backup is

The prob is, I cant find any posts within SQL made by him - which is whats confusing me if I can see his posts in the backup.

He deleted his posts in your forum. Unless you restore his posts from the backup, you won't see the posts, because they don't exist anymore.

2,721

(1 replies, posted in PunBB 1.2 discussion)

Moved to PunBB Discussion

Well, as you can imagine it didn't work quite right.  The topics were moved, but the pagination wasn't calculated correctly.

That should work perfectly fine, other than update_forum not being run: what exactly was the issue?
Edit: Aha, I assume you mean the viewforum.php pagination. As Elbekko said, getting update_forum to run should fix the issue smile

INSERT INTO `punbb_users`
VALUES ( 5, 4, 'Dandy', '', 'goldieXXXXnd@btinternet.com', 'Got Ears?', NULL , NULL , NULL , NULL , 'goldiethelXXXXgend@hotmail.com', NULL , NULL , 'Seat BB105, Upper Deck, Dick D', 0, 'Hate is baggage. Life''s too short to be pissed off all the time.', NULL , NULL , 1, 1, 0, 1, 1, 1, 1, 1, 1, 'English', 'Oxygen', 826, 1150221176, 1123433477, '0.0.0.0', 1150229329, NULL , NULL , NULL, 0, NULL, 1, 1) ;

Tell me when you do it so I can remove the password hash wink

Basically, you had 4 new columns. I just added values for them to the end of the query. (0, NULL, 1, 1)

Indeed
Run

describe punbb_users

and I'll see if I can figure out what's missing/what goes where wink

OK, look for the lines that start
INSERT INTO `punbb_users`
and have the missing usernames in them. There should be two of them. Run those two queries.