Jump to content
Sign in to follow this  
halluzineyt

More Categories SQL Fix i need Help

Recommended Posts

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..

Share this post


Link to post
Share on other sites
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 by web-project

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×