<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic update alfresco problem in Alfresco Forum</title>
    <link>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29640#M12625</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;Hi,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;I upgraded my alfresco 4.0 &amp;gt; 4.2 &amp;gt; 5.0 &amp;gt; 5.2.&lt;BR /&gt;But in my current version (5.2) all working correct but number of tables is 101. But if I install alfresco from box it would be 74 (or 71 don't remember). Is it normal?&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;I am using alfresco 5.2. And after installing beCPG extention I have a lot of sql-scripts in&lt;/SPAN&gt;&lt;BR style="color: #727174; background-color: #ffffff;" /&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;alfresco\tomcat\temp\Alfresco&lt;/SPAN&gt;&lt;BR style="color: #727174; background-color: #ffffff;" /&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;And in&amp;nbsp;some scrips I see&amp;nbsp;&lt;/SPAN&gt;&lt;BR style="color: #727174; background-color: #ffffff;" /&gt;&lt;SPAN style="color: #727174; background-color: #ffffff; border: 0px;"&gt;INSERT IGNORE INTO alf_qname (ns_id,version,local_name) SELECT id,0, 'labelingLabelingTemplate' FROM alf_namespace WHERE uri = '&lt;/SPAN&gt;&lt;A href="http://www.bcpg.fr/model/quality/1.0" rel="nofollow noopener noreferrer" style="color: #1e88e5; background-color: #ffffff; border: 0px; text-decoration: none; padding: 0px calc(12px + 0.35ex) 0px 0px;" target="_blank"&gt;http://www.bcpg.fr/model/quality/1.0&lt;/A&gt;&lt;SPAN style="color: #727174; background-color: #ffffff; border: 0px;"&gt;' ;&lt;/SPAN&gt;&lt;BR style="color: #727174; background-color: #ffffff;" /&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;And IGNORE is not supported by postgres 9.4 which alfresco is using.&lt;/SPAN&gt;&lt;BR style="color: #727174; background-color: #ffffff;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;And can you explain me who add scripts to&amp;nbsp;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;alfresco\tomcat\temp\Alfresco directory and why. Should I execute this scripts on my database?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;I need your help!!!&lt;/SPAN&gt;&lt;BR style="color: #727174; background-color: #ffffff;" /&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;Best regards.&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 12 Oct 2017 06:23:00 GMT</pubDate>
    <dc:creator>faradey1791</dc:creator>
    <dc:date>2017-10-12T06:23:00Z</dc:date>
    <item>
      <title>update alfresco problem</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29640#M12625</link>
      <description>Hi,I upgraded my alfresco 4.0 &amp;gt; 4.2 &amp;gt; 5.0 &amp;gt; 5.2.But in my current version (5.2) all working correct but number of tables is 101. But if I install alfresco from box it would be 74 (or 71 don't remember). Is it normal?I am using alfresco 5.2. And after installing beCPG extention I have a lot</description>
      <pubDate>Thu, 12 Oct 2017 06:23:00 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29640#M12625</guid>
      <dc:creator>faradey1791</dc:creator>
      <dc:date>2017-10-12T06:23:00Z</dc:date>
    </item>
    <item>
      <title>Re: update alfresco problem</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29641#M12626</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;When you upgrade Alfresco it is normal to have more tables than for a fresh install. You are still carrying around the JBPM tables which will not be&amp;nbsp;created anymore for a new install. The patch to delete those JBPM tables is optional and not enabled by default, so they stick around.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The scripts in the temp directory are generated by Alfresco on-the-fly during the upgrade and already executed - you should do nothing with them.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 12 Oct 2017 08:13:20 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29641#M12626</guid>
      <dc:creator>afaust</dc:creator>
      <dc:date>2017-10-12T08:13:20Z</dc:date>
    </item>
    <item>
      <title>Re: update alfresco problem</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29642#M12627</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Alexandr, you already asked about the beCPG add-on SQL &lt;A _jive_internal="true" href="https://community.alfresco.com/thread/233746-update-alfresco-script" rel="nofollow noopener noreferrer"&gt;over here&lt;/A&gt;. You really need to ask beCPG about it.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 12 Oct 2017 17:51:29 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29642#M12627</guid>
      <dc:creator>jpotts</dc:creator>
      <dc:date>2017-10-12T17:51:29Z</dc:date>
    </item>
    <item>
      <title>Re: update alfresco problem</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29643#M12628</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Ok. thank you. I asked them, but they don't answer(( I solved it by executing script from&amp;nbsp;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;alfresco\tomcat\temp\Alfresco (after removing word IGNORE).&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Oct 2017 08:16:17 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/update-alfresco-problem/m-p/29643#M12628</guid>
      <dc:creator>faradey1791</dc:creator>
      <dc:date>2017-10-16T08:16:17Z</dc:date>
    </item>
  </channel>
</rss>

