Portales Municipales
Jan 12, 2021, 1:15:52 PM1/12/21
to AtoM Users
In
Rebuild search index and clear cache i have error:
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 'function function JOIN object object ON function.id = object.id WHERE object.cla' at line 1
Dan Gillean
Jan 12, 2021, 3:17:25 PM1/12/21
to ICA-AtoM Users
Hi there,
First: AtoM 2.5.x expects MySQL 5.7, while AtoM 2.6 expects MySQL 8.0. Please make sure that you have carefully reviewed the 2.6 installation documentation and updated all relevant dependencies. Note that we also recommend Ubuntu 18.04 and PHP 7.2 for AtoM 2.6!
Looking at the error message, the next thing I would suggest checking would be the SQL modes set in MySQL, and disabling/removing STRICT_TRANS_TABLES if it is enabled. I believe this might be enabled by default in 5.7 and later - however in the MySQL section of the installation docs for 2.6 we recommend setting different default SQL modes. See the bottom half of this section:
If you want to check or change the SQL modes of an installation, the following page might help:
If you're new to using the MySQL command prompt, we have basic instructions on how to access it, and how to find out your MySQL credentials if you don't know them, here:
If this STILL doesn't work, then one thing we could try next is repeating the upgrade process. Make sure you have your SQLdump outside of AtoM before proceeding!
After dropping and recreating the database, but BEFORE loading your backup, we can try to run the tools:purge command-line task. This will flush any data from the db, which can sometimes be useful after multiple installation attempts. Remember, be sure you have a copy of your sqldump outside of AtoM before running this - everything will be deleted!
- php symfony tools:purge
Now you can reload the sqldump, run the upgrade task, restart services, clear the application cache, re-index, and see if it helps.
Let us know if this helps.
Cheers,
he / him
On Tue, Jan 12, 2021 at 1:15 PM Portales Municipales <portalesm...@gmail.com> wrote:
In Rebuild search index and clear cache i have error: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 'function function JOIN object object ON function.id = object.id WHERE object.cla' at line 1
--
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/9a27c25c-26b4-4e8f-bfe6-03cac607f65cn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages