Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products Fields Groups


thejudge99

Recommended Posts

Hi ilyadgonbad

this addon is written for 2.3.1 - i pressume you're trying it for an older version , one that doesnt have this function.

 

If that is the only error you have you could try hard coding the complette URL

 

<!-- start Product Fields group tab -->
<link rel="stylesheet" type="text/css" href="PATH_TO_MY_CSS/ext/jquery/ui/redmond/jquery-ui-1.8.19.custom.css">
<!-- end Product Fields group tab -->

 

where PATH_TO_MY_CSS is probably "catalog" - having never used an older version cannot say if that is the case.

 

If you do indeed have other errors then i would suggest upgrading your oscommerce.

 

Jules

Edited by thejudge99
Link to comment
Share on other sites

  • 3 months later...
  • Replies 59
  • Created
  • Last Reply

Top Posters In This Topic

Hi Julian

 

I got the error message as below:

 

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 'select p.products_id, pd.products_name, p' at line 1

 

select count(*) as total select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price_cost, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id, p.products_fields_group_id , pfgn.products_fields_group_name from products p, products_description pd, products_to_categories p2c , products p LEFT JOIN products_fields_groups_names pfgn on p.products_fields_group_id = pfgn.products_fields_group_id and pfgn.language_id = '1' where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and pd.products_name like '%test 182%'

 

 

also when I tried to edit product with product field group, and save it, I can see it at the back end, but it doesn't show one website. I can PM you my web if you need to have a look.

 

Thanks

 

Lyn

Link to comment
Share on other sites

ok

 

replace

as total select

 

with

as total ,

 

replace

from products p, products_description

with

from  products_description

 

you also have a p.products_price in there which i assume is part of another addon

 

the main actual query you will find in 6h

catalog/admin/categories.php

 

 

jules

Edited by thejudge99
Link to comment
Share on other sites

  • 2 weeks later...

Hi Jules,

 

Sorry for late reply. I was trying to solve problem with product image.

 

I had tried to modify the admin/categories.php as you suggested and it works great now.

 

Thank you so much for your help!

 

regards,

 

Lyn

 

(the error happen when I tried to search product in categories/products, after comment out the products p, it works great!)

Link to comment
Share on other sites

  • 1 month later...

Hi Jules,

 

I have a small problem and have not been able to find it.

After adding a new language, the review tab doesn't pick up this language (I already checked in the source view and the language variable for the new language isn't there), this results in jumping back

to the index page when clicking on the review tab.

 

Other languages are fine and the contribution is running fine too.

 

I appreciate your help,

 

Thanks.

 

Gerhard

Addons installed on my website:

 

- Addons Installed

- Advanced Special Offer Discounts

- AJAX-Attribute Manager for osc 2.3.1

- Banner box v1.1.1

- Dutch Language Pack

- Extra Pages-info box with admin for OSC2.3

- German Language Pack

- Login Box

- Multi-language Support for Configuration

- Multiple products manager

- Order Editor

- OSC PDF Catalogue 2.1

- PDF-Datasheet

- product Field Groups

- Quickly Update Product Stock

- Unit of weight

- YAG (Yet another Guestbook)

Link to comment
Share on other sites

the script is taking the value of IMAGE_BUTTON_REVIEWS found in includes/languages/xxxxxxxx.php which is Reviews in english.php - which creates a link with Reviews as title

 

<li><a href="xxxxx" title="Reviews">Reviews(4)</a></li>

 

and the matching div

 

<div id="Reviews">XXXXXXXXXXXXXXXX</div>

 

If you check your source the title tag of the link should match the ID of the div. This is what links them together.

Do you have some special character for IMAGE_BUTTON_REVIEWS ? This may or may not effect it - i havent tried that.

 

 

What you can do is replace the 2 occurences of IMAGE_BUTTON_REVIEWS with something hardcoded - which would be the same regardless of language

 

in products_info.php

 

replace

 

<li><a href="/product_reviews_pfg.php?Tc=<? echo (int)$groups_tms_count?>&products_id=<? echo (int)$HTTP_GET_VARS['products_id']?>" title="<? echo IMAGE_BUTTON_REVIEWS ;?>" ><? echo IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : '') ;?></a></li>

 

 

with

 

<li><a href="/product_reviews_pfg.php?Tc=<? echo (int)$groups_tms_count?>&products_id=<? echo (int)$HTTP_GET_VARS['products_id']?>" title="reviews" ><? echo IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : '') ;?></a></li>

 

and replace

 

<div id="<? echo IMAGE_BUTTON_REVIEWS ;?>"></div>

 

with

 

<div id="reviews"></div>

 

This can only be a mismatch between the 2 tags

 

Jules

Link to comment
Share on other sites

Hi Jules,

 

Thanks for your quick answer.

 

The special characters were the problem (Thai language). For the moment I just changed the Thai translation into English.

This is for "review" not a big problem as Thai also use the word "review" literally translated into Thai.

 

But is it possible to let the script work with these characters?

 

The reviews themselves show correct, also in Thai.

 

Thanks,

 

Gerhard.

Addons installed on my website:

 

- Addons Installed

- Advanced Special Offer Discounts

- AJAX-Attribute Manager for osc 2.3.1

- Banner box v1.1.1

- Dutch Language Pack

- Extra Pages-info box with admin for OSC2.3

- German Language Pack

- Login Box

- Multi-language Support for Configuration

- Multiple products manager

- Order Editor

- OSC PDF Catalogue 2.1

- PDF-Datasheet

- product Field Groups

- Quickly Update Product Stock

- Unit of weight

- YAG (Yet another Guestbook)

Link to comment
Share on other sites

Im not exactly sure wether this is a browser issue or a jquery issue - my script generates the needed tab code in the correct format - but jquery handles the actual tabbing .

 

I wouldnt actually change your Thai equivalent to reviews - this word will still be used / seen by your customers - i would change only the title tag and the ID tag - by following the above instuctions. This would be transparent to your customers.

 

Jules

Link to comment
Share on other sites

Hi Jules,

 

Thanks a lot, I hadn't thought about that.

It's working perfect now.

 

Gerhard

Addons installed on my website:

 

- Addons Installed

- Advanced Special Offer Discounts

- AJAX-Attribute Manager for osc 2.3.1

- Banner box v1.1.1

- Dutch Language Pack

- Extra Pages-info box with admin for OSC2.3

- German Language Pack

- Login Box

- Multi-language Support for Configuration

- Multiple products manager

- Order Editor

- OSC PDF Catalogue 2.1

- PDF-Datasheet

- product Field Groups

- Quickly Update Product Stock

- Unit of weight

- YAG (Yet another Guestbook)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...