Opened 6 years ago

Closed 6 years ago

#1750 closed defect (fixed)

Adding/Editing Events Does Not Work on IIS

Reported by: reto.kohli Owned by: kramer
Priority: normal Milestone: Contrexx 3.1 SP1
Component: Calendar Version: 3.1
Severity: normal Keywords: calendar
Cc:

Description

After installing on IIS/MS-MySQL, events could not be stored. The errors were due to invalid values being present in the queries (both INSERT and UPDATE) FIX: calendar/lib/event.class.php, 1028 ff. Changes marked with "*"


$formData = array(

'type' => $type, 'startdate' => $startDate, 'enddate' => $endDate, 'use_custom_date_display' => $useCustomDateDisplay

  • 'showStartDateList' => intval($showStartDateList),
  • 'showEndDateList' => intval($showEndDateList),
  • 'showStartTimeList' => intval($showStartTimeList),
  • 'showEndTimeList' => intval($showEndTimeList),

[...]

'priority' => $priority,

  • 'price' => intval($price),

Changes to the database table structure:


ALTER TABLE contrexx_module_calendar_event

CHANGE invitation_sent invitation_sent INT( 1 ) NOT NULL DEFAULT '0';


Change History (6)

comment:1 Changed 6 years ago by thomas.daeppen

  • Milestone changed from unknown to Contrexx 3.1 Hotfix 2
  • Owner changed from comvation to thomas.daeppen

comment:2 Changed 6 years ago by thomas.daeppen

  • Owner changed from thomas.daeppen to comvation

comment:3 Changed 6 years ago by kramer

  • Resolution set to fixed
  • Status changed from new to closed

(In https://github.com/Cloudrexx/cloudrexx/commit/1abbb20bcba36164b38c4a1447e82ac94b619b72) Merged revision 28857 from trunk to branch contrexx_3_1 - Calendar (fixed #1750): if the sql mode STRICT_TRANS_TABLES has been selected, it was not possible to add an event to the calendar module

comment:4 Changed 6 years ago by kramer

  • Resolution fixed deleted
  • Status changed from closed to reopened

should be tested on an IIS server

comment:5 Changed 6 years ago by kramer

  • Owner changed from comvation to kramer
  • Status changed from reopened to new

comment:6 Changed 6 years ago by kramer

  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.