Posted by Shiny on June 18, 2006 at 3:55am
1 follower
| Project: | TrackBack |
| Version: | 4.7.x-1.x-dev |
| Component: | Receiving |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
The table defs use varchar, limiting url length, but not enforcing this limti in php code.
The result is a log file full of sql errors, and annoyed sysadmins.
255chars is too short for many URLS anyways.
so, i made a patch to turn the varchars into text.
tested in postgresql 8.1
BEGIN;
ALTER table trackback_received add column new_name text;
update trackback_received set new_name = name;
alter table trackback_received alter column new_name set not null;
alter table trackback_received drop column name;
alter table trackback_received rename new_name to name;
ALTER table trackback_received add column new_subject text;
update trackback_received set new_subject = subject;
alter table trackback_received alter column new_subject set not null;
alter table trackback_received drop column subject;
alter table trackback_received rename new_subject to subject;
ALTER table trackback_received add column new_url text;
update trackback_received set new_url = url;
alter table trackback_received alter column new_url set not null;
alter table trackback_received drop column url;
alter table trackback_received rename new_url to url;
ALTER table trackback_received add column new_excerpt text;
update trackback_received set new_excerpt = excerpt;
alter table trackback_received alter column new_excerpt set not null;
alter table trackback_received drop column excerpt;
alter table trackback_received rename new_excerpt to excerpt;
COMMIT;