I have a MySQL database application that is used and managed by cgi-bin
scripts (CGI.pm). In development the performance was fine, but a
productin trial showed the performance to be unacceptable. I am
attempting to fix the performance by using mod_perl2 which I have never
used. I have successful
Brian Gaber wrote:
> I have modified scripts to work in mod_perl2, but they don't
> work reliably. Sometimes they work and then they stop working and then
> I have to stop and start Apache to get it working again.
"stop working" is really too generic a description for anyone to really
d
Michael Peters wrote:
Brian Gaber wrote:
I have modified scripts to work in mod_perl2, but they don't
work reliably. Sometimes they work and then they stop working and then
I have to stop and start Apache to get it working again.
"stop working" is really too generic a description
eeing this in your development environment? Yes
Can you reproduce the problem reliably? Yes
Thanks.
-Original Message-
From: Jim Brandt [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 2:36 PM
To: Michael Peters
Cc: Brian Gaber; modperl@perl.apache.org
Subject: Re: mod_perl2
Brian Gaber wrote:
> Is there anything useful in the Apache error log? Works fine a few
> times and then
> DBD::mysql::st execute failed: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near '' at line 1 at
> /us
2008/6/12 Michael Peters <[EMAIL PROTECTED]>:
> Brian Gaber wrote:
>> # Determine MySQL locks table name
>> my $sth = $dbh->prepare("SELECT * FROM region_props WHERE region =
>> '$region'");
>> $sth->execute();
> Btw, this is *really* bad security wise. $region is coming straight from the
> brows
Hi Brian,
"Brian Gaber" <[EMAIL PROTECTED]> wrote...
my $region = param('region'); # ...
my $sth = $dbh->prepare(
"SELECT * FROM region_props WHERE region = '$region'"
);
Works fine a few times and then:
DBD::mysql::st execute failed: You have an error in your SQL syntax;
check the manual t
Michael,
Thank you very much for this valuable advice.
Cheers.
Brian
-Original Message-
From: Michael Peters [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 3:05 PM
To: Brian Gaber
Cc: Jim Brandt; modperl@perl.apache.org
Subject: Re: mod_perl2 newbie DBI