Re: problems with branch-1.7

Piotras wrote:
> Tarjei Huse <tarjei-y/[email protected]> wrote:
> 
>> Hi, I tested a fresh checkout of branch-1-7 today.
>>
>> It compiled fine, but then it was still missing the column
>> repligard.author. It seems to me that this may be because the file
>> repligard.sql contains two statements, one adding the author field and
>> the other adding a locked field. The problem is that this happens when
>> the file is added to the mysql db:
>> midcom:/opt/lampp/share/midgard# /opt/lampp/bin/mysql midgard <
>> repligard.sql
>> ERROR 1060 (42S21) at line 1: Duplicate column name 'locked'
> 
> Yes, but we use -f switch for mysql, so all statements from this file should 
> be executed even if error happens. 
>  
>> Testing this after removing the line proved that this .sql file is not
>> in use by datagard (or so it seemed).

> empty.sql seems to be untouched since 1.4.
> We use additional queries and files to alter tables.

Why isn't repligard.sql run then? That would have solved my problem :-)
T

>> I then tried to patch empty.sql to see if that would remove the problem
>> of "ais_topic" not found (that was my original problem). It did.
>>
>> So, I end up thinking that the problem is that current empty.sql in
>> branch-1-7 is missing this patch:
>> @@ -328,6 +328,7 @@
>>    guid varchar(80) NOT NULL default '',
>>    action enum('create','update','delete') NOT NULL default 'create',
>>    sitegroup int(11) NOT NULL default '0',
>> +  author int(11) NOT NULL default '0',
>>    creator varchar(80) NOT NULL default '',
>>    created datetime NOT NULL default '0000-00-00 00:00:00',
>>    revisor varchar(80) NOT NULL default '',
>>
>> Is this correct?
> 
> Looks like. I will add author and locked then.
> 
> Piotras
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe-b5ZhpPVuLA+tlBvVaVFjCkB+6BGkLq7r@public.gmane.org
> For additional commands, e-mail: [email protected]
>