[Catalyst] Database schema -- Can't locate object method "new" via package

[Matt S Trout]

Sarah Berry wrote:
> I think I've got it working! I'll post my solution in a bit here. Many 
> thanks to Brandon for pointing out some syntax errors and showing me 
> which plugin I hadn't installed.
> 
> My problem now is building the queries. How can I see what SQL code is 
> being generated for me? According to the tutorial John so kindly pointed 
> me towards, the SQL that was used should be output by 
> script/myapp_server.pl, but that only gives me errors like
> 
> 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 '= 'Date' ) OR ( select COUNT 'Date' ) ) ) 
> ORDER BY sensorid' at line 1 at 
> /usr/lib/perl5/vendor_perl/5.8.7/DBIx/Class/Storage/DBI.pm line 516.
> 
> and not the whole query.

export DBIX_CLASS_STORAGE_DBI_DEBUG=1

c.f. perldoc DBIx::Class::Storage::DBI for more details

and remember this is the Catalyst list and there's a dbix-class mailing list 
too :)

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +