Re: [Phpgroupware-developers] Installation problem - phpgwapi and lang table

[David Delon]

> 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