Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

On newer versions of MySQL/MariaDB, 'system' keyword can cause issues #3790

Closed
SaleSmart opened this issue Sep 4, 2020 · 3 comments
Closed
Labels
bug Undesired behaviour resolved A fixed issue
Milestone

Comments

@SaleSmart
Copy link

Hi,
I installed Cacti 1.2.10 on Ubuntu 20.0.4., and imported old Cacti (0.8f) database dump. Upgrade failed, there is an error only one line:
UPDATE cdef SET system=1 WHERE name LIKE '_%' Fail
What can I do to solve this issue?
Thanks in advance!

@TheWitness
Copy link
Member

What version of MariaDB?

@TheWitness TheWitness changed the title Cacti upgrade problem Error Upgrading Cacti from Pre 1.x from Recent MariaDB version Sep 7, 2020
TheWitness added a commit that referenced this issue Sep 7, 2020
Error Upgrading Cacti from Pre 1.x from Recent MariaDB version
@TheWitness TheWitness added bug Undesired behaviour resolved A fixed issue labels Sep 7, 2020
@TheWitness TheWitness added this to the 1.2.15 milestone Sep 7, 2020
@TheWitness
Copy link
Member

Okay, update the one modified file and try again. I'm pretty sure that "system" is now a reserved word in a modern MariDB/MySQL

@TheWitness
Copy link
Member

Yea, confirmed it was handled in other places. That fix should do you right.

@netniV netniV changed the title Error Upgrading Cacti from Pre 1.x from Recent MariaDB version When upgrading Cacti on later versions of MySQL/MariaDB, 'system' keyword can cause issues Nov 2, 2020
@netniV netniV changed the title When upgrading Cacti on later versions of MySQL/MariaDB, 'system' keyword can cause issues On newer versions of MySQL/MariaDB, 'system' keyword can cause issues Nov 2, 2020
@github-actions github-actions bot locked and limited conversation to collaborators Feb 1, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour resolved A fixed issue
Projects
None yet
Development

No branches or pull requests

2 participants