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

* Your Email Address
* Spam protection	Enter the letters below: .__ .__ .__ . .. . [__)[__)[__)\|__\|\ / \| \[__)[__)\| \| \/
Comment	> 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 > > > >
Attachment
Watch this ticket