Apache's mod_rewrite and relative paths. A simple question?

Hi Kyle,

Nice to meet you, sir.

I have a large VB forum (version 4.22) and we're researching means of archiving old inactve posts. Your post here is of interest and sounds like...

[KrON]

That does indeed mean you have no orphan PMs. I don't think dumping and reimporting your database fixed it, I think that what probably happened is that the cronjob responsible for Orphan PM cleanup was...

[KrON]

SELECT pmtext.pmtextid
FROM pmtext AS pmtext
LEFT JOIN pm AS pm USING(pmtextid)
WHERE pm.pmid IS NULL;

This query will find the ids of your orphan PMs. You could write a...

[KrON]

You're sort of stuck using prefork if you're using PHP. PHP (and subsequent modules) are not entirely threadsafe, so using the worker MPM is not advisable.

Worker does scale better on >...

[KrON]

Can't help you on what table type they are supposed to be, but to change them back to MyISAM:

[I]alter table[/I] searchcore engine=[I]myisam[/I];

[KrON]

Yes, you can overload is_member_of() with multiple usergroups, such as:

<if condition="is_member_of($bbuserinfo, 1,2,3,4,5)"></if>

You can also do conditions like:...

[KrON]

Just got confirmation from Jelsoft. They boned up the email they sent out, and sent it to everyone instead of just "active" licensees. Those of us who didn't have an active license will not...

[KrON]

I just saw this in the faq:

"I let my license expire and now I can not renew – what are my options? You are not eligible for upgrade pricing. You must purchase a new license."...

[KrON]

Error 28 tends to mean that MySQL is unable to write to your disk, because it's full. Make sure the partition with your MySQL data files and /tmp directory aren't full.

[KrON]

Somewhere in my post history I've covered how we handle archiving at PbNation. Essentially we move old, inactive posts to post_X tables, then create a MySQL Merge table against all of those post_X tables...

[KrON]

Actually, it turns into a major issue pretty quick. Username is indeed a field in the user table, but for speed reasons Jelsoft also stores username for each post in the post table.

This...

[KrON]

Well, I ended up fixing it with the BASE attribute, but I also opened up another can of worms.

I'll post my really messy "fix" here in case anyone else ever follows in my footsteps....

[KrON]

Yanno, I saw this when I was googling for solutions a while ago but it didn't click. It seems to be doing the job! I will report back once I have things worked out, but in my testing, just putting a base...

[KrON]

Dag, all those views and no ideas?

[KrON]

I've managed to stump myself on something that I believe is rather simple, so I'm calling upon the collective brain of the vB community to see if what I am attempting to do is feasible.

Let's...

[KrON]

I ended up complaining so much that our host went back to the manufacturer and found a solution that doesn't mess with the client IPs.

At any rate, the solution I suggested above was working...

[KrON]

For now, I just hacked the fetch_ip() function to:

return $this->fetch_alt_ip();

Which isn't an optimal solution, is there a reason this isn't an option if fetch_alt_ip()...

[KrON]

So,

Today our host switched us to a new loadbalancer that masks a clients real IP address.

The clients IP is forwarded in the _SERVER["HTTP_X_FORWARDED_FOR"] header....

[KrON]

#4 chimes in with a pretty please!