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

Offset is a reserved word in MariaDB 10.6 affecting Report #4424

Closed
seanmancini opened this issue Oct 15, 2021 · 7 comments
Closed

Offset is a reserved word in MariaDB 10.6 affecting Report #4424

seanmancini opened this issue Oct 15, 2021 · 7 comments
Labels
bug Undesired behaviour resolved A fixed issue
Milestone

Comments

@seanmancini
Copy link

Hey Guys,

Noticed while testing you get the following error when click the reporting tab

Cacti 1.2.19
Mariadb 10.6.4

2021-10-15 17:07:09 - CMDPHP SQL Backtrace: (/reports_admin.php[94]:reports(), /lib/html_reports.php[1584]:db_fetch_assoc(), /lib/database.php[501]:db_fetch_assoc_prepared(), /lib/database.php[515]:db_execute_prepared())
2021-10-15 17:07:09 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, '') AS cint FROM reports LEFT JOIN user_auth ON user_auth.id=reports....' at line 1 
@seanmancini seanmancini added bug Undesired behaviour unverified Some days we don't have a clue labels Oct 15, 2021
@TheWitness
Copy link
Member

Are there any reports on that page?

@bmfmancini
Copy link
Member

bmfmancini commented Oct 15, 2021 via email

@TheWitness
Copy link
Member

Can you check the MariaDB manual to see if offset is a new reserved word in 10.6?

@bmfmancini
Copy link
Member

bmfmancini commented Oct 16, 2021 via email

@TheWitness
Copy link
Member

Yea, I'll post a fix in a few seconds, but that does not mean that 10.6 is supported. Burning a trail ;)

@TheWitness TheWitness changed the title [1.2.19] - SQL backtraces when clicking report tab Offset is a reserved word in MariaDB 10.6 affecting Report Oct 16, 2021
TheWitness added a commit that referenced this issue Oct 16, 2021
Offset is a reserved word in MariaDB 10.6 affecting Report
@TheWitness TheWitness added resolved A fixed issue and removed unverified Some days we don't have a clue labels Oct 16, 2021
@TheWitness TheWitness added this to the v1.2.19 milestone Oct 16, 2021
@TheWitness
Copy link
Member

Keep testing.

@bmfmancini
Copy link
Member

bmfmancini commented Oct 16, 2021 via email

@github-actions github-actions bot locked and limited conversation to collaborators Jan 15, 2022
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

3 participants