Home » Forums » TaskStep » Bug Reports

Installation Problem

Submitted by along614 on Mon, 01/19/2009 - 3:59pm

I cannot get the Setting defaults and creating sample items to insert. I keep getting this error:

Failed to insert data. The error given was: Incorrect integer value: 'NULL' for column 'id' at row 1

I checked PHPmyadmin and the only error I notice shows on all the tables:

The following indexes appear to be equal and one of them should be removed: PRIMARY, id_2

That error shows on contexts,items, projects, sections, settings.

Im running on Abyss Web Server. Please help! Thanks

‹ polish translation and MySQL Task Completion without a due date ›
22 Feb10:13

Fixing the installation problem

By Mikhail

Open your install.php file located at install directory, in a txt editor of your choice, and remove single quotes for null, From lines 142 to 150...
It is: "VALUES ('NULL', ....
It must be: "VALUES (NULL, ....
Check it out all the null values in lines 148 and 150...

Same thing with update.php (lines 38, 50, 51 & 52) in the same install directory.

And the same problem exists in the edit.php (line 39) and edit_types.php (line 25) files in root directory.

The removal of the single quotes it must be related to recent changes (or maybe not so recent) on PHP and MySQL servers...

Regards!