You should declare different MasonAllowGlobals variables for DBI handler when you have different apps on same server. Because the MasonAllowGlobals variables exist in all child-process of Apache.
-----邮件原件----- 发件人: mason-users-boun...@lists.sourceforge.net [mailto:mason-users-boun...@lists.sourceforge.net] 代表 Michael R Boudreau 发送时间: 2009年11月4日 6:22 收件人: Mason List 主题: [Mason] Application is querying the wrong database 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 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Mason-users mailing list Mason-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mason-users
