Search

I'm using Symphony 2.3 and I'm trying to filter a select box link field. I'm using a parameter value as the filter value. The filter values I'm using should match the @handle of the linked items. I get the following error message when I test...

loadXML():
    StartTag: invalid element name in Entity, line: 166
    /home/jeffstreet/webapps/jeffstreet_climbing/symphony/lib/toolkit/class.xsltprocess.php:135

and this error in the XML when I debug...

MySQL Error (1066): Not unique table/alias: 't31' in query: SELECT SQLCACHE DISTINCT e.id, e.sectionid, e.author_id, UNIXTIMESTAMP(e.creation_date) AS creation_date FROM sym_entries AS e LEFT JOIN sym_entries_data_3 AS t31 ON e.id = t31.entryid LEFT JOIN sym_entries_data_7 AS t71 ON (e.id = t71.entryid) LEFT JOIN sym_entries_data_31 AS t31 ON (e.id = t31.entryid) WHERE 1

    AND `e`.`section_id` = '1' 
     AND (`t31`.date >= '1929-08-01 10:11:18'
            AND `t31`.date <= '2012-11-01 08:00:00' ) 
      AND (
        t7_1.value IN ('done')
        OR t7_1.handle IN ('done')
      )
     AND (`t31`.relation_id IN ('65') ) 
    ORDER BY (
        SELECT `ed`.value
        FROM sym_entries_data_3 AS `ed`
        WHERE entry_id = e.id
      ) DESC</error>

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details