Ticket #1 (closed defect: duplicate)
phBMS Error: 100 thrown when saving tasks
| Reported by: | rcoe | Owned by: | brieb |
|---|---|---|---|
| Priority: | minor | Milestone: | 0.62 |
| Component: | phpbms | Version: | 0.61 |
| Keywords: | Cc: |
Description (last modified by mipalmer) (diff)
phBMS Error: 100 thrown when saving tasks When trying to save or retrieve an event in v0.61, using Apache 2.0.44 and mySQL 5, I get the following error:
Could not retrieve record: 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 'repeatfrequency,repeattype,repeatdays,repeattimes,repeat,date_Format(repeatunt' at line 4 SELECT id, subject, assignedtoid, type, content, importance, category, attachedtabledefid, attachedid, parentid,location,private,status, repeat,repeatfrequency,repeattype,repeatdays,repeattimes,repeat,date_Format(repeatuntildate,"%c/%e/%Y") as repeatuntildate, completed,date_Format(completeddate,"%c/%e/%Y") as completeddate,date_Format(startdate,"%c/%e/%Y") as startdate, time_format(starttime,"%l:%i %p") as starttime,date_Format(enddate,"%c/%e/%Y") as enddate, time_format(endtime,"%l:%i %p") as endtime, assignedtoid,date_Format(assignedtodate,"%c/%e/%Y") as assignedtodate,time_format(assignedtotime,"%l:%i %p") as assignedtotime,assignedbyid, createdby, creationdate, modifiedby, modifieddate FROM notes WHERE id=2
However, the record is stored in the db anyway, it just can't be reopened. I've only just installed the app yesterday, so I can't say with certainty how ubiquitous the bug is but it seems to be in the Organizer, when creating tasks and events, as well as retrieving these types of records.
