Tickets :: Comment on [#6864] Cannot add galleries in ansel

* Your Email Address
* Spam protection	Enter the letters below: .__.\ / . ..__. \| \| >< \| \|[__] \|__\|/ \\__\|\__\|\| \|
Comment	> Sorry, it's the same for me. I have removed, then reinstall ansel > from 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; > > > > > >> Fixed. > >> > >> http://lists.horde.org/archives/cvs/Week-of-Mon-20080609/079538.html > >> http://lists.horde.org/archives/cvs/Week-of-Mon-20080609/079539.html > >
Attachment
Watch this ticket

Saved Queries