Open beta test of the new database

[Co-Rion]

After some trials and tribulations we're proud to announce the Beta Database. The database should be an exact copy of the production database running on a beefier machine.

Against the spirit of Google, beta means beta, and not "unsupported" or "don't sue us". It means that:

All changes on the Beta Database will be lost, as it is only temporary.

The database is a copy of PerlMonks as of the 24th of September. Please don't post real questions there and also don't post answers there. It will be wiped whenever a new copy of the real PerlMonks database is loaded into it.

As we're moving from MySQL 4 to MySQL 5, there are bound to be some queries and pages that don't work anymore. ambrus thankfully has already found two such instances (MySQL 5 is very picky about the order of implicit JOINs and LEFT JOINs). Please go there, check that everything is as you expect, and reply here with the pages you find that are not working.

The test program

For regression testing, I'm using the following program. It would be nice if your bug reports used a similar program to verify the bug or that the bug got fixed. Please also check that the bug does not also occur with the normal PerlMonks site :).

#!/opt/perl/bin/perl5.10.0
use strict;
use Test::WWW::Mechanize;
use Test::More;

use vars qw($beta $production $login $pass);
($login,$pass) = @ARGV;

my @tests = <DATA>;
chomp @tests;
plan tests => 4+ 2*@tests;

my %mech = (
    beta => {
        url => 'http://qs343.pair.com/~monkperl/beta.cgi?',
        mech => Test::WWW::Mechanize->new(),
    },
    production => {
        url => 'http://perlmonks.net/?',
        mech => Test::WWW::Mechanize->new(),
    },
);
for my $site (sort keys %mech) {
    my $m = $mech{$site}->{mech};
    my $url = $mech{$site}->{url};
    $m->get("${url}node=109");
    $m->submit_form(
        with_fields => {
            user => $login,
            passwd => $pass,
        },
    );
    $m->content_like(qr!Hey\.\s*Glad you're back!i, "Logged in as '$lo
+gin'")
        or $m->save_content('login.fail');
    $m->content_unlike(qr!Oops!i, "Correct password")
        or $m->save_content('login.fail');
};

for my $url (@tests) {
    for my $site (sort keys %mech) {
        my $u = $mech{$site}->{url} . $url;
        my $m = $mech{$site}->{mech};
        $m->get($u);
        $m->content_unlike( qr/Server Error\s*\(Error ID/, "[$site] No
+ error on $url" );
        $m->save_content('log.html');
    };
};

__DATA__
node=The+Monastery+Gates
node=Message+Inbox
node=Patch+lister
node=Recently+Active+Threads;nnt-as-of=2008-08-21

Known bugs

1. The linked /css/common.css is not found. This is because common.css does not live in the database and I don't want to mess with the global RewriteRules just for testing.
2. The beta website isn't as responsive as it could be because it runs as a CGI instead of using mod_perl.

Thanks for helping us test,
Co-Rion for the gods

Update: Removed link to http://qs343.pair.com/~monkperl/beta.cgi?node_id=109 as Google found it and the script doesn't exist anymore.

[hossman]

Link to "The Monastery Gates" in upper right nav links results in 500 error. behavior is consistent when tested multiple times: http://qs343.pair.com/~monkperl/beta.cgi?node_id=131

Ditto for "PerlMonks Test Database" in the blue bar under the monk pictures: http://qs343.pair.com/~monkperl/beta.cgi?

[Anonymous Monk]

My new user doesn't show up in NN or RAT (bogus email), neither can Anonymous Monk post to snippets (I knew I couldn't post reviews)

[Corion]

New users only show up when they've confirmed their email address, this is identical to the production site, but understandably you didn't test that here.

I'm not sure if Anonymous Monk can post to snippets here - I'll test that resp. check the code, thanks. I've just looked - Anonymous Monk isn't allowed to post snippets anymore, sorry.

[Anonymous Monk]

Thanks. It would be nice if he wasn't shown the form in that case (temptation).