Re: [Openinteract-dev] sql field too small in page table

[Chris W. <ch...@cw...>]

joseph speigle wrote:
> I get the following when scanning to add a page
> 
> DBD::Pg::st execute failed: ERROR: value too long for type
> character varying(30) at
> /usr/lib/perl5/site_perl/5.8.0//SPOPS/SQLInterface.pm line 284.
> INSERT INTO page ( author, directory, keywords, main_template,
> content_location, location, template_parse, boxes, active_on,
> mime_type, page_size, is_active, notes, title, storage,
> expires_on ) VALUES ( NULL, '/cl', NULL, NULL, NULL,
> '/cl/bzip.htm', 'no', NULL, '2003-04-05', 'x-system/x-unix;
> commands text', NULL, 'yes', NULL, NULL, 'file', '2004-04-04' )

Looks like the mime type 'x-system/x-unix; commands text' is too 
long. That's an interesting one... I'll look in a standard magic 
file and find the longest content type. (Should have done that a 
while ago...) Then I'll modify this table and the 'content_type' 
table with the length.

In the meantime you should be able to issue an 'alter table' 
statement and modify the length of 'content_type' to 40 or so.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.