Re: how to change a story's element_type in the database

OK I have also tried updating the element_type field from
1104 to 1  
in the story table for a few stories. But it doesn't seem to
have an  
impact.

When I go into the bricolage interface the particular
stories are  
still listed as being of the old story element_type. I tried
 
republish and no effect.

Is there another table in bricolage that needs to be updated
to allow  
a story element_type to be changed?

thank you
Dawn

On 12-Mar-07, at 1:34 AM, Scott Lanning wrote:

> On Sun, 11 Mar 2007, Dawn Buie wrote:
>> Is the problem that I would have to CREATE a new
story, that I  
>> can't change the element type of a story without
changing the id  
>> of the story?
>
> I would imagine so. The code isn't sophisticated enough
to check
> that all the subelements are identical and then decide
that it's okay
> to change the element type. You might change it
manually in the  
> database,
> the 'element__id' (or whatever it's called these days)
column in
> the 'story' table.
>
>> I'm also wondering what the purpose of the
bric_soap asset  
>> commands 'element_type_set' and 'element_type' are.
Wish there was  
>> more documentation on that.
>
> Originally it was only 'element'. Then I think I added
'element_type',
> corresponding to what was in the UI in version <=
1.8.
> But then 'element_type' was renamed to
'element_type_set'
> and 'element' was renamed to 'element_type'
(corresponding to UI  
> changes).
> Then both functionalites were merged, leaving only
'element_type'.
> Hilarity ensued.
>

On Mon, 12 Mar 2007, Dawn Buie wrote:
> OK I have also tried updating the element_type field
from 1104 to 1 in the 
> story table for a few stories. But it doesn't seem to
have an impact.
>
> When I go into the bricolage interface the particular
stories are still 
> listed as being of the old story element_type. I tried
republish and no 
> effect.
>
> Is there another table in bricolage that needs to be
updated to allow a story 
> element_type to be changed?

Probably story_container_tile, or whatever it's called in
1.10.
I'm just guessing, though, and there might be some member
tables
that have to be changed.

Please add it to http
://wiki.bricolage.cc/bin/view/Bric/UsefulSQL
if you figure it out.