An error occured in a database query!
I have posted similar items previuosly but would like to consolidate them into one post as it may offer clues.
So far I've tried to do the following and have received a similar error message relating to values not being passed on. (error messages below)
1. Create a Structure.
2. Add an item to a Calendar.
3. Create a Quizz
Note that I have been using Tikiwiki for only 2 months and originally installed Ver 2.4 but recently did a fresh install of Ver 3.0 (note:- not upgrade so all new files)
I have received this error messages in both versions.
My Environment is:-
HP xw4600 Workstation 3.0Ghz 3Gb Ram
Windows XP Pro (SP2)
Apache HTTP Server 2.2
PHP 5.2.9
MYSQL 5.1
Tikiwiki 3.0
Slightly desperate so any help appreciated.
The Error messages are below:-
1. Create a Structure.
An error occured in a database query!
Context:
File tiki-admin_structures.php
Url tiki-admin_structures.php
Query:
insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values(?,?,?,?)
Values:
0 0
1 30
2 Testing
3 1
Message:
Built query was probably:
insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values('0','30','Testing','1')
2. Add an item to a Calendar.
An error occured in a database query!
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 Meeting
3 Staff Meeting
4 1
5
6
7 0
8 1243886400
9 1243886400
10 0
11 0
12 0
13 0
14 NULL
15 1244681740
16 1244681740
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','Meeting','Staff Meeting','1',,,'0','1243886400','1243886400','0','0','0','0',NULL,'1244681740','1244681740')
3. Create a Quizz
An error occured in a database query!
Context:
File tiki-edit_quiz.php
Url tiki-edit_quiz.php
Query:
insert into `tiki_quizzes`(`name`,`description`,`canRepeat`,`storeResults`,`immediateFeedback`, `showAnswers`, `shuffleQuestions`, `shuffleAnswers`,`publishDate`, `expireDate`,`questionsPerPage`,`timeLimited`,`timeLimit`,`created`,`taken`,`passingperct`) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Values:
0 Cad - Autocad
1
2 y
3 y
4 y
5 y
6 n
7 n
8 1244679960
9 1276215960
10 999
11 y
12 10
13 1244680112
14 0
15 50
Message:
Built query was probably:
insert into `tiki_quizzes`(`name`,`description`,`canRepeat`,`storeResults`,`immediateFeedback`, `showAnswers`, `shuffleQuestions`, `shuffleAnswers`,`publishDate`, `expireDate`,`questionsPerPage`,`timeLimited`,`timeLimit`,`created`,`taken`,`passingperct`) values('Cad - Autocad','','y','y','y','y','n','n','1244679960','1276215960','999','y','10','1244680112','0','50')