Loading...
 
Skip to main content

Database error when adding calendar item

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Database error when adding calendar item
Version
3.x
Category
  • Error
Feature
Calendar
Resolution status
Invalid
Submitted by
Newstech
Lastmod by
Ushindi Gedeon
Rating
(0)
Description

Cannot create a calendar item. Working as user admin. Receive error "An error occured in a database query!".

System config: Win XP SP3. Tiki 3.0, IIS version 5.1, MySQL 5.0.24, PHP for Windows 5.2.9.2.


Error text follows:

Context:
File tiki-calendar_edit_item.php
Url tiki-calendar_edit_item.php?
Query:
INSERT INTO `tiki_calendar_items` (`user`,`calendarId`,`name`,`description`,`status`,`url`,`lang`,`allday`,`start`,`end`,`priority`,`locationId`,`categoryId`,`nlId`,`recurrenceId`,`lastmodif`,`created`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Values:
0 admin
1 1
2 A test event
3 This is text for a test event.
4 1
5
6
7 0
8 1243332000
9 1243342800
10 0
11 0
12 0
13 0
14 NULL
15 1243280012
16 1243280012
Message:

Built query was probably:
INSERT INTO `tiki_calendar_items` (`user`,`calendarId`,`name`,`description`,`status`,`url`,`lang`,`allday`,`start`,`end`,`priority`,`locationId`,`categoryId`,`nlId`,`recurrenceId`,`lastmodif`,`created`) VALUES ('admin','1','A test event','This is text for a test event.','1',,,'0','1243332000','1243342800','0','0','0','0',NULL,'1243280012','1243280012')

Solution
Workaround
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2525
Created
Monday 25 May, 2009 20:13:15 UTC
by Unknown
LastModif
Tuesday 26 May, 2026 11:12:03 UTC


Show PHP error messages