The following mysource_area in our design is causing a MySource Error. Strangely we have had this mysource_area (unchanged) since James Hunter built our design in October and it has produced drop down menus without problems until we upgraded to 3.6.4 last Friday.
[quote] <mysource_area id_name=“left_menu” design_area=“menu_normal”>
<mysource_set name=“level” value=“top”/>
<mysource_set name=“show_subs” value=“always”/>
<ul>
<mysource_asset>
<li>
<div class=“subnav-holder”>
<a href="<MySource_PRINT var=‘asset_link’ />"><mysource_print var=“asset_short_name” /></a>
<mysource_sub design_area=“menu_normal”>
<ul class=“subnav”>
<mysource_asset>
<li><a href="<MySource_PRINT var=‘asset_link’ />"><mysource_print var=“asset_name” /></a></li>
</mysource_asset>
</ul>
</mysource_sub>
</div>
</li><li class=“menuDivider”>|</li>
</mysource_asset>
</ul>
</mysource_area>[/quote]
Take the mysource_area out of the design and our web site is fine (but without much needed menus), put the area back in and we get the following error (also posted in http://forums.matrix.squiz.net/index.php?showtopic=1620)
[quote]MySource Error
File: [SYSTEM_ROOT]/core/include/assertions.inc Line: 504
Message: [ASSERT EXCEPTION] DB Error: invalid number
SELECT DISTINCT a.assetid, l.majorid, a.type_code, a.status, a.name, a.short_name, pt.path, l.sort_order FROM sq_ast a INNER JOIN sq_ast_lnk l ON a.assetid = l.minorid INNER JOIN sq_ast_path pt ON a.assetid = pt.assetid INNER JOIN sq_ast_perm p ON a.assetid = p.assetid WHERE l.majorid IN (61) AND BITAND(l.link_type, 1) > 0 AND p.userid IN ('0','7',7) GROUP BY a.assetid, l.majorid, a.type_code, a.status, a.name, a.short_name, pt.path, l.sort_order HAVING MIN(p.granted) <> 0 ORDER BY l.majorid, l.sort_order [nativecode=ORA-01722: invalid number] (LINE 193 IN [SYSTEM_ROOT]/data/private/assets/design_customisation/5643/design_file.php) [SYS0270]
Backtrace: Show [/quote]
Any help very much appreciated! 
Sarah