Jump to content



Photo
- - - - -

Header Footer Content Modules for V2.3


  • Please log in to reply
222 replies to this topic

#81   NodsDorf

NodsDorf
  • Members
  • 1,284 posts
  • Real Name:Don Ford
  • Gender:Male
  • Location:ohio usa

Posted 30 January 2012 - 22:21

@Gergely

I have the same issue as Veronica.

1146 - Table 'columb22_231osc.TABLE_MENU' doesn't exist

select count(*) as total from TABLE_MENU x left join TABLE_MENU_TEXT y on x.menu_id = y.menu_id where y.language_id = '1'


The problem is that Header & Footer Conent is not in my Module Box, (see screen shot)

I don't know if we skipped some instructions or what. I have read them many times and do not believe I missed any steps. Somewhere we have to get the module installed but I don't see anywhere how to do that.

I want to make sure I don't miss anything so here are the instructions:

Step 1.
Make a full backup first!!!!!!!!!!!!
DONE

Step 2.
Install preconditions
These Are:
SCM
- Allmanufacturers -Done
- Admin extends boxes -Done




Step 3.
Add new menu modul to follow the path.
I have no idea what this means ?

Step 4.
Add superfish-1.4.8 package to catalog/ext/jquery/superfish/
-Done


Step 5.
If you have already installed allmanufacturers.php be carefull.
Allow allmanufacturers module in SCM if you like to use manufacturers in menu.


Step 6.
Install in Header Footer Content Modules Menu package.
Where? / How? / I don't See it Anywhere.

Step 7.
If you didnt add admin boxes yet do it now.
If you mean extra boxes.. yes done.


Step 8.
Add new menu elements in menu editor.
not available because Header Footer isn't installed yet..


Step 9.
Configure Menu Module.
not available because Header Footer isn't installed yet..


Step 10.
Look at cache enhance (A section) in upgrade_v1.0_to_v1.2.txt
Done


Additionally I have ran the queries you asked Veronica to:
SELECT *
FROM `configuration_group`
WHERE `configuration_group_title` LIKE '%FILENAME%'

SQL query: SELECT * FROM `configuration_group` WHERE `configuration_group_title` LIKE '%FILENAME%' LIMIT 0, 30 ;
Rows: 2 configuration_group_id configuration_group_title configuration_group_description sort_order visible 16 FILENAME_ Define files in configuration table 1 0 18 ADMIN_FILENAME_ Define files in configuration table 1 0

SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%MENU%'

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0007 sec )


SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%EXTENDS%'

Generated by: phpMyAdmin 3.4.7.1 / MySQL 5.1.56-log
SQL query: SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%EXTENDS%' LIMIT 0, 30 ;
Rows: 4 configuration_id configuration_title configuration_key configuration_value configuration_description configuration_group_id sort_order last_modified date_added use_function set_function 423 Module Version Number SQL_EXTENDS_VERSION_NUMBER v1.1 Version number of installed module 6 1 NULL 2012-01-30 15:50:31 NULL tep_sanitize_string( 424 Extends Admin Box FILENAME_EXTENDS extends_.php Set Extends Admin Box filename. Do not edit! 18 2 NULL 0000-00-00 00:00:00 NULL tep_sanitize_string( 448 Extends example second filename FILENAME_EXTENDS_EXAMPLE2 extends_example2.php Set Extends Example second filename. Do not edit! 18 1 NULL 0000-00-00 00:00:00 NULL NULL 447 Module Version Number SQL_EXTENDS_EXAMPLE_VERSION_NUMBER v1.0 Version number of installed module 6 1 NULL 2012-01-30 16:18:36 NULL tep_sanitize_string(


I really appreciate all the work you put into this, I would love to get it working correctly.
Thank you very much,
Don

Attached Files


Edited by NodsDorf, 30 January 2012 - 22:27.


#82   Gergely

Gergely

    Action Hero

  • Community Team
  • 1,256 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 02 February 2012 - 18:39

@Gergely

I have the same issue as Veronica.

1146 - Table 'columb22_231osc.TABLE_MENU' doesn't exist

select count(*) as total from TABLE_MENU x left join TABLE_MENU_TEXT y on x.menu_id = y.menu_id where y.language_id = '1'


The problem is that Header & Footer Conent is not in my Module Box, (see screen shot)

I don't know if we skipped some instructions or what. I have read them many times and do not believe I missed any steps. Somewhere we have to get the module installed but I don't see anywhere how to do that.

I want to make sure I don't miss anything so here are the instructions:


Additionally I have ran the queries you asked Veronica to:

SELECT *
FROM `configuration_group`
WHERE `configuration_group_title` LIKE '%FILENAME%'

SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%MENU%'


SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%EXTENDS%'


I really appreciate all the work you put into this, I would love to get it working correctly.
Thank you very much,
Don


Hi all,

the main problem is that you are not installed Header Footer Content Modules!

Download header_footer_content_modules_v1.2.zip and install it.

regards,
Gergely

some rewrites :-


#83   NodsDorf

NodsDorf
  • Members
  • 1,284 posts
  • Real Name:Don Ford
  • Gender:Male
  • Location:ohio usa

Posted 02 February 2012 - 20:29

@Gergely

How I missed that I don't know, thank you very much, Everything seems to be working correctly now.

#84   apolyshow

apolyshow
  • Members
  • 244 posts
  • Real Name:Andreas
  • Gender:Male

Posted 17 February 2012 - 09:35

Does anyone knows that the hfc menu doesn't work in Mozilla? The links are not working but in IE 9 everythink is ok....
One amateur made the Arc, 5.000 pro made the Titanic...

#85   Gergely

Gergely

    Action Hero

  • Community Team
  • 1,256 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 17 February 2012 - 15:28

Could you pass a link to me for testing?

some rewrites :-


#86   apolyshow

apolyshow
  • Members
  • 244 posts
  • Real Name:Andreas
  • Gender:Male

Posted 18 February 2012 - 08:34

www. iliofos.gr/estore

And i am fasing this problem when i am installing the Manufactures in the menu bar then when i am choosing the page everything is ok and the page with all manufacturers is coming. But when i am choosing a manufacturer from that page then i am taking this error inside the page

1054 - Unknown column 'c.categories_hide_from_groups' in 'where clause'

select count(p.products_id) as total from products p left join specials_retail_prices s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '19' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0

[TEP STOP]

One amateur made the Arc, 5.000 pro made the Titanic...

#87   Gergely

Gergely

    Action Hero

  • Community Team
  • 1,256 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 18 February 2012 - 13:44

1054 - Unknown column 'c.categories_hide_from_groups' in 'where clause'

select count(p.products_id) as total from products p left join specials_retail_prices s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '19' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0

[TEP STOP]


Well, the products_to_categories and the categories table is not set in the query. Oscommerce use left join like this:

left join ". TABLE_PRODUCTS_TO_CATEGORIES . " p2c on (p.products_id = p2c.products_id) left join " . TABLE_CATEGORIES . " c on (p2c.categories_id = c.categories_id)

some rewrites :-


#88   kymation

kymation

    Code Monkey

  • Community Sponsor
  • 8,335 posts
  • Real Name:Jim Keebaugh
  • Gender:Male
  • Location:Aberdeen WA USA

Posted 18 February 2012 - 18:35

@apolyshow -- categories_hide_from_groups is not a field in a stock osCommerce database. It appears that you have tried to install another Addon to hide categories and have not completed the install process. You need to complete the database portion of that other Addon or remove it.

Regards
Jim

My Addons

Banners Box Download Support
Categories Accordion Box Download Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box Download Support
Get 1 Free 2.2x Support
Modular Front Page Download Support
Modular SEO Header Tags Download Support
MVS 2.2x Support
PDF Datasheet Download Support
Price in Cart Only/MAPP Download Support
Price Updater 2.2x
Products Specifications 2.3.x Development Version Support Bugs/Suggestions
Request a Review Download Support
Shopping List Download Support New!
Specials Image Overlay Download Support
Superfish Categories Box Download Support
Theme Switcher 2.3+ Support  Updated


#89   apolyshow

apolyshow
  • Members
  • 244 posts
  • Real Name:Andreas
  • Gender:Male

Posted 18 February 2012 - 19:15

I have fix the error but i haven't fix the issue with Mozzila
One amateur made the Arc, 5.000 pro made the Titanic...

#90   apolyshow

apolyshow
  • Members
  • 244 posts
  • Real Name:Andreas
  • Gender:Male

Posted 06 March 2012 - 10:42

Is it possible to help me create the submenu?
When i am trying to create a sub page it always goes in a wrong place....
Pleaser help cause i am not a programmer...
One amateur made the Arc, 5.000 pro made the Titanic...

#91   apolyshow

apolyshow
  • Members
  • 244 posts
  • Real Name:Andreas
  • Gender:Male

Posted 20 March 2012 - 16:30

Not in Mozilla but also not working with chrome....
At least me can't work hfc menu in those browsers
And when i am saying not working , you can't choose the menus from these browsers....

Edited by apolyshow, 20 March 2012 - 16:32.

One amateur made the Arc, 5.000 pro made the Titanic...

#92   Guidog

Guidog
  • Members
  • 4 posts
  • Real Name:Guido

Posted 04 April 2012 - 10:12

Hello!
I uploaded all files, but can't install modules.
When I go ( in admin) to Modules --> Header-Footer Contents--> + Install Module (10) [top right]
I see list of modules, but I dont see "install" button.
but I see:
Parse error: syntax error, unexpected T_CLASS in /home/may/store/root/includes/modules/header_footer_contents/hfc_manufacturers.php on line 1

There is not white spaces.
File have just one row and lot of content are commented out (it should be so?) (I uncommented, but no changes... shows just error).

I installed version:
Header Footer Content Modules v1.2
1 Oct 2011

#93   Gergely

Gergely

    Action Hero

  • Community Team
  • 1,256 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 05 April 2012 - 09:11

@Guidog

Hi

The hfc_manufacturers.php should contain correct codes. I have just downloaded the packege and its correct.

some rewrites :-


#94   CrazyCarzCustoms

CrazyCarzCustoms
  • Members
  • 151 posts
  • Real Name:Rob
  • Gender:Male
  • Location:Oliveira do Hospital - Portugal

Posted 16 July 2012 - 15:54

Hi Gergely,

I am trying to install your module ( twice now ( i am a double noob) ) but i get this message:



Parse error: syntax error, unexpected T_CLASS in/home/xxxxxxxxx/public_html/includes/modules/header_footer_contents/hfc_information.php on line 1

Also the modules bos on the left side looks strange , it is still working but it is not like normal , do you have any idea what i am doing wrong here?
Thanks very much for any help you can give.



Greets,
Rob

#95   CrazyCarzCustoms

CrazyCarzCustoms
  • Members
  • 151 posts
  • Real Name:Rob
  • Gender:Male
  • Location:Oliveira do Hospital - Portugal

Posted 16 July 2012 - 16:26

Hi Gergely,

As some extra info:

This is how some of the files look in DW , 5 are like this and 5 are nice like you expect them to be.


<?php/* $Id$ Author: Tóth Gergely http://oscom.hu v1.0 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2010 osCommerce Released under the GNU General Public License*/ class hfc_manufacturers { var $code = 'hfc_manufacturers'; var $group = 'header_footer_contents'; var $title; var $description; var $sort_order; var $enabled = false; function hfc_manufacturers() { $this->title = MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_TITLE; $this->description = MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_DESCRIPTION; if ( defined('MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_STATUS') ) { $this->sort_order = MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_SORT_ORDER; $this->enabled = (MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_STATUS == 'True'); switch (MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_CONTENT_PLACEMENT) { case 'Left Header' : $this->group = 'header_contents_left'; break; case 'Center Header' : $this->group = 'header_contents_center'; break; case 'Right Header' : $this->group = 'header_contents_right'; break; case 'Header Line' : $this->group = 'header_line'; break; case 'Left Footer' : $this->group = 'footer_contents_left'; break; case 'Center Footer' : $this->group = 'footer_contents_center'; break; case 'Right Footer' : $this->group = 'footer_contents_right'; break; case 'Footer Line' : $this->group = 'footer_line'; break; } } } function getData() { global $HTTP_GET_VARS, $oscTemplate; $data = ''; $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name"); if ($number_of_rows = tep_db_num_rows($manufacturers_query)) { if ($number_of_rows <= MAX_DISPLAY_MANUFACTURERS_IN_A_LIST) {// Display a list $manufacturers_list = '<ul style="list-style: none; margin: 0; padding: 0;">'; while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { $manufacturers_name = ((strlen($manufacturers['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturers['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $manufacturers['manufacturers_name']); if (isset($HTTP_GET_VARS['manufacturers_id']) && ($HTTP_GET_VARS['manufacturers_id'] == $manufacturers['manufacturers_id'])) $manufacturers_name = '<strong>' . $manufacturers_name .'</strong>'; $manufacturers_list .= '<li><a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id']) . '">' . $manufacturers_name . '</a></li>'; } $manufacturers_list .= '</ul>'; $content = $manufacturers_list; } else {// Display a drop-down $manufacturers_array = array(); if (MAX_MANUFACTURERS_LIST < 2) { $manufacturers_array[] = array('id' => '', 'text' => PULL_DOWN_DEFAULT); } while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { $manufacturers_name = ((strlen($manufacturers['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturers['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $manufacturers['manufacturers_name']); $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers_name); } $content = tep_draw_form('manufacturers', tep_href_link(FILENAME_DEFAULT, '', 'NONSSL', false), 'get') . tep_draw_pull_down_menu('manufacturers_id', $manufacturers_array, (isset($HTTP_GET_VARS['manufacturers_id']) ? $HTTP_GET_VARS['manufacturers_id'] : ''), 'onchange="this.form.submit();" size="' . MAX_MANUFACTURERS_LIST . '" style="width: 100%"') . tep_hide_session_id() . '</form>'; } $data = '<div class="ui-widget infoBoxContainer">' . ' <div class="ui-widget-header infoBoxHeading">' . MODULE_BOXES_MANUFACTURERS_BOX_TITLE . '</div>' . ' <div class="ui-widget-content infoBoxContents">' . $content . '</div>' . '</div>'; } return $data; } function execute() { global $SID, $oscTemplate; if ((USE_CACHE == 'true') && empty($SID)) { $output = tep_cache_manufacturers_box(); } else { $output = $this->getData(); } $oscTemplate->addBlock($output, $this->group); } function isEnabled() { return $this->enabled; } function check() { return defined('MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_STATUS'); } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Currencies Module', 'MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_CONTENT_PLACEMENT', 'Right Header', 'Should the module be loaded in the header or the footer position?', '6', '1', 'tep_cfg_select_option(array(\'Left Header\', \'Center Header\', \'Right Header\', \'Header Line\', \'Left Footer\', \'Center Footer\', \'Right Footer\', \'Footer Line\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Module Version Number', 'MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_VERSION_NUMBER', 'v1.0', 'Version number of installed module', '6', '1', 'tep_sanitize_string(', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { return array('MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_VERSION_NUMBER','MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_STATUS', 'MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_CONTENT_PLACEMENT', 'MODULE_HEADER_FOOTER_CONTENTS_MANUFACTURERS_SORT_ORDER'); } }?>

#96   CrazyCarzCustoms

CrazyCarzCustoms
  • Members
  • 151 posts
  • Real Name:Rob
  • Gender:Male
  • Location:Oliveira do Hospital - Portugal

Posted 16 July 2012 - 16:45

Hi Gergely,I think i found it , there were some files , like the one up one post , corrupted , i just opend the original files and replaced the corrupted files , using copy and paste , with the original files in DreamWeaver and that seems to have done the trick.
So now i have a look and see how this works ;-)

Gr. Rob

#97   CrazyCarzCustoms

CrazyCarzCustoms
  • Members
  • 151 posts
  • Real Name:Rob
  • Gender:Male
  • Location:Oliveira do Hospital - Portugal

Posted 17 July 2012 - 10:38

Hi Gergely,

I´m back again , in your manual you say at point A. uninstall header footer old modules.

Can you explain wich files or modules you mean by that please.

Gr. Rob

#98   CrazyCarzCustoms

CrazyCarzCustoms
  • Members
  • 151 posts
  • Real Name:Rob
  • Gender:Male
  • Location:Oliveira do Hospital - Portugal

Posted 19 July 2012 - 11:21

OK , figured that one out.

#99   CrazyCarzCustoms

CrazyCarzCustoms
  • Members
  • 151 posts
  • Real Name:Rob
  • Gender:Male
  • Location:Oliveira do Hospital - Portugal

Posted 19 July 2012 - 13:07

Use sort order options for modules first. The second problem if it dosen't work. Then http://forums.oscomm...r-bugfix-need/.

Finaly you have to edit module codes.


Hmmm , did this but it did not resolve the problem , i might have another problem then.
Still , if i install the cart and the search box in the same header part ( header right) but with different sort numbers than i think that the search box goes over the cart.
Any suggestions?

Gr, Rob

#100   Gergely

Gergely

    Action Hero

  • Community Team
  • 1,256 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 19 July 2012 - 14:58

Hi,

Maybe something missing in install process before. The sort number works even if you use a 0 sort value and off use the module. The above link fix this problem.

Switch on all modules whitch are installed and use not 0 value for sorts.

Maybe the search or the cart module can be inconsistent in html codes.

Sorry me, I have doing and testing the next release but no time to finish the new pack yet.

some rewrites :-