shuffled 0 Posted November 7, 2009 I believe I screwed up my install, though the instructions seemed pretty straightforward. I am not a programmer, so keep your responses simple please. After modifying my files and then importing the sql file, I logged into my admin and went to "more categories" under the catalog tab and go this error: 1146 - Table 'chipzonecatalog.categories_more_languages' doesn't exist select * from categories_more, categories_more_languages where enabled = 1 and languages_id = '1' and box_id_language= '1' [TEP STOP] Any help would be greatly appreciated! Doug Share this post Link to post Share on other sites
shuffled 0 Posted November 7, 2009 I believe I screwed up my install, though the instructions seemed pretty straightforward. I am not a programmer, so keep your responses simple please. After modifying my files and then importing the sql file, I logged into my admin and went to "more categories" under the catalog tab and go this error: 1146 - Table 'chipzonecatalog.categories_more_languages' doesn't exist select * from categories_more, categories_more_languages where enabled = 1 and languages_id = '1' and box_id_language= '1' [TEP STOP] Any help would be greatly appreciated! Disregard, thanks to Peter's advice, I went back and downloaded the English version of the file and uploaded both categories_more.php files and the error went away. Doug Share this post Link to post Share on other sites
shuffled 0 Posted November 7, 2009 Disregard, thanks to Peter's advice, I went back and downloaded the English version of the file and uploaded both categories_more.php files and the error went away. Well I thought things were great. I am not getting any errors, but my new boxes do not show up on the site at all. I can toggle the default category box on and off with true/false. I can also use the program under the catalog. I have named 3 boxes and clicked the "enable" radio button and selected several categories for each. Even after clicking "update", I do not see the new boxes on the site. Doug Share this post Link to post Share on other sites
oneeezy 0 Posted November 16, 2009 Im have uploaded this contribution and it is working fine, but now i have another problem..please go to my site for reference: http://66.49.195.144/index.php Do you see where I have my first category "PACKAGE DEALS" and my second category "CREATE WEDDING"? usually when your editing a heading like that you would go to the catalog/includes/languages/english.php file , find the text you want to replace, and replace it. I like to use a custom image for this text... but now that I have installed the "More Categories" contrib there is no option for this... Can someone please explain how I can change the "PACKAGE DEALS" and "CREATE WEDDING" text into images and where to do it? Thanks :lol: , Justin Windows Phone 7 Forum | Tricks, Tips, Hacks, Apps, and Games for your Windows Phone 7! Share this post Link to post Share on other sites
halluzineyt 1 Posted December 7, 2009 (edited) help this is appearing on my admin!! Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/atickmob/public_html/shop/admin/includes/filenames.php:57) in /home/atickmob/public_html/shop/admin/includes/functions/sessions.php on line 67 and this one on my catalog i dont really know what to do now !! Parse error: syntax error, unexpected T_VARIABLE in /home/atickmob/public_html/shop/includes/column_left.php on line 11 i followed all the steps and executed the sql whats wrong pls help i need to finish this today,, the more categories appeared on my admin but this shows up help!! 1146 - Table 'atickmob_atickdbase.categories_more_languages' doesn't exist select * from categories_more, categories_more_languages where enabled = 1 and languages_id = '1' and box_id_language= '1' [TEP STOP] Edited December 7, 2009 by halluzineyt Share this post Link to post Share on other sites
halluzineyt 1 Posted December 7, 2009 I have amended all the files, checked and double checked them using DiffMerge, and I am confident I have done everything correctly. The .sql file executed without errors. However, when I go my store to check the results I am presented with: 1146 - Table 'databasename.categories_more' doesn't exist select * from categories_more where enabled = 1 [TEP STOP] and when I go into the Admin side of my store, and select Catalog>More Categories I am presented with: More Category Boxes 1146 - Table 'databasename.categories_more' doesn't exist select * from categories_more [TEP STOP] I would love any suggestions on this, as this feature is key to how my client whats his store setting up. Thanks in advance, Jonathan HELP Im encountering this too.. i thought it is just the database table i DROPED it then i tried to reinstal now i cant execute it again im getting this help!!!! Error SQL query: 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' ); MySQL said: #1062 - Duplicate entry '8675309' for key 1 Share this post Link to post Share on other sites
halluzineyt 1 Posted December 7, 2009 i reinstalled the contribution hopes somebody will response to this so i can install it again and i can give credits to your work.. Share this post Link to post Share on other sites
halluzineyt 1 Posted December 9, 2009 bump can you just suggest me a running adons that have the same ability as this one it seems that the contributor doesnt go here anymore.. my version is osCommerce Online Merchant v2.x same as others using this stuff but its not working for me.. Share this post Link to post Share on other sites
koun 0 Posted December 16, 2009 Great addon. One question is it possible to have some categorie boxes on the left column and some on the right column? Share this post Link to post Share on other sites
halluzineyt 1 Posted January 13, 2010 has anybody written a right sql codes for this?? 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
halluzineyt 1 Posted January 13, 2010 (edited) AT LAST SOLVED IT!!! GUYS having problems with this.. 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 nevermind the new updates click and download the 1st release. replace this files admin/more_categories.php admin/includes/languages/english/more_categories.php includes/boxes/more_categories.php "USE THE FIRST RELEASE" dont forget that.. the latest updates have errors i dont know why the important part is i made it run successfully! here how it looks like.. My link What i did is followed all the steps on the new release .. but then i used the old files for those 3.. Edited January 13, 2010 by halluzineyt 1 enge reacted to this Share this post Link to post Share on other sites
halluzineyt 1 Posted January 14, 2010 did somebody configured this already?? do you know how can i put the image in right side with a little space and then lessen the gap between the categories?? Share this post Link to post Share on other sites
leebra 0 Posted January 16, 2010 @halluzineyt : i got your following error to, and i try to re-download the first package (7 July 2005), is it right? i replace the 3 following files, but nothing happen? still error... could you help me please?? thankyou so much Share this post Link to post Share on other sites
halluzineyt 1 Posted January 17, 2010 @halluzineyt : i got your following error to, and i try to re-download the first package (7 July 2005), is it right? i replace the 3 following files, but nothing happen? still error... could you help me please?? thankyou so much when you run your SQL do you have errors on it too?? what errors are you getting same as before? Share this post Link to post Share on other sites
leebra 0 Posted January 17, 2010 when you run your SQL do you have errors on it too?? what errors are you getting same as before? when i run the SQL nothing happen, 14 queries successful. but when i try to load my web, the error same as yours. Ok, first. what i should do? download the latest release, but change 3 *new* file with the FIRST RELEASE?? Share this post Link to post Share on other sites
klynns 0 Posted January 20, 2010 I have just installed this contribution and have run across a HUGE issue. I can no longer access my admin panel. I get this instead : Not Found The requested URL /store/admin/FILENAME_LOGIN was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Can anyone help? Thanks! Autumn Share this post Link to post Share on other sites
Jonnoa2 0 Posted January 28, 2010 (edited) I have the following problem where the order I put the category's in on the admin side shows up in a different order to customers on the main site. Can anyone point me in the right direction. Edited January 28, 2010 by Jonnoa2 Share this post Link to post Share on other sites
halluzineyt 1 Posted February 9, 2010 I have just installed this contribution and have run across a HUGE issue. I can no longer access my admin panel. I get this instead : Not Found The requested URL /store/admin/FILENAME_LOGIN was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Can anyone help? Thanks! Autumn check the file permission there must be a file that dont have the right permission,, Share this post Link to post Share on other sites
halluzineyt 1 Posted February 9, 2010 I have the following problem where the order I put the category's in on the admin side shows up in a different order to customers on the main site. Can anyone point me in the right direction. can i see some screen shots? Share this post Link to post Share on other sites
halluzineyt 1 Posted February 9, 2010 when i run the SQL nothing happen, 14 queries successful. but when i try to load my web, the error same as yours. Ok, first. what i should do? download the latest release, but change 3 *new* file with the FIRST RELEASE?? try the second one ? but i think i have done some changes according to the threads sollution on page 1 about the filenames/ Share this post Link to post Share on other sites
orangejax 0 Posted February 13, 2010 (edited) Hello, i also had the problem with "categories_more_languages dos not exist" and how it was told view posts before i replaced three files with the ones from the first release ... Now it works in the admin area .. i activated two category-boxes in the admin area but they don't show up online?? Online it still shows the wohle list of categories ?? would be very happy about answers =) jaxxx Edited February 13, 2010 by orangejax Share this post Link to post Share on other sites
enge 0 Posted April 25, 2010 Hi, Same mistake... I downloaded the 3 files (called news)of the FIRST release, and it's run now. But... what about multi languages ? I try to have "english" and "french" web site.... How can I do ? Box title is now fixed in one language... May be TABLE_CATEGORIES_MORE_LANGUAGES usable for that ?, but don't run actually... Please Help ;-) Thanks Share this post Link to post Share on other sites
enge 0 Posted April 25, 2010 Hi, Same mistake... I downloaded the 3 files (called news)of the FIRST release, and it's run now. But... what about multi languages ? I try to have "english" and "french" web site.... How can I do ? Box title is now fixed in one language... May be TABLE_CATEGORIES_MORE_LANGUAGES usable for that ?, but don't run actually... Please Help ;-) I try to use the last one addon: for 4 languages... but I don't undersatnd how it can works... Thanks Share this post Link to post Share on other sites
enge 0 Posted April 26, 2010 Hi, Same mistake... I downloaded the 3 files (called news)of the FIRST release, and it's run now. But... what about multi languages ? I try to have "english" and "french" web site.... How can I do ? Box title is now fixed in one language... May be TABLE_CATEGORIES_MORE_LANGUAGES usable for that ?, but don't run actually... Please Help ;-) I try to use the last one addon: for 4 languages... but I don't undersatnd how it can works... Thanks Share this post Link to post Share on other sites
enge 0 Posted April 26, 2010 Sorry for spam. This is a bad use of this tool ... But is there anybody to help us ??? I tried to add a table CATECOGIES_MORE_LANGUAGES, but I don't know what column to instert in it... I think something was forgotten on this add-on !!! Thanks a lot. Share this post Link to post Share on other sites