More Categories SQL Fix i need Help

[halluzineyt]

has anybody written a right sql codes for this?? a lot of people have problem on this from the forums

 

INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` ) VALUES ( '8675309', 'More Categories', 'More Category Boxes options', '20', '1' );

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ( '', 'Enable Default Category Box?', 'DEFAULT_CATEGORY_BOX_ENABLED', 'true', 'More Category Boxes - enable/disable the default categories box?<br><br>(Usually found in the left column)', '8675309', '0', NULL , '0000-00-00 00:00:00', NULL , 'tep_cfg_select_option(array(''true'', ''false''),' );

DROP TABLE IF EXISTS `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',
 `category3_id` int(11) NOT NULL default '0',
 `category4_id` int(11) NOT NULL default '0',
 `category5_id` int(11) NOT NULL default '0',
 `category6_id` int(11) NOT NULL default '0',
 `category7_id` int(11) NOT NULL default '0',
 `category8_id` int(11) NOT NULL default '0',
 `category9_id` int(11) NOT NULL default '0',
 `category10_id` int(11) NOT NULL default '0',
 `category11_id` int(11) NOT NULL default '0',
 `category12_id` int(11) NOT NULL default '0',
 `category13_id` int(11) NOT NULL default '0',
 `category14_id` int(11) NOT NULL default '0',
 `category15_id` int(11) NOT NULL default '0',
 `category16_id` int(11) NOT NULL default '0',
 `category17_id` int(11) NOT NULL default '0',
 `category18_id` int(11) NOT NULL default '0',
 `category19_id` int(11) NOT NULL default '0',
 `category20_id` int(11) NOT NULL default '0',
 `category21_id` int(11) NOT NULL default '0',
 `category22_id` int(11) NOT NULL default '0',
 `category23_id` int(11) NOT NULL default '0',
 `category24_id` int(11) NOT NULL default '0',
 `category25_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`box_id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

INSERT INTO `categories_more` VALUES (1, 'box1' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (2, 'box2' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (3, 'box3' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (4, 'box4' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (5, 'box5' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (6, 'box6' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (7, 'box7' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (8, 'box8' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (9, 'box9' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO `categories_more` VALUES (10, 'box10' ,0  ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);

 

this latest sql code from it wont give you the table for languages thus resulting on having this error

 

1146 - Table 'atickmob_atickdbase.TABLE_CATEGORIES_MORE_LANGUAGES' doesn't exist

select * from categories_more,TABLE_CATEGORIES_MORE_LANGUAGES where enabled = 1 and languages_id = '1' and box_id_language= box_id 

 

can anybody help to fix this? please..

[web-project]

1146 - Table 'atickmob_atickdbase.TABLE_CATEGORIES_MORE_LANGUAGES' doesn't exist

simply read the error, read again the manual and you will find that you skipped one of installations steps.

 

The variable TABLE_CATEGORIES_MORE_LANGUAGES is not defined in your database.php file, this is the reason why the oscommerce can't find the table

Edited January 13, 2010 by web-project

[chinholee]

i need help upgrading from ms2.2 to rc2.2 in my more sql data. i cant upload from myphpadmin, i m getting configuration error