[rt-users] SearchBuilder problems with sorting by Custom Fields

Kenneth Crocker KFCrocker at lbl.gov
Wed May 21 14:22:00 EDT 2008


Jesse, whomever,


	I managed to execute the "fixdeps" in my test environment. I wasn't 
sure how to answer all the questions on where to put stuff as I know 
little or nothing about that stuff, although I AM certainly learning. I 
DO have a couple questions about the results. The following is what the 
"fixdeps" displayed while doing it's thing:

   CPAN.pm: Going to build R/RU/RUZ/DBIx-SearchBuilder-1.53.tar.gz

Cannot determine perl version info from SearchBuilder.pm
*** Module::AutoInstall version 1.03
*** Checking for Perl dependencies...
[Core Features]
- Test::More                 ...loaded. (0.62 >= 0.52)
- DBD::SQLite                ...loaded. (1.11)
- File::Temp                 ...loaded. (0.16)
- DBI                        ...loaded. (1.47)
- Want                       ...loaded. (0.10)
- Encode                     ...loaded. (2.01)
- Class::ReturnValue         ...loaded. (0.53 >= 0.4)
- Cache::Simple::TimedExpiry ...loaded. (0.23 >= 0.21)
- Clone                      ...loaded. (0.20)
[Lower case API]
- capitalization             ...loaded. (0.03 >= 0.03)
[Schema generation]
- DBIx::DBSchema             ...loaded. (0.33)
- Class::Accessor            ...loaded. (0.22)
*** Module::AutoInstall configuration finished.
Checking if your kit is complete...
Looks good
Writing Makefile for DBIx::SearchBuilder
make[1]: Entering directory 
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K'
cp SearchBuilder.pm blib/lib/DBIx/SearchBuilder.pm
cp SearchBuilder/Handle.pm blib/lib/DBIx/SearchBuilder/Handle.pm
cp SearchBuilder/Handle/mysqlPP.pm 
blib/lib/DBIx/SearchBuilder/Handle/mysqlPP.pm
cp SearchBuilder/Handle/mysql.pm blib/lib/DBIx/SearchBuilder/Handle/mysql.pm
cp SearchBuilder/Handle/Sybase.pm 
blib/lib/DBIx/SearchBuilder/Handle/Sybase.pm
cp SearchBuilder/Unique.pm blib/lib/DBIx/SearchBuilder/Unique.pm
cp SearchBuilder/Union.pm blib/lib/DBIx/SearchBuilder/Union.pm
cp SearchBuilder/Handle/Oracle.pm 
blib/lib/DBIx/SearchBuilder/Handle/Oracle.pm
cp SearchBuilder/Record/Cachable.pm 
blib/lib/DBIx/SearchBuilder/Record/Cachable.pm
cp SearchBuilder/Handle/Informix.pm 
blib/lib/DBIx/SearchBuilder/Handle/Informix.pm
cp SearchBuilder/Handle/SQLite.pm 
blib/lib/DBIx/SearchBuilder/Handle/SQLite.pm
cp SearchBuilder/Handle/ODBC.pm blib/lib/DBIx/SearchBuilder/Handle/ODBC.pm
cp SearchBuilder/Handle/Pg.pm blib/lib/DBIx/SearchBuilder/Handle/Pg.pm
cp SearchBuilder/SchemaGenerator.pm 
blib/lib/DBIx/SearchBuilder/SchemaGenerator.pm
cp SearchBuilder/Record.pm blib/lib/DBIx/SearchBuilder/Record.pm
Manifying blib/man3/DBIx::SearchBuilder::Handle::mysql.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::mysqlPP.3
Manifying blib/man3/DBIx::SearchBuilder::Handle.3
Manifying blib/man3/DBIx::SearchBuilder.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Sybase.3
Manifying blib/man3/DBIx::SearchBuilder::Union.3
Manifying blib/man3/DBIx::SearchBuilder::Unique.3
Manifying blib/man3/DBIx::SearchBuilder::Record::Cachable.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Oracle.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::SQLite.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Informix.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Pg.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::ODBC.3
Manifying blib/man3/DBIx::SearchBuilder::Record.3
Manifying blib/man3/DBIx::SearchBuilder::SchemaGenerator.3
make[1]: Leaving directory 
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K'
   RUZ/DBIx-SearchBuilder-1.53.tar.gz
   /tools/bin/make -- OK
Running make test
make[1]: Entering directory 
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K'
PERL_DL_NONLAZY=1 /tools/bin/perl "-MExtUtils::Command::MM" "-e" 
"test_harness(0, 'inc', 'blib/lib', 'blib/arch')" t/00.load.t 
t/01basics.t t/01nocap_api.t t/01records.t t/01searches.t 
t/02order_outer.t t/02records_cachable.t t/02records_integers.t 
t/02records_object.t t/02searches_joins.t t/03rebless.t 
t/03transactions.t t/03versions.t t/10schema.t t/11schema_records.t t/pod.t
t/00.load...............ok 

t/01basics..............ok 

t/01nocap_api...........ok 

t/01records.............ok 

         65/65 skipped: various reasons
t/01searches............ok 

         76/76 skipped: various reasons
t/02order_outer.........ok 

         98/98 skipped: various reasons
t/02records_cachable....ok 

         16/16 skipped: various reasons
t/02records_integers....ok 

         33/33 skipped: various reasons
t/02records_object......ok 

         11/11 skipped: various reasons
t/02searches_joins......ok 

         47/47 skipped: various reasons
t/03rebless.............ok 

         4/4 skipped: various reasons
t/03transactions........ok 

         42/42 skipped: various reasons
t/03versions............ok 

         6/6 skipped: various reasons
t/10schema..............ok 

         14/17 skipped: various reasons
t/11schema_records......ok 

         63/63 skipped: various reasons
t/pod...................skipped
         all skipped: Test::Pod 1.00 required for testing POD
All tests successful, 1 test and 475 subtests skipped.
Files=16, Tests=496, 13 wallclock secs ( 6.87 cusr +  2.22 csys =  9.09 CPU)
make[1]: Leaving directory 
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K'
   RUZ/DBIx-SearchBuilder-1.53.tar.gz
   /tools/bin/make test -- OK
Running make install
make[1]: Entering directory 
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K'
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Unique.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Union.pm
Installing 
/opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/SchemaGenerator.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Record.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/mysqlPP.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/mysql.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Sybase.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
Installing 
/opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Informix.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/SQLite.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/ODBC.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Pg.pm
Installing 
/opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Record/Cachable.pm
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::mysql.3
Installing 
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::mysqlPP.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Sybase.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Union.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Unique.3
Installing 
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Record::Cachable.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Oracle.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::SQLite.3
Installing 
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Informix.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Pg.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::ODBC.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Record.3
Installing 
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::SchemaGenerator.3
Writing 
/opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/auto/DBIx/SearchBuilder/.packlist
Appending installation info to 
/opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/perllocal.pod
make[1]: Leaving directory 
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K'
   RUZ/DBIx-SearchBuilder-1.53.tar.gz
   /tools/bin/make install  -- OK

Install module CSS::Squish
Running install for module 'CSS::Squish'
Running make for R/RU/RUZ/CSS-Squish-0.07.tar.gz
Fetching with LWP:
 
ftp://cpan.cs.utah.edu/pub/CPAN/authors/id/R/RU/RUZ/CSS-Squish-0.07.tar.gz
Checksum for 
/home/rt/.cpan/sources/authors/id/R/RU/RUZ/CSS-Squish-0.07.tar.gz ok
CSS-Squish-0.07/
CSS-Squish-0.07/t/
CSS-Squish-0.07/t/05-basic-loop-prevention.t
CSS-Squish-0.07/t/css/
CSS-Squish-0.07/t/css/01-basic-import.css
CSS-Squish-0.07/t/css/05-loop-prevention-2.css
CSS-Squish-0.07/t/css/05-loop-prevention.css
CSS-Squish-0.07/t/css/04-recursion.css
CSS-Squish-0.07/t/css/blam.css
CSS-Squish-0.07/t/css/foo/
CSS-Squish-0.07/t/css/foo/04-recursion-2.css
CSS-Squish-0.07/t/css/foo/04-recursion-3.css
CSS-Squish-0.07/t/css/01-basic.css
CSS-Squish-0.07/t/css/03-skip-http.css
CSS-Squish-0.07/t/css/foo.css
CSS-Squish-0.07/t/css/02-edge-cases.css
CSS-Squish-0.07/t/css/07-basic-extra-roots4.css
CSS-Squish-0.07/t/css/05-loop-prevention-3.css
CSS-Squish-0.07/t/css/foo2.css
CSS-Squish-0.07/t/css/07-basic-extra-roots.css
CSS-Squish-0.07/t/css/07-basic-extra-roots3.css
CSS-Squish-0.07/t/99-pod-coverage.t
CSS-Squish-0.07/t/css3/
CSS-Squish-0.07/t/css3/07-basic-extra-roots2.css
CSS-Squish-0.07/t/css3/07-basic-extra-roots3.css
CSS-Squish-0.07/t/03-skip-http.t
CSS-Squish-0.07/t/07-basic-extra-roots.t
CSS-Squish-0.07/t/css2/
CSS-Squish-0.07/t/css2/07-basic-extra-roots2.css
CSS-Squish-0.07/t/02-edge-cases.t
CSS-Squish-0.07/t/00-use.t
CSS-Squish-0.07/t/01-basic.t
CSS-Squish-0.07/t/04-recursion.t
CSS-Squish-0.07/t/06-server-relative-urls.t
CSS-Squish-0.07/t/99-pod.t
CSS-Squish-0.07/MANIFEST
CSS-Squish-0.07/CHANGES
CSS-Squish-0.07/lib/
CSS-Squish-0.07/lib/CSS/
CSS-Squish-0.07/lib/CSS/Squish.pm
CSS-Squish-0.07/Makefile.PL
CSS-Squish-0.07/README
CSS-Squish-0.07/META.yml

   CPAN.pm: Going to build R/RU/RUZ/CSS-Squish-0.07.tar.gz

Checking if your kit is complete...
Looks good
Writing Makefile for CSS::Squish
make[1]: Entering directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu'
cp lib/CSS/Squish.pm blib/lib/CSS/Squish.pm
Manifying blib/man3/CSS::Squish.3
make[1]: Leaving directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu'
   RUZ/CSS-Squish-0.07.tar.gz
   /tools/bin/make -- OK
Running make test
make[1]: Entering directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu'
PERL_DL_NONLAZY=1 /tools/bin/perl "-MExtUtils::Command::MM" "-e" 
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00-use......................ok 

t/01-basic....................ok 

t/02-edge-cases...............ok 

t/03-skip-http................ok 

t/04-recursion................ok 

t/05-basic-loop-prevention....ok 

t/06-server-relative-urls.....skipped
         all skipped: Functionality non-existant.  (and tests incomplete.)
t/07-basic-extra-roots........ok 

t/99-pod-coverage.............skipped
         all skipped: Test::Pod::Coverage 1.00 required for testing POD 
coverage
t/99-pod......................skipped
         all skipped: Test::Pod 1.00 required for testing POD
All tests successful, 3 tests skipped.
Files=10, Tests=13,  3 wallclock secs ( 1.34 cusr +  0.59 csys =  1.93 CPU)
make[1]: Leaving directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu'
   RUZ/CSS-Squish-0.07.tar.gz
   /tools/bin/make test -- OK
Running make install
make[1]: Entering directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu'
Installing /opt/rt-3.4.4/perl/lib/5.8.5/CSS/Squish.pm
Installing /opt/rt-3.4.4/perl/man/man3/CSS::Squish.3
Writing /opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/auto/CSS/Squish/.packlist
Appending installation info to 
/opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/perllocal.pod
make[1]: Leaving directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu'
   RUZ/CSS-Squish-0.07.tar.gz
   /tools/bin/make install  -- OK
MAILGATE dependencies:
         Pod::Usage...found
         HTML::TreeBuilder...found
         Getopt::Long...found
         HTML::FormatText...found
         LWP::UserAgent...found
MASON dependencies:
         CGI::Cookie >=1.20...found
         Text::WikiFormat >=0.76...found
         XML::RSS >=1.05...found
         Storable >=2.08...found
         CSS::Squish 0.06...MISSING
         HTML::Mason >=1.23...found
         Apache::Session >=1.53...found
         Digest::MD5 >=2.27...found
         GD::Text...found
         GD...found
         Errno...found
         GD::Graph...found

Install module CSS::Squish
Running install for module 'CSS::Squish'
Running make for R/RU/RUZ/CSS-Squish-0.07.tar.gz
   Has already been unwrapped into directory 
/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu
   Has already been made
Running make test
   Has already been tested successfully
Running make install
   Already done
ORACLE dependencies:
         DBD::Oracle...found

SOMETHING WAS MISSING!
bash-2.03$


	My questions are:

	1) When it states "1 test and 475 skipped" is that bad?
	2) When is showed where it was installing everything, it displayed

"Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder"

	So ..... why didn't it install to rt-3.6.6   AND
	3) We are using perl 5.8.8, so I am concerned about those results or 
directory or whatever as well.
	4) What is "Squish" and did that install OK?

	I just can't tell on some of this stuff. When it asks questions like 
"Always commit changes to config variables to disk? [no]" do I enter 
"y", "yes", "no" or just hit enter?

	When it asked about building perl, I thought I should enter where we 
keep our perL. Correct??

Parameters for the 'perl Build.PL' command?
Typical frequently used settings:

     --install_base /home/xxx             # different installation directory

Your choice:  [] /apps/rt/rt-3.6.6/perl
Parameters for the './Build' command?


	So .... can anyone tell me what I did? did it work? did it go where I 
thought it should go? Did I enter the right answers to it's questions? 
Have I successfully installed SearchBuilder 1.5.3 or is everything back 
to 3.4.4?

	I VERY confused by these questions AND results. Please help and Thanks 
ahead of time.

Kenn
LBNL


On 5/20/2008 5:14 PM, Jesse Vincent wrote:
> 
> On May 21, 2008, at 6:11 AM, Kenneth Crocker wrote:
> 
>> Emmanuel,
>>
>>
>>     I downloaded 3.6.6 and am up to the "make testdeps". This ran fine 
>> but
>> for a couple things missing:
>>
>>  Calendar::Simple...found
>>         DBIx::SearchBuilder 1.50...MISSING
>>                 DBIx::SearchBuilder version 1.5 required--this is only
>> version 1.49 at (eval 27) line 2.
>>         Date::Format...found
>>         CSS::Squish 0.06...MISSING
>>
>>     How do I get the latest SearchBuilder and download it if it wasn't
>> included in the original download?
> 
> 
> 'make fixdeps' or use 'cpan' to manually install it.
> 
>> Why does it state it wants 1.50 instead of 1.53? This is confusing for 
>> me.
> 
> It's a minimum version requirement. "At least 1.50"




More information about the rt-users mailing list