[horde] [imp] Upgrade Schema error for Horde_History-2.1.2

[Michael J Rubinsky]

Quoting Andrea Zagli <azagli at libero.it>:

> Il giorno gio 25 lug 2013 02:16:41 CEST, Louis-Philippe Allard ha scritto:
>
>> On Wed, Jul 24, 2013 at 7:59 PM, Louis-Philippe Allard <
>> lp.allard.1 at gmail.com> wrote:
>>
>>> On Wed, Jul 24, 2013 at 5:33 PM, Ralf Lang <lang at b1-systems.de> wrote:
>>>
>>>> On 24.07.2013 21:48, Brent wrote:
>>>>>
>>>>> Call to undeclared method "Horde_Db_Adapter_Pdo_Mysql::dropIndex" from
>>>>> "Horde_Db_Adapter_Pdo_Mysql::dropIndex"
>>>>>
>>>>> Upgrade schema error for Horde_History-2.1.2.
>>>>>
>>>>> Not sure if this goes to imp or to the horde list.
>>>>>
>>>>> brent
>>>>>
>>>>>
>>>>>
>>>> See horde list for existing discussion on this subject.
>>>>
>>>> --
>>>>
>>>>
>>> I too have an issue updating the DB schema for Horde_History.  I get:
>>>
>>> SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP
>>> 'index_horde_histories_on_history_modseq'; check that column/key exists
>>>
>>> I will look at the maillist as Ralf suggested.  I just thought to let
>>> people know of this error message...
>>>
>>
>> Different problem I believe.  I will send my own email request to the list
>> so we keep each issues separate.
>
>
> same problem
>
> i solved with
>
> http://bugs.horde.org/ticket/12498
>
> but i don't know if it this the right way (what is the right  
> horde_histories table structure?)


mysql> SHOW CREATE TABLE horde_histories;
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table           | Create Table                                        
                                                                        
                                                                        
                                                                        
                                                                        
                                                                        
                                                                        
                                                                        
                                                                        
                                                                        
   |
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| horde_histories | CREATE TABLE `horde_histories` (
   `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `object_uid` varchar(255) NOT NULL,
   `history_action` varchar(32) NOT NULL,
   `history_ts` bigint(20) NOT NULL,
   `history_desc` text,
   `history_who` varchar(255) DEFAULT NULL,
   `history_extra` text,
   `history_modseq` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`history_id`),
   KEY `index_horde_histories_on_history_action` (`history_action`),
   KEY `index_horde_histories_on_history_ts` (`history_ts`),
   KEY `index_horde_histories_on_history_modseq` (`history_modseq`),
   KEY `index_horde_histories_on_object_uid` (`object_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2200 bytes
Desc: PGP Public Key
URL: <http://lists.horde.org/archives/horde/attachments/20130730/74484aec/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6062 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130730/74484aec/attachment-0001.bin>