I don't think the convertor even has a delete statement in it, so I don't see how that's possible

7,127

(3 replies, posted in PunBB 1.2 bug reports)

Nope, not yet, I'll email you when I get home smile

Well, I saw something similar to this at a game I modded. A table used to crash every so often for seemingly no particluar reason. The admin thought the problem might have been some corrupted MySQL libraries, but he was too lazy to re-install it, since we were moving to a new server. We moved and haven't had a problem since wink
Basically, if this is on a server you control, think about re-installing MySQL and seeing if that helps.

7,129

(71 replies, posted in Feature requests)

Definable user groups and post previews are in the original post smile

7,130

(13 replies, posted in PunBB 1.2 troubleshooting)

YES! I know what the problem with this is I think! big_smile
I had a problem like this on a board of mine. I think the issue was with mod_cache not being configured properly or something along those lines.
I'm taking a look at the HTTP requests and that seems to be exactly what's happening: the action of whatever happened before is being cached and re-played over and over./

7,131

(1 replies, posted in Feature requests)

Dunno exactly how this ports over to anything other then MySQL, but I'll suggest it anyway smile

Current code:

$result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'`') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());

My suggestion

$result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'` LIKE "'.$db_prefix.'%"') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());

That way, if there is a prefix, we only fetch the stats for the board we're looking at. smile

Oh, I forgot to say why this is good tongue
It helps people running multiple things from one database (be it multiple PunBB installs or anything) see how much space PunBB is actually taking up. I know I have a CVS version of PHPBB 3.0 in the database with PunBB, and it threw my stats off a lot tongue

7,132

(3 replies, posted in PunBB 1.2 bug reports)

And in the area of other odd developments, go manipulation of forms to make it so admins can't read the board! tongue
Obviously, neither of these are very serious (you'd need admin access to do any of them, and hopefully you don't have untrustworthy admins) but are probably worth fixing (if a hacker gets admin, locking out all Guests and then messing up all the group stats would be annoying to say the least: of course, if you have the DB plugin they could do much worse).

7,133

(3 replies, posted in PunBB 1.2 bug reports)

Mmm, I just found out that you can ban the Guest account. big_smile
And I do mean ban, I don't mean turn off their ability to read the board tongue

Some people "set it and forget it"
Lets take these forums as an example.
There are close to 3500 posters. Lets say Rickard had a giant thread that everyone was supposed to post in once. Imagine the server having to send out over 1k emails every time someone posted.
And subscriptions are already able to be set by the admins

For threads/forums with few posters maybe.
For threads/forums with many posters that have auto-subscribe on... that means every time someone posts in that thread everyone who is subscribed needs to be informed.

reviewum.com wrote:

Oh... well, then, GO FOR IT!!!   big_smile    I mean, heck, if the process will only add more emails to the sytem, but not resources during every post / pageview then it should totally be a user defined option.

Erm, who said that? tongue
I said the option to auto-subscribe would be a user table thing. I didn't mention the fact that it would have to send all the emails as well.

auto subscribe would be in the user table, and so would be grabbed every pageview anyway wink

7,138

(4 replies, posted in PunBB 1.2 troubleshooting)

Here you go

It depends on how photopost's database is set up.

Give us your site URL so we can check it out?

7,141

(10 replies, posted in Feature requests)

No, no other changes
and thanks wink

7,142

(10 replies, posted in Feature requests)

search.php (for last 72 hrs):

FIND

            else if ($action == 'show_24h')
            {
                $result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>'.(time() - 86400)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
                $num_hits = $db->num_rows($result);

                if (!$num_hits)
                    message($lang_search['No recent posts']);
            }

Replace with

            else if ($action == 'show_24h')
            {
                $result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>'.(time() - 259200)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
                $num_hits = $db->num_rows($result);

                if (!$num_hits)
                    message($lang_search['No recent posts']);
            }

All the .php files in the cache folder can be deleted.
What's your site?

7,144

(4 replies, posted in General discussion)

http://punbb.org/forums/viewtopic.php?pid=39852#p39852

7,145

(2 replies, posted in Programming)

Well, the way IC does it is to have an array storing the data: take a look at it wink

Angie wrote:

I keep getting this error when I tried to install PunBB:

An error occured on line 55 in ***/include/dblayer/mysql.php.

PunBB reported: Unable to select database. MySQL reported: Access denied for user: ****@localhost' to database '***'

I'm sure I had filled in everything correctly. And if I make a slight change to the info I filled in, I would get this:

An error occured on line 58 in file ***/include/dblayer/mysql.php.

PunBB reported: Unable to connect to MySQL server. MySQL reported: Access denied for user: ***@localhost' (Using password: YES)

Can someone please help?

The first error means you're entering a valid login/pass, but you're not allowed access to that table.
The second means you're entering an invalid login/pass

They're bloat, pure and simple tongue
1. Would lead to a lot of stress on the mailserver of a larger board due to the amount of emails it would have to send every time someone posted. Imagine a 1k post thread with just as many subscribers.
2. Similar to above, would send out a HUGE amount of emails on a regular basis.
3. There's a digest mod for 1.1.5 I'm planning on updating to work for 1.2.5

rofl big_smile

Add an extra query to the page based on p.poster, not that hard, although I don't see why you need it

7,150

(9 replies, posted in Feature requests)

OK, to force people to subscribe:

FIND:
$subscribe = isset($_POST['subscribe']) ? 1 : 0;
REPLACE WITH
$subscribe = isset($_POST['subscribe']) ? 1 : 1;

Quick and dirty hack smile