Latest News: (loading..)
Sign in to follow this  
Followers 0
jcall

[Contribution] More Category Boxes

293 posts in this topic

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by halluzineyt

Share this post


Link to post
Share on other sites

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

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

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

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

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

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 by halluzineyt
enge likes this

Share this post


Link to post
Share on other sites

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

@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 :

 

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

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

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

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 by Jonnoa2

Share this post


Link to post
Share on other sites

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

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

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

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 by orangejax

Share this post


Link to post
Share on other sites

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

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

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

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

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  
Followers 0