Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Customization from the Admin / Featured Category Addon

Featured Category Addon

Started by jagall on 24 Aug 2011, 2:33 PM · Views: 1,971

Results 1 to 14 of 14
24 Aug 2011, 2:33 PM
#1
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Featured Category Addon

Hi, I have been looking but cannot find a particular thread on this add on. I have downloaded it and have got it semi working but coming up with this error when i click on link in sidebox:

TEXT_DISPLAY_NUMBER_OF_FEATURED_CATEGORY, this will bring you to the category.

Also noticed in the instructions which are little confusing it states that the filenames.php has to be updated in the includes folder. Noticed that the >? is missing from the end of this file but when I put it back in the site stops working??? just wonder if anyone has any thoughts on this?

24 Aug 2011, 2:41 PM
#2
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

jagall:

Hi, I have been looking but cannot find a particular thread on this add on. I have downloaded it and have got it semi working but coming up with this error when i click on link in sidebox:

TEXT_DISPLAY_NUMBER_OF_FEATURED_CATEGORY, this will bring you to the category.

Also noticed in the instructions which are little confusing it states that the filenames.php has to be updated in the includes folder. Noticed that the >? is missing from the end of this file but when I put it back in the site stops working??? just wonder if anyone has any thoughts on this?

In addition to this none of the features under admin/configuration are displaying either

24 Aug 2011, 3:17 PM
#3
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Featured Category Addon

It sounds like you didn't upload some of the files/folders to the right places.

That constant is defined in includes/languages/english.php, which should have ended up in includes/languages/YOUR_TEMPLATE.

https://www.zen-cart.com/tutorials/index.php?article=313

24 Aug 2011, 3:31 PM
#4
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

stevesh:

It sounds like you didn't upload some of the files/folders to the right places.

That constant is defined in includes/languages/english.php, which should have ended up in includes/languages/YOUR_TEMPLATE.

https://www.zen-cart.com/tutorials/index.php?article=313

that text is actually in the tpl_featured_categories_default.php in the template folder, the instructions advised to put in the template_default but I put copy in both the template_default and my own template folder, as there is nothing showing either for the settings in the admin side, i.e. settings but it does allow me to add a category?

24 Aug 2011, 3:42 PM
#5
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Featured Category Addon

Yes, but it's defined in english.php. That definition isn't there, which is why you're seeing the constant name.

I'll have to take a look at the admin part.

24 Aug 2011, 3:48 PM
#6
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

changed the english.php file, the instructions said define('TEXT_DISPLAY_NUMBER_OF_FEATURED_CATEGORIES', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> categories on featured)'); //featured category

but think it should be:

define('TEXT_DISPLAY_NUMBER_OF_FEATURED_CATEGORY', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> categories on featured)'); //featured category

so the text is gone and is displaying 1 of 2 but nothing actually displays at this point unless you click the link i.e. displaying 1 of 2

25 Aug 2011, 9:25 AM
#7
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

Hi Stevesh,

Got this working, discovered that was missing the ; on the last configuration_group table, duh I know but working fine now except cannot seem to get it to display as single column but prob some setting I am not changing. thanks for help.
On another note do you know anything about using tabbed product pro?

27 Aug 2011, 2:07 PM
#8
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

autoace

It was same sql that I downloaded but I just added the ; at the end of last statement but here it is anyway:

CREATE TABLE categories_featured (
featured_id int( 11 ) NOT NULL AUTO_INCREMENT ,
categories_id int( 11 ) NOT NULL default '0',
featured_date_added datetime default NULL ,
featured_last_modified datetime default NULL ,
expires_date date NOT NULL default '0001-01-01',
date_status_change datetime default NULL ,
status int( 1 ) NOT NULL default '1',
featured_date_available date NOT NULL default '0001-01-01',
PRIMARY KEY ( featured_id ) ,
KEY idx_status_zen ( status ) ,
KEY idx_categories_id_zen ( categories_id ) ,
KEY idx_date_avail_zen ( featured_date_available ) ,
KEY idx_expires_date_zen ( expires_date )
);

INSERT INTO configuration_group (
configuration_group_id ,
configuration_group_title ,
configuration_group_description ,
sort_order ,
visible
)
VALUES (
2811, 'Featured Categories Listing', 'Featured Categories Listing', '23', '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 (
NULL , 'Random Featured Categories for SideBox', 'MAX_RANDOM_SELECT_FEATURED_CATEGORIES', '2', 'Number of random FEATURED categories to rotate in the sidebox<br />Enter the number of categories to display in this sidebox at one time.<br /><br />How many categories do you want to display in this sidebox?', '3', '30', NULL , '0000-00-00 00:00:00', NULL , NULL
),

(
NULL , 'Display Category Display - Default Sort Order', 'CATEGORY_FEATURED_LIST_SORT_DEFAULT', '1', 'What Sort Order Default should be used for Featured Category Display?<br />Default= 1 for Category Name<br /><br />1= Category Name<br />2= Category Name Desc<br />3= Date Added desc<br />4= Date Added<br />5= Category Sort Order', '2811', '11', NULL , '', NULL , 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''5''), '
),
(
NULL , 'Maximum Display of Featured Categories Page', 'MAX_DISPLAY_CATEGORIES_FEATURED', '10', 'Number of featured categories to list per screen', '2811', '29', NULL , '', NULL , NULL
),

(
NULL , 'Display Category Image', 'CATEGORY_FEATURED_LIST_IMAGE', '1102', 'Do you want to display the category Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', '2811', '1', NULL , '', NULL , NULL
),

(
NULL , 'Category Image - No Image Status', 'CATEGORY_IMAGE_NO_IMAGE_STATUS', '1', 'Use automatic No Image when none is added to category<br />0= off<br />1= On', '4', '60', NULL , '2008-05-12 15:37:20', NULL , 'zen_cfg_select_option(array(''0'', ''1''), '
),
(
NULL , 'Image - Featured Categories Height', 'IMAGE_FEATURED_CATEGORY_LISTING_HEIGHT', '80', 'Default = 80', '4', '47', NULL , '', NULL , NULL
),
(
NULL , 'Image - Featured Category Width', 'IMAGE_FEATURED_CATEGORY_LISTING_WIDTH', '100', 'Default = 100', '4', '46', NULL , '', NULL , NULL
),
(
NULL , 'Display Category Name', 'CATEGORY_FEATURED_LIST_NAME', '2101', 'Do you want to display the Category Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', '2811', '4', NULL , '', NULL , NULL
),

(
NULL , 'Display Category Date Added', 'CATEGORY_FEATURED_LIST_DATE_ADDED', '2601', 'Do you want to display the Category Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', '2811', '9', NULL , '', NULL , NULL
),
(
NULL , 'Display Category Description', 'CATEGORY_FEATURED_LIST_DESCRIPTION', '150', 'How many characters do you want to display of the Category Description?<br /><br />0= OFF<br />150= Suggested Length, or enter the maximum number of characters to display', '2811', '10', NULL , '', NULL , NULL
),
(
NULL , 'Default Featured Categories Group ID', 'CATEGORY_FEATURED_LIST_GROUP_ID', '2811', 'Warning: Only change this if your Featured Categories Group ID has changed from the default of 2811<br />What is the configuration_group_id for Featured Categories Listings?', '2811', '12', NULL , '', NULL , NULL
),

(
NULL , 'Show Featured Categories on Main Page', 'SHOW_PRODUCT_INFO_MAIN_FEATURED_CATEGORIES', '2', 'Show Featured Categories on Main Page<br />0= off or set the sort order', '24', '66', '', '', NULL , 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3'', ''4''), '
),
(
NULL , 'Show Featured Categories on Main Page - Errors and Missing Categories Page', 'SHOW_PRODUCT_INFO_MISSING_FEATURED_CATEGORY', '4', 'Show Featured Categories on Main Page - Errors and Missing Categories <br />0= off or set the sort order', '24', '76', NULL , '0000-00-00 00:00:00', NULL , 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3'', ''4''), '
),
(
NULL , 'Featured Categories Columns per Row', 'SHOW_CATEGORY_INFO_COLUMNS_FEATURED_CATEGORIES', '3', 'Featured Categories Columns per Row', '24', '96', NULL , '', NULL , 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''5'', ''6'', ''7'', ''8'', ''9'', ''10'', ''11'', ''12''), '
),
(
NULL , 'Maximum Display of Featured Categories - Main Page', 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED_CATEGORIES', '9', 'Number of featured Categories to list on main page', '3', '28', NULL , '', NULL , NULL
);

Did you change anything in either the configuration group or configuration tables prior to installing this?

27 Aug 2011, 5:03 PM
#9
autoace avatar

autoace

Totally Zenned

Join Date:
Jun 2009
Posts:
618
Plugin Contributions:
0

Re: Featured Category Addon

No, I didn't change anything in the sql code.

Thank you,
autoace

27 Aug 2011, 9:39 PM
#10
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

how are you installing the sql, are you uploading the file or pasting in the text?

28 Aug 2011, 2:28 AM
#11
autoace avatar

autoace

Totally Zenned

Join Date:
Jun 2009
Posts:
618
Plugin Contributions:
0

Re: Featured Category Addon

Pasting the text.

Thank you,
autoace

29 Aug 2011, 12:15 AM
#12
jagall avatar

jagall

Zen Follower

Join Date:
Mar 2011
Location:
Ireland
Posts:
286
Plugin Contributions:
0

Re: Featured Category Addon

autoace:

Pasting the text.

hi did you get this to work yet?

30 Aug 2011, 10:38 PM
#13
autoace avatar

autoace

Totally Zenned

Join Date:
Jun 2009
Posts:
618
Plugin Contributions:
0

Re: Featured Category Addon

No not yet, :frusty:

Thank you,
autoace

21 Oct 2011, 5:23 PM
#14
everayla avatar

everayla

New Zenner

Join Date:
Feb 2011
Location:
Durango, CO
Posts:
21
Plugin Contributions:
0

Re: Featured Category Addon

Okay, we have added this addon, but we keep getting this error when we click on the Featured Categories bar in the Catalog tab in our admin:
1146 Table 'everayla_znc1.TABLE_FEATURED_CATEGORY' doesn't exist
in:
[select count(*) as total from znc_categories c, TABLE_FEATURED_CATEGORY f, znc_categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.categories_id = f.categories_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Does anyone know what we need to do to fix this?

Thanks
Everayla Outdoors
https://www.everayla.com