[TYPO3-dam-devel] RFC Bugfix: 6639: SQL errors when using List module to create new item

Andreas Balzer andreasbalzer at gmail.com
Tue Feb 12 08:11:58 CET 2008


Hi,
I think Peter is right. We are not about releasing version 2 of DAM so this
is a plain bug fixing version with some but only a few new functionalites
inside. As the version is released it'll be safe to update the T3
installations following the manual. There shouldn't be any problems updating
the dam extension itself. However some minor problems might occur due to the
change of other service extensions used by DAM.

Anyway.. I'm for: Place a huge message telling people why they should update
(maybe this can be done with a podcast?)

And after all: The version of DAM that many people are using is not a
"stable" called version or is it? Things are likely to change then in my
opinion..

What do you think?

Greetings,
Andreas

On Feb 11, 2008 11:47 PM, Peter Kühn <peter.kuehn at wmdb.de> wrote:

>  > Can any one clarify your motivation?
>
> well, at least i can try by asking: what is the 1-0 branch good for?
> re-releasing the existing version for historical reasons?
>
> i still cant see your point.
>
> from my point of view: whats in the trunk is what will be in the
> upcoming release. the upcoming release will replace the bug with a
> working solution.
> this is the mission as i understand it: to be able to tell the people
> "version 1.0 had bugs. those are fixed in 1.1 - please update"
>
> am i wrong? then please explain slowly - im blonde.
>
>
>
> Michiel Roos schrieb:
> > Please please good people,
> >
> > We don't close a bug when it in fact does exist.
> >
> > I can go as far as:
> > "We ignore the bug for now and focus on the trunk"
> > - Even though a fix is supplied we will ignore this bug.
> > - When we have finished fixing all the bugs in the trunk we will get
> > back to you.
> >
> > My worry is now that after all the bugs have been fixed . . . this bug
> > will still be ignored because all of us are eager to work on new
> features.
> >
> > Can any one clarify your motivation?
> >
> > Kind regards,
> >
> > Michiel Roos
> >
> > Netcreators BV :: creation and innovation
> > www.netcreators.com
> >
> > Interesse in werken bij Netcreators?
> > http://www.netcreators.com/bedrijf/vacatures/
> >
> > On Feb 7, 2008, at 8:09 PM, Peter Kühn wrote:
> >
> >> I totally agree w/ ben.
> >>
> >> Request: close the ticket marked "resolved".
> >>
> >> pls ack.
> >>
> >> ben van 't ende [netcreators] schrieb:
> >>> Andreas Balzer wrote:
> >>>> Hi :)
> >>>> I asked nearly the same some days ago. As it seems like: yes :) Feel
> >>>> free to download the "old" version from TER ;)
> >>>>
> >>>> Although I would just tell the people to update to the newest
> >>>> version as
> >>>> soon as it is released..
> >>>
> >>> Hi,
> >>>
> >>> We should focus in the new release.
> >>>
> >>> gRTz
> >>>
> >>> ben
> >>>
> >>>
> >>>> Andreas
> >>>>
> >>>> On Dec 29, 2007 1:10 PM, Peter Kühn <peter.kuehn at wmdb.de
> >>>> <mailto:peter.kuehn at wmdb.de>> wrote:
> >>>>
> >>>>    Ola!
> >>>>
> >>>>    did i get this right? the reason why i tried to reproduce the bug
> >>>> for
> >>>>    about half an hour without success is, that it only exists in
> >>>> version
> >>>>    1-0 - the one we want to release asap with the version we´re
> working
> >>>>    on? ;)
> >>>>    do i really have to setup a historical version to prove a fix for
> a
> >>>>    historical bug?
> >>>>
> >>>>    You're not serious, are you?
> >>>>
> >>>>    pekue
> >>>>
> >>>>    Michiel Roos schrieb:
> >>>>> Hi,
> >>>>>
> >>>>> This is a svn patch request.
> >>>>>
> >>>>> Type: bugfix
> >>>>>
> >>>>> Problem: SQL errors are thrown when creating a new media record from
> >>>>> list mode.
> >>>>>
> >>>>> Cause:
> >>>>> tx_dam_fileUsage calls getMediaUsageReferences with a uid like:
> >>>>> 'NEW9834759453987'. This confuses getMediaUsageReferences in a bad
> >>>>    way.
> >>>>> It tries to control its own sanity by cleaning the passed in
> >>>>    uidlist using:
> >>>>> $GLOBALS['TYPO3_DB']->cleanIntList($uidList)
> >>>>>
> >>>>> That comes out '0' (zero).
> >>>>>
> >>>>> No other parameters are passed in, so the resulting $where ends up
> >>>>    empty
> >>>>> and the query fails.
> >>>>>
> >>>>> Responsibility lies with tx_dam_fileUsage which should not try to
> get
> >>>>> 'media usage references' for a non exising record.
> >>>>>
> >>>>> The attached patch checks if we are dealing with a new record using:
> >>>>>   if (strstr('NEW', $PA['row']['uid']) != '') {
> >>>>>      // get the media file ref
> >>>>>   }
> >>>>>
> >>>>> Branches:
> >>>>> 1-0
> >>>>> Not present in trunk.
> >>>>>
> >>>>> Kind regards,
> >>>>>
> >>>>>
> >>>>> Michiel Ros
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> ------------------------------------------------------------------------
> >>>>
> >>>>
> >>>>>
> >>>>> --- lib/class.tx_dam_tcefunc.php      2007-12-25
> >>>>    04:06:06.000000000 -0500
> >>>>> +++ lib/class.tx_dam_tcefunc.fix.php  2007-12-25
> >>>>    04:06:22.000000000 -0500
> >>>>> @@ -837,7 +837,9 @@
> >>>>>              $itemOut = '';
> >>>>>
> >>>>>              $itemOut .=
> >>>>
> >>>>
> '<h4>'.$LANG->sl('LLL:EXT:dam/lib/locallang.xml:fileReference').'</h4>';
> >>>>
> >>>>> -             $rows =
> >>>>    tx_dam_db::getMediaUsageReferences($PA['row']['uid'], '');
> >>>>> +             if (strstr('NEW', $PA['row']['uid']) != '') {
> >>>>> +                     $rows =
> >>>>    tx_dam_db::getMediaUsageReferences($PA['row']['uid'], '');
> >>>>> +             }
> >>>>>
> >>>>>              for ($index = 0; $index < 2; $index++) {
> >>>>>
> >>>>    _______________________________________________
> >>>>    TYPO3-team-dam mailing list
> >>>>    TYPO3-team-dam at lists.netfielders.de
> >>>>    <mailto:TYPO3-team-dam at lists.netfielders.de>
> >>>>
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-dam
> >>>>
> >>>>
> >>>>
> >>>>
> ------------------------------------------------------------------------
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> TYPO3-team-dam mailing list
> >>>> TYPO3-team-dam at lists.netfielders.de
> >>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-dam
> >>>
> >>>
> >> _______________________________________________
> >> TYPO3-team-dam mailing list
> >> TYPO3-team-dam at lists.netfielders.de
> >> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-dam
> >
> _______________________________________________
> TYPO3-team-dam mailing list
> TYPO3-team-dam at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-dam
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.netfielders.de/pipermail/typo3-team-dam/attachments/20080212/521f971c/attachment-0001.htm 


More information about the TYPO3-team-dam mailing list