I get these when I look at the module page after copy the module to my module page. I hacked the description down to the first sentence and it worked.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(255) in /orangepics/drupal/drupal-4.7.3/includes/database.pgsql.inc on line 84.

user warning: query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('globalredirect', 'This module will do a 301 redirect for all nodes that have a URL Alias but are being accessed as a node. This will ensure that pages that have a URL Alias are only accessable from the aliased URL, thus ensuring your site doesnt end up in Google Sandpit for duplicate content.', 'module', 'modules/globalredirect/globalredirect.module', 0, 0, 1) in /orangepics/drupal/drupal-4.7.3/includes/database.pgsql.inc on line 103.

Comments

nicholasthompson’s picture

nicholasthompson
Primary language English
commented

Interesting... Why is that a problem in PostgreSQL and not MySQL? Is the description field a different size?

I'll shorten it...

nicholasthompson’s picture

nicholasthompson
Primary language English
commented
Status: Active » Fixed

shortened/reworded... I assume this fixes the issue.

hass’s picture

hass commented
Status: Fixed » Active

i have had the same problem with MySQL 5.0.24a and Drupal 4.7.4 - Global Redirect has Version 1.1.2.3.

user warning: Data too long for column 'description' at row 1 query: system_modules INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('globalredirect', 'This module will do a 301 redirect for all nodes that have a URL Alias but are being accessed as a node. This will ensure that pages that have a URL Alias are only accessable from the aliased URL, thus ensuring your site doesnt end up in Google Sandpit for duplicate content.', 'module', 'modules/globalredirect/globalredirect.module', 0, 0, 1) in c:\Inetpub\wwwroot\drupal\includes\database.mysql.inc on line 121.

nicholasthompson’s picture

nicholasthompson
Primary language English
commented
Status: Active » Needs review

I have shortened the alias to...

This module will do a 301 redirect for all nodes which have an alias but are not using that alias.

Can someone check this in the other databases as I have never seen this error in the DB's I've tested it on (MySQL 4 and 5)

hass’s picture

hass commented

i checked the description field in my Mysql 5 dev server. It is VARCHAR(255) and you string has had 276 chars and was therefor a little bit oversized... :-)

Tobias Maier’s picture

Tobias Maier commented
Status: Needs review » Fixed

I think this is fixed, too

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)