These are chat archives for collectiveaccess/support

May 2017
Karl Becker
May 23 2017 08:10
hi! One question concerning Pawtucket2: is it possible to set the sorting of related objects in detail pages to the title in alphabetic order instead IDs as it is now? Right now, when I’m on the detail page for an entity, the related objects (Verknüpfte Objekte) look like this:
In ca_entities_default_html.php in my Pawtucket theme there is this part of code which I assume pulls the related objects. would it be possible to change the sorting order and if so, where do I start? Thanks a lot for every input!
{{{<ifcount code="ca_objects" min="1">
                    <div class="row">
                        <div class='col-md-6 col-lg-6'><p><h5>Verknüpfte Objekte</h5></p><HR></div>
                        <div id="browseResultsContainer">
                        <?php print caBusyIndicatorIcon($this->request).' '.addslashes(_t('Loading...')); ?>
                            </div><!-- end browseResultsContainer -->
                        </div><!-- end row -->
                        <script type="text/javascript">
                jQuery(document).ready(function() {
                    jQuery("#browseResultsContainer").load("<?php print caNavUrl($this->request, '', 'Search', 'objects', array('search' => 'entity_id:^ca_entities.entity_id'), array('dontURLEncodeParameters' => true)); ?>", function() {
                            autoTrigger: true,
                            loadingHtml: '<?php print caBusyIndicatorIcon($this->request).' '.addslashes(_t('Loading...')); ?>',
                            padding: 20,
                            nextSelector: 'a.jscroll-next'
May 23 2017 13:05

Hi, we suddenly started receiving below given error for an older version of providence (1.4). For many years it is running fine with mysql version 5.6.29. We have about 50000 records in our database. Any clue to solve this problem?

Error 250: Invalid SQL statement
Lock wait timeout exceeded; trying restarting transation(in Db->mysql->execute())
Request halted. Error 250: Invalid SQL statement
Deadlock found when trying to get lock; try restarting transation(in Db->mysql->execute())
Request halted.

May 23 2017 13:28
Hi , I am new to Collective access. I have installed both Providence and Pawtucket2 on my local system. Both are using same Database. The issue is related with my media files like images. How I can use same media files for both? . Please help
Karl Becker
May 23 2017 17:08
@salmansaleel "By default Pawtucket will serve media uploaded in Providence out of the media directory in the root of its installation directory. To ensure that Pawtucket can find your media create a symbolic link called media from the media directory in your Providence installation to the root of your Pawtucket installation."(see You have to create a Symlink to the media folder of providence