[Tickets #11245] Re: DB schema "update" failed

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11245
------------------------------------------------------------------------------
  Ticket             | 11245
  Updated By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | DB schema "update" failed
  Queue              | Whups
  Version            | Git develop
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2012-07-09 07:25) wrote:

> Are you sure you are using a virgin database?  Since there is only  
> one place where this table is created, the only way this can happen  
> is if you attempt to run the migration on a database that has the  
> table already but the schema data indicates that the migration was  
> not run.

I'm pretty sure the database was clean as I recreated it several times.
(Took me a while to figure out #11244 as it "locked me out". So I  
recreated the database, prefs and config from scratch)

I've just recreated the database and it fails with another error  
during the first creation:

2012-07-09T09:24:00+02:00 ERR: HORDE [horde] SQL QUERY FAILED:  
SQLSTATE[HY000]: General error: 1 no such table: whups_shares_seq
         DROP TABLE "whups_shares_seq" [pid 2717 on line 812 of  
"/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]

After that I get the "whups_transactions" error mentioned previously.