frafac Posted June 25, 2008 Share Posted June 25, 2008 Hi all, I've just installed "product extra fields" contribution on my fresh installation of oscommerce 2.2...but I have a problem... in admin panel I can add new fields... but I cannot insert fields value in the add product page... and naturally I can see nothing in diplay product page. my osc is 2.2rc2a and the contribution is extra_fields_v2_0i.zip, available in http://addons.oscommerce.com/info/2202 Any ideas will be appreciates... Regards Francesco Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 25, 2008 Share Posted June 25, 2008 Have you defined the extra product field using Product Maintenance >> Product Extra Fields in your admin area? If you have check you have updated admin/categories.php as per the installation instructions Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
satish Posted June 25, 2008 Share Posted June 25, 2008 Your contrib installation is incomplete. Satish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
frafac Posted June 25, 2008 Author Share Posted June 25, 2008 Your contrib installation is incomplete. Satish What can I do to complete installation? Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 25, 2008 Share Posted June 25, 2008 Read the installation instructions and follow all of them Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
satish Posted June 26, 2008 Share Posted June 26, 2008 logic: when You add product fields thru admin then these details go in data base. Now a code uses this detail and creates additional field related boxes in admin product cretae page. Also the details for these products then are used in user side to display. So see that all steps are taken care. Satish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
frafac Posted June 27, 2008 Author Share Posted June 27, 2008 I forgot some code in categories.php.. and now when I create a new product I can finally see the field I created... and Insert it... But I have now another problem.. in the product_info.php.. when I see product info page I cannot see field I created... so I change product_info.php with that in the contribution...and than I0ve this error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languag' at line 5 SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value ,pef.products_extra_fields_status as status FROM products_extra_fields pef LEFT JOIN products_to_products_extra_fields ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id= and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order What's wrong? Thanks in advance... logic:when You add product fields thru admin then these details go in data base. Now a code uses this detail and creates additional field related boxes in admin product cretae page. Also the details for these products then are used in user side to display. So see that all steps are taken care. Satish Quote Link to comment Share on other sites More sharing options...
satish Posted June 27, 2008 Share Posted June 27, 2008 ptf.products_extra_fields_value<>'' <> should not be a blank. You need to analyse Your code. It appears You added some additioal code not following exactly what the contribution wants. saSatish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
frafac Posted June 27, 2008 Author Share Posted June 27, 2008 ptf.products_extra_fields_value<>'' <> should not be a blank. You need to analyse Your code. It appears You added some additioal code not following exactly what the contribution wants. saSatish Thanks for your patience... now I replace the file... and no error become... but I cannot see in product info page the fields I added.. can you tell me a contrib that is ok 100%? Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 27, 2008 Share Posted June 27, 2008 product extra fields The problem occurs when you do not follow all the instructions exactly. I have installed it and it works fine. Have another go and follow the instructions very carefully Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
frafac Posted June 27, 2008 Author Share Posted June 27, 2008 Thanks for your patience... now I replace the file... and no error become... but I cannot see in product info page the fields I added..can you tell me a contrib that is ok 100%? Now I istalled "bug fix of bugfix from majidmx" and I can see extra fields in product page... but.. laste question :) I want to see extra fields below product name... but I see instead product name below extra fields... :( Any ideas? Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 27, 2008 Share Posted June 27, 2008 Move the code you installed in product_info.php to wherever you want it. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
frafac Posted June 27, 2008 Author Share Posted June 27, 2008 Move the code you installed in product_info.php to wherever you want it. Ok.. do you know if I can put a photo as value of one field? Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 27, 2008 Share Posted June 27, 2008 Extra fields is used to display additional data about the product. If you want to display images you will need a different contribution or to do some coding. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
satish Posted June 29, 2008 Share Posted June 29, 2008 The contribution is ok. You are not placing the code as needed. Satish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
ZeroHero Posted August 29, 2008 Share Posted August 29, 2008 I have successful installed the contribution but the "Product Listing" does not display the Product Name instead it display only the product extra field. Is this a norm or do i have to enable the product name display? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.