[Tickets #6864] Cannot add galleries in ansel

bugs at horde.org bugs at horde.org
Mon Jun 9 09:05:01 UTC 2008 

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/6864
-----------------------------------------------------------------------
 Ticket             | 6864
 Created By         | postmaster at ecommerce-pme.com
 Summary            | Cannot add galleries in ansel
 Queue              | Ansel
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Milestone          |
 Patch              |
 Owners             |
-----------------------------------------------------------------------


postmaster at ecommerce-pme.com (2008-06-09 05:04) wrote:

Hi

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`
--

More information about the bugs mailing list