92 replies to this topic

[NodsDorf]

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

Quote

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%'

Quote

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%' 

Quote

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

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

Quote

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

•  hfc-issue.jpg   93.34K   8 downloads

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

[Gergely]

NodsDorf, on 30 January 2012, 22:21, said:

@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

[NodsDorf]

@Gergely

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

[apolyshow]

Does anyone knows that the hfc menu doesn't work in Mozilla? The links are not working but in IE 9 everythink is ok....

[Gergely]

Could you pass a link to me for testing?

[apolyshow]

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]

[Gergely]

apolyshow, on 18 February 2012, 08:34, said:

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)

[kymation]

@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

[apolyshow]

I have fix the error but i haven't fix the issue with Mozzila

[apolyshow]

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...

[apolyshow]

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.

[Guidog]

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

[Gergely]

@Guidog

Hi

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