Re: Class:DBI problems...
On Tue, 16 Sep 2003, Tony Bowden wrote: The Class::DBI list may be able to help you better ... I looked on class-dbi.com, and tried googling for 'class::dbi' mailing list with no luck; any hints? Graham Tony
Re: Class:DBI problems...
The Class::DBI list may be able to help you better ... I looked on class-dbi.com, and tried googling for 'class::dbi' mailing list with no luck; any hints? See the bottom of perldoc Class::DBI: To join the users list visit http://groups.kasei.com/mail/info/cdbi-talk To join the developers list visit http://groups.kasei.com/mail/info/cdbi-dev dave
Re: Class:DBI problems...
Je 2003-09-17 10:06:04 +0100, Graham Seaman skribis: The Class::DBI list may be able to help you better ... I looked on class-dbi.com, and tried googling for 'class::dbi' mailing list with no luck; any hints? http://search.cpan.org/author/TMTM/Class-DBI-0.94/lib/Class/DBI.pm#SUPPORT SUPPORT Support for Class::DBI is via the mailing list. The list is used for general queries on the use of Class::DBI, bug reports, patches, and suggestions for improvements or new features. To join the list visit http://groups.kasei.com/mail/info/cdbi-talk Paul -- Paul Makepeace ... http://paulm.com/ What is the capital of Norway? Three things: location, location, location. -- http://paulm.com/toys/surrealism/
Re: Class:DBI problems...
On Wed, 17 Sep 2003, David Wright wrote: See the bottom of perldoc Class::DBI: To join the users list visit http://groups.kasei.com/mail/info/cdbi-talk Oops, didn't RTFM. Thanks! Graham
Re: Class:DBI problems...
Tony Bowden [EMAIL PROTECTED] wrote: On Tue, Sep 16, 2003 at 06:15:19PM +0100, Graham Seaman wrote: Failure while doing 'SELECT issue_id, title, number, current FROM tableSite::Issue/table WHERE current = ? ' with 'SearchSQL in Site::Issue' DBD::mysql::st execute failed: You have an error in your SQL syntax near 'tableSite::Issue/table WHERE current = '1' ' at line 2 at /usr/lib/perl5/site_perl/5.6.1/Ima/DBI.pm line 735 grepping turns up nowhere at all that this table is being wrapped round class names, let alone where it should be stripped out... and I've got kind of lost trying to track this through the rather convoluted structure of Class::DBI and associated modules. There's nothing in Class::DBI or Ima::DBI that should be doing this. That said, Class::DBI 0.90 is rather old now, and how all this works has changed significantly in the last year ... My main guess would be that $class-table somehow is returning tableSite::Issue/table. Would that be true? This sounds extremely like you've imported a load of CGI.pm routines into that classes namespace... -Dom -- | Semantico: creators of major online resources | | URL: http://www.semantico.com/ | | Tel: +44 (1273) 72 / Fax: +44 (1273) 723232 | | Address: 33 Bond St., Brighton, Sussex, BN1 1RD, UK. |
Re: Class:DBI problems...
On Wed, 17 Sep 2003, Dominic Mitchell wrote: This sounds extremely like you've imported a load of CGI.pm routines into that classes namespace... You're right, but I don't understand how: another vhost (not using Class:DBI or in any way related to the problem site) had just started using CGI.pm to output a cookie. Remove the use of CGI.pm from this other site, and the Class::DBI problem goes away. Graham
Re: Class:DBI problems...
Graham Seaman [EMAIL PROTECTED] wrote: On Wed, 17 Sep 2003, Dominic Mitchell wrote: This sounds extremely like you've imported a load of CGI.pm routines into that classes namespace... You're right, but I don't understand how: another vhost (not using Class:DBI or in any way related to the problem site) had just started using CGI.pm to output a cookie. Remove the use of CGI.pm from this other site, and the Class::DBI problem goes away. No idea how it's happening. But shared mod_perl hosting is a bad idea because you're all effectively operating in a single process. Actually, I would suspect an AUTOLOAD module somewhere is getting called. Not sure how best to debug this sort of thing... -Dom -- | Semantico: creators of major online resources | | URL: http://www.semantico.com/ | | Tel: +44 (1273) 72 / Fax: +44 (1273) 723232 | | Address: 33 Bond St., Brighton, Sussex, BN1 1RD, UK. |
Class:DBI problems...
Hi, A live site which has not been touched for some time has suddenly and mysteriously started failing with error messages like: Failure while doing 'SELECT issue_id, title, number, current FROM tableSite::Issue/table WHERE current = ? ' with 'SearchSQL in Site::Issue' DBD::mysql::st execute failed: You have an error in your SQL syntax near 'tableSite::Issue/table WHERE current = '1' ' at line 2 at /usr/lib/perl5/site_perl/5.6.1/Ima/DBI.pm line 735 grepping turns up nowhere at all that this table is being wrapped round class names, let alone where it should be stripped out... and I've got kind of lost trying to track this through the rather convoluted structure of Class::DBI and associated modules. Can anyone hazard a guess as to what might have happened here (this is Class:DBI 0.90 running on perl 5.6.1), or point me to a more appropriate forum? Sorry, no non-perl stuff :-( Cheers Graham
Re: Class:DBI problems...
On Tue, Sep 16, 2003 at 06:15:19PM +0100, Graham Seaman wrote: Failure while doing 'SELECT issue_id, title, number, current FROM tableSite::Issue/table WHERE current = ? ' with 'SearchSQL in Site::Issue' DBD::mysql::st execute failed: You have an error in your SQL syntax near 'tableSite::Issue/table WHERE current = '1' ' at line 2 at /usr/lib/perl5/site_perl/5.6.1/Ima/DBI.pm line 735 grepping turns up nowhere at all that this table is being wrapped round class names, let alone where it should be stripped out... and I've got kind of lost trying to track this through the rather convoluted structure of Class::DBI and associated modules. There's nothing in Class::DBI or Ima::DBI that should be doing this. That said, Class::DBI 0.90 is rather old now, and how all this works has changed significantly in the last year ... My main guess would be that $class-table somehow is returning tableSite::Issue/table. Would that be true? Can anyone hazard a guess as to what might have happened here (this is Class:DBI 0.90 running on perl 5.6.1), or point me to a more appropriate forum? The Class::DBI list may be able to help you better ... Tony