| Summary | Cannot add galleries in ansel |
| Queue | Ansel |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | mrubinsk (at) horde (dot) org |
| Requester | postmaster (at) ecommerce-pme (dot) com |
| Created | 06/09/2008 (6247 days ago) |
| Due | |
| Updated | 06/10/2008 (6246 days ago) |
| Assigned | 06/09/2008 (6247 days ago) |
| Resolved | 06/09/2008 (6247 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
help, please ask on the mailing lists.
cvs, updated the entire horde from cvs, removed then reinstall the
mysql tables from ansel.sql. and always: The gallery "test" couldn't
be created: The gallery "test" could not be created: MDB2 Error: no
such field
Thank you for your work.
JB
-- --------------------------------------------------------
--
-- Structure de la table `ansel_datatree_transition`
--
CREATE TABLE `ansel_datatree_transition` (
`datatree_id` int(11) NOT NULL,
`image_id` int(11) NOT NULL,
`vfsname` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_faces`
--
CREATE TABLE `ansel_faces` (
`face_id` int(11) NOT NULL,
`image_id` int(11) NOT NULL,
`gallery_id` int(11) NOT NULL,
`face_name` varchar(100) NOT NULL,
`face_x1` int(11) NOT NULL,
`face_y1` int(11) NOT NULL,
`face_x2` int(11) NOT NULL,
`face_y2` int(11) NOT NULL,
`face_signature` blob,
PRIMARY KEY (`face_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_faces_index`
--
CREATE TABLE `ansel_faces_index` (
`face_id` int(11) NOT NULL,
`index_position` int(11) NOT NULL,
`index_part` blob,
KEY `ansel_faces_index_face_id_idx` (`face_id`),
KEY `ansel_faces_index_index_part_idx` (`index_part`(30)),
KEY `ansel_faces_index_index_position_idx` (`index_position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_galleries_tags`
--
CREATE TABLE `ansel_galleries_tags` (
`gallery_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
PRIMARY KEY (`gallery_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_image_attributes`
--
CREATE TABLE `ansel_image_attributes` (
`image_id` int(11) NOT NULL,
`attr_name` varchar(50) NOT NULL,
`attr_value` varchar(255) default NULL,
PRIMARY KEY (`image_id`,`attr_name`),
KEY `ansel_image_attributes_image_idx` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_images`
--
CREATE TABLE `ansel_images` (
`image_id` int(11) NOT NULL,
`gallery_id` int(11) NOT NULL,
`image_filename` varchar(255) NOT NULL,
`image_type` varchar(100) NOT NULL,
`image_caption` text,
`image_uploaded` int(11) NOT NULL,
`image_sort` int(11) NOT NULL,
`image_faces` int(11) NOT NULL,
PRIMARY KEY (`image_id`),
KEY `ansel_images_gallery_idx` (`gallery_id`),
KEY `ansel_images_gallery_image_idx` (`image_id`,`gallery_id`),
KEY `ansel_images_uploaded_idx` (`image_uploaded`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_images_tags`
--
CREATE TABLE `ansel_images_tags` (
`image_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
PRIMARY KEY (`image_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares`
--
CREATE TABLE `ansel_shares` (
`share_id` int(11) NOT NULL,
`share_owner` varchar(32) NOT NULL,
`share_parents` varchar(255) default NULL,
`perm_creator` smallint(6) NOT NULL,
`perm_default` smallint(6) NOT NULL,
`perm_guest` smallint(6) NOT NULL,
`share_flags` smallint(6) NOT NULL default '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` text,
`attribute_default` int(11) default NULL,
`attribute_default_type` varchar(6) default NULL,
`attribute_default_prettythumb` text,
`attribute_style` varchar(50) default NULL,
`attribute_category` varchar(255) NOT NULL default '',
`attribute_last_modified` int(11) default NULL,
`attribute_date_created` int(11) default NULL,
`attribute_images` int(11) NOT NULL default '0',
`attribute_has_subgalleries` int(11) NOT NULL default '0',
`attribute_slug` varchar(255) default NULL,
`attribute_age` int(11) NOT NULL default '0',
`attribute_download` varchar(255) default NULL,
`attribute_passwd` varchar(255) default NULL,
`attribute_faces` int(11) NOT NULL,
PRIMARY KEY (`share_id`),
KEY `ansel_shares_share_owner_idx` (`share_owner`),
KEY `ansel_shares_perm_creator_idx` (`perm_creator`),
KEY `ansel_shares_perm_default_idx` (`perm_default`),
KEY `ansel_shares_perm_guest_idx` (`perm_guest`),
KEY `ansel_shares_attribute_category_idx` (`attribute_category`),
KEY `ansel_shares_share_parents_idx` (`share_parents`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares_groups`
--
CREATE TABLE `ansel_shares_groups` (
`share_id` int(11) NOT NULL,
`group_uid` int(11) NOT NULL,
`perm` smallint(6) NOT NULL,
KEY `ansel_shares_groups_share_id_idx` (`share_id`),
KEY `ansel_shares_groups_group_uid_idx` (`group_uid`),
KEY `ansel_shares_groups_perm_idx` (`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares_seq`
--
CREATE TABLE `ansel_shares_seq` (
`sequence` int(11) NOT NULL auto_increment,
PRIMARY KEY (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares_users`
--
CREATE TABLE `ansel_shares_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(32) NOT NULL,
`perm` smallint(6) NOT NULL,
KEY `ansel_shares_users_share_id_idx` (`share_id`),
KEY `ansel_shares_users_user_uid_idx` (`user_uid`),
KEY `ansel_shares_users_perm_idx` (`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `ansel_tags`
--
CREATE TABLE `ansel_tags` (
`tag_id` int(11) NOT NULL,
`tag_name` varchar(255) NOT NULL,
PRIMARY KEY (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
http://lists.horde.org/archives/cvs/Week-of-Mon-20080609/079538.html
http://lists.horde.org/archives/cvs/Week-of-Mon-20080609/079539.html
State ⇒ Resolved
http://lists.horde.org/archives/cvs/Week-of-Mon-20080609/079538.html
http://lists.horde.org/archives/cvs/Week-of-Mon-20080609/079539.html
share name to the Perms system, and the share name persists in the
share object, so when it's added to the DB, it attempts to add that
field as well....
columns even was removed from the share driver. I don't know where
this happen. But adding the share_name column solves all the problems.
Assigned to Michael Rubinsky
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Cannot add galleries in ansel
Queue ⇒ Ansel
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
I have installed horde from CVS today, installed ansel, loading the sql file.
The gallery "test" couldn't be created: The gallery "test" could not
be created: MDB2 Error: no such field. No more informations.
It seems the same when i run the scripts in "upgrades", and upgrades
sql files. I have uninstall and reinstall ansel tables, nothing change.
--
-- Structure de la table `ansel_datatree_transition`
--
CREATE TABLE `ansel_datatree_transition` (
`datatree_id` int(11) NOT NULL,
`image_id` int(11) NOT NULL,
`vfsname` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_datatree_transition`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_faces`
--
CREATE TABLE `ansel_faces` (
`face_id` int(11) NOT NULL,
`image_id` int(11) NOT NULL,
`gallery_id` int(11) NOT NULL,
`face_name` varchar(100) NOT NULL,
`face_x1` int(11) NOT NULL,
`face_y1` int(11) NOT NULL,
`face_x2` int(11) NOT NULL,
`face_y2` int(11) NOT NULL,
`face_signature` blob,
PRIMARY KEY (`face_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_faces`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_faces_index`
--
CREATE TABLE `ansel_faces_index` (
`face_id` int(11) NOT NULL,
`index_position` int(11) NOT NULL,
`index_part` blob,
KEY `ansel_faces_index_face_id_idx` (`face_id`),
KEY `ansel_faces_index_index_part_idx` (`index_part`(30)),
KEY `ansel_faces_index_index_position_idx` (`index_position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_faces_index`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_galleries_tags`
--
CREATE TABLE `ansel_galleries_tags` (
`gallery_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
PRIMARY KEY (`gallery_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_galleries_tags`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_image_attributes`
--
CREATE TABLE `ansel_image_attributes` (
`image_id` int(11) NOT NULL,
`attr_name` varchar(50) NOT NULL,
`attr_value` varchar(255) default NULL,
PRIMARY KEY (`image_id`,`attr_name`),
KEY `ansel_image_attributes_image_idx` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_image_attributes`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_images`
--
CREATE TABLE `ansel_images` (
`image_id` int(11) NOT NULL,
`gallery_id` int(11) NOT NULL,
`image_filename` varchar(255) NOT NULL,
`image_type` varchar(100) NOT NULL,
`image_caption` text,
`image_uploaded` int(11) NOT NULL,
`image_sort` int(11) NOT NULL,
`image_faces` int(11) NOT NULL,
PRIMARY KEY (`image_id`),
KEY `ansel_images_gallery_idx` (`gallery_id`),
KEY `ansel_images_gallery_image_idx` (`image_id`,`gallery_id`),
KEY `ansel_images_uploaded_idx` (`image_uploaded`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_images`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_images_tags`
--
CREATE TABLE `ansel_images_tags` (
`image_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
PRIMARY KEY (`image_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_images_tags`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares`
--
CREATE TABLE `ansel_shares` (
`share_id` int(11) NOT NULL,
`share_owner` varchar(32) NOT NULL,
`share_parents` varchar(255) default NULL,
`perm_creator` smallint(6) NOT NULL,
`perm_default` smallint(6) NOT NULL,
`perm_guest` smallint(6) NOT NULL,
`share_flags` smallint(6) NOT NULL default '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` text,
`attribute_default` int(11) default NULL,
`attribute_default_type` varchar(6) default NULL,
`attribute_default_prettythumb` text,
`attribute_style` varchar(50) default NULL,
`attribute_category` varchar(255) NOT NULL default '',
`attribute_last_modified` int(11) default NULL,
`attribute_date_created` int(11) default NULL,
`attribute_images` int(11) NOT NULL default '0',
`attribute_has_subgalleries` int(11) NOT NULL default '0',
`attribute_slug` varchar(255) default NULL,
`attribute_age` int(11) NOT NULL default '0',
`attribute_download` varchar(255) default NULL,
`attribute_passwd` varchar(255) default NULL,
`attribute_faces` int(11) NOT NULL,
PRIMARY KEY (`share_id`),
KEY `ansel_shares_share_owner_idx` (`share_owner`),
KEY `ansel_shares_perm_creator_idx` (`perm_creator`),
KEY `ansel_shares_perm_default_idx` (`perm_default`),
KEY `ansel_shares_perm_guest_idx` (`perm_guest`),
KEY `ansel_shares_attribute_category_idx` (`attribute_category`),
KEY `ansel_shares_share_parents_idx` (`share_parents`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_shares`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares_groups`
--
CREATE TABLE `ansel_shares_groups` (
`share_id` int(11) NOT NULL,
`group_uid` int(11) NOT NULL,
`perm` smallint(6) NOT NULL,
KEY `ansel_shares_groups_share_id_idx` (`share_id`),
KEY `ansel_shares_groups_group_uid_idx` (`group_uid`),
KEY `ansel_shares_groups_perm_idx` (`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_shares_groups`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares_seq`
--
CREATE TABLE `ansel_shares_seq` (
`sequence` int(11) NOT NULL auto_increment,
PRIMARY KEY (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Contenu de la table `ansel_shares_seq`
--
INSERT INTO `ansel_shares_seq` (`sequence`) VALUES
(2);
-- --------------------------------------------------------
--
-- Structure de la table `ansel_shares_users`
--
CREATE TABLE `ansel_shares_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(32) NOT NULL,
`perm` smallint(6) NOT NULL,
KEY `ansel_shares_users_share_id_idx` (`share_id`),
KEY `ansel_shares_users_user_uid_idx` (`user_uid`),
KEY `ansel_shares_users_perm_idx` (`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_shares_users`
--
-- --------------------------------------------------------
--
-- Structure de la table `ansel_tags`
--
CREATE TABLE `ansel_tags` (
`tag_id` int(11) NOT NULL,
`tag_name` varchar(255) NOT NULL,
PRIMARY KEY (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `ansel_tags`
--