[sql] Failed to execute: /*==============================================================*/ /* Table structure for table directory_file */ /*==============================================================*/ CREATE TABLE directory_file ( id_file INT DEFAULT 0 NOT NULL, title LONGVARCHAR DEFAULT NULL, id_physical_file INT DEFAULT NULL, file_size INT DEFAULT NULL, mime_type VARCHAR(255) DEFAULT NULL, extension VARCHAR(50) DEFAULT NULL, date_expiration TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (id_file) )
[sql] Failed to execute: /*==============================================================*/ /* Init table directory_action */ /*==============================================================*/ REPLACE INTO directory_action VALUES (1, 'directory.action.modify.name', 'directory.action.modify.description', 'jsp/admin/plugins/directory/ModifyDirectory.jsp', 'edit', 'MODIFY', 0)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (2, 'directory.action.modify.name', 'directory.action.modify.description', 'jsp/admin/plugins/directory/ModifyDirectory.jsp', 'edit', 'MODIFY', 1)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (3, 'directory.action.manage_record.name', 'directory.action.manage_record.description', 'jsp/admin/plugins/directory/ManageDirectoryRecord.jsp', 'folder-open', 'MANAGE_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (4, 'directory.action.manage_record.name', 'directory.action.manage_record.description', 'jsp/admin/plugins/directory/ManageDirectoryRecord.jsp', 'folder-open', 'MANAGE_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (5, 'directory.action.import_record.name', 'directory.action.import_record.description', 'jsp/admin/plugins/directory/ImportDirectoryRecord.jsp', 'upload', 'IMPORT_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (6, 'directory.action.import_record.name', 'directory.action.import_record.description', 'jsp/admin/plugins/directory/ImportDirectoryRecord.jsp', 'upload', 'IMPORT_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (7, 'directory.action.delete_all_directory_record.name', 'directory.action.delete_all_directory_record.description', 'jsp/admin/plugins/directory/ConfirmRemoveAllDirectoryRecord.jsp', 'trash-o', 'DELETE_ALL_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (8, 'directory.action.delete_all_directory_record.name', 'directory.action.delete_all_directory_record.description', 'jsp/admin/plugins/directory/ConfirmRemoveAllDirectoryRecord.jsp', 'trash-o', 'DELETE_ALL_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (9, 'directory.action.disable.name', 'directory.action.disable.description', 'jsp/admin/plugins/directory/ConfirmDisableDirectory.jsp', 'remove', 'CHANGE_STATE', 1)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (10, 'directory.action.enable.name', 'directory.action.enable.description', 'jsp/admin/plugins/directory/DoEnableDirectory.jsp', 'check', 'CHANGE_STATE', 0)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (11, 'directory.action.copy.name', 'directory.action.copy.description', 'jsp/admin/plugins/directory/DoCopyDirectory.jsp', 'clone', 'COPY', 0)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (12, 'directory.action.copy.name', 'directory.action.copy.description', 'jsp/admin/plugins/directory/DoCopyDirectory.jsp', 'clone', 'COPY', 1)
[sql] Failed to execute: REPLACE INTO directory_action VALUES (13, 'directory.action.delete.name', 'directory.action.delete.description', 'jsp/admin/plugins/directory/ConfirmRemoveDirectory.jsp', 'trash', 'DELETE', 0)
[sql] Failed to execute: /*==============================================================*/ /* Init table directory_record_action */ /*==============================================================*/ REPLACE INTO directory_record_action VALUES (1, 'directory.action.modify.name', 'directory.action.modify.description.record', 'jsp/admin/plugins/directory/ModifyDirectoryRecord.jsp', 'edit', 'MODIFY_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (2, 'directory.action.modify.name', 'directory.action.modify.description.record', 'jsp/admin/plugins/directory/ModifyDirectoryRecord.jsp', 'edit', 'MODIFY_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (3, 'directory.action.copy.name', 'directory.action.copy.description', 'jsp/admin/plugins/directory/DoCopyDirectoryRecord.jsp', 'clone', 'COPY_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (4, 'directory.action.copy.name', 'directory.action.copy.description', 'jsp/admin/plugins/directory/DoCopyDirectoryRecord.jsp', 'clone', 'COPY_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (5, 'directory.action.delete.name', 'directory.action.delete.description', 'jsp/admin/plugins/directory/ConfirmRemoveDirectoryRecord.jsp', 'trash', 'DELETE_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (6, 'directory.action.disable.name', 'directory.action.disable.description', 'jsp/admin/plugins/directory/ConfirmDisableDirectoryRecord.jsp', 'remove', 'CHANGE_STATE_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (7, 'directory.action.enable.name', 'directory.action.enable.description', 'jsp/admin/plugins/directory/DoEnableDirectoryRecord.jsp', 'check', 'CHANGE_STATE_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (8, 'directory.action.delete.name', 'directory.action.delete.description', 'jsp/admin/plugins/directory/ConfirmRemoveDirectoryRecord.jsp', 'trash', 'DELETE_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (9, 'directory.action.history.name', 'directory.action.history.description', 'jsp/admin/plugins/directory/ResourceHistory.jsp', 'list', 'HISTORY_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (10, 'directory.action.history.name', 'directory.action.history.description', 'jsp/admin/plugins/directory/ResourceHistory.jsp', 'list', 'HISTORY_RECORD', 1)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (11, 'directory.actions.title.visualisation', 'directory.actions.title.visualisation', 'jsp/admin/plugins/directory/DoVisualisationRecord.jsp', 'eye', 'VISUALISATION_RECORD', 0)
[sql] Failed to execute: REPLACE INTO directory_record_action VALUES (12, 'directory.actions.title.visualisation', 'directory.actions.title.visualisation', 'jsp/admin/plugins/directory/DoVisualisationRecord.jsp', 'eye', 'VISUALISATION_RECORD', 1)
[sql] Failed to execute: INSERT INTO directory_physical_file (id_physical_file, file_value) VALUES (2,'<?xml version="1.0"?>rn<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">rn <xsl:output method="text"/>rnrn <xsl:template match="directory">rn <xsl:apply-templates select="list-entry/entry"/>rn <xsl:apply-templates select="list-entry/status"/>rn <xsl:if test="count(//partialexport)=0">rn <xsl:text> </xsl:text>rn </xsl:if>rn <xsl:apply-templates select="list-record/record"/>rn </xsl:template>rn rn <xsl:template match="record">rn <xsl:apply-templates select="list-entry/entry/list-record-field"/>rn <xsl:if test="status = true()">rn <xsl:text>;"</xsl:text>rn <xsl:value-of disable-output-escaping="yes" select="status"/>rn <xsl:text>"</xsl:text>rn </xsl:if>rn <xsl:if test="count(//partialexport)=0">rn <xsl:text> </xsl:text>rn </xsl:if>rn </xsl:template>rn rn <xsl:template match="list-record-field">rn <xsl:text>"</xsl:text>rn <xsl:apply-templates select="record-field"/>rn <xsl:text>"</xsl:text>rn <xsl:if test="position()!=last()">rn <xsl:text>;</xsl:text>rn </xsl:if>rn </xsl:template>rn rn <xsl:template match="entry">rn <xsl:text>"</xsl:text>rn <xsl:if test="@showxy = ''true''">rn <xsl:value-of select="title"/>rn <xsl:text>_X</xsl:text>rn <xsl:text>,</xsl:text>rn <xsl:value-of select="title"/>rn <xsl:text>_Y,</xsl:text>rn <xsl:value-of select="title"/>rn <xsl:text>_provider,</xsl:text>rn </xsl:if>rn <xsl:value-of select="title"/>rn <xsl:if test="@showxy = ''true''">rn <xsl:text>_address</xsl:text>rn </xsl:if>rn <xsl:text>"</xsl:text>rn <xsl:if test="position()!=last()">rn <xsl:text>;</xsl:text>rn </xsl:if>rn </xsl:template>rnrn <xsl:template match="status">rn <xsl:if test="@display=''yes''">rn <xsl:text>;"status";</xsl:text>rn </xsl:if>rn </xsl:template>rn rn <xsl:template match="record-field">rn <xsl:choose>rn <xsl:when test="../@geolocation = ''true''">rn <xsl:if test="../../@showxy = ''true''">rn <xsl:if test="@title = ''X''">rn <xsl:value-of disable-output-escaping="yes" select="record-field-value"/>rn <xsl:text>,</xsl:text>rn </xsl:if>rn <xsl:if test="@title = ''Y''">rn <xsl:value-of disable-output-escaping="yes" select="record-field-value"/>rn <xsl:text>,</xsl:text>rn </xsl:if>rn <xsl:if test="@title = ''provider''">rn <xsl:value-of disable-output-escaping="yes" select="record-field-value"/>rn <xsl:text>,</xsl:text>rn </xsl:if>rn </xsl:if>rn <xsl:if test="@title = ''address''">rn <xsl:value-of disable-output-escaping="yes" select="record-field-value"/>rn </xsl:if>rn </xsl:when>rn <xsl:otherwise>rn <xsl:value-of disable-output-escaping="yes" select="record-field-value"/>rn <xsl:if test="position()!=last()">rn <xsl:text>,</xsl:text>rn </xsl:if>rn </xsl:otherwise>rn </xsl:choose>rn </xsl:template>rn rn</xsl:stylesheet>rn')
[sql] Failed to execute: INSERT INTO directory_physical_file (id_physical_file, file_value) VALUES (4,'<?xml version="1.0"?>rn<xsl:stylesheet version="1.0"rn xmlns:xsl="http://www.w3.org/1999/XSL/Transform">rn rn <xsl:param name="title-descriptive" />rn <xsl:param name="title-sort-asc" />rn <xsl:param name="title-sort-desc" />rn rn <xsl:output method="html" indent="yes" />rnrn <xsl:template match="directory">rn rn <table class="table table-striped" name="results_list" id="results_list">rn <tr>rn <th> </th>rn <xsl:apply-templates select="list-entry/entry" />rn <xsl:apply-templates select="list-entry/status" />rn </tr>rn rn <xsl:apply-templates select="list-record/record"/>rn </table>rn </xsl:template>rnrn <xsl:template match="record">rn <tr>rn <td class="link-directory-record">rn <a class="btn btn-primary btn-small" href="jsp/site/Portal.jsp?page=directory&id_directory_record={@id}&view_directory_record=1" title="{$title-descriptive}">rn <i class="icon-eye-open icon-white"></i><span class="glyphicon glyphicon-search"></span>rn </a>rn </td>rn <xsl:apply-templates select="list-entry/entry/list-record-field" />rn <td><xsl:value-of disable-output-escaping="yes" select="status" /></td>rn </tr>rn </xsl:template>rnrn <xsl:template match="list-record-field">rn <xsl:choose>rn <xsl:when test="position()=1">rn <td class="first-record-field">rn <xsl:choose>rn <xsl:when test="@geolocation = ''true''">rn <xsl:call-template name="field-geolocalisation" />rn </xsl:when>rn <xsl:otherwise>rn <xsl:apply-templates select="record-field" />rn </xsl:otherwise>rn </xsl:choose>rn </td>rn </xsl:when>rn <xsl:otherwise> rn <td>rn <xsl:choose>rn <xsl:when test="@geolocation = ''true''">rn <xsl:call-template name="field-geolocalisation" />rn </xsl:when>rn <xsl:otherwise>rn <xsl:apply-templates select="record-field" />rn </xsl:otherwise>rn </xsl:choose>rn </td>rn </xsl:otherwise>rn </xsl:choose>rn </xsl:template>rnrn <xsl:template match="entry">rn <xsl:variable name="id-directory" select="../../@id" />rn <th>rn <xsl:if test="@is-sortable = ''true''">rn <a class="sort" id="sort" href="jsp/site/Portal.jsp?page=directory&id_directory={$id-directory}&sorted_attribute_name={@id}&asc_sort=true#sort" title="{$title-sort-asc}">rn <i class="icon-chevron-up"></i>rn </a>rn <a class="sort" href="jsp/site/Portal.jsp?page=directory&id_directory={$id-directory}&sorted_attribute_name={@id}&asc_sort=false#sort" title="{$title-sort-desc}">rn <i class="icon-chevron-down"></i>rn </a>rn </xsl:if>rn <span><xsl:value-of select="title" /></span>rn </th>rn </xsl:template>rnrn <xsl:template match="record-field"> rn rn <xsl:variable name="type-recordfield" select="@type-entry" />rn <xsl:variable name="show" select="@isShownInList" />rn <xsl:choose>rn <xsl:when test="$type-recordfield=''10''">rn <xsl:text> </xsl:text>rn </xsl:when>rn <xsl:when test="not(string(record-field-value)='''')"> rn <xsl:value-of disable-output-escaping="yes"rn select="record-field-value" />rn </xsl:when> rn <xsl:otherwise>rn <xsl:text> </xsl:text>rn </xsl:otherwise>rn </xsl:choose> rn <xsl:choose>rn <xsl:when test="$type-recordfield=''10'' and $show=''false''"> rn <xsl:text> </xsl:text>rn </xsl:when>rn <xsl:otherwise> rn <xsl:apply-templates select="file" />rn </xsl:otherwise>rn </xsl:choose> rn <br />rn </xsl:template>rnrn <xsl:template match="file">rn <xsl:variable name="id" select="@id" />rn <xsl:variable name="type" select="@type-entry" />rn <xsl:variable name="height" select="./height" />rn <xsl:variable name="width" select="./width" />rn <xsl:if test="child::node()">rn <xsl:choose> rn <xsl:when test="$type=''10''">rn <xsl:choose>rn <xsl:when test="$height!=''-1'' and $width!=''-1''">rn <img src="image?resource_type=directory_entry_img&id={$id}" height="{$height}" width="{$width}" />rn </xsl:when>rn <xsl:when test="$height=''-1'' and $width!=''-1''">rn <img src="image?resource_type=directory_entry_img&id={$id}" width="{$width}" />rn </xsl:when>rn <xsl:when test="$height!=''-1'' and $width=''-1''">rn <img src="image?resource_type=directory_entry_img&id={$id}" height="{$height}" />rn </xsl:when>rn <xsl:otherwise>rn <img src="image?resource_type=directory_entry_img&id={$id}"/>rn </xsl:otherwise>rn </xsl:choose>rn </xsl:when>rn <xsl:otherwise>rn rn <a href="jsp/site/plugins/directory/DoDownloadFile.jsp?id_file={$id}">rn <xsl:value-of disable-output-escaping="yes"rn select="title" />( <xsl:value-of disable-output-escaping="yes"rn select="size" /> O)rn </a>rn </xsl:otherwise>rn </xsl:choose>rn </xsl:if>rn <br />rn </xsl:template>rn <xsl:template match="status">rn <xsl:choose>rn <xsl:when test="@display=''yes''">rn <th>Statut</th>rn </xsl:when>rn <xsl:otherwise>rn <th> </th>rn </xsl:otherwise>rn </xsl:choose>rn rn </xsl:template>rn rn <xsl:template name="field-geolocalisation">rn <input type="hidden" name="record_id">rn <xsl:attribute name="value"><xsl:value-of disable-output-escaping="yes" select="../../../@id"/></xsl:attribute>rn </input>rn <xsl:if test="../../../status/@icon > 0">rn <input type="hidden" name="state_icon">rn <xsl:attribute name="value">image?resource_type=workflow_icon_img&id=<xsl:value-of disable-output-escaping="yes" select="../../../status/@icon"/></xsl:attribute> rn </input>rn </xsl:if>rn <input type="hidden" name="geolocation">rn <xsl:attribute name="value"><xsl:value-of disable-output-escaping="yes" select="../@id" /></xsl:attribute>rn </input>rn rn <input type="hidden" name="title">rn <xsl:attribute name="value"><xsl:value-of disable-output-escaping="yes" select="../../entry[position()=1]/list-record-field/record-field[position()=1]/record-field-value" /></xsl:attribute>rn </input>rn rn <input type="hidden">rn <xsl:attribute name="name">x</xsl:attribute>rn <xsl:attribute name="id">x</xsl:attribute>rn <xsl:attribute name="value"><xsl:value-of disable-output-escaping="yes" select="record-field[@title=''X'']" /></xsl:attribute>rn </input>rn rn <input type="hidden">rn <xsl:attribute name="name">y</xsl:attribute>rn <xsl:attribute name="id">y</xsl:attribute>rn <xsl:attribute name="value"><xsl:value-of disable-output-escaping="yes" select="record-field[@title=''Y'']" /></xsl:attribute>rn </input>rn <xsl:value-of disable-output-escaping="yes" select="record-field[@title=''address'']" />rn </xsl:template>rn</xsl:stylesheet>rnrnrn')
[sql] Failed to execute: /*==============================================================*/ /* Init table directory_file */ /*==============================================================*/ INSERT INTO directory_file (id_file, title, id_physical_file, file_size, mime_type) VALUES (1,'export_directory_xml.xsl',1,1802,'text/xml')
[sql] Failed to execute: INSERT INTO directory_file (id_file, title, id_physical_file, file_size, mime_type) VALUES (2,'export_directory_csv.xsl',2,1261,'text/xml')
[sql] Failed to execute: INSERT INTO directory_file (id_file, title, id_physical_file, file_size, mime_type) VALUES (3,'form_search_style.xsl',3,294,'text/xml')
[sql] Failed to execute: INSERT INTO directory_file (id_file, title, id_physical_file, file_size, mime_type) VALUES (4,'result_list_style.xsl',4,2758,'text/xml')
[sql] Failed to execute: INSERT INTO directory_file (id_file, title, id_physical_file, file_size, mime_type) VALUES (5,'result_record_style.xsl',5,5935,'text/xml') 
