Page 1 of 1

Error during installation

PostPosted: Thu Jun 14, 2007 8:31 pm
Author: tliau
Hi there,

I have problem during installation. Please help. The error is shown below:-

An error occurred trying to update the database
Field 'cat_desc' doesn't have a default value

Re: Error during installation

PostPosted: Thu Jun 14, 2007 10:07 pm
Author: Helter
you may have selected the incorrect "Database Type"

Re: Error during installation

PostPosted: Fri Jun 15, 2007 12:53 am
Author: tliau
No, I have chosen the right database. Most of my tables are created without problems.

PostPosted: Fri Jun 15, 2007 8:39 am
Author: shedt_v
Are you installing into an empty database?

Re: Error during installation

PostPosted: Tue Jun 19, 2007 2:22 am
Author: tliau
I am doing a fresh installation of Integramod following the instruction to create a empty database. Some of the tables are created successfully when run the install.php. It stops at this error and installation cannot carry on.

Re: Error during installation

PostPosted: Tue Jun 19, 2007 8:27 am
Author: Helter
there is an issue with mysqli so if your running mysql5 try selecting db type 4

Re: Error during installation

PostPosted: Tue Jun 19, 2007 11:58 pm
Author: tliau
there are only 3 db type available when launch the install.php

MySQL 3.x
MySQL 4.x/5.x
MySQL 4.x/5.x /w MySQLi

I chose to MySQL 4.x/5.x, that is when I got this error. I tried with MySQL 3.x and got the same error. When I try the last option, I got this message "The PHP configuration on your server doesn't support the database type that you chose".