6.0.0-alpha14
7/1/25

[#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 05/16/2008 (6255 days ago)
Due 05/16/2008 (6255 days ago)
Updated 05/16/2008 (6255 days ago)
Assigned
Resolved 05/16/2008 (6255 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