insert new table |
insert new table |
hafdis |
Mar 22 2007, 11:07 AM
Post
#1
|
Newbie Group: Members Posts: 18 Joined: 13-March 07 Member No.: 2,193 |
Hi again
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 |
hafdis |
Mar 22 2007, 04:15 PM
Post
#2
|
Newbie Group: Members Posts: 18 Joined: 13-March 07 Member No.: 2,193 |
np, found it
|
Lo-Fi Version | Time is now: 26th May 2024 - 02:38 PM |