| 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 | 04/22/2009 (5931 days ago) |
| Due | |
| Updated | 04/22/2009 (5931 days ago) |
| Assigned | 04/22/2009 (5931 days ago) |
| Resolved | 04/22/2009 (5931 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | 3.3.4 |
| Patch | No |
State ⇒ Not A Bug
Priority ⇒ 1. Low
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.
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?
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.
State ⇒ Feedback
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?
Milestone ⇒ 3.3.4
Assigned to Michael Rubinsky
Queue ⇒ Horde Framework Packages
Priority ⇒ 2. Medium
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ unable to create new calendar
Type ⇒ Bug
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----------