Ticket #1 (defect)
Opened 2 years ago
Last modified 2 years ago
phBMS Error: 100 thrown when saving tasks
Status: closed (duplicate)
| Reported by: | rcoe | Assigned to: | brieb |
|---|---|---|---|
| Priority: | minor | Milestone: | 0.62 |
| Component: | phpbms | Version: | 0.61 |
| Keywords: | Cc: | ||
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.
Attachments
Change History
10/07/06 14:06:18: Modified by mipalmer
- description changed.
10/07/06 14:27:26: Modified by Anonymous
10/07/06 17:08:56: Modified by brieb
- status changed from new to assigned.
- milestone changed from unknown to 0.70.
10/11/06 15:41:30: Modified by mipalmer
- description changed.
10/12/06 13:52:07: Modified by brieb
- status changed from assigned to closed.
- resolution set to duplicate.
Not really a duplicate, but related to ticket #8.
03/30/07 01:41:54: Modified by cialis
- cc set to New York.
- keywords set to Key word.
- type deleted.
03/30/07 02:24:24: Modified by mipalmer
- cc deleted.
- keywords deleted.
- type set to defect.
Query lists repeat twice is one problem. The other is the conflict with mysql5's 'repeat' function.
Suggested Fix: remove the first repeat from the query code and leave the ticked repeat in.
Problem Area: status, repeat,repeatfrequency,repeattype,repeatdays,repeattimes,`r epeat`,date_Format(repeatuntildate,