140 replies to this topic

[kymation]

Changing to include_once() fixed it for me, but other people have previously stated that this did not fix the problem for them. I have no idea why it is working sometimes and not others.

Yes, the include() in application_top.php should be enough, but it doesn't seem to work, even if you global() the variable. Another puzzle.

Regards
Jim

[apolyshow]

apolyshow, on 29 December 2011 - 11:32 AM, said:

Another one problem
When i am installing the Search module and tells it to find something in my site like a manufacturer it returns an error . This the message

1054 - Unknown column 'p2pef.products_extra_fields_value' in 'where clause'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) , products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%sanyo%' or p.products_model like '%sanyo%' or m.manufacturers_name like '%sanyo%' or p2pef.products_extra_fields_value like '%sanyo%' or pd.products_description like '%sanyo%') )

[TEP STOP]


Can you help me?

Any help?

[Gergely]

apolyshow, on 30 December 2011 - 04:35 PM, said:

Any help?

There is no products_extra_fields_value field.
Install extra field into your data table and do controll at advanced_search.php.

[apolyshow]

I am facing this kind of problem. Wheni am installing the languages module at the right header and then go to install and another one to the same grid then the second goes to the same line. I want to put it down after and not right next to the first cause at he same line it goes outside of my borders. How can we put the language in the midle or in the right float?

[mumme]

I found a small bug with the menu model.

If you create a menu elements with dopdown  in the end of the menu, just before the "manufactures +".
Then the "Manufactures +" will be doubled and be posted both in the main menu and in the "drop-down" menu.
If you post a menu elemnts wihout dropdown, between the one with the dropdown and the manufaturex +, it works.

[mumme]

I have added a function to show the main categories in the menu, (as dropdown like manufactures +).
It works, and i can put up installation instructions if any body wants, I just have a problem with multilanguage:

This Query is working fine, as you can see I have put cd.language_id='1'

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES  . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id  and cd.language_id='1' order by sort_order, cd.categories_name");

But I want a multilangugage function in a query like this.
(with cd.language_id="'.$languages_id.'"
This query isnt working, do anybody know how to get the right language in the query?

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");

[Gergely]

mumme, on 02 January 2012 - 11:53 AM, said:

I found a small bug with the menu model.

If you create a menu elements with dopdown  in the end of the menu, just before the "manufactures +".
Then the "Manufactures +" will be doubled and be posted both in the main menu and in the "drop-down" menu.
If you post a menu elemnts wihout dropdown, between the one with the dropdown and the manufaturex +, it works.

Hi mumme,

thanks for bug report. I will be improve.

regards,
Gergely

[Gergely]

mumme, on 02 January 2012 - 01:38 PM, said:

I have added a function to show the main categories in the menu, (as dropdown like manufactures +).
It works, and i can put up installation instructions if any body wants, I just have a problem with multilanguage:

This Query is working fine, as you can see I have put cd.language_id='1'

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES  . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id  and cd.language_id='1' order by sort_order, cd.categories_name");

But I want a multilangugage function in a query like this.
(with cd.language_id="'.$languages_id.'"
This query isnt working, do anybody know how to get the right language in the query?

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");

Look at bm_categories.php

Regards,
Gergely

[vmjarala]

Hi!

This contribution looks great! Thanks, Gergely!
However, I can't find it anywhere to install on my admin screens. I saw someone else posted the same, and I looked again at the same spot, and no module was available for installation.

I wonder if I'm missing any of the pre-reqs to run this? I do have the one that is called "contributions". I need that, right?

Any other tips?

I am working with the latest version from 12/31.

Thanks!

[Gergely]

vmjarala, on 02 January 2012 - 10:20 PM, said:

Hi!

This contribution looks great! Thanks, Gergely!
However, I can't find it anywhere to install on my admin screens. I saw someone else posted the same, and I looked again at the same spot, and no module was available for installation.

I wonder if I'm missing any of the pre-reqs to run this? I do have the one that is called "contributions". I need that, right?

Any other tips?

I am working with the latest version from 12/31.

Thanks!

Hi,

did you install http://addons.oscommerce.com/info/8186 SCM?

Regards,
Gergely

[vmjarala]

Thanks for your reply, Gergely!

Yes, I do have that one. I believe it's the one that has added the following to my admin section (+ "extends" and "example" boxes):

[img]C:\Users\Vero\Desktop\contrib.jpg[/img]

What else am I missing?
I don't seem to be able to do anything with this particular addon.

Thanks again for your help!

[vmjarala]

Doesn't look like the image attached... and I can't seem to get it up here... sorry

[mumme]

Gergely, on 02 January 2012 - 08:31 PM, said:

Look at bm_categories.php

Regards,
Gergely

I copied the query from bm_categories.php

But in bm_Categories.php i find this:

function getData() {
	  global $categories_string, $tree, $languages_id, $cPath, $cPath_array;
	  $categories_string = '';

So i guess I need to implement the getData -> $languages_id into hfc_menu.php.

I will try..

[vmjarala]

Magnus,
Please let me know if that works. And, if so, how you implement that...

[vmjarala]

The other thing I don't remember doing is running a SQL query. Was I supposed to for any of the addons?  Was that supposed to happen automatically?  Thanks again!

[apolyshow]

I want to put an image in my header background and the module doesn't understand it to control the grid and put the modules.
Tje code that i have put to stylesheet is

#
header {

height: 240px;

background-image: url('images/header_bg.jpg');

background-repeat:no-repeat;

}

What can i do so the module understands the size of this image? Do i have to configure the grids?
Is the code for the image ok?  Do i have to put something else also in another page?

Edited by apolyshow, 04 January 2012 - 01:33 PM.

[Gergely]

apolyshow, on 01 January 2012 - 07:59 PM, said:

I am facing this kind of problem. Wheni am installing the languages module at the right header and then go to install and another one to the same grid then the second goes to the same line. I want to put it down after and not right next to the first cause at he same line it goes outside of my borders. How can we put the language in the midle or in the right float?

Use sort order options for modules first. The second problem if it dosen't work. Then http://forums.oscommerce.com/tracker/issue-370-box-header-tags-modules-sort-order-bugfix-need/.

Finaly you have to edit module codes.

[Gergely]

vmjarala, on 03 January 2012 - 07:26 PM, said:

Thanks for your reply, Gergely!

Yes, I do have that one. I believe it's the one that has added the following to my admin section (+ "extends" and "example" boxes):

[img]C:UsersVeroDesktopcontrib.jpg[/img]

What else am I missing?
I don't seem to be able to do anything with this particular addon.

Thanks again for your help!

The normal steps:

1. Install main HFC module handler (Header Footer Contents Modules v1.11)
2. Test HFC modules


3. Install Admin Extends
4. Add extend boxes from contributions admin menu

5. Add menu module v1.2 (copy only)
6. Install menu from install.txt and upgrage.txt
7. Install menu module from header footer contents

[Gergely]

vmjarala, on 04 January 2012 - 12:57 AM, said:

The other thing I don't remember doing is running a SQL query. Was I supposed to for any of the addons?  Was that supposed to happen automatically?  Thanks again!

If developers use this module availabilty.

[vmjarala]

Thanks, Gergely!

The normal steps:

1. Install main HFC module handler (Header Footer Contents Modules v1.11)
2. Test HFC modules
I INSTALLED: http://addons.oscommerce.com/info/8165
I HAVE THE 12/31 VERSION. I WAS NOT ABLE TO TEST BECAUSE I COULD NOT SEE A WAY TO ACTUALLY ACTIVATE MODULES! ALL CHMOD PERMISSIONS ARE SET TO 755. BECAUSE I COULDN'T DO IT, I WENT BACK AND STARTED TRYING TO FIND THE PRE-REQS
(btw, I'm not shouting... just a quick way of responding to you without the quoting feature)  )
What else could be wrong? I did go back and compare what I had with the newest I could find marked as "full package" (v1.2). Are you telling me I should use the v1.11, instead?
THANKS!


3. Install Admin Extends
4. Add extend boxes from contributions admin menu
DONE

5. Add menu module v1.2 (copy only)
6. Install menu from install.txt and upgrage.txt
7. Install menu module from header footer contents
I THINK I GOT THIS TOO.