[Tickets #2206] NEW: error when trying to add file in /scripts to database

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2206
-----------------------------------------------------------------------
 Ticket             | 2206
 Created By         | atlas at literateminds.com
 Summary            | error when trying to add file in /scripts to database
 Queue              | Sam
 Version            | HEAD
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


atlas at literateminds.com (2005-06-30 09:34) wrote:

im using mysql 4.1.x on debian sarge (3.1) 
horde sam and other modules are all HEAD tag from CVS as of today.
06-30-2005 10:30 am MST.

Here are my steps:

cd horde
cvs co sam
cd sam/scripts/sql
mysql -U horde < amavisd_sql.mysql.sql

and I get a SQL error back saying that there was an error near 'NOT NULL and
to check my documenation yaddy yadda...'

It looks like its referring to the id column as its specifying default
without a value for it,
shown here:

CREATE TABLE policy (
  id                   INT UNSIGNED DEFAULT NOT NULL auto_increment,
  policy_name          VARCHAR(255), -- not used by amavisd-new

  virus_lover          VARCHAR(1),      -- Y/N
  spam_lover           VARCHAR(1),      -- Y/N  (optional field)
  banned_files_lover   VARCHAR(1),      -- Y/N  (optional field)

so I dropped the tables it already created and took out the default (as im
not sure why there would be a default value in a serial type field)  and ran
it.. it worked :D

Hope this helps =)
Take Care guys and thanks for such a rad framework