Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Trying to make more category boxes cont. work


cbsezer

Recommended Posts

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

Michelle, ma belle, these are scripts that go together well !!

Link to comment
Share on other sites

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?

Michelle, ma belle, these are scripts that go together well !!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...