[TYPO3-project-realty] Displayed hidden and deleted pics

[Florian Köhler]

If anybody else has this problem, a simple solution for shown but not 
displayed thumbnail images in gallery view is changing the query in

private function countImages() (file: class.ty_realty_p1.php) to:



$dbResult = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
			'COUNT(*) as number',
			REALTY_TABLE_IMAGES,
			'realty_object_uid=' . $this->internal['currentRow']['uid'].' AND 
deleted=0'
		);

This probem (in my case?)  properly  has a more complex background: If 
there is an openImmo update of an object (with images), the images of 
this object are also stored in the zip File, which will be uploaded to 
FTP import folder. After the cronjob update, these images are stored as 
a copy in the upload folder and as new entry in db. The deleted-flag of 
the older db entries is set to '1'. But old images and db entries will 
never be deleted by the  import-script.



Florian Köhler schrieb:
> Hi Oliver,
> 
> I'm still using vers. 0.3.0 of realty. I'm sorry, but i can´t try vers 
> 0.3.1 at the moment, because the site is already online. The error is 
> only in gallery view. I guess the problem can be fixed by a simple 
> change of db query: .... and deleted='0'
> 
> 
> 
> Oliver Klee schrieb:
>> Hi Flo,
>>
>> Florian Köhler schrieb:
>>> I have the same problems with the "not shown pics". In my
>>> case, this problem I figured out has nothing to do with deleted pics in
>>> front or backend. The same thing is happening in my system, whenever I
>>> update an already existing record via open immo import. After the
>>> import, the old pics are in db and also copies of these with an ending
>>> (f.e. _02).
>>
>> Which version of realty are you using? Does this problem still happen
>> with latest released version realty 0.3.1?
>>
>> Best regards,
>>
>>
>> Oliver