Premis with error

[tiago...@rfs.pt]

Hello everyone,

We are having some issues with our AtoM.

We are running it under Ubuntu 16.04 and the application version is 2.4.0 - 156

When we go to Settings and choose Permissions and change any of the values and we try to save we get an Error 500.

We tried to export the sql tables and import them in a clean install and the problem persists which tells us that the problem is in our database.

Has anyone ever had this problem?

In addition does anyone have like a map of all the sql tables? A way to figure out which tables are connected with each other so that we can see if we can figure out where the problem is?

Thanks in advance.

[Ricardo Pinho]

Hi Tiago,
Just some suggestions:

>  When we go to Settings and choose Permissions and change any of the values and we try to save we get an Error 500.

I've noticed that your install has no data:
http://biblio.rfs.pt:11000/index.php/informationobject/browse?topLod=0
Are you able to create data without error?
During installation, did you run the SQL to give atom user the nedded permissions?
https://www.accesstomemory.org/pt/docs/2.4/admin-manual/installation/linux/ubuntu-xenial/#create-the-database
mysql -h localhost -u root -p -e "GRANT ALL ON atom.* TO 'atom'@'localhost' IDENTIFIED BY '12345';"
(I recommend: Additionally, it’s always a good idea to create a specific MySQL user for AtoM to keep things safer)

> In addition does anyone have like a map of all the sql tables? A way to figure out which tables are connected with each other so that we can see if we can figure out where the problem is?

There is a nice Steve Breker (Artefactual) presentation explaning how to use atom database:

https://pt.slideshare.net/accesstomemory/constructing-sql-queries-for-atom

And you can find the database ERD on wiki: 

https://wiki.accesstomemory.org/Development/ERDs

Best regards...

<tiago...@rfs.pt> escreveu no dia segunda, 30/07/2018 à(s) 13:32:

additionally i recover this from the log

2018/07/30 13:27:47 [error] 1130#1130: *1135 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function setValue() on null in /usr/share/nginx/atom/apps/qubit/modules/settings/actions/permissionsAction.class.php:94

Stack trace:

#0 /usr/share/nginx/atom/cache/qubit/prod/config/config_core_compile.yml.php(966): SettingsPermissionsAction->execute(Object(sfWebRequest))

#1 /usr/share/nginx/atom/cache/qubit/prod/config/config_core_compile.yml.php(961): sfExecutionFilter->executeAction(Object(SettingsPermissionsAction))

#2 /usr/share/nginx/atom/cache/qubit/prod/config/config_core_compile.yml.php(947): sfExecutionFilter->handleAction(Object(sfFilterChain), Object(SettingsPermissionsAction))

#3 /usr/share/nginx/atom/cache/qubit/prod/config/config_core_compile.yml.php(1045): sfExecutionFilter->execute(Object(sfFilterChain))

#4 /usr/share/nginx/atom/vendor/symfony/lib/filter/sfCacheFilter.class.php(65): sfFilterChain->execute()

#5 /usr/share/nginx/atom/cache/qubit/prod/config/config_core_compile.yml.php(1045): sfCacheFilter->execute(Object(sfFilt" while reading response header from upstream, client: 81.84.249.147, server: _, request: "POST /index.php/settings/permissions HTTP/1.1", upstream: "fastcgi://unix:/run/php7.0-fpm.atom.sock:", host: "biblio.rfs.pt:11000", referrer: "http://biblio.rfs.pt:11000/index.php/settings/permissions"

--
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-user...@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/f0461c06-c8ae-4b37-af9a-59aa9e46de2b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ricardo Pinho

[tiago...@rfs.pt]

Hello Ricardo,

We are running some tests so at the moment the virtual machine is blank and we are experimenting some solutions, with no result so far.

Yes we gave every permission, and we were able to create new records

[Dan Gillean]

Hi Tiago, 

Was this test instance upgraded from an earlier version? If so, did you remember to run the sql-upgrade task?

It sounds like there could be a database schema migration that was not run for some reason. You could try the following and see if it helps - especially if your site is empty or you don't need to preserve any data. Note that if you DO have data you need to preserve, save it now, and load it again later - the following will destroy any data present! 

First we will run the tools:purge command to remove all data. We'll run it with the --demo option so it creates a user account named demo, with the following login credentials: 

• email: de...@example.com
• password: demo

Note: if you run the command WITHOUT the --demo option, AtoM will prompt you to create a new site title, description, user name, email, and password. Try: 

• php symfony tools:purge --demo

Now let's drop and recreate the AtoM database for good measure. The following command assumes your MySQL database user and pass are root, and your database name is atom - please make changes as needed if this is not the case: 

• mysql -u root -proot -e 'drop database atom; create database atom character set utf8 collate utf8_unicode_ci;'
  

If you have saved data, now would be the time to reload it. 

Now let's try running the sql-upgrade task. Try: 

• php symfony tools:upgrade-sql

You might want to restart services after this, and clear the application cache. 

Let us know if it helps! 

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

@accesstomemory

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-atom-users@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/e43b016b-5bf9-40da-bc85-0c2d33c5ba0c%40googlegroups.com.

[Gomes Silva]

Hello everyone,

This is also happening to me, but hasn't anything to do with upgrade. I'm using AtoM 2.4 on Ubuntu 16. Installed using the official instructions.

I believe this to be a bug, because I can reproduce it in Artefactual's https://demo.accesstomemory.org/ as well.

This is what I did:

1. Change language to Portuguese

2. Go to Taxonomies, Rights basis

3. Add a new right basis (e.g. Test)

4. Go to Settings, Permissions

5. Change a checklist (e.g. copyright thumb) and press "save"

Then a perpetually "Page not found" will appear. No matter what you do, you cannot change (and save) PREMIS checklist ever again.

You can save any other tab setting, not the Permissions tab.

[Dan Gillean]

Hi Gomes,

Thank you for your report, it has helped me better understand what the original issue was. I actually ran into this bug during our recent AtoMCamp, and could reproduce it without having to change languages - so I think the issue is caused by adding new terms to the Rights Basis taxonomy, and then trying to update the corresponding permissions settings.

I am on a borrowed computer today unfortunately, so I can't reproduce this in a local test environment and file a bug, but I will very soon. I will post back here with an issue ticket link, and any further information I have.

Regards,

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

@accesstomemory

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/d682417c-0de3-4912-a646-d16bf52677d7%40googlegroups.com.

[Gomes Silva]

Thank you for your support Dan.

There should be other ways to trigger the bug, because I have another installation (clean install) were I didn't created a a new right basis and this bug appeared anyway. I just cannot reproduce it or find the cause.

Regards,

[José Anjos]

Hi.
I have the same problem.
I have attached some logs to try to help on debug.
Cheers

[Dan Gillean]

Hi José, 

Thank you for this. I have filed an issue ticket, and we are prioritizing it as one of the last bugs we'll address for the 2.4.1 release, since it is clearly affecting many users. Ticket here - I've added your error logs to it for reference:

• https://projects.artefactual.com/issues/12434
  

Regards, 

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

@accesstomemory

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/a5a0b24a-f332-409a-b866-ec6ed50fe0dc%40googlegroups.com.