Download & Extend

Missing quote in db_add_column $attributes default parameter

Project:File (Field) Paths
Version:5.x-1.3
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

As per documentation, the 'default' value in $attributes array supposed to be "''":-

<?php
db_add_column
($ret = array(), 'files', 'origname', 'varchar(255)', array('not null' => TRUE, 'default' => ''));
?>

<?php
db_add_column
($ret = array(), 'files', 'origname', 'varchar(255)', array('not null' => TRUE, 'default' => "''"));
?>

Otherwise you would get an error when running update.php:-

warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE files ALTER origname SET default ^ ....
nobody click here