[horde] Unknown column 'sequence' in 'field list' (Kronolith error)

[Michael Rubinsky]

Quoting Luis Felipe Marzagao <lfbm.andamentos at gmail.com>:

> Hi:
>
> I have Horde 3.3.1, upgraded from 3.2.x.
>
> I did follow the UPGRADING documentation and executed the  
> scripts/upgrades/2008-08-29_fix_mdb2_sequences.php, and everything  
> looked just fine.
>
> In fact, all my horde applications seems to be running just fine,  
> but I keep getting this on my log file:
>
> Nov 18 09:30:02 HORDE [error] [kronolith] MDB2 Error: no such field:  
> _doQuery: [Error message: Could not execute statement]
> [Last executed query: INSERT INTO kronolith_shares_seq (sequence)  
> VALUES (NULL)]
> [Native code: 1054]
> [Native message: Unknown column 'sequence' in 'field list']
> [pid 8887 on line 881 of "/usr/share/pear/Horde/Share/sql.php"]
>
> In fact, there´s no 'sequence' column in my horde_shares_seq table:
>
> mysql> describe kronolith_shares_seq;
> +-------+---------+------+-----+---------+----------------+
> | Field | Type    | Null | Key | Default | Extra          |
> +-------+---------+------+-----+---------+----------------+
> | id    | int(11) | NO   | PRI | NULL    | auto_increment |
> +-------+---------+------+-----+---------+----------------+
> 1 row in set (0.00 sec)
>
> The sequence field was present on my previous table, which I was  
> able to see in my backup, and I think that was changed by the  
> aforementioned upgrade script.
>
> I have MDB2_Schema installed:
>
> [root at centos ~]# pear list
> ...
> MDB2_Schema      0.8.2   beta
> ...
>
> Any pointers? Is it possible to manually fix the problem?

Are you running PHP4 by any chance?

Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin