navigation  interaction  search

 other resources

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

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,

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.

Add/Change #1 (phBMS Error: 100 thrown when saving tasks)




Change Properties
Action

 
Copyright © 2006-2007 Kreotek, LLC. All Rights reserved.