6.0.0-beta6
4/10/26

[#6712] seqence tables missing
Summary seqence tables missing
Queue Horde Base
Queue Version HEAD
Type Enhancement
State Rejected
Priority 2. Medium
Owners
Requester adrieder (at) sbox (dot) tugraz (dot) at
Created 5/16/08 (6538 days ago)
Due 05/16/2008 (6538 days ago)
Updated 5/16/08 (6538 days ago)
Assigned
Resolved 5/16/08 (6538 days ago)
Milestone
Patch No

History
05/16/2008 09:15:17 AM Jan Schneider Comment #2
State ⇒ Rejected
Reply to this comment
No, not all dbs use tables for sequence emulation.
05/16/2008 07:48:02 AM adrieder (at) sbox (dot) tugraz (dot) at Comment #1
State ⇒ New
Priority ⇒ 2. Medium
Type ⇒ Enhancement
Summary ⇒ seqence tables missing
Due ⇒ 05/16/2008
Queue ⇒ Horde Base
Milestone ⇒
Patch ⇒ No
Reply to this comment
would it be possible to provide also the sql statements for the 
xxx_shares_seq tables in the corresponding sql scripts, otherwise the 
horde db user needs the create table privilege.



Error message:

HORDE [debug] [kronolith] MDB2 Error: insufficient permissions: [Error 
message: on demand sequence kronolith_share

s could not be created]



Solution:

e.g. for mysql:

CREATE TABLE `kronolith_shares_seq` (

   `sequence` int(11) NOT NULL auto_increment,

   PRIMARY KEY  (`sequence`)

)

Saved Queries