I still think there's value in taking that query, replacing the question marks with their respective values, and running it directly against the database. If it fails, you keep removing parts of the input data until it works. Once it works, you can add parts back until you zero in on the data that is causing it to fail.
Additionally, I would simplify the problem for testing by creating a new table with one column for the input you posted, hook it up with transfer, and see if it still fails. If it doesn't fail, I'd then work backwards by slowly adding properties and relationships between my test tables until they match real tables and relationships and it fails. Debugging likes this will take time but it should lead you to the cause of the problem. - Gabriel On Mon, Nov 16, 2009 at 8:38 AM, dev-sg1 <[email protected]> wrote: > > Hello All, > > The sql query generated by Transfer which creates bug is : > > SELECT NULL as mnul_title, va_menu_1.mnu_mfd_id, NULL as mnul_lng_id, > va_menu_1.mnu_timestamp, NULL as mnul_mnu_id, va_menu_1.mnu_id, > va_menu_1.mnu_libelle_bo, NULL as mnul_html_content, NULL as > mnul_timestamp, '' as transfer_compositeid,NULL as transfer_parentKey, > 1 as transfer_orderIndex,'prestation.Menu' as transfer_className,'' as > transfer_parentClassName,'' as transfer_parentParentClassName,'' as > transfer_parentCompositeName,'false' as transfer_isArray,'' as > transfer_compositeName, 'false' as transfer_isProxied FROM va_menu > va_menu_1 WHERE va_menu_1.mnu_id = ? AND va_menu_1.mnu_id IS NOT > NULL UNION ALL SELECT va_menu_lng_2.mnul_title, NULL as mnu_mfd_id, > va_menu_lng_2.mnul_lng_id, NULL as mnu_timestamp, > va_menu_lng_2.mnul_mnu_id, NULL as mnu_id, NULL as mnu_libelle_bo, > va_menu_lng_2.mnul_html_content, va_menu_lng_2.mnul_timestamp, CAST > (va_menu_lng_2.mnul_lng_id as varchar(1000)) + '|' + CAST > (va_menu_lng_2.mnul_mnu_id as varchar(1000)) + '|' as > transfer_compositeid,CAST(va_menu_1.mnu_id as varchar(1000)) as > transfer_parentKey, 2 as transfer_orderIndex,'locale.Menu' as > transfer_className,'prestation.Menu' as transfer_parentClassName,'' as > transfer_parentParentClassName,'' as > transfer_parentCompositeName,'true' as transfer_isArray,'Locales' as > transfer_compositeName, 'false' as transfer_isProxied FROM va_menu > va_menu_1 INNER JOIN va_menu_lng va_menu_lng_2 ON va_menu_1.mnu_id = > va_menu_lng_2.mnul_mnu_id WHERE va_menu_1.mnu_id = ? ORDER BY > transfer_orderIndex ASC > > If anyone has an idea. > > Best Regards. > > Julien > > > --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
