Information duplicating itself

[FHYA]

Hi all

We seem to have a SERIOUS problem with information multiplying in the archival descriptions. This happens with titles, and with arrangement, and with radNotes. I cannot for the life of me figure out why this is happening. Attached are screenshots. Please advise. 

[FHYA]

Also please note that the information is obviously not duplicated in the excel spreadsheet and the csv. 

[Dan Gillean]

Hi Chloe, 

Interesting... So, I understand from your second email that these descriptions were created via CSV import? Might it be possible for me to take a look at the CSV file? If so, please feel free to send it to me off-list. 

In the meantime, the first thing I'd suggest is running a few of our maintenance commands and restarting services to see if this is just a display issue, and not actually written to the MySQL database. 

As a first step, I'd suggest: rebuilding the nested set, re-generating your slugs, and then clearing the cache, restarting PHP-FPM and memcached, and finally, repopulating the search index. Since you have a custom theme, you may also want to recompile the CSS for the theme. All of the following commands should be run from the root AtoM installation directory - if you've followed our recommended installation instructions, this is generally /usr/share/nginx/atom. 

Recompile your theme's CSS: 

To run this command, you will need to know the name of your theme plugin. It should be visible in the user interface in Admin > Themes. 

Below are instructions for recompiling the CSS for the base Dominion theme. You may want to run the command on both Dominion and your custom theme, if your custom theme extends the base Dominion theme. Here is how you'd do it for the Dominion theme: 

• make -C plugins/arDominionPlugin

Repeat the command for your custom theme, swapping in the name of the custom theme plugin where the above command says arDominionPlugin. 

Rebuilding the nested set: 

• php symfony propel:build-nested-set
• See: 
• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/cli-tools/#rebuild-the-nested-set
• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/troubleshooting/#rebuilding-the-nested-set

Regenerating slugs: 

Note: if you run this command with the --delete option, then any manual slug changes you have made (using the Rename module to edit slugs, for example) will be reset. Running the command without the --delete option means only slugs that are missing will be generated - the delete option will replace all slugs. 

• php symfony propel:generate-slugs --delete
• See: 
• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/cli-tools/#generate-slugs
• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/troubleshooting/#generating-slugs

Clear the application cache: 

• php symfony cc
• See: 
• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/clear-cache/
• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/troubleshooting/#clearing-the-application-cache

Restarting PHP-FPM and memcached:

On Ubuntu 14.04 with PHP 5.x: 

• sudo service php5-fpm restart
• sudo service memcached restart

On Ubuntu 16.04 with PHP 7.0: 

• sudo systemctl restart php7.0-fpm
• sudo systemctl restart memcached

See: 

• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/troubleshooting/#restarting-php-fpm
  
• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/troubleshooting/#restarting-memcached
  

Repopulating the search index: 

• php symfony search:populate
• See: 
• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/populate-search-index/
• https://www.accesstomemory.org/docs/2.5/admin-manual/maintenance/troubleshooting/#populating-the-search-index

IMPORTANT: Before testing to see if the above has helped, be sure to clear your browser cache as well, so you are seeing an updated version of the page! I recommend re-testing using a Private/Incognito browser window, since by default these tend not to use the browser's cache. 

Let us know if that makes a difference. If it doesn't, then you might try adding one of the affected records to the clipboard and exporting it - does the duplication show up in the export?

• If yes, then this suggests that the data might actually be duplicated in AtoM's MySQL database. If the descriptions were created via CSV import, then the issue may be with some element of the CSV - especially if you prepared it using Microsoft Excel. Excel tends to use its own custom character encoding and line endings, which can cause strange issues when importing to AtoM. See here for more info. 
• If no, then this suggests that it's either a display issue, or some bug in the code. If the above didn't resolve it, I'll have to check with our developers for further suggestions. You may also want to have a developer review your custom theme, and even try flipping your theme back to the base Dominion theme for a moment, to see if there's something in the theme code that is causing the issue. 

Let us know if running the above tasks helps!

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/bf43c021-9811-41e5-a982-b81d8eeb8e0d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.