The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> insert new table
hafdis
post Mar 22 2007, 11:07 AM
Post #1


Newbie
*

Group: Members
Posts: 18
Joined: 13-March 07
Member No.: 2,193



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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic
hafdis   insert new table   Mar 22 2007, 11:07 AM
hafdis   np, found it   Mar 22 2007, 04:15 PM


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 16th April 2024 - 03:32 PM