cbsezer Posted November 8, 2005 Share Posted November 8, 2005 Im trying to add a new catogory box to my site structure under the blast she image for girl clothes. here is the website http://www.blaststore.com/test the "more category boxes" contribution seemt very promising so I dowloaded it and started following the read me file. I exactly did what it told me and came to the 8th step where it tells to Execute/import the MySQL commands in more_categories.sql using phpMyAdmin. This has been my first time editing a database and I thought I almost managed it.. but pittly i did not! the first time I went to my admim page, I saw the more categories button under the catalog section and I got very exited, i pressed "enable default category box?" (which for some reason became BOX_CATALOG_MORE_CATEGORIES in another admin window I opened ) when I give a new name to the box and select a category say both yes/no to category box enabled and update it I come up with this warning 1054 - Unknown column 'category3_id' in 'field list' update categories_more set infobox_name = 'box1', enabled = '0', category1_id = '64', category2_id = '64', category3_id = '64', category4_id = '64', category5_id = '64', category6_id = '48', category7_id = '64', category8_id = '64', category9_id = '64', category10_id = '64' , category11_id = '64', category12_id = '64', category13_id = '64', category14_id = '64', category15_id = '64', category16_id = '64', category17_id = '64', category18_id = '64', category19_id = '64', category20_id = '64' , category21_id = '64', category22_id = '64', category23_id = '64', category24_id = '64', category25_id = '64' where box_id = '1' [TEP STOP] I can't figure out what I did wrong and am in need of proffecional guidence, please help Quote Michelle, ma belle, these are scripts that go together well !! Link to comment Share on other sites More sharing options...
cbsezer Posted November 8, 2005 Author Share Posted November 8, 2005 when I export my database for categories_more it looks like this -- -- Table structure for table `categories_more` -- CREATE TABLE `categories_more` ( `box_id` tinyint(5) NOT NULL auto_increment, `infobox_name` varchar(255) NOT NULL default 'infobox', `enabled` tinyint(4) NOT NULL default '0', `category1_id` int(11) NOT NULL default '0', `category2_id` int(11) NOT NULL default '0', PRIMARY KEY (`box_id`) ) TYPE=MyISAM AUTO_INCREMENT=52 ; -- -- Dumping data for table `categories_more` -- INSERT INTO `categories_more` VALUES (1, 'box1', 0, 0, 0); INSERT INTO `categories_more` VALUES (2, 'box2', 0, 0, 0); INSERT INTO `categories_more` VALUES (3, 'box3', 0, 0, 0); INSERT INTO `categories_more` VALUES (4, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (5, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (6, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (7, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (8, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (9, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (10, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (11, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (12, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (13, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (14, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (15, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (16, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (17, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (18, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (19, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (20, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (21, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (22, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (23, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (24, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (25, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (26, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (27, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (28, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (29, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (30, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (31, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (32, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (33, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (34, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (35, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (36, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (37, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (38, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (39, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (40, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (41, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (42, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (43, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (44, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (45, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (46, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (47, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (48, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (49, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (50, '', 0, 0, 0); INSERT INTO `categories_more` VALUES (51, '', 0, 0, 0); I only created 3 boxes since I only need one more does it look right? Quote Michelle, ma belle, these are scripts that go together well !! Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.