• Registered: 2021-09-15
  • Posts: 9

Topic: 1064 TROUBLE

SQL error. See 'logs/sql.log' ||1064 ||
need help whit an error.
Values string:
SQL execute 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 'ORDER BY
        e.`sDate`' at line 57
Values string:

I recibed this error ever time i save an event. So i need help, first instalation.

Calendar version 5.1.1.

From Spain.
thanx for de work,

Quote Post 1

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: 1064 TROUBLE

Hi there,
I have sent you an email: 2021-09-19 @ 17:07 with the solution (an updated toolbox.php file)

Roel

Quote Post 2

  • Registered: 2021-09-15
  • Posts: 9

Re: 1064 TROUBLE

checkend and working thank you very much Roel.
thanx again.

Quote Post 3

4 Reply by dwcondu

  • dwcondu
  • Guest

Re: 1064 TROUBLE

What(Where) is the solution? I'm getting the same error when trying to assign category (other than no cat) to Event. I can update by directly modifying database. I greeped for the words "'ORDER BY ..... sDate`'" in the program's files to no avail.

Thanks
BTW - I have 5.1.1M version

Quote Post 4

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: 1064 TROUBLE

The solution is under Known Issues and Fixes (2nd from the top). Click here

You can also send me an email (via the Contact Us page) and then I will send you an updated toolbox  file.

Roel

Quote Post 5