Re: [Tikiwiki-devel] 3.0 to 4.1 filegals upgrade problem

[lindon <li...@ti...>]

I don't have any ideas, but am wondering if it's related to a pretty serious
problem with image gals reported here:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2892&trackerId=5&show=view.
For this one, trying to go to image galleries gives a system error with 4.0
when there is a parent/child gallery relationship. At least i think that's
the trigger, because I'm able to get rid of the error by setting all parent
id's to -1.

lindon

On Fri, Jan 1, 2010 at 7:53 AM, Jonny Bradley <jo...@ti...> wrote:

>
> I just upgraded a 3.0 site to 4.1 and the existing file gals disappeared. A
> new gallery called "File Galleries" was created with galleryId of 3, but the
> existing galleries (id's 1 and 2) still had parentId set to -1.
>
> By changing the parentId's to 3 i managed to get them to reappear, but this
> must be causing problems for others. I did have a look at the script
> responsible a while ago (20090811_filegals_container_tiki.sql), but was
> unable to fix it - i think it's because some versions of mysql don't support
> the select from select statement i think - this was on MySQL version 4.1.22
> on a shared host, so i can't upgrade it.
>
> Anyone got any ideas how to get round it?
>
> jb
>
>
>
> ------------------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> Tikiwiki-devel mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>