Help - Search - Members - Calendar
Full Version: insert new table
HTMLHelp Forums > Programming > Databases
hafdis
Hi again smile.gif

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;


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 smile.gif
hafdis
np, found it
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.