Loading...
 
Architecture / Installation

Architecture / Installation


An error occured in a database query!

posts: 50

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')

posts: 1630 Canada

That is very strange.

Can you duplicate on the demo site?

M ;-)


posts: 50

No I can't duplicate on demo site.
On demo site I was able to:-
1. Create a Structure.
2. Add an item to a Calendar.
3. Create a Quizz
... without a problem ??



posts: 50

Found the culprit....

I set up a new install using Mysql 4.1 instead of Mysql 5.1.
These database errors no longer occur.
Mysql 4.1 will do for now but I'm curious that others haven't experienced same issues.
Are there some tweaks for Mysql 5.1 to avoid these errors ??

Cheers



Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting