Take a look at the CSS classes rowodd and roweven
2,701 2007-06-23 00:34
Re: How can I change (alternate) backround colour of every other post? (2 replies, posted in PunBB 1.2 discussion)
2,702 2007-06-23 00:33
Re: Last Post Help (5 replies, posted in PunBB 1.2 troubleshooting)
Don't use the directions on the wiki, they also are very inefficent
2,703 2007-06-22 23:39
Re: What theme you using? (16 replies, posted in PunBB 1.2 modifications, plugins and integrations)
DanKelly: this topic is from 2004, before the current version of PunBB ever came out. Thus, all the styles being discussed aren't relevant
2,704 2007-06-22 22:15
Re: Punbb Problem? Need Help (5 replies, posted in PunBB 1.2 troubleshooting)
Nope, I'm from the US
2,705 2007-06-22 22:10
Re: Punbb Problem? Need Help (5 replies, posted in PunBB 1.2 troubleshooting)
index.php
FIND
<?php echo $forum_field."\n".$moderators ?>
REPLACE WITH
<?php echo $forum_field ?>
2,706 2007-06-22 21:13
Re: Posting a new topic appends random posts to the new thread! Eek! (7 replies, posted in PunBB 1.2 troubleshooting)
I'm unsure: it could be, potentially
2,707 2007-06-22 21:08
Re: Posting a new topic appends random posts to the new thread! Eek! (7 replies, posted in PunBB 1.2 troubleshooting)
I don't know what to tell you, posts don't randomly shift their topics.
2,708 2007-06-22 19:14
Re: php in main.tpl (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Not directly
http://punbb.org/docs/faq.html#faq3_4
2,709 2007-06-22 19:12
Re: Banning TLD's, like .ru? (30 replies, posted in PunBB 1.2 discussion)
You might want to look at this
http://us2.php.net/manual/en/function.gethostbyaddr.php
2,710 2007-06-22 19:11
Re: Posting a new topic appends random posts to the new thread! Eek! (7 replies, posted in PunBB 1.2 troubleshooting)
Where were those posts originally?
2,711 2007-06-22 17:44
Re: How To Move All Topics From One Forum To Another ? (15 replies, posted in PunBB 1.2 troubleshooting)
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)
2,712 2007-06-22 14:38
Re: Some new topics not displayed on index page (12 replies, posted in PunBB 1.2 troubleshooting)
2,713 2007-06-22 14:27
Re: Some new topics not displayed on index page (12 replies, posted in PunBB 1.2 troubleshooting)
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.
2,714 2007-06-22 14:23
Re: Some new topics not displayed on index page (12 replies, posted in PunBB 1.2 troubleshooting)
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.
2,715 2007-06-22 13:54
Re: Some new topics not displayed on index page (12 replies, posted in PunBB 1.2 troubleshooting)
Hmm, could you link to your forum?
2,716 2007-06-22 13:26
Re: Some new topics not displayed on index page (12 replies, posted in PunBB 1.2 troubleshooting)
Are you making topics/posts through post.php?
2,717 2007-06-22 13:25
Re: Slow query on new forum 1.2.15 (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
2,718 2007-06-22 12:08
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Well, you would just run the queries that are inserts to the posts table for this user's posts.
2,719 2007-06-22 11:44
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
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
2,720 2007-06-22 11:13
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
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 2007-06-22 11:11
Re: [1.3] the API - information needed (1 replies, posted in PunBB 1.2 discussion)
Moved to PunBB Discussion
2,722 2007-06-21 22:31
Re: How To Move All Topics From One Forum To Another ? (15 replies, posted in PunBB 1.2 troubleshooting)
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
2,723 2007-06-21 19:43
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
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
Basically, you had 4 new columns. I just added values for them to the end of the query. (0, NULL, 1, 1)
2,724 2007-06-21 19:22
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Indeed
Run
describe punbb_users
and I'll see if I can figure out what's missing/what goes where
2,725 2007-06-21 18:27
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
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.