724 replies to this topic

[kymation]

Then something is triggering an error in the processing code. You'll have to debug that, as I can't see it here.

Regards
Jim

[bbabbitt]

I am instaling the product specification add-on (vesrion 1.1.11) on my osCommerce v 2.3.1 site and have encountered the following message in the product page:

1146 - Table 'bbabbitt_osc1.TABLE_PRODUCTS_XSELL' doesn't exist

select count(xp.xsell_id) as total from TABLE_PRODUCTS_XSELL xp, products p where xp.products_id = '34' and xp.xsell_id = p.products_id and p.products_status = '1'

[TEP STOP]

The database, as expected, doesn't have a table named products_xsell or anything like it. I also couldn't find mention of creating anything with that or any similar name in the database with the products_specifications.sql file provided.

How do I get past this or what have I done wrong?

[kymation]

As mentioned previously in this forum thread -- go to your Admin and turn off the cross-sell tab.

Regards
Jim

[ce7]

installed a brand new oscommerce, without any other add on installed, copy and paste all the files to the catalog, run the SQL files. This is the message when click on the product in the front page, inside the Description column, and when you click on the review or ask a question tab, it just jump to the index.php

1146 - Table 'inmotion_test.TABLE_PRODUCTS_TO_DOCUMENTS' doesn't exist

select count(*) as total from TABLE_PRODUCTS_TO_DOCUMENTS where products_id = '16'

Edited by ce7, 23 July 2012 - 03:27 AM.

[kymation]

Go to the Product Specifications configuration menu and set Show Documents tab to False.

Regards
Jim

Edited by kymation, 23 July 2012 - 03:31 AM.

[ce7]

thanks Jim

[ce7]

set the document tab to false, the next error message:
(PS. some products has perfect description, but some show this error message! error one, such as Hewlett Packard LaserJet 1100Xi )

Parse error: syntax error, unexpected T_STRING in /test/includes/functions/clean_code.php(162) : eval()'d code on line 1

[kymation]

That's the usual PHP problem with apostrophes/single quotes. If you  have ckeditor installed, just edit the product and save it without making any changes. If not, you'll have to manually add three backslashes in front of every apostrophe.

There is a fix for this, but it involves editing a bunch of files. As usual, I don't have time to release half of what I've done.

Regards
Jim

[ce7]

ok, will install CKEditor later, thanks!

By the way, do you have update version of PDF Datasheet your addon? (If not, when will it be possible be update?)

thank you

Lyn

[kymation]

Update? It's working as is, with the exception of one optional module that (almost) nobody uses. If you need that module, post in the support thread. I may be able to find the time to fix it.

Regards
Jim

[bbabbitt]

Thank you Jim, for helping with the cross-sell tab problem. I took the tab out of products_tabs.php and it works great!

BTW, you show Price Updater as working with version 2.2x. What problems, if any, can I expect installing it with version 2.3.1?

[kymation]

It needs minor updates to add template_top.php etc. This one should work for the main file. The rest of the files from the 2.2x distribution should work, except the link from the Catalog box will have to be modified.

Regards
Jim

Edit: Wrong box.

Edited by kymation, 24 July 2012 - 12:39 AM.

[ce7]

Hi Jim,

I had installed this addon on brandnew 2.3.1 and it works. Then I tried to installed with my current shop also with 2.3.1 version.
In the product_info.php page, there are also four others addons that demand code modify, they are

Child Attributes (fnzb)
Products Fields Groups
Sitemap SEO
QTPro Featured

In the admin site, it works find, but when I modified the prodcut_info.php,
I then got this error message, and also the bxgallery doesn't work as usual.
(the bxGallery will appear the main on the top and then another bxGallery with thumbnails below, and the error message right next to it.)

Warning: Invalid argument supplied for foreach()
in /includes/functions/html_output.php on line 379

Is there a way to fix this error?

thanks

Lyn

[ce7]

Hi Jim,

I just tried to modified the product_info.php again, this time use your product_info.php to add other addons one by one and test,
I found that the problem cause the foreach() is the code for product option between Child Attributes and Products Specifications.

This is the code for Child Attributes as below:

 <p><?php echo TEXT_PRODUCT_OPTIONS; ?></p>
<p>
<?php
$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
$products_options_array = array();
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
while ($products_options = tep_db_fetch_array($products_options_query)) {
$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
if ($products_options['options_values_price'] != '0') {
$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
}
}
if (is_string($HTTP_GET_VARS['products_id']) && isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
$selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
} else {
$selected_attribute = false;
}
?>
<!--
<strong><?php echo $products_options_name['products_options_name'] . ':'; ?></strong><br /><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute, 'id="id_' . $products_options_name['products_options_id'] . '"'); ?><br />
//-->
<?php
//====================================================================================
// BOE Child Attributes (fnzb) 

Can I please ask your help and see how it can work with your Products Spcieifications?

Thank you very much in advance.

Lyn

[ce7]

sorry, just found that I did not copy the code for Child Attributes completely.

 <!--
<strong><?php echo $products_options_name['products_options_name'] . ':'; ?></strong><br /><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute, 'id="id_' . $products_options_name['products_options_id'] . '"'); ?><br />
//-->
<?php
//====================================================================================
// BOE Child Attributes (fnzb)
echo '<strong>' . $products_options_name['products_options_name'] . ':</strong><br />' . tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute, 'id="id_' . $products_options_name['products_options_id'] . '"');
echo '<div id="child_' . $products_options_name['products_options_id'] . '"></div><br/>';
?>
<script type="text/javascript">
$( "#<?php echo 'id_' . $products_options_name['products_options_id']?>" ).change(function() {loadChildOptions('<?php echo $HTTP_GET_VARS['products_id']?>','<?php echo $products_options_name['products_options_id']?>',this.value);});
$( "#<?php echo 'id_' . $products_options_name['products_options_id']?>" ).trigger('change');
</script>
<?php
// EOE Child Attributes (fnzb)
//====================================================================================
}
?>
</p>

thanks

Lyn

[kymation]

You'll have to combine the code for the two Addons. Products Specifications doesn't modify the code for the attributes; it just moves it. You'll need to find where the code was moved and make the changes for Child Attributes there.

Regards
Jim

[ce7]

Hi Jim,

Thanks I end up delete the last part of Child Attributes code as I have no idea about PHP code and how to combine them.

It seems ok so far and I have a further question.

Configuration / Products Specification, I set Show Question Tab and Show Friend Tab as true, and it did show up on the front end product_info.php page, but when I click on either of them, it just jump to the product list page (I mean index, New Products For month page).

Does it mean that I can not use these two tab or some setting I need to modify? Many thanks in advance.

Lyn

[kymation]

There's something wrong with the Javascript on your page. Use View Source in Firefox and click on each of the JS file links in the top section. If you find one that gives a 404 Not Found page, that one's broken and needs to be fixed.

It's also possible that you removed the tabs Javascript from the page. Again using View Source, find the following:

  <script type="text/javascript">
	$(function() {
	  $( "#tabs" ).tabs({ selected: 0 });
	  return false;
	});
  </script>

If it's missing, put it back just before the tabs start.

Regards
Jim

[ce7]

set the two tab false and then true again, now it works, just in IE the layout changed completely.

[img]http://s19.postimage.org/jlan9my1r/product_images_2.gif[/img]
[img]http://s19.postimage.org/jzbz98i5b/product_images_1.gif[/img]
[img]http://s19.postimage.org/s63z0t87z/product_images_3.gif[/img]


???

Thanks

Lyn

[ce7]

ok, thanks Jim! I will try it now!

Lyn