It just happened, I've attached the Apache log.
thanks
Nigel
>>> Matt Sergeant <[EMAIL PROTECTED]> 07/11/02 05:25pm >>>
On Thu, 11 Jul 2002, Nigel Peck wrote:
> That's the problem, there aren't any error messages, apart from the
> message below in the event log which (as far as I can see) is about
as
> useful as a chocolate fireguard.
>
> (There's nothing in the Apache error.log)
>
> =-=-=-=-=-=-=-=-=-=-=-=-=
> Application popup: Apache.exe - Application Error : The instruction
at
> "0x00a61029" referenced memory at "0x00000004". The memory could not
be
> "read".
>
> Click on OK to terminate the program
> Click on CANCEL to debug the program
> =-=-=-=-=-=-=-=-=-=-=-=-=
That's a segfault. What happened immediately *before* that in the
error
log (with AxDebugLevel 10)?
--
<!-- Matt -->
<:->Get a smart net</:->
ITM Business Solutions
Unit 4
Nine Trees Trading Estate
Morthen Road
Rotherham
S66 9JG
Reception
Tel: 01709 703288
Fax: 01709 701549
Help Desk
Tel:01709 530424
Fax: 01709 702159
CONFIDENTIALITY NOTICE: This message is intended only for the use of
the individual or entity to which it is addressed, and may contain
information that is privileged, confidential and exempt from disclosure
under applicable law.
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] fast handler called for
/axkit/salesdb.xsp
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Running plugin:
Apache::AxKit::StyleChooser::QueryString
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Content Provider
Override: Apache::AxKit::Provider::File
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] [req] File Provider given
$r: c:/web/axkit/salesdb.xsp
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] checking if we process
this resource
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] media: screen, preferred
style: #default
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Cache: key =
f0a0480af08a140346ccd07fe1d8c797
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] getting styles and
external entities from the XML
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] styles not cached -
calling $provider->get_styles()
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] using XS get_styles
(libxml2)
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] calling xs_get_styles_fh()
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] calling
xs_get_styles_str()
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] xs_get_styles returned: ,
, {http://apache.org/xsp/core/v1}page
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Calling
GetMatchingProcessors with (screen, , , , {http://apache.org/xsp/core/v1}page)
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] get_styles: loading style
modules
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] get_styles: looking for
mapping for style type: 'application/x-xsp'
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] get_styles: looking for
mapping for style type: 'application/x-xpathscript'
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] cache doesn't exist
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] some condition failed.
recreating output
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] styles:
Apache::AxKit::Language::XSP(.)
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] styles:
Apache::AxKit::Language::XPathScript(./style/salesdb.xps)
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Style Provider Override:
Apache::AxKit::Provider::File
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] [uri] File Provider
looking up uri .
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] [uri] File Provider set
filename to c:/web/axkit
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] about to execute:
Apache::AxKit::Language::XSP::handler
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] XSP: parsing fh
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Recompiling XSP script
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] package
Apache::AxKit::Language::XSP::ROOTc_3a::web::axkit::salesdb_2exsp;
@Apache::AxKit::Language::XSP::ROOTc_3a::web::axkit::salesdb_2exsp::ISA =
('Apache::AxKit::Language::XSP::Page');
use Apache;
use Apache::Constants qw(:common);
use XML::LibXML;#initialize xsp namespace
#initialize xsp namespace
sub handler {
my ($r, $cgi, $document) = @_;
my ($parent);
{ my $elem =
$document->createElement(q|results|);$document->setDocumentElement($elem); $parent =
$elem; }
eval {
if (do {$cgi->param(q|query_string|)}) {
{ my $elem =
$document->createElement(q|original_query|);$parent->appendChild($elem); $parent =
$elem; }
{
my $text = $document->createTextNode("".do {
$cgi->param(q|query_string|)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
if (do {$cgi->param(q|query_field|)}) {
my $query_string;
if (do {$cgi->param(q|query_field|)} eq
"Record_Number") {
my $param_query = do
{$cgi->param(q|query_string|)};
$param_query =~ s/\s+//g;
die "Record Numbers must be digits
only" unless $param_query =~ m/^\d+$/;
$query_string = "SELECT * from
itm_telephone_datab WHERE Record_Number LIKE $param_query;";
}
elsif (do {$cgi->param(q|query_field|)} eq
"Company_Name") {
$query_string = "SELECT * from
itm_telephone_datab WHERE Company_Name RLIKE \"" . do {$cgi->param(q|query_string|)} .
"\";";
}
elsif (do {$cgi->param(q|query_field|)} eq
"Address") {
my $param_query = do
{$cgi->param(q|query_string|)};
$param_query =~ s/\s+/[ ]*/g;
$query_string = "SELECT * from
itm_telephone_datab WHERE " .
"(address1 REGEXP
'$param_query')" .
" || (address2 REGEXP
'$param_query')" .
" || (address3 REGEXP
'$param_query')" .
" || (address4 REGEXP
'$param_query')" .
" || (address5 REGEXP
'$param_query')" .
" || (postcode REGEXP
'$param_query')" .
";";
{ my $elem =
$document->createElement(q|test|);$parent->appendChild($elem); $parent = $elem; }
{
my $text = $document->createTextNode("".do {
$param_query}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
}
if (do {$cgi->param(q|action|)} eq "details") {
{
my $text = $document->createTextNode(q|
|);
$parent->appendChild($text);
}
{
my ($dbh, $connect_count, $driver, $transactions, $dburl, $user, $pass);
$transactions = 0;$driver = "dbi:". q|mysql|;$dburl = "". q|SalesDB|;$dbh =
DBI->connect($driver . ($dburl ? ":$dburl" : ''),
$user, $pass,
{
PrintError => 0,
AutoCommit => $transactions ? 0 : 1,
RaiseError => 1,
}) unless $connect_count;
$connect_count++;
AxKit::XSP::ESQL::new_query();
{
my ($query, $max_rows, $skip_rows, @params, $rv);
$max_rows = 0; $skip_rows = 0;
$query = "". do {$query_string};
{
AxKit::XSP::ESQL::prepare($dbh, $query);
$rv = AxKit::XSP::ESQL::execute(@params);
my ($col, $ancestor, $format);
if ($skip_rows) {
1 while (AxKit::XSP::ESQL::get_count() < $skip_rows && AxKit::XSP::ESQL::get_row());
}
if (AxKit::XSP::ESQL::get_row()) {
do {
{ my $elem = $document->createElement(q|result|);$parent->appendChild($elem); $parent
= $elem; }
{ my $elem = $document->createElement(q|showdetails|);$parent->appendChild($elem);
$parent = $elem; }
{ my $text = $document->createTextNode(q|yes|);$parent->appendChild($text); }
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|record_number|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|record_number|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|company_name|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|company_name|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|address1|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|address1|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|address2|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|address2|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|address3|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|address3|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|address4|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|address4|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|address5|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|address5|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|postcode|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|postcode|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem =
$document->createElement(q|telephone_number|);$parent->appendChild($elem); $parent =
$elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|telephone_number|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|fax_number|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|fax_number|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
my $history = convert(do {$col = ""; $ancestor = 0; $format = "";$col =
q|history_box|;$ancestor = 0;AxKit::XSP::ESQL::get_column($col, $ancestor)});{ my
$elem = $document->createElement(q|history_box|);$parent->appendChild($elem); $parent
= $elem; }
{
my $text = $document->createTextNode("".do {
$history}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem = $document->createElement(q|recall_date|);$parent->appendChild($elem);
$parent = $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|recall_date|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->appendChild($text);
}
$parent = $parent->getParentNode;
{ my $elem =
$document->createElement(q|contract_renewal_da|);$parent->appendChild($elem); $parent
= $elem; }
{
my $text = $document->createTextNode("".do {
$col = ""; $ancestor = 0; $format = "";$col = q|contract_renewal_da|;$ancestor =
0;AxKit::XSP::ESQL::get_column($col, $ancestor)}); # non xsp tag
$parent->a
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] XSP Compilation finished
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Turning off cache!
[Fri Jul 12 12:39:13 2002] [warn] [client 127.0.0.1] [AxKit] Cache: key =
6993c82634c33918a22138a860a69ab9
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
