August 2008

DBI now correctly quotes PostgreSQL

I ran into an interesting problem while upgrading the production FreshPorts server. Specifically, this error: select PortsUpdatingAdd(E’20080708′::date, E’users of emulators/qemu-devel’, E’’, EE’ The port has been updated to a 20080620 SVN snapshot, which uses the new (incompatible) kqemu-kmod-devel port that now also works for the 32 bit “qemu” executable on amd64. If you upgrade qemu-devel

DBI now correctly quotes PostgreSQL Read More »

The fix

The fix: $ cvs di -ub Index: =================================================================== RCS file: /home/repositories/freshports-1/scripts/,v retrieving revision 1.52 diff -u -b -r1.52 — 6 Jun 2008 18:13:41 -0000 1.52 +++ 10 Aug 2008 21:09:51 -0000 @@ -160,6 +160,7 @@ # we are updating # NOTE: NULLIfEmpty invokes db_escape + # these items were escaped

The fix Read More »

More NULL problems

This morning I encountered more NULL problems. The error in question was: $ cat 2008. DBD::Pg::st execute failed: ERROR: column “enull” does not exist LINE 19: depends_lib = ENULL, ^ Could not execute SQL update ports set short_description = E’A KDE editor/modeler for POV-RayTM scenes’, long_description = E’KPovModeler is a graphical editor / modeler for

More NULL problems Read More »

Scroll to Top