lj wrote:

I started playing with PunBB today, thought I'd have a look at the database... one of the first things I noticed was that the posts table has a poster varchar and a poster_id integer... only the latter one seems to be needed if you ask me.

As my forum (currently a phpBB) has over 500,000 posts, that's a lot of repetition! wink

I couldn't find any topics debating the issue except this one... so what's the reason for doing it like this? Perhaps if there's a problem query that required breaking "normal form" (whatever that is!) then I'd be interested to take a look...

In a quick glance, here was one query I found (from post.php):

$result = $db->query('SELECT poster, message FROM '.$db->prefix.'posts WHERE id='.$qid) or error('Unable to fetch quote info', __FILE__, __LINE__, $db->error());

So, it prevents having to join the users table into the query when fetching a quote smile

6,452

(13 replies, posted in PunBB 1.2 troubleshooting)

Something is odd then, as .domain.com should work
What's the site?

People putting extra whitespace after it
It messes up the headers that get sent out (and spits out quite a few ugly error messages)

6,454

(10 replies, posted in PunBB 1.2 show off)

Benny wrote:

I can't I am build tables alone on regular HTML not my problem thier use on Opera or firefox, i write HTML good and still there have problems!

If you were writing it properly, there would be no problems in Firefox tongue
http://validator.w3.org/check?verbose=1 … /index.php
Result:       Failed validation, 90 errors

Try fixing those

http://punres.org/doku.php?id=how-tos:adding_rank_icons

lament wrote:

ok cool thanks.. any reason why he's the only one having this problem? a browser setting?

It could be, it could also be Norton Internet Security improving "privacy" tongue

miik wrote:

for windows users:

install_mod.php
change all:  NOT NULL DEFAULT '';    to   NOT NULL DEFAULT 0;

Why? I never had an issue running it...

FredrikK wrote:

When installing:

"An error was encountered
File: /customers/brunna.se/brunna.se/httpd.www/install_mod.php
Line: 76

PunBB reported: Unable to add columns to table

Database reported: Duplicate column name 'g_pm' (Errno: 1060)"

What to do? sad

Did you already install this or a similar mod before?

Well, check your database, see if there are actually posts for those topic IDs.
If there aren't, then either someone manually removed them or they never got inserted back in

3 possibilities:
1 You manually deleted that post via the database
2. You manually deleted the person/people that posted it
3. The person/people that posted it has/have no group

AssD wrote:

Thanks, I have runed the SQL now, but what do you mean with rebuild the search index?
Sorry for being a noob. ^^;

Check out the administration panel wink

CREATE TABLE kiwizone_search_words (
                    id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
                    word VARCHAR(20) BINARY NOT NULL DEFAULT '',
                    PRIMARY KEY (word),
                    KEY kiwizone_search_words_id_idx (id)
                    ) TYPE=MyISAM;

Run that SQL, and then rebuild the search index

Yeah, you deleted the table tongue
Take a look at install.php for the correct code, or wait for me to look at it tongue

6,462

(3 replies, posted in PunBB 1.2 troubleshooting)

Do you have extra characters somewhere up there (an extra tab or space maybe?)

No, that means you made a mistake in editing the files wink
Enabling debug mode: http://punbb.org/forums/viewtopic.php?id=2658
It will help us see why your queries aren't working

6,464

(2 replies, posted in PunBB 1.2 troubleshooting)

Before you do that, I'd do a couple things
1: Fix the style
2: Undo whatever mods you made. I can see the Administration link without logging in
3: Don't use the redirect

6,465

(3 replies, posted in Feature requests)

Connor: It wouldn't be hard as a mod tongue
Click a button to enable user mode. This sets a cookie on your comp. the check_cookie function checks for the cookie, and if it's there you are given the member usergroup. It also gives you a link to remove the cookie, which will mean you go back to whatever your group is normally.

6,466

(9 replies, posted in Feature requests)

Write a plugin to allow them to edit template files

6,467

(6 replies, posted in PunBB 1.2 troubleshooting)

jop wrote:

I had a similar problem. I used two domains for my site www.keffatliv.ath.cx and keffatliv.ath.cx.
The problem was that when using www.keffatliv.ath.cx the keffatliv.ath.cx cookie were read but the www.keffatliv.ath.cx were written to.

So a user who had logged in using keffatliv.ath.cx could not log out using www.keffatliv.ath.cx. The solution was to redirect www.keffatliv.ath.cx to keffatliv.ath.cx.

You should have set the cookie_domain in config.php to .keffatliv.ath.cx

Jora: Assuming you're talking about http://synpeople.com/, you should set your cookie_domain to .synpeople.com

chrizz: Assuming you're talking about http://www.garaget.org/, you should set your cookie_domain to .garaget.org

It isn't with plain PunBB

6,469

(10 replies, posted in PunBB 1.2 troubleshooting)

That's not a bug, it's how PunBB works tongue
If you really want to change that, you can wait for 1.3 or install the Mark topics as read mod

Did you mod your board?

I have absolutely no clue hmm

Through MySQL directly (or though the DB plugin)?

It doesn't really point much of anywhere, since you shouldn't be having this problem
any chance you could give my account admin status for a second (I just registered with username "test") so I can see if I get the error (and try to figure out what's wrong from that)?

That is odd :-/

That happens to be a browser issue: have you modified any settings in your browser recently?