[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-developers] Installation problem - phpgwapi and lang t
From: |
David Delon |
Subject: |
Re: [Phpgroupware-developers] Installation problem - phpgwapi and lang table |
Date: |
Mon, 18 Mar 2002 21:07:59 +0100 |
User-agent: |
Mutt/1.2.5i |
> 6) Screen fills up with Database errors, the first of which is
>
> ===============================================
> Database error: Invalid SQL: CREATE TABLE lang (message_id varchar(255) NOT
> NULL, app_name varchar(100) NOT NULL DEFAULT 'common', lang varchar(5) NOT
> NULL, content text, PRIMARY KEY(message_id,app_name,lang))
> ===============================================
>
Hello,
If you don't want to upgrade to Mysql 3.23 here is a quick fix :
* drop your database
* edit phpgwapi/setup/tables_current.inc.php
and replace
'lang' => array(
'fd' => array(
'message_id' => array('type' =>
'varchar', 'precision' => 255, 'nullable' => false, 'default' => ''),
'app_name' => array('type' => 'varchar',
'precision' => 100, 'nullable' => false, 'default' => 'common'),
'lang' => array('type' => 'varchar',
'precision' => 5, 'nullable' => false, 'default' => ''),
'content' => array('type' => 'text')
),
by
'fd' => array(
'message_id' => array('type' =>
'varchar', 'precision' => 150, 'nullable' => false, 'default' => ''),
'app_name' => array('type' => 'varchar',
'precision' => 100, 'nullable' => false, 'default' => 'common'),
'lang' => array('type' => 'varchar',
'precision' => 5, 'nullable' => false, 'default' => ''),
'content' => array('type' => 'text')
),
* start setup procedure again.
That's all !
--
David