6.0.0-git
2019-03-20

[#8206] unable to create new calendar
Summary unable to create new calendar
Queue Horde Framework Packages
Queue Version FRAMEWORK_3
Type Bug
State Not A Bug
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester jpedwardspost (at) yahoo (dot) co (dot) uk
Created 2009-04-22 (3619 days ago)
Due
Updated 2009-04-22 (3619 days ago)
Assigned 2009-04-22 (3619 days ago)
Resolved 2009-04-22 (3619 days ago)
Milestone 3.3.4
Patch No

History
2009-04-22 19:54:52 Michael Rubinsky Comment #4
State ⇒ Not A Bug
Priority ⇒ 1. Low
Reply to this comment
I cannot reproduce this. I just ran a completely fresh installation 
and it worked as expected.  The only way I can think of that this 
would happen is if you either had an older version of Horde access 
this database before the new install did, or you had an older version 
of the Share library in the include path somehow. The version that is 
included with the bundle has the correct sequence column name, so 
unless someone else can reproduce this, I'm going to close this.
2009-04-22 18:49:22 jpedwardspost (at) yahoo (dot) co (dot) uk Comment #3 Reply to this comment
You said that this is a fresh install, but are you 100% sure that you
are not using an existing database?  In other words, are you sure
that the *_seq tables in your database are not from a previous horde
install?
Heck!

Well, I did have an existing horde database on the server - it's the 
one that's preinstalled with the plesk / virtuozzo vps image which is 
the control panel that is on my vps.



But, that database is not the groupware version and it's not even 
visible to me through my control panel.  I don't know the mysql 
user/password for it or even what they called it.   I think I could 
probably find out how to get into it via ssh but to be honest I've 
never even tried.



The database I installed I named horde_gw and I first created it 
through the plesk control panel and then I created a 'superuser' for 
it also via plesk.



I downloaded: 
ftp://ftp.horde.org/pub/horde-webmail/horde-webmail-1.2.3-rc1.tar.gz   
(md5 of file sitting on my webserver checks out with this download so 
must be same file)



unpacked it; ran setup.php; chose options to create tables only (not 
create database) and it all seemed to go fine with no errors.



I am new to the whole horde scene but to be honest I'm sure as I can 
be that this was just a vanilla fresh install and no upgrade scripts 
were run.  Hope this helps.



JP.








2009-04-22 14:31:50 Michael Rubinsky Comment #2
State ⇒ Feedback
Reply to this comment
You said that this is a fresh install, but are you 100% sure that you 
are not using an existing database?  In other words, are you sure that 
the *_seq tables in your database are not from a previous horde install?
2009-04-22 11:31:41 Jan Schneider Assigned to Michael Rubinsky
State ⇒ Assigned
Milestone ⇒ 3.3.4
 
2009-04-22 11:31:16 Jan Schneider Version ⇒ FRAMEWORK_3
Queue ⇒ Horde Framework Packages
 
2009-04-22 09:42:56 jpedwardspost (at) yahoo (dot) co (dot) uk Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Summary ⇒ unable to create new calendar
Queue ⇒ Horde Groupware Webmail Edition
Milestone ⇒
Patch ⇒ No
Reply to this comment
Fresh install of horde groupware webmail edition 1.2.3-RC1 on Ubuntu 
Linux webserver, PHP Version: 4.4.2-1



Login to horde as Imp authorised user and unable to create a new calendar.



Message in horde.log (pasted at the bottom) complains about Unknown 
column 'id' in 'field list' for table kronolith_shares_seq.



Problem seems to be resolved by renaming existing column 'sequence' to 
new name of 'id'.

ALTER TABLE `kronolith_shares_seq` CHANGE `sequence` `id` INT( 11 ) 
NOT NULL AUTO_INCREMENT



--------Message in horde.log pasted below------

Apr 21 16:17:53 HORDE [error] [kronolith] MDB2 Error: no such field: 
_doquery: [Error message: Could not execute statement]

[Last executed query: INSERT INTO kronolith_shares_seq (id) VALUES (NULL)]

[Native code: 1054]

[Native message: Unknown column 'id' in 'field list']

  [pid 5574 on line 1006 of 
"/var/www/vhosts/mywebsite.co.uk/httpdocs/horde/lib/Horde/Share/sql.php"]

--------Paste End----------


Saved Queries