Hi all, This is a problem I've never encountered before--I'm not even sure where to start looking.
I'm running a few different Mason apps on a Solaris server with Apache 2.2.11, Perl 5.8.4, mod_perl 2.0.4, and Mason 1.42. Today one of our users sent this error message that appeared in her browser. The thing that doesn't make sense to me is the message "Table 'subfillmail.metadata' doesn't exist", because 'metadata' is a table but in a completely different database (that other database is also the target of a different Mason app). So why is one Mason app randomly trying to run its queries on the wrong database? Where would you start looking to troubleshoot this? > System error > > > error: Cannot execute subroutine get_journals query 1: Table > 'subfillmail.metadata' doesn't exist at > /w1/WWW/WWW-intra/metadata/article_finder.mhtml line 37. > > context: > ... > 33: m2.objectid=m1.objectid AND > 34: m2.metadatatypecode = 1" ) > 35: or die "Cannot prepare subroutine get_journals query 1: $DBI::errstr"; > 36: > 37: $sth1->execute > 38: or die "Cannot execute subroutine get_journals query 1: $DBI::errstr"; > 39: > 40: my ($key, $value); > 41: $sth1->bind_columns(\$key, \$value) > ... > code stack: /w1/WWW/WWW-intra/metadata/article_finder.mhtml:37 > /w1/WWW/WWW-intra/subfillmail/sfmail_display.html:46 > raw error > <http://folio.uchicago.edu/WWW-intra/subfillmail/sfmail_display.html?rmailid=5 > 02159#raw> -- Michael R. Boudreau Senior Publishing Technology Analyst The University of Chicago Press 1427 E. 60th Street Chicago, IL 60637 (773) 753-3298 fax: (773) 753-3383 ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Mason-users mailing list Mason-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mason-users
