openinteract-dev

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

[joseph s. <joe...@jk...>]

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

joe
-- 
joseph speigle
www.sirfsup.com
jo...@jk...
page: 377-7377 (210)

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.

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.