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

[Pierre Baudracco]

Hello Patrice,

your posts didn't end in the mailling list as you haven't suscribe.
Here it is !

Bye

LAUZELY Patrice wrote:
> 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



-- 
------------------------------------------------------------------------------
Pierre Baudracco - pierre.baudracco@aliacom.fr
ALIACOM - www.aliacom.fr - Toulouse : 05 62 19 24 91 - Paris : 01 48 25 53 13