Plain new AtoM 2.6 ->> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

Vincent Paillusson

unread,

Oct 8, 2020, 6:53:51 AM10/8/20

to AtoM Users

Hi Everyone,

I used AtoM 2.5.4 last year and decided to install a plain new 2.6 on another server.

I followed the intrsuctions here: https://www.accesstomemory.org/en/docs/2.6/admin-manual/installation/linux/ubuntu-bionic/

but I get the following error when I try to browse subjects:

[wrapped: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RECURSIVE aas AS
(
SELECT tb1.id, tb1.parent_id, 1 as lev
' at line 2]

or when I try to import EAD data:

Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RECURSIVE cte AS ( SELECT io1.id, io1.parent_id, io1.identifier,' at line 1

Can't get what's going on...

Thank you for any help or hint you could provide

Dan Gillean

unread,

Oct 8, 2020, 9:35:32 AM10/8/20

to ICA-AtoM Users

Hi Vincent,

Just going to start with ruling out some of the initial possibilities. First, what version of MySQL do you have installed? Both of these queries use recursive methods that are only supported in MySQL 8.0, which is what we recommend installing in the documentation. If you have tried upgrading in place and reusing an older MySQL version (such as 5.7), then you might see these types of errors.

Did you load your 2.5.4 data into your new 2.6 installation? If yes, did you remember to follow all the steps in our Upgrading documentation, including dropping and re-creating the database, running the upgrade tasks, and restarting services? See:

https://www.accesstomemory.org/docs/2.6/admin-manual/installation/upgrading/

Cheers,

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

@accesstomemory

he / him

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/9ab95eb7-3ef4-4c59-8ef2-a97362e25b94n%40googlegroups.com.

Vincent Paillusson

unread,

Oct 8, 2020, 12:37:22 PM10/8/20

to ica-ato...@googlegroups.com

Hi Dan,

Thank you for your quick answer. That was it. I thought I followed precisely the installation procedure but I missed this Mysql 8 thing.

It's working fine right now.

Cheers,

You received this message because you are subscribed to a topic in the Google Groups "AtoM Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ica-atom-users/_G7ec4qHspk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAC1FhZKATFPhMHBEHXk3ds%2BfGhjpQCGTTBPwh9t-%3De69Vk-Z3g%40mail.gmail.com.