Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Option Types v2


Zappo

Recommended Posts

  • 2 weeks later...

I´ve used this contribution for some time but now i ran in to some problems.

I´m trying to use 2 setups of images selections. The first for fonts and the second for colors. When I change the image in the second dropdown the image in the first dropdown disperse.

Edited by OpusVista
Link to comment
Share on other sites

I´m trying to use 2 setups of images selections. The first for fonts and the second for colors. When I change the image in the second dropdown the image in the first dropdown disperse.

 

Read here for the solution

Link to comment
Share on other sites

I too have faced this problem.

Has solved as follows:

 

Open includes/modules/option_types.php

 

Find

$Image_displayed = 0;

Below add

$Image_Dropdown[$product_info['products_id']]='';
$ImageText[$product_info['products_id']]='';
$First_ImageText[$product_info['products_id']]='';

 

Find

$ImageSelector_Name = $ProdOpt_Name . ': <script language="JavaScript" type="text/JavaScript">var ImageText'.$product_info['products_id'] . ' = new Array(' . $ImageText[$product_info['products_id']] . ')</script>';
$ImageSelector_Dropdown = '<select name="' . $Image_Dropdown_ID . '" onChange="document.getElementById(\'ImageSelect' . $product_info['products_id'] . '\').innerHTML=ImageText'.$product_info['products_id'].'[this.selectedIndex];">' . $Image_Dropdown[$product_info['products_id']] . '</select> ' . $ProdOpt_Comment;

 

Replace with

$ImageSelector_Name = $ProdOpt_Name . ': <script language="JavaScript" type="text/JavaScript">var ImageText'.$ProdOpt_ID . ' = new Array(' . $ImageText[$product_info['products_id']] . ')</script>';
$ImageSelector_Dropdown = '<select name="' . $Image_Dropdown_ID . '" onChange="document.getElementById(\'ImageSelect' . $ProdOpt_ID . '\').innerHTML=ImageText'.$ProdOpt_ID.'[this.selectedIndex];">' . $Image_Dropdown[$product_info['products_id']] . '</select> ' . $ProdOpt_Comment;

 

Find

<center><?php echo '<div class="main" id="ImageSelect' . $product_info['products_id'] . '">' . $First_ImageText[$product_info['products_id']] . '</div>';?></center>

 

Replace with

<center><?php echo '<div class="main" id="ImageSelect' . $ProdOpt_ID . '">' . $First_ImageText[$product_info['products_id']] . '</div>';?></center>

It works smile.gif

 

I found the solution to my problem

Link to comment
Share on other sites

i have a problem with install steps fron intall.txt

 

all waz fine till step 5

 

*************************************
5. admin/orders.php and admin/invoice.php
*************************************
find:
echo '<br /><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	  if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
	  echo '</i></small></nobr>';
replace with:
echo '<br><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	  if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
	  echo '</i></small>';
find:
echo '<br /><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	  echo '</i></small></nobr>';
replace with:-
	  echo '<br><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	  echo '</i></small>';

 

when i try to find second part

find:
echo '<br /><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	  echo '</i></small></nobr>';
replace with:-
	  echo '<br><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	  echo '</i></small>';

 

there waz nothing to find in both file orders.php and invoice.php

 

i check both original file from oscommerce kit v2.3.1 ....and same thing i can't find second part so i can replace!

 

 

i use oscommerce v2.3.1 and i try to install this addon http://addons.oscommerce.com/info/8193

any clue?

Link to comment
Share on other sites

Sorry but can I get help for my problem please?

 

I think there is something wrong with my includes/classes/shopping_cart.php

All the input boxes keep showing as CUSTOMER INPUT, including on admin side.

If somebody could please take a look at this and fix it for me.

 

I would suggest this

Link to comment
Share on other sites

  • 2 weeks later...
  • 3 weeks later...

Steven, check your email, the issue was in file includes/classes/shopping_cart.php

 

To all

 

Checking both, the uploaded file and the manual instructions about file includes/classes/shopping_cart.php, I think they are both wrong, no wonder that it doesn't work

 

Till there is an update to that package, I recommend to use the file from the old package instead and merge it manually into your new file

 

 

I have tried installing on a clean 2.3.1 site (localhost) several times by following the instructions and manually adding and also tried the drop in. Having same issue of if you use a textbox then the product doesn't get added to the shopping cart. The use of textbox is the reason I even tried to use this contribution.

 

The link to the old release for 2.2rc2a is there but when I try to download it I get an empty zip file called null_1_2_3_4_5_6_7_8_9.zip. Does any one know of another place that I can get the 2.2rc2a version so I can merge it manually into my new file?

Link to comment
Share on other sites

@@ToneDJ

 

Try to download the latest version uploaded by Zappo

 

I am not sure which version you are referring too. The only ones I can find are option types 2.3.1 which is the one I am trying to use and the older version option types v2 which is just an empty zip file. Is there another version that I am not seeing?

Link to comment
Share on other sites

I am not sure which version you are referring too. The only ones I can find are option types 2.3.1 which is the one I am trying to use and the older version option types v2 which is just an empty zip file. Is there another version that I am not seeing?

 

Click on the "history" tab of the pld version and you will see all previous uploads. Pick the latest uploaded by zappo

Link to comment
Share on other sites

Click on the "history" tab of the pld version and you will see all previous uploads. Pick the latest uploaded by zappo

 

I used the old file (includes/classes/shopping_cart.php) from zappo's latest upload and now it is working. Thank you multimixer

Link to comment
Share on other sites

I used the old file (includes/classes/shopping_cart.php) from zappo's latest upload and now it is working. Thank you multimixer

 

You need to update the file now to version 2.3.1 Use a file-comparison program, there are just a couple of changes to do

Link to comment
Share on other sites

Having a problem after installing Option Types v2 (optiontypes231)

here is the code from line 350-370

 

<?php

}

?>

</table></td>

</tr>

<?php

} else {

?>

<tr>

<td colspan="3" class="pageHeading"> <?php echo HEADING_TITLE_OPT; ?> </td>

</tr>

<tr>

<td colspan="3" class="smallText" align="right">

<?php

$options = "select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by products_options_id";

$options_split = new splitPageResults($option_page, MAX_ROW_LISTS_OPTIONS, $options, $options_query_numrows);

 

echo $options_split->display_links($options_query_numrows, MAX_ROW_LISTS_OPTIONS, MAX_DISPLAY_PAGE_LINKS, $option_page, 'value_page=' . $value_page . '&attribute_page=' . $attribute_page, 'option_page');

?>

</td>

</tr>

 

Parse error: syntax error, unexpected '}' in admin\products_attributes.php on line 356

 

When I click Product Attributes this is what comes up :(

Ive installed on a WAMP server, everything else is working but i think ive broke it :(

Any help appreciated

Edited by fap
Link to comment
Share on other sites

I have Option Types 2.1.3 up and running.

It works fine with Select, Text and Radio, but fails with Checkbox, See here:

 

http://always-with-me.com/product_info.php?cPath=21&products_id=1006

 

The option that fails "Charms" comes up OK if I change it to Select or Radio

 

I using 2.2ms2

PHP 5.3

MySql 3.23.54

 

Can anyone help.

Link to comment
Share on other sites

Code for question above:

 

<?php

/*

$Id: option_types.php 2009-06-01 $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2009 AvanOsch for http://shop.crystalcopy.nl

 

Released under the GNU General Public License

*/

 

// - Zappo - Option Types v2 - Use some easy shorter names for products_options_name values

$Default = false; // Set this value to true if current option is Default (drowpdown) (see below)

$ProdOpt_ID = $products_options_name['products_options_id'];

$ProdOpt_Name = $products_options_name['products_options_name'];

$ProdOpt_Comment = $products_options_name['products_options_comment'];

$ProdOpt_Length = $products_options_name['products_options_length'];

 

$products_attribs_query = tep_db_query("select distinct options_values_id, options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . (int)tep_db_input($product_info['products_id']) . "' and options_id = '" . $ProdOpt_ID . "' order by products_options_sort_order");

$products_attribs_array = tep_db_fetch_array($products_attribs_query);

// Get Price for Option Values (Except for Multi-Options (Like Dropdown and Radio))

if ($products_attribs_array['options_values_price'] != '0') {

$tmp_html_price = ' (' . $products_attribs_array['price_prefix'] . $currencies->display_price($products_attribs_array['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

} else {

$tmp_html_price = '';

}

switch ($products_options_name['products_options_type']) {

 

case OPTIONS_TYPE_TEXT:

$tmp_html = '<input type="text" name="id[' . TEXT_PREFIX . $ProdOpt_ID . ']" id="id[' . TEXT_PREFIX . $ProdOpt_ID . ']" size="' . $ProdOpt_Length .'" maxlength="' . $ProdOpt_Length . '"

value="' . $cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$ProdOpt_ID] .'"';

if (OPTIONS_TYPE_PROGRESS == 'Text' || OPTIONS_TYPE_PROGRESS == 'Both') {

$tmp_html .= 'onKeyDown="textCounter(this,\'progressbar_'. $ProdOpt_ID . '\',' . $ProdOpt_Length . ')"

onKeyUp="textCounter(this,\'progressbar_'. $ProdOpt_ID . '\',' . $ProdOpt_Length . ')"

onFocus="textCounter(this,\'progressbar_'. $ProdOpt_ID . '\',' . $ProdOpt_Length . ')">   ' . $ProdOpt_Comment . $tmp_html_price .

'<div id="counterbar_'. $ProdOpt_ID . '" class="bar"><div id="progressbar_'. $ProdOpt_ID . '" class="progress"></div></div>

<script>textCounter(document.getElementById("id[' . TEXT_PREFIX . $ProdOpt_ID . ']"),"progressbar_' . $ProdOpt_ID . '",' . $ProdOpt_Length . ',"counterbar_'. $ProdOpt_ID . '")</script>';

} else {

$tmp_html .= '>' . $ProdOpt_Comment . $tmp_html_price;

} ?>

<tr>

<td class="main"><?php echo $ProdOpt_Name . ' :'; ?></td>

<td class="main"><?php echo $tmp_html; ?></td>

</tr> <?php

break;

 

case OPTIONS_TYPE_TEXTAREA:

$tmp_html = '<textarea wrap="soft" rows="5" name="id[' . TEXT_PREFIX . $ProdOpt_ID . ']"

id="id[' . TEXT_PREFIX . $ProdOpt_ID . ']"';

if (OPTIONS_TYPE_PROGRESS == 'TextArea' || OPTIONS_TYPE_PROGRESS == 'Both') {

$tmp_html .= 'onKeyDown="textCounter(this,\'progressbar_'. $ProdOpt_ID . '\',' . $ProdOpt_Length . ')"

onKeyUp="textCounter(this,\'progressbar_'. $ProdOpt_ID . '\',' . $ProdOpt_Length . ')"

onFocus="textCounter(this,\'progressbar_'. $ProdOpt_ID . '\',' . $ProdOpt_Length . ')">' .

$cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$ProdOpt_ID] . '</textarea>

<div id="counterbar_'. $ProdOpt_ID . '" class="bar"><div id="progressbar_'. $ProdOpt_ID . '" class="progress"></div></div>

<script>textCounter(document.getElementById("id[' . TEXT_PREFIX . $ProdOpt_ID . ']"),"progressbar_' . $ProdOpt_ID . '",' . $ProdOpt_Length . ',"counterbar_'. $ProdOpt_ID . '")</script>';

} else {

$tmp_html .= '>' . $cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$ProdOpt_ID] . '</textarea>';

} ?>

<tr>

<td class="main" colspan="2"><b><?php echo $ProdOpt_Name . ' :</b><br>' . $ProdOpt_Comment . ' ' . $tmp_html_price; ?></b></td>

</tr>

<tr>

<td class="main" colspan="2"><?php echo $tmp_html; ?></td>

</tr> <?php

break;

 

case OPTIONS_TYPE_RADIO:

$tmp_html = '<table>';

$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)$product_info['products_id'] . "' and pa.options_id = '" . $ProdOpt_ID . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "' order by pa.products_options_sort_order");

while ($products_options_array = tep_db_fetch_array($products_options_query)) {

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$ProdOpt_ID]) && ($products_options_array['products_options_values_id'] == $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$ProdOpt_ID])) {

$checked = true;

} else {

$checked = false;

}

$tmp_html .= '<tr><td class="main">';

$tmp_html .= tep_draw_radio_field('id[' . $ProdOpt_ID . ']', $products_options_array['products_options_values_id'], $checked);

$tmp_html .= $products_options_array['products_options_values_name'];

if ($products_options_array['options_values_price'] != '0') {

$tmp_html .= ' (' . $products_options_array['price_prefix'] . $currencies->display_price($products_options_array['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

}

$tmp_html .= '</tr></td>';

}

$tmp_html .= '</table>'; ?>

<tr>

<td class="main"><?php echo $ProdOpt_Name . ' :<br><small>' . $ProdOpt_Comment . '</small>'; ?></td>

<td class="main"><?php echo $tmp_html; ?>

 

<!--- ADM hack begin ------------------------------------------------------------>

 

<td class="main">

<script language="javascript"><!--

document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link('selection_popup_image.php', 'selection_image_ID=' . $products_options_name['products_options_selection_image']) . '\\\')">' . '<b>' . $products_options_name['products_options_selection_text'] . '</b>' . '</a>'; ?>');

//--></script>

</td>

 

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '15'); ?></td>

</tr>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_silver.gif', '400%', '1'); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '15'); ?></td>

</tr>

 

<!--- ADM hack end --------------------------------------------------------------->

 

 

</tr> <?php

 

 

 

break;

 

case OPTIONS_TYPE_CHECKBOX:

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$ProdOpt_ID])) {

$checked = true;

} else {

$checked = false;

}

$tmp_html = tep_draw_checkbox_field('id[' . $ProdOpt_ID . ']', $products_attribs_array['options_values_id'], $checked) . '   ';

$tmp_html .= $ProdOpt_Comment ;

$tmp_html .= $tmp_html_price; ?>

<tr>

<td class="main"><?php echo $ProdOpt_Name . ' :'; ?></td>

<td class="main"><?php echo $tmp_html; ?></td>

</tr> <?php

break;

 

case OPTIONS_TYPE_FILE:

$number_of_uploads++;

//BOF - Zappo - Option Types v2 - Added dropdown with previously uploaded files

if ($old_uploads == true) unset($uploaded_array);

$uploaded_array[] = array('id' => '', 'text' => TEXT_NONE);

$uploaded_files_query = tep_db_query("select files_uploaded_name from " . TABLE_FILES_UPLOADED . " where sesskey = '" . tep_session_id() . "' or customers_id = '" . (int)$customer_id . "'");

while ($uploaded_files = tep_db_fetch_array($uploaded_files_query)) {

$uploaded_array[] = array('id' => $uploaded_files['files_uploaded_name'], 'text' => $uploaded_files['files_uploaded_name'] . ($tmp_html_price ? ' - ' . $tmp_html_price : ''));

$old_uploads = true;

}

$tmp_html = '<input type="file" name="id[' . TEXT_PREFIX . $ProdOpt_ID . ']">' . // File field with new upload

tep_draw_hidden_field(UPLOAD_PREFIX . $number_of_uploads, $ProdOpt_ID); // Hidden field with number of this upload (for this product)

$tmp_html .= $tmp_html_price;

if ($old_uploads == true) $tmp_html .= '<br>' . tep_draw_pull_down_menu(TEXT_PREFIX . UPLOAD_PREFIX . $number_of_uploads, $uploaded_array, $cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$ProdOpt_ID]);

//EOF - Zappo - Option Types v2 - Added dropdown with previously uploaded files ?>

<tr>

<td class="main"><?php echo $ProdOpt_Name . ' :' . (($old_uploads == true) ? '<br>' . TEXT_PREV_UPLOADS . ': ' : ''); ?></td>

<td class="main"><?php echo $tmp_html; ?></td>

</tr> <?php

break;

 

//BOF - Zappo - Added Image Selector Option

case OPTIONS_TYPE_IMAGE:

$Image_Opticount_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . (int)$product_info['products_id'] . "' and options_id ='" . (int)$ProdOpt_ID . "'");

$Image_Opticount = tep_db_fetch_array($Image_Opticount_query);

$Image_displayed = 0;

$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)$product_info['products_id'] . "' and pa.options_id = '" . (int)$ProdOpt_ID . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.products_options_sort_order");

while ($products_options = tep_db_fetch_array($products_options_query)) {

$pOptValName = $products_options['products_options_values_name'];

$Image_displayed++;

if ($products_options['options_values_price'] != '0') {

$option_price = ' (' . $products_options['price_prefix'] . ' ' . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

} else {

$option_price = '';

}

$Image_Dropdown_ID = 'id[' . $ProdOpt_ID . ']';

$Image_Name = (OPTIONS_TYPE_IMAGENAME == 'Name') ? $products_options['products_options_values_name'] : $products_options['products_options_values_id'];

$Real_Image_Name = OPTIONS_TYPE_IMAGEPREFIX . $Image_Name . ((OPTIONS_TYPE_IMAGELANG == 'Yes') ? '_'.$languages_id : '') . '.jpg';

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$ProdOpt_ID]) && ($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$ProdOpt_ID] == $products_options['products_options_values_id'])) {

$Image_Dropdown[$product_info['products_id']] .= '<option value="' . $products_options['products_options_values_id'] . '" SELECTED>' . $pOptValName . $option_price . '</option>';

$First_ImageText[$product_info['products_id']] = '<img src="' . OPTIONS_TYPE_IMAGEDIR . $Real_Image_Name . '" alt="'.$pOptValName.'" title="'.$pOptValName.'">';

$ImageText[$product_info['products_id']] .= '"<img src=\"' . OPTIONS_TYPE_IMAGEDIR . $Real_Image_Name . '\" alt=\"'.$pOptValName.'\" title=\"'.$pOptValName.'\">"';

} else {

$Image_Dropdown[$product_info['products_id']] .= '<option value="' . $products_options['products_options_values_id'] . '">' . $pOptValName . $option_price . '</option>';

$ImageText[$product_info['products_id']] .= '"<img src=\"' . OPTIONS_TYPE_IMAGEDIR . $Real_Image_Name . '\" alt=\"'.$pOptValName.'\" title=\"'.$pOptValName.'\">"';

if ($First_ImageText[$product_info['products_id']] == '' && $Image_displayed == 1) $First_ImageText[$product_info['products_id']] = '<img src="' . OPTIONS_TYPE_IMAGEDIR . $Real_Image_Name . '" alt="'.$pOptValName.'" title="'.$pOptValName.'">';

}

// BOF - Zappo - PreLoad the Images

if ($Image_displayed == 1) echo '<div id="ImagePreload">';

echo '<img src="' . OPTIONS_TYPE_IMAGEDIR . $Real_Image_Name . '" alt="'.$pOptValName.'" title="'.$pOptValName.'">';

if ($Image_displayed != $Image_Opticount['total']) {

$ImageText[$product_info['products_id']] .= ',';

} else { // - Zappo - PreLoad the Images - Close Div...

echo '</div>';

}

// EOF - Zappo - PreLoad the Images

}

$ImageSelector_Name = $ProdOpt_Name . ': <script language="JavaScript" type="text/JavaScript">var ImageText'.$product_info['products_id'] . ' = new Array(' . $ImageText[$product_info['products_id']] . ')</script>';

$ImageSelector_Dropdown = '<select name="' . $Image_Dropdown_ID . '" onChange="document.getElementById(\'ImageSelect' . $product_info['products_id'] . '\').innerHTML=ImageText'.$product_info['products_id'].'[this.selectedIndex];">' . $Image_Dropdown[$product_info['products_id']] . '</select> ' . $ProdOpt_Comment;

?>

<tr>

<td class="main"><?php echo $ImageSelector_Name; ?></td>

<td class="main"><?php echo $ImageSelector_Dropdown; ?></td>

</tr>

<tr>

<td width="100%" class="main" colspan="2">

<center><?php echo '<div class="main" id="ImageSelect' . $product_info['products_id'] . '">' . $First_ImageText[$product_info['products_id']] . '</div>';?></center>

</td>

</tr>

<?php

break;

//EOF - Zappo - Added Image Selector Option

 

default:

$Default = true; // Set this value to check if current option is Default (drowpdown)

// - Zappo - Option Types v2 - Default action is (standard) dropdown list. If something is not correctly set, we should always fall back to the standard.

}

?>

Link to comment
Share on other sites

Adding to the above two posts:

I now have the "Checkbox options displayed correctly, see:

http://always-with-me.com/product_info.php?cPath=21&products_id=1006

 

However if I check more than one option, only the last checked option appears in the shopping cart.

The cost of the added single option does appear in the cart total.

 

Help.

Link to comment
Share on other sites

I have an unmodified version of OSC 2.3.1 installed and working.

 

I want to add Option Types 2.3.1 but do not understand the limited instructions.

 

There is an install.txt file which shows how to modify the exisiting OSC files, that I understand, but what are the files in the directory "Drop-on-Top-files" for. What do I do with them

Link to comment
Share on other sites

  • 2 weeks later...

Hi there,

 

I have Problem with Option Type V2, I cannot delete items using Option Type from the shopping cart. Other items can be deleted. Further updating the amount of these Option Type items create a new item in the cart.

 

In one shop it is working RC2 and in another one built up from this one is not working anymore. I guess I did some oscommerce version updates which interfere. Maybe somebody run into the same problem or knows where to look at?

Thanks.

Link to comment
Share on other sites

Using osCommerce 2.3.1

 

 

Installed and for some reason not working.

 

Appears to be an issue with the SQL file

 

1054 - Unknown column 'products_options_value_text' in 'field list'

 

select products_options_id, products_options_value_id, products_options_value_text from customers_basket_attributes where customers_id = '1' and products_id = '732{8}34{7}0'

 

and

 

Unknown column 'popt.products_options_order' in 'order clause'

Edited by mvanderhoff
Link to comment
Share on other sites

Also on products getting this error:

 

1054 - Unknown column 'popt.products_options_order' in 'order clause'

 

select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from products_options popt, products_attributes patrib where patrib.products_id='879' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by popt.products_options_order, popt.products_options_name

 

[TEP STOP]

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...