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' )

Correction: that was the 'mime_type' field, and after scanning the 
magic file it should be extended to 50, not 40. The modified schema 
will be in the next version, out shortly.

Chris

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