[horde] Horde 4.0-ALPHA1: table already exists

[Hiromi Kimura]

Quoting Jan Schneider <jan at horde.org>?

> Zitat von Hiromi Kimura <hiromi at tac.tsukuba.ac.jp>:
>
>> Quote: Jan Schneider <jan at horde.org>?
>>> The installation method for Horde 4 has been changed to use the PEAR
>>> installer. To prepare your local PEAR installation to install software from
>>> Horde's PEAR server, run the following commands from the command line:
>>>
>>> pear channel-discover pear.horde.org
>>> pear install horde/horde_role-alpha
>>> pear run-scripts horde/horde_role
>>>
>>> The last command will ask you for the filessystem location for your Horde
>>> installation. This should be some path in your web server's document root,
>>> e.g. /var/www/horde. These commands only need to be run once. You are now
>>> prepared to install, upgrade and uninstall Horde packages. To  
>>> install the alpha
>>> release of Horde, run the following commands:
>>>
>>> pear install horde/horde-alpha
>>>
>>> Just go to the config/ directory of your Horde installation and copy
>>> conf.php.dist to conf.php:
>>>
>>> cd /var/www/horde/config/
>>> cp conf.php.dist conf.php
>>>
>>> Then point your browser to the installation location, go to the
>>> Administration/Configuration screen and start configuring. You  
>>> probably want
>>> to:
>>>
>>> 1. Configure a real authentication backend!
>>> 2. Configure a database backend (Horde configuration, Database tab)
>>> 3. Install the database tables ("Update all DB schemas" button)
>>
>> After these steps, I get some sql errors at each login.
>>
>> 2011-03-09T12:18:18+09:00 ERR: HORDE4 [horde] SQL QUERY FAILED:  
>> SQLSTATE[42S01]: Base table or view already exists: 1050 Table  
>> 'horde_activesync_schema_info' already exists
>>        CREATE TABLE `horde_activesync_schema_info` ( `version` int(11) )
>>          ENGINE=InnoDB DEFAULT CHARSET=utf8 [pid 14865 on line 782  
>> of "/usr/local/share/pear/Horde/Db/Adapter/Base.php"]
>> 2011-03-09T12:18:18+09:00 ERR: HORDE4 [horde] SQL QUERY FAILED:  
>> SQLSTATE[42S01]: Base table or view already exists: 1050 Table  
>> 'horde_alarm_schema_info' already exists
>>        CREATE TABLE `horde_alarm_schema_info` ( `version` int(11) )
>>          ENGINE=InnoDB DEFAULT CHARSET=utf8 [pid 14865 on line 782  
>> of "/usr/local/share/pear/Horde/Db/Adapter/Base.php"]
>> 2011-03-09T12:18:18+09:00 ERR: HORDE4 [horde] SQL QUERY FAILED:  
>> SQLSTATE[42S01]: Base table or view already exists: 1050 Table  
>> 'horde_auth_schema_info' already exists
>>        CREATE TABLE `horde_auth_schema_info` ( `version` int(11) )
>>          ENGINE=InnoDB DEFAULT CHARSET=utf8 [pid 14865 on line 782  
>> of "/usr/local/share/pear/Horde/Db/Adapter/Base.php"]
>
> Please read the release notes. Upgrades are *not* supported at the  
> moment. Keep following Git if this is what you used in the past.

This is my another test machine and tried clean installation without Git.

> With that being said, it still shouldn't happen. I can only imagine  
> insufficient DB permissions between your mixed up Horde installations.

Humm, I made the DB account as 'grant all privileges' for this horde-alpha.


-=-=-=-=-
Hiromi KIMURA http://www.tac.tsukuba.ac.jp/~hiromi/
PGP Fingerprint16 = 2A 27 2E 46 9E 75 4E 3D  E3 FD 5A DC 2A AA 3A 2E