[Obm] MySQL Error Runing 'install_obmdb_0.9.mysql.sh'

[LAUZELY Patrice]

Hello,

Yes I finally did it by removing either 'default NULL' or 'DEFAULT 0' 
for each 'int(8)', int(1) and 'timestamp(14)' entries from 
"obm-0.9.3/scripts/0.9/create_obmdb_0.9.mysql.sql".

First, I found that since MySQL version 4.1 you can't specify a default 
value with 'auto_increment'.

I just found a page which is talking about kind of problems I got with 
"timestamp" fields too :
http://bugs.mysql.com/bug.php?id=2539

Some MySQL version seems to be buggy and refuse "default value" for some 
fields.

So if someone else is having the same problem, just remove the "default 
value"  where you get errors to fix the problem.
My Installation is working well anyway.

Regards,
Patrice.

>Did you succeed with this install at the end ?
>
>  
>
>>Hello list,
>>
>>I'm trying to install OBM on a RedHat Enterprise Linux v4 box.
>>obm-0.9.3
>>MySQL-4.1.10a-1.RHEL4.1
>>
>>When I run the mysql installation script (I configured it with good
>>login/pwd/dbname and french language ), I get this strange Mysql error :
>>ERROR 1067 (42000) at line 84: Invalid default value for 'userobm_id'
>>
>>Have you ever seen this kind of error ?
>>Maybe I forgot something...
>>Any trick is welcome.
>>
>>Thx
>>Patrice
>>    
>>
>
>
>  
>