WebInstall mysql issue

cmdb

Hi Support,

I choose the WebInstall way to install idoit on my windows xp (mysql 5.0,php5),i follow step by step

everything got through,but on installation i got an error :

Step 6: Installation
Installation status
Creating database connection OK

Checking database names OK

Creating system database OK

Creating mandator database OK

Importing system database ERROR ('C:\Program' ²»ÊÇÄÚ²¿»òÍâ²¿ÃüÁî£¬Ò²²»ÊÇ¿ÉÔËÐÐµÄ³ÌÐò)

Rollback (DB-Query): Dropping system database OK

Finished installation rollback! OK

Installation failed! ERROR (1 errors)

Then i use "try again"

Step 6: Installation
Installation status
Creating database connection OK

Checking database names OK

Mandator database already exists! ERROR

Installation failed! ERROR (1 errors)

What can i do the following ? any advise will be appreciation!

cmdb

btw, i am a fresh man for MySQL ,and i do not what`s the mean " Mandator database " for…

npotthast

Hm, have you tried the patch: http://www.i-doit.de/downloads/patch_2345-2409.zip?
Alternatively you can try to install i-doit into a directory without spaces (like not 'Program Files'). Before installing it the second time make sure to delete already created databases.

cmdb

@npotthast:

Hm, have you tried the patch: http://www.i-doit.de/downloads/patch_2345-2409.zip?
Alternatively you can try to install i-doit into a directory without spaces (like not 'Program Files'). Before installing it the second time make sure to delete already created databases.

Hi Npotthast,thanks first!

i follow you setp,drop database,use the patch, error occur on step 6:

Step 6: Installation
Installation status
Creating database connection OK

Checking database names OK

Creating system database OK

Creating mandator database OK

Importing system database OK

Importing mandator database ERROR (ERROR 1364 (HY000) at line 10183: Field 'isys_workflow_type__occurrence' doesn't have a default value)

Rollback (DB-Query): Dropping system database OK

Rollback (DB-Query): Dropping mandant database OK

Finished installation rollback! OK

Installation failed! ERROR (1 errors)

How to fix that? Many thanks!

ds

It has something to do with your mysql version, which could be an interpretation problem of our dump. I still dont have a solution for this but i'll let you know if i get any.

ds

I see there are some workarounds described at http://drupal.org/node/43316:

Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"

or

Start MySQL with the option –sql-mode="MYSQL40"

cmdb

@ds:

I see there are some workarounds described at http://drupal.org/node/43316:

Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"

or

Start MySQL with the option –sql-mode="MYSQL40"

Hi ds ,after i fellow you step, i finished my indstallation,many thanks!

PS,i use i-doit V.09,but the Language is de , how can i change it to english or other language?

ds

You should have two mandants, one for german and one for english language.
They are selectable directly after the login page.