Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

  • 2 weeks later...
Posted (edited)

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
Posted

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

Posted

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?

Posted

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.

Posted

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

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

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?

Posted

@@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?

Posted

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

Posted

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

Posted (edited)

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
Posted

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.

}

?>

Posted

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

Posted

I have installed Option Types 2.3.1 but when I go to Admin -> Products Attributes, in the Product Options area the table headings are not loaded and the columns show "error"

  • 2 weeks later...
Posted

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.

Posted (edited)

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
Posted

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]

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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