[TYPO3-dev] Versioning and foreign field as label

[Michel Georgy - 4eyes GmbH]

Nobody any suggestions? 

Would be much appreciated.

Greets Michel 




On Oct 21, 2011, at 11:06 AM, Michel Georgy - 4eyes GmbH wrote:

> Hi all, 
> 
> There seems to be a little Problem if you work with versioning/workspaces and have a intermediate table where 
> the label of this table is a foreign field. 
> 
> If you create a new version in DRAFT Workspace there will be generated 2 records in database, an actual draft version and 
> a placeholder. And here's the problem in "class.t3lib_tcemain.php:883":
> 
> 	$newVersion_placeholderFieldArray[$TCA[$table]['ctrl']['label']] = '[PLACEHOLDER, WS#' . $this->BE_USER->workspace . ']';
> 
> As the label is a foreign field and therefore just a integer in our case, an error is shown because insertDB now tries to 
> save a string value ("PLACEHOLDER, WS#1") to the Integer field. 
> 
> As a workaround i changed the type of the column to varchar. In my opinion just suitable as a tempory solutions. 
> 
> Did i miss something? Any suggestions for better solutions or confirmations for this problem are appreciated. 
> 
> Best regards
> 
> Michel 
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev