PattyM

I'm using InfoBox Admin v2.25. All works fine but when I go to do an advanced seach, this is what is shows on the page. 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, 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 = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%alcatel%' or p.products_model like '%alcatel%' or m.manufacturers_name like '%alcatel%' or p2pef.products_extra_fields_value like '%alcatel%') ) Can someone tell me how to resolve this problem? Thank you.

I'm hoping one of the experts with EP can help me with this. I'm sure its a common thing. I have EP and Product Extra Field contributions installed and working seperatly. The tables are all created. Both programs work fine seperatly. I just need to be able to put the Product Extra Field table fields in Easy Populate. As of now, Easy populate only adds fields from the products and products_description tables from the default OSC installation. How do I modify Easy Populate code to add the two additional tables and their fields used in Product Extra Fields? The documention in EP reads, EXTRA FIELDS CONTRIBUTION ----------------------------------------- (sorry, ran out of time) and easypopulate.php reads, // FINAL NOTE: this currently only works with the "products" & "products_description" table. // If it works well and I don't get a plethora of problems reported, // I may expand it to more tables. Feel free to make requests, but // as always, only as me free time allows. So where do I get instructions on how to do this???? Thank you.

Thank you for your quick reply. However, my documentation does not give the instructions on how to do this. In the section that reads, X. OTHER CONTRIBUTION INTEGRATION HELP under EXTRA FIELDS CONTRIBUTION, it reads ----------------------------------------- (sorry, ran out of time) So I do not have the instructions on how to make Extra Feilds Contribution work with Easy Populate. Also, in easypopulate.php it reads, // FINAL NOTE: this currently only works with the "products" & "products_description" table. // If it works well and I don't get a plethora of problems reported, // I may expand it to more tables. Feel free to make requests, but // as always, only as me free time allows. If you could provide me with instructions I would greatly appreciate it.

The tables are all created. Both programs work fine seperatly. I just need to be able to put the Product Extra Field tables in Easy Populate. As of now, Easy populate only adds the products and products_description tables from the default OSC installation. How do I modify Easy Populate code to add the two additional tables used in Product Extra Fields?

I'm trying to get New Attribute Manager 4.1b to work. I've installed it 3 times and still am having the same problem. After installing, when I go to edit a product to add the attributes, when I select the product I want to edit, the page just refreshes and never takes me to the attributes page. I'm using OSC 2.2rc2a. Is there a simple fix for this or else another easy attribute manager? I've looked at AJAX attribute manager, but there are no directions on how to install! Any help would be appreciated. Thank you.

I have Products Extra Fields 2_0 installed along iwth Easy Populate 2.7. I realize the instructions only give directions on how to add extra fields to the products and products-descriptions tables thru the easypopulate.php file. However, I also need to add the tables used in the Products Extra Fields contribution which are table names products_extra_fields and products_to_products_extra_field. How do I add these extra tables in to make them work with Easy Populate? I'm using OSC 2.2rc2a Thank you in advance.

Thanks for replying so quick, Jack! Yes, I did run Fill Tags for categories. You wrote, " installing the code changes in the indes file for that section. " Not sure what you mean by "that section". I have the index file in root (that's where store is installed), is there some other index "section" that code needs to be installed in? Thanks again in advance.

Hi! New to the boards and not too familar with php. I have what I think is a simple problem for an expert. However, I don't know how to fix it. I have Header Tags working fine as far as it displaying a category title and category description when creating a new category. My problem is when I have subcategories. In a category with subcategories, I lose the category title and category description and it just displays the subcategories where this text should be. For example, I have a category "Incontinence Supplies". If I have no subcategories, it will display the category title and category description and all the products just fine on the page. However, I would like this category broken down into subcategories "Briefs", "Underpads" etc. Each subcategory shows the title and category descriptions and products, but the main category "Incontinence Supplies" loses its category title and category description. You can see what I mean at https://oxytechmedicalsupply.com. Click on Incontinence Supplies and you will see no title or description. I really need it broken down this way in hopes to better optomize the site. Any help is greatly appreciated. Thanks in advance.