Ask not what osTicket community can do for you - ask what you can do for osTicket community

Go Back   osTicket Forums > Project Tools > osTicket Bug Tracker > Bug
Reload this Page DB Error #1064
Register Projects FAQ Members List Calendar Search Today's Posts Mark Forums Read

Issue Type Bug   Project osTicket Bug Tracker
DB Error #1064
Issue Tools
Category Unknown
Affected Version 1.6 rc5
Priority Unknown
Status Fixed
Fixed Version 1.6 rc5
Users able to reproduce bug 0
Submitted 07-05-2009
Attachments 0
Users unable to reproduce bug 0
Assigned Users (none) Tags (none)

issueid=128 07-05-2009 11:39 PM
Junior Member
DB Error #1064
Every so often, I receive the following error via email.

Code:
Subject: DB Error #1064

[DELETE  FROM ost_syslog WHERE TIMESTAMPDIFF(MONTH,created,NOW())>=12]

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 '(MONTH,created,NOW())>=12' at line 1
I used the installer to setup osTicket.

While I have not begun to actively use it with clients, I have been doing a bit of internal testing for our needs.

Note that I am not using the email system for creating new tickets.

Any ideas?
Reply

07-06-2009 02:04 AM
Developer
  
TIMESTAMPDIFF is a MySQL 5 feature! I've since updated the latest release to fix the issue including other bugs. Please download the latest version again and replace all files with the exception of setup directory and include/settings.php
Reply
10-08-2009 02:09 PM
Junior Member
  
Could you provide me with a listing of places the changes need to be made? We have customized our install in several areas. If I just upload the new files, I am afraid I may break the changes we have made via mods.

Thanks
scubes13
Reply
10-17-2009 09:52 AM
Junior Member
  
Quote:
Originally Posted by peter
TIMESTAMPDIFF is a MySQL 5 feature! I've since updated the latest release to fix the issue including other bugs. Please download the latest version again and replace all files with the exception of setup directory and include/settings.php
I get the same DB #1064 error with a different issue:

[DELETE FROM ost_ticket WHERE ticket_id=]

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 '' at line 1 71.1.94.130

any help would be appreciated...It would shameful that I have
to hire someone else to fix this, when the coder can not.

I know this product is free, but worthless with poor
coding issues...
Reply
10-17-2009 10:55 AM
Developer
  
@dscurlock - I'm not even sure what version of osTicket are you having problems with - just because the error code is #1064 doesn't means it's the same issue. In fact it's not related to the time stamp bug at all.

If you find osTicket worthless why don't you switch to something else then?
Reply
10-22-2009 03:38 AM
Junior Member
  
Don't let someone like dscurlock get you down, peter, I use osTicket 1.6 RC5 and it's great! Love it.

Thanks,
Reply
10-22-2009 03:43 AM
Junior Member
  
Quite so smittyline, this helpdesk system is brilliant - far better than ones I have used & paid large chunks of money for in the past. Now working in a school, I have close to no budget, but I have been amazed as to how good open source can get.
Reply
03-13-2012 11:04 AM
Junior Member
  
Another fantastic example of people being unhelpful..
imagine being told to use another product , if you have a slight issue..
That's the way to encourage users..

I am ashamed for him, typical forum response.. tut tut. !
Reply

Issue Tools
Subscribe to this issue

All times are GMT -4. The time now is 06:49 AM.

Contact Us - osTicket Community Forums - Archive - Top