Applebluvd Posted March 30, 2003 Share Posted March 30, 2003 I am trying to install the "Category with Subs" contribution by Chuck Burgess (http://www.oscommerce.com/community/contributions,1023/page,3) and need a little help. Until I get used to what things mean, I'm a little stuck! I have added lines to the database when installing other mods and changed files, etc but I don't know what to do with the first step in this mod that reads " Add the following to the database: INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES('Category Tabs', 'CATEGORY_TABS', 'Tabs', 'Choose to have category tabs, the category box on the left, or both.', '1', '2', now(), '', "tep_cfg_select_option(array('Tabs', 'Box', 'Both'),");" I went into PhPAdmin and looked at the Configuration table, but couldn't make heads or tails out of what exactly it is that I am supposed to do here. It looks like greek to me and I need a translator!! :? Teresa Link to comment Share on other sites More sharing options...
Applebluvd Posted March 31, 2003 Author Share Posted March 31, 2003 Ok, I understand from someone that this is an sql query. I ran it, but from what I can tell nothing happened. What is supposed to happen when I run this sql query? :? Link to comment Share on other sites More sharing options...
Ajeh Posted March 31, 2003 Share Posted March 31, 2003 If you look at your configuration table and look at the last record added to it ... you will see that this was entered on there with a setting for how you want the CATEGORY_TABS configured Link to comment Share on other sites More sharing options...
Applebluvd Posted March 31, 2003 Author Share Posted March 31, 2003 I'm starting to feel really stupid here! :oops: I think I may have tried to run it in the wrong place which is why I didn't see anything change. Let's see if I am doing this correctly.... Go to PHPAdmin select database select configuration table select sql tab copy query into edit box hit go If this is the correct steps, then I am getting the following error when I try it: Error SQL-query : SELECT * FROM `configuration` WHERE 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function ) VALUES ( 'Category Tabs', 'CATEGORY_TABS', 'Tabs', 'Choose to have category tabs, the category box on the left, or both.', '1', '2', now( ) , '', "tep_cfg_select_option(array('Tabs', 'Box', 'Both')," ) LIMIT 0, 30 MySQL said: You have an error in your SQL syntax near 'INSERT INTO configuration (configuration_title, configuration_key, configuration' at line 1 If I'm not doing this correctly, could you tell me where I am supposed to run this query? In case it helps any, I am running Ian's loaded version 5 and have added in addition to the mods it comes with, Admin Members Discount and xmembers v2.2 contributions. Thanks for your help Link to comment Share on other sites More sharing options...
Ajeh Posted March 31, 2003 Share Posted March 31, 2003 Sort the configuration table by configuration_key ... see if you already have it in there. Link to comment Share on other sites More sharing options...
Ajeh Posted March 31, 2003 Share Posted March 31, 2003 And this is the peice you want to run from the SQL box if it is not in there: INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES('Category Tabs', 'CATEGORY_TABS', 'Tabs', 'Choose to have category tabs, the category box on the left, or both.', '1', '2', now(), '', "tep_cfg_select_option(array('Tabs', 'Box', 'Both'),"); Link to comment Share on other sites More sharing options...
Applebluvd Posted March 31, 2003 Author Share Posted March 31, 2003 Thank you Linda! It took me a few minutes to figure out how to sort by configuration_key but it was there. Does that mean I can now move on to step 2??? :D Link to comment Share on other sites More sharing options...
Ajeh Posted March 31, 2003 Share Posted March 31, 2003 Yes ... looks like you got that setting in the configuration table so on to step 2 ... :D Link to comment Share on other sites More sharing options...
Applebluvd Posted March 31, 2003 Author Share Posted March 31, 2003 Thanks Linda! You have been most helpful. Moved on to step 2 and beyond and everything is working! Does that mean I graduate from beginner newbie to intermediate newbie? This greek is starting to look more like Spanish........which is only saying a little! :lol: Thanks again! Link to comment Share on other sites More sharing options...
Ajeh Posted March 31, 2003 Share Posted March 31, 2003 lol ... you are moving up in the world and can now teach how to install that add-on to the next person. :D It becomes clear as mud soon ... :wink: Link to comment Share on other sites More sharing options...
mitjan Posted April 4, 2003 Share Posted April 4, 2003 PROBLEM !!! When adding to database I got an error (using phpMyAdmin): SQL-query : [Edit] [Create PHP Code] INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function ) VALUES ( 'Category Tabs', 'CATEGORY_TABS', 'Tabs', 'Choose to have category tabs, the category box on the left, or both.', '1', '2', now( ) , '', "tep_cfg_select_option(array('Tabs', 'Box', 'Both')," ) I'm quite a newie so I can't figure out whats wrong. I copied text from install file and also one from this topic. Always got same error: now( ) is coloured red (if that means anything :wink: ) Anybody can help, plizzzzz?? Mitja Link to comment Share on other sites More sharing options...
mitjan Posted April 4, 2003 Share Posted April 4, 2003 FIXED!!! :lol: Sorry to bother... Mitja Link to comment Share on other sites More sharing options...
Genius Posted July 2, 2003 Share Posted July 2, 2003 Hi , I have a similar problem and not too sure, I have installed the contribution and all was fine, until i went to my web page, i was able to see the subcategories of the 3 sample categories ( Hardware, Software and DVD MOVIE) , when i added my own category and sub categories.. i can only see the category but the sub categories are not showing , Please help!! Link to comment Share on other sites More sharing options...
Genius Posted July 2, 2003 Share Posted July 2, 2003 OH forgot to mention that i looked in my database and saw 2 entries for the category tabs, Is that normal or do i need to remove one of them. thanks Link to comment Share on other sites More sharing options...
Guest Posted October 17, 2003 Share Posted October 17, 2003 Im having similiar problems.. I have the contribution running on My localhost server just fine.. But when I uploaded it to My store it wont show the sub-categories.. Im thinking its in the fact that the categories and subs dont start at 1 since this is the only difference in the two stores.. Could someone suggest a fix.. Link to comment Share on other sites More sharing options...
kerch98 Posted February 13, 2004 Share Posted February 13, 2004 I have the same problem. Default Categories show sub-categories, but my custom sub-categories don't show up. Link to comment Share on other sites More sharing options...
carlost Posted June 19, 2004 Share Posted June 19, 2004 Hi, I did a search on Chuck Burgess and foiund this string. I am also having the same problem with the subcataggories not showing up on custom tabs. As there are no older answers to this, I am hoping that Chuck Burgess or someone else out there who knows what to do about this - will respond with an answer. Thanks in advance. Carlos Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.