i have setup my page again and photogallery, but i got this error after i installed the gallery
CODE
dbname*.wp_fim_cat’ doesn’t exist
there is a fix for this
CODE
--
-- Table structure for table `wp_fim_cat`
--
DROP TABLE IF EXISTS `wp_fim_cat`;
CREATE TABLE IF NOT EXISTS `wp_fim_cat` (
`catname` varchar(255) NOT NULL default '',
`id` int(11) NOT NULL auto_increment,
`date` datetime default NULL,
`description` text NOT NULL,
`folder` varchar(255) NOT NULL default '',
`cover` varchar(50) default '',
`status` varchar(20) NOT NULL default 'public',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
-- Table structure for table `wp_fim_comments`
--
DROP TABLE IF EXISTS `wp_fim_comments`;
CREATE TABLE IF NOT EXISTS `wp_fim_comments` (
`id` int(11) NOT NULL auto_increment,
`image_id` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`author_comment` text NOT NULL,
`author_name` varchar(255) NOT NULL default '',
`author_email` varchar(255) NOT NULL default '',
`author_url` varchar(255) NOT NULL default '',
`author_ip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
-- Table structure for table `wp_fim_images`
--
DROP TABLE IF EXISTS `wp_fim_images`;
CREATE TABLE IF NOT EXISTS `wp_fim_images` (
`id` smallint(11) NOT NULL auto_increment,
`image` varchar(255) default NULL,
`date` datetime default NULL,
`title` varchar(255) default NULL,
`description` text,
`cat` varchar(10) NOT NULL default '',
`status` varchar(50) default 'include',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
-- Table structure for table `wp_fim_cat`
--
DROP TABLE IF EXISTS `wp_fim_cat`;
CREATE TABLE IF NOT EXISTS `wp_fim_cat` (
`catname` varchar(255) NOT NULL default '',
`id` int(11) NOT NULL auto_increment,
`date` datetime default NULL,
`description` text NOT NULL,
`folder` varchar(255) NOT NULL default '',
`cover` varchar(50) default '',
`status` varchar(20) NOT NULL default 'public',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
-- Table structure for table `wp_fim_comments`
--
DROP TABLE IF EXISTS `wp_fim_comments`;
CREATE TABLE IF NOT EXISTS `wp_fim_comments` (
`id` int(11) NOT NULL auto_increment,
`image_id` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`author_comment` text NOT NULL,
`author_name` varchar(255) NOT NULL default '',
`author_email` varchar(255) NOT NULL default '',
`author_url` varchar(255) NOT NULL default '',
`author_ip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
-- Table structure for table `wp_fim_images`
--
DROP TABLE IF EXISTS `wp_fim_images`;
CREATE TABLE IF NOT EXISTS `wp_fim_images` (
`id` smallint(11) NOT NULL auto_increment,
`image` varchar(255) default NULL,
`date` datetime default NULL,
`title` varchar(255) default NULL,
`description` text,
`cat` varchar(10) NOT NULL default '',
`status` varchar(50) default 'include',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
thing is, i have to add this in thru phpmyadmin, i have full access to that, but i dont know how to add this table in, run the SQL query from in phpmyadmin.
can someone of you good people here guide me