Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Josh Reid 182 posts 258 karma points
    Sep 23, 2009 @ 13:19
    Josh Reid
    0

    TopicsList and CommentsLists not displaying

    Hi Guys

    I have an umbraco install of 4.0.2.1 on IIS 6 with MSSQL2005.

    The uForum package installed correctly and after publishing the forums under my homepage node in content tree, initial viewing appeared ok, displaying the forum overview macro on the base forum.

    But if I create a topic under one of the sub-forums, after posting, on that topic page i get the - Error parsing XSLT file: \xslt\forum-commentsList.xslt

    I have looked at the database tables and all appears correct, the forum node ids are listed and the relationships between those and topics look ok, member id is ok, and the comment relationships look ok as well...

    Any thoughts why the topicsList on the Forum page doesn't appear at all? And the commentList on the topic page throws a XSLT parse error?

    Also if i leave the comment reply field empty and post the form I get a nasty error:

    No node exists with id '0' --- Exception Details: System.ArgumentException: No node exists with id '0'

    Response.Redirect(uForum.Library.Xslt.NiceCommentUrl(c.TopicId, c.Id, 10));

    Any thoughts much appreciated! Thanks...

    Josh

  • Chris Koiak 700 posts 2626 karma points
    Sep 24, 2009 @ 10:56
    Chris Koiak
    0

    Hi Josh,

    It's probably that an invalid input is being passed to an xslt extension, e.g. passing -1 to GetNiceUrl, etc.

    I've never used uForum, but I can give you some basic xslt debugging hints.

    • Try saving the xslt in the developer section. This'll provide a much more detailed error
    • Try adding ?umbDebugShowTrace=true to the end of your url. This'll should display any xslt debugging errors
    • Remove the content from the xslt... add each line/section back in and keep checking until it falls over again. You've now found the offending section/line of code.

    Hope this helps.

  • Josh Reid 182 posts 258 karma points
    Sep 25, 2009 @ 01:14
    Josh Reid
    0

    Yeah thanks Chris...

    I have been trying all of those things, so going through the package installed xslt files it appears that the following is turning up no result/s:

    In topicsList:

    <xsl:variable name="topics" select="uForum.raw:Topics($currentPage/@id, $items, $p)//topic"/>

    And likewise in the commentsList:

    <xsl:variable name="topicID" select="number(umbraco.library:ContextKey('topicID'))"/>
    <xsl:variable name="topic" select="uForum.raw:Topic($topicID)/topics/topic"/>

    Anyone used the uForum come across this type of thing???

  • Josh Reid 182 posts 258 karma points
    Sep 25, 2009 @ 05:53
    Josh Reid
    0

    After some testing I have found output from <xsl:value-of select="uForum.raw:Topic($topicID)"/>

    System.ArgumentException: Keyword not supported: 'datalayer'. at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions&amp; userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at uForum.Businesslogic.Data.getDataSetFromSql(String connection, String sql, String tableName) at uForum.Businesslogic.Data.GetDataSetAsNode(String sql, String elementName)

    Do you think this is this an error in the uForum package dll or maybe in my web.config?

    Thanks!

  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Sep 25, 2009 @ 10:26
    Dirk De Grave
    0

    Hi Josh,

    How does the umbracoDbDSN app key's value look like (web.config) ?

    If using sql server (from what i can read in the exception), it should read as 

    server=.;database=db;user id=DBUSER;password=DBPASSWORD

     

    Cheers,

    /Dirk

  • Chris Koiak 700 posts 2626 karma points
    Sep 25, 2009 @ 10:49
    Chris Koiak
    0

    There's an old post about a similar issue here http://forum.umbraco.org/yaf_postst6604_Error-editing-a-Macro-using-TinyMCE-Keyword-not-supported-datalayer.aspx

    The solution seemed to be to remove the "datalayer=SqlServer " from the connection string.

  • Josh Reid 182 posts 258 karma points
    Sep 25, 2009 @ 15:23
    Josh Reid
    0

    It works! Indeed the solution was to remove the "datalayer=SqlServer " from the connection string.

    Thanks for your time guys ;)

     

Please Sign in or register to post replies

Write your reply to:

Draft