CRE 6.4B2B PRODUCT ATTRIBUTE ERROR

MMC-SUPER · **Joined:** Fri Aug 27, 2010 10:21 am **Posts:** 38

Need some help - has anyone received a product attribute sorting error? Didn't change anything and keep getting this error.

Array ([products_options_sort_order]=>1) 1064 - You have an error in your SQL syntax; check the manual that corresponds to your SQL server version for the right syntax to use near " at line 1

update products_attributes set products_options_sort_order = '1' where products_attributes set products_options_sort_order ='1' where products_attributes_id =

[TEN STOP]

Would appreciate some help in how to fix this. Don't really do anything but add products and attributes so not sure what happened.

Thanks.

soundzgood2 · **Posted:** Sat Nov 05, 2011 1:16 am

Maybe corrupted on upload or earlier beta version code.
Check /admin/includes/functions/attributes_sorter_added_functions.php for this function and replace with the code below:

Code:

////
// Set Product Attributes Sort Order to Products Option Value Sort Order
  function tep_update_attributes_products_option_values_sort_order($products_id) {
    $attributes_sort_order_query = tep_db_query("select distinct pa.products_attributes_id, pa.options_id, pa.options_values_id, pa.products_options_sort_order, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $products_id . "' and pa.options_values_id = pov.products_options_values_id");
    while ($attributes_sort_order = tep_db_fetch_array($attributes_sort_order_query)) {
      tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_options_sort_order = '" . $attributes_sort_order['products_options_values_sort_order'] . "' where products_id = '" . $products_id . "' and products_attributes_id = '" . $attributes_sort_order['products_attributes_id'] . "'");
    }
  }

Simon

MMC-SUPER · **Joined:** Fri Aug 27, 2010 10:21 am **Posts:** 38

Thanks Simon:

Did what you asked and received same error.

Here's the way the file looks now:

--Font size--8 pt9 pt10 pt11 pt12 pt14 pt--Syntax--BasicBrainfuckCColdfusionCPPCSSHTMLJavaJavascriptPascalPerlPhpPythonRubyRobots txtSQLT-SQLVisual BasicXML <?php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334<?php
/*
WebMakers.com Added: attributes_sorter_added_functions.php
Additional functions for the admin

Shoppe Enhancement Controller - Copyright (c) 2003 WebMakers.com
Linda McGrath - osCommerce@WebMakers.com
*/

function tep_delete_products_attributes($delete_product_id) {
// delete product attributes
// tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . "pad, " . TABLE_PRODUCT_ATTRIBUTES . 'pa where pa.products_id = '" . $delete_product_id . "'" . " and pad.products_attributes_id='" . pa.products_attributes_id . "'");

// delete associated downloads
$products_delete_from_query= tep_db_query("select pa.products_id, pad.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad where pa.products_id='" . $delete_product_id . "' and pad.products_attributes_id= pa.products_attributes_id");
while ( $products_delete_from=tep_db_fetch_array($products_delete_from_query) ) {
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $products_delete_from['products_attributes_id'] . "'");
}
// tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_copy_to_check['products_id'] . "'");

tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $delete_product_id . "'");
}

function tep_copy_products_attributes($products_id_from,$products_id_to) {
global $copy_attributes_delete_first, $copy_attributes_duplicates_skipped, $copy_attributes_duplicates_overwrite, $copy_attributes_include_downloads, $copy_attributes_include_filename;
// $products_id_to= $copy_to_products_id;
// $products_id_from = $pID;
$products_copy_to_query= tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_id='" . $products_id_to . "'");
$products_copy_to_check_query= tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_id='" . $products_id_to . "'");
$products_copy_from_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_from . "'");
$products_copy_from_check_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_from . "'");

// Check for errors in copy request
if (!$products_copy_from_check=tep_db_fetch_array($products_copy_from_check_query) or !$products_copy_to_check=tep_db_fetch_array($products_copy_to_check_query) or $products_id_to == $products_id_from ) {
echo '<table width="100%"><tr>';
if ($products_id_to == $products_id_from) {
// same products_id
//echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . 'WARNING: Cannot copy from Product ID #' . $products_id_from . ' to Product ID # ' . $products_id_to . ' ... No copy was made' . '</td>';

echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . CANNOT_COPY_PRODUCT_ERROR_1 . $products_id_from . CANNOT_COPY_PRODUCT_ERROR_2 . $products_id_to . CANNOT_COPY_PRODUCT_ERROR_3 . '</td>';

} else {
if (!$products_copy_from_check) {
// no attributes found to copy
//echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . 'WARNING: No Attributes to copy from Product ID #' . $products_id_from . ' for: ' . tep_get_products_name($products_id_from) . ' ... No copy was made' . '</td>';

echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . NO_ATTRIBUTES_COPY_ERROR_1 . $products_id_from . NO_ATTRIBUTES_COPY_ERROR_2 . tep_get_products_name($products_id_from) . NO_ATTRIBUTES_COPY_ERROR_3 . '</td>';
} else {
// invalid products_id
// echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . 'WARNING: There is no Product ID #' . $products_id_to . ' ... No copy was made' . '' . '</td>';

echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . NO_PRODUCT_ERROR_1 . $products_id_to . NO_PRODUCT_ERROR_2 . '</td>';
}
}
echo '</tr></table>';
} else {

if (false) { // Used for testing
echo $products_id_from . 'x' . $products_id_to . ' ';
echo $copy_attributes_delete_first;
echo $copy_attributes_duplicates_skipped;
echo $copy_attributes_duplicates_overwrite;
echo $copy_attributes_include_downloads;
echo $copy_attributes_include_filename . ' ';
} // false for testing

if ($copy_attributes_delete_first=='1') {
// delete all attributes and downloads first
$products_delete_from_query= tep_db_query("select pa.products_id, pad.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad where pa.products_id='" . $products_id_to . "' and pad.products_attributes_id= pa.products_attributes_id");
while ( $products_delete_from=tep_db_fetch_array($products_delete_from_query) ) {
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $products_delete_from['products_attributes_id'] . "'");
}
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_copy_to_check['products_id'] . "'");
}
if(!(isset($rows)) ){
$rows = '';
}

while ( $products_copy_from=tep_db_fetch_array($products_copy_from_query) ) {
$rows++;
// This must match the structure of your products_attributes table
// Current Field Order: products_attributes_id, options_values_price, price_prefix, products_options_sort_order, product_attributes_one_time, products_attributes_weight, products_attributes_weight_prefix, products_attributes_units, products_attributes_units_price
// First test for existing attribute already being there
$check_attribute_query= tep_db_query("select products_id, products_attributes_id, options_id, options_values_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_to . "' and options_id='" . $products_copy_from['options_id'] . "' and options_values_id ='" . $products_copy_from['options_values_id'] . "'");
$check_attribute= tep_db_fetch_array($check_attribute_query);
// Check if there is a download with this attribute
$check_attributes_download_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id ='" . $products_copy_from['products_attributes_id'] . "'");
$check_attributes_download=tep_db_fetch_array($check_attributes_download_query);

// Process Attribute
$skip_it=false;
switch (true) {
case ($check_attribute and $copy_attributes_duplicates_skipped):
// skip duplicate attributes
// echo 'DUPLICATE ' . ' Option ' . $products_copy_from['options_id'] . ' Value ' . $products_copy_from['options_values_id'] . ' Price ' . $products_copy_from['options_values_price'] . ' SKIPPED ';
$skip_it=true;
break;
case (!$copy_attributes_include_downloads and $check_attributes_download['products_attributes_id']):
// skip download attributes
// echo 'Download - ' . ' Attribute ID ' . $check_attributes_download['products_attributes_id'] . ' do not copy it ';
$skip_it=true;
break;
default:
// echo '$check_attributes_download ' . $check_attributes_download['products_attributes_id'] . ' ';
if ($check_attributes_download['products_attributes_id']) {
if (DOWNLOAD_ENABLED=='false' or !$copy_attributes_include_downloads) {
// do not copy this download
// echo 'This is a download not to be copied ';
$skip_it=true;
} else {
// copy this download
// echo 'This is a download to be copied ';
}
}

// skip anything when $skip_it
if (!$skip_it) {
if ($check_attribute['products_id']) {
// Duplicate attribute - update it
// echo 'Duplicate - Update ' . $check_attribute['products_id'] . ' Option ' . $check_attribute['options_id'] . ' Value ' . $check_attribute['options_values_id'] . ' Price ' . $products_copy_from['options_values_price'] . ' ';
// tep_db_query("update set " . TABLE_PRODUCTS_ATTRIBUTES . ' ' . options_id=$products_copy_from['options_id'] . "', '" . options_values_id=$products_copy_from['options_values_id'] . "', '" . options_values_price=$products_copy_from['options_values_price'] . "', '" . price_prefix=$products_copy_from['price_prefix'] . "', '" . products_options_sort_order=$products_copy_from['products_options_sort_order'] . "', '" . product_attributes_one_time=$products_copy_from['product_attributes_one_time'] . "', '" . products_attributes_weight=$products_copy_from['products_attributes_weight'] . "', '" . products_attributes_weight_prefix=$products_copy_from['products_attributes_weight_prefix'] . "', '" . products_attributes_units=$products_copy_from['products_attributes_units'] . "', '" . products_attributes_units_price=$products_copy_from['products_attributes_units_price'] . " where products_id='" . $products_id_to . "' and products_attributes_id='" . $check_attribute['products_attributes_id'] . "'");

$sql_data_array = array(
'options_id' => tep_db_prepare_input($products_copy_from['options_id']),
'options_values_id' => tep_db_prepare_input($products_copy_from['options_values_id']),
'options_values_price' => tep_db_prepare_input($products_copy_from['options_values_price']),
'price_prefix' => tep_db_prepare_input($products_copy_from['price_prefix']),
'products_options_sort_order' => tep_db_prepare_input($products_copy_from['products_options_sort_order']),
);

$cur_attributes_id = $check_attribute['products_attributes_id'];
tep_db_perform(TABLE_PRODUCTS_ATTRIBUTES, $sql_data_array, 'update', 'products_id = \'' . tep_db_input($products_id_to) . '\' and products_attributes_id=\'' . tep_db_input($cur_attributes_id) . '\'');
} else {
// New attribute - insert it
// echo 'New - Insert ' . 'Option ' . $products_copy_from['options_id'] . ' Value ' . $products_copy_from['options_values_id'] . ' Price ' . $products_copy_from['options_values_price'] . ' ';
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . $products_id_to . "', '" . $products_copy_from['options_id'] . "', '" . $products_copy_from['options_values_id'] . "', '" . $products_copy_from['options_values_price'] . "', '" . $products_copy_from['price_prefix'] . "', '" . $products_copy_from['products_options_sort_order'] . "') ");
}

// Manage download attribtues
if (DOWNLOAD_ENABLED == 'true') {
if ($check_attributes_download and $copy_attributes_include_downloads) {
// copy download attributes
// echo 'Download - ' . ' Attribute ID ' . $check_attributes_download['products_attributes_id'] . ' ' . $check_attributes_download['products_attributes_filename'] . ' copy it ';
$new_attribute_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_to . "' and options_id='" . $products_copy_from['options_id'] . "' and options_values_id ='" . $products_copy_from['options_values_id'] . "'");
$new_attribute= tep_db_fetch_array($new_attribute_query);

$sql_data_array = array(
'products_attributes_id' => tep_db_prepare_input($new_attribute['products_attributes_id']),
'products_attributes_filename' => tep_db_prepare_input($check_attributes_download['products_attributes_filename']),
'products_attributes_maxdays' => tep_db_prepare_input($check_attributes_download['products_attributes_maxdays']),
'products_attributes_maxcount' => tep_db_prepare_input($check_attributes_download['products_attributes_maxcount'])
);

$cur_attributes_id = $check_attribute['products_attributes_id'];
tep_db_perform(TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD, $sql_data_array);
}
}
} // $skip_it
break;
} // end of switch
} // end of product attributes while loop
} // end of no attributes or other errors
} // eof: tep_copy_products_attributes

////
// Check if product has attributes
function tep_has_product_attributes($products_id) {
$attributes_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_id . "'");
$attributes = tep_db_fetch_array($attributes_query);

if ($attributes['count'] > 0) {
return true;
} else {
return false;
}
}

////
// Set attributes_discounted on/off
function tep_discount_products_attributes($products_id, $on_off='1') {
$attributes_discount_query = tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_id . "'");
while ($attributes_discount = tep_db_fetch_array($attributes_discount_query)) {
// echo $attributes_discount['products_attributes_id'] . ' - ' . $on_off . ' ';
tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set attributes_discounted = '" . $on_off . "' where products_attributes_id = '" . $attributes_discount['products_attributes_id'] . "'");
}
}

////
// Set products_price_excluded on/off
function tep_products_price_excluded($products_id, $on_off='1') {
tep_db_query("update " . TABLE_PRODUCTS . " set products_price_excluded='" . $on_off . "' where products_id='" . $products_id . "'");
}

////
////
////
// Set Product Attributes Sort Order to Products Option Value Sort Order
function tep_update_attributes_products_option_values_sort_order($products_id) {
$attributes_sort_order_query = tep_db_query("select distinct pa.products_attributes_id, pa.options_id, pa.options_values_id, pa.products_options_sort_order, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $products_id . "' and pa.options_values_id = pov.products_options_values_id");
while ($attributes_sort_order = tep_db_fetch_array($attributes_sort_order_query)) {
tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_options_sort_order = '" . $attributes_sort_order['products_options_values_sort_order'] . "' where products_id = '" . $products_id . "' and products_attributes_id = '" . $attributes_sort_order['products_attributes_id'] . "'");
}
}

//CLR 030312 add function to draw pulldown list of option types
// Draw a pulldown for Option Types
function draw_optiontype_pulldown($name, $default = '') {
$values = array();
$values[] = array('id' => 0, 'text' => 'Select');
$values[] = array('id' => 1, 'text' => 'Text');
$values[] = array('id' => 2, 'text' => 'Radio');
$values[] = array('id' => 3, 'text' => 'Checkbox');
$values[] = array('id' => 4, 'text' => 'Text Area');
// $values[] = array('id' => 5, 'text' => 'File Upload');
return tep_draw_pull_down_menu($name, $values, $default);
}

//CLR 030312 add function to translate type_id to name
// Translate option_type_values to english string
function translate_type_to_name($opt_type) {
if ($opt_type == 0) return 'Select';
if ($opt_type == 1) return 'Text';
if ($opt_type == 2) return 'Radio';
if ($opt_type == 3) return 'Checkbox';
if ($opt_type == 4) return 'Text Area';
// if ($opt_type == 5) return 'File Upload';
return 'Error ' . $opt_type;
}

?>
<?php
<?php
<?php
/*
WebMakers.com Added: attributes_sorter_added_functions.php
Additional functions for the admin

Shoppe Enhancement Controller - Copyright (c) 2003 WebMakers.com
Linda McGrath - osCommerce@WebMakers.com
*/

function tep_delete_products_attributes($delete_product_id) {
// delete product attributes
// tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . "pad, " . TABLE_PRODUCT_ATTRIBUTES . 'pa where pa.products_id = '" . $delete_product_id . "'" . " and pad.products_attributes_id='" . pa.products_attributes_id . "'");

// delete associated downloads
$products_delete_from_query= tep_db_query("select pa.products_id, pad.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad where pa.products_id='" . $delete_product_id . "' and pad.products_attributes_id= pa.products_attributes_id");
while ( $products_delete_from=tep_db_fetch_array($products_delete_from_query) ) {
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $products_delete_from['products_attributes_id'] . "'");
}
// tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_copy_to_check['products_id'] . "'");

tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $delete_product_id . "'");
}

function tep_copy_products_attributes($products_id_from,$products_id_to) {
global $copy_attributes_delete_first, $copy_attributes_duplicates_skipped, $copy_attributes_duplicates_overwrite, $copy_attributes_include_downloads, $copy_attributes_include_filename;
// $products_id_to= $copy_to_products_id;
// $products_id_from = $pID;
$products_copy_to_query= tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_id='" . $products_id_to . "'");
$products_copy_to_check_query= tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_id='" . $products_id_to . "'");
$products_copy_from_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_from . "'");
$products_copy_from_check_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_from . "'");

// Check for errors in copy request
if (!$products_copy_from_check=tep_db_fetch_array($products_copy_from_check_query) or !$products_copy_to_check=tep_db_fetch_array($products_copy_to_check_query) or $products_id_to == $products_id_from ) {
echo '<table width="100%"><tr>';
if ($products_id_to == $products_id_from) {
// same products_id
//echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . 'WARNING: Cannot copy from Product ID #' . $products_id_from . ' to Product ID # ' . $products_id_to . ' ... No copy was made' . '</td>';

echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . CANNOT_COPY_PRODUCT_ERROR_1 . $products_id_from . CANNOT_COPY_PRODUCT_ERROR_2 . $products_id_to . CANNOT_COPY_PRODUCT_ERROR_3 . '</td>';

} else {
if (!$products_copy_from_check) {
// no attributes found to copy
//echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . 'WARNING: No Attributes to copy from Product ID #' . $products_id_from . ' for: ' . tep_get_products_name($products_id_from) . ' ... No copy was made' . '</td>';

echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . NO_ATTRIBUTES_COPY_ERROR_1 . $products_id_from . NO_ATTRIBUTES_COPY_ERROR_2 . tep_get_products_name($products_id_from) . NO_ATTRIBUTES_COPY_ERROR_3 . '</td>';
} else {
// invalid products_id
// echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . 'WARNING: There is no Product ID #' . $products_id_to . ' ... No copy was made' . '' . '</td>';

echo '<td class="messageStackError">' . tep_image(DIR_WS_ICONS . 'warning.gif', ICON_WARNING) . NO_PRODUCT_ERROR_1 . $products_id_to . NO_PRODUCT_ERROR_2 . '</td>';
}
}
echo '</tr></table>';
} else {

if (false) { // Used for testing
echo $products_id_from . 'x' . $products_id_to . ' ';
echo $copy_attributes_delete_first;
echo $copy_attributes_duplicates_skipped;
echo $copy_attributes_duplicates_overwrite;
echo $copy_attributes_include_downloads;
echo $copy_attributes_include_filename . ' ';
} // false for testing

if ($copy_attributes_delete_first=='1') {
// delete all attributes and downloads first
$products_delete_from_query= tep_db_query("select pa.products_id, pad.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad where pa.products_id='" . $products_id_to . "' and pad.products_attributes_id= pa.products_attributes_id");
while ( $products_delete_from=tep_db_fetch_array($products_delete_from_query) ) {
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $products_delete_from['products_attributes_id'] . "'");
}
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_copy_to_check['products_id'] . "'");
}
if(!(isset($rows)) ){
$rows = '';
}

while ( $products_copy_from=tep_db_fetch_array($products_copy_from_query) ) {
$rows++;
// This must match the structure of your products_attributes table
// Current Field Order: products_attributes_id, options_values_price, price_prefix, products_options_sort_order, product_attributes_one_time, products_attributes_weight, products_attributes_weight_prefix, products_attributes_units, products_attributes_units_price
// First test for existing attribute already being there
$check_attribute_query= tep_db_query("select products_id, products_attributes_id, options_id, options_values_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_to . "' and options_id='" . $products_copy_from['options_id'] . "' and options_values_id ='" . $products_copy_from['options_values_id'] . "'");
$check_attribute= tep_db_fetch_array($check_attribute_query);
// Check if there is a download with this attribute
$check_attributes_download_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id ='" . $products_copy_from['products_attributes_id'] . "'");
$check_attributes_download=tep_db_fetch_array($check_attributes_download_query);

// Process Attribute
$skip_it=false;
switch (true) {
case ($check_attribute and $copy_attributes_duplicates_skipped):
// skip duplicate attributes
// echo 'DUPLICATE ' . ' Option ' . $products_copy_from['options_id'] . ' Value ' . $products_copy_from['options_values_id'] . ' Price ' . $products_copy_from['options_values_price'] . ' SKIPPED ';
$skip_it=true;
break;
case (!$copy_attributes_include_downloads and $check_attributes_download['products_attributes_id']):
// skip download attributes
// echo 'Download - ' . ' Attribute ID ' . $check_attributes_download['products_attributes_id'] . ' do not copy it ';
$skip_it=true;
break;
default:
// echo '$check_attributes_download ' . $check_attributes_download['products_attributes_id'] . ' ';
if ($check_attributes_download['products_attributes_id']) {
if (DOWNLOAD_ENABLED=='false' or !$copy_attributes_include_downloads) {
// do not copy this download
// echo 'This is a download not to be copied ';
$skip_it=true;
} else {
// copy this download
// echo 'This is a download to be copied ';
}
}

// skip anything when $skip_it
if (!$skip_it) {
if ($check_attribute['products_id']) {
// Duplicate attribute - update it
// echo 'Duplicate - Update ' . $check_attribute['products_id'] . ' Option ' . $check_attribute['options_id'] . ' Value ' . $check_attribute['options_values_id'] . ' Price ' . $products_copy_from['options_values_price'] . ' ';
// tep_db_query("update set " . TABLE_PRODUCTS_ATTRIBUTES . ' ' . options_id=$products_copy_from['options_id'] . "', '" . options_values_id=$products_copy_from['options_values_id'] . "', '" . options_values_price=$products_copy_from['options_values_price'] . "', '" . price_prefix=$products_copy_from['price_prefix'] . "', '" . products_options_sort_order=$products_copy_from['products_options_sort_order'] . "', '" . product_attributes_one_time=$products_copy_from['product_attributes_one_time'] . "', '" . products_attributes_weight=$products_copy_from['products_attributes_weight'] . "', '" . products_attributes_weight_prefix=$products_copy_from['products_attributes_weight_prefix'] . "', '" . products_attributes_units=$products_copy_from['products_attributes_units'] . "', '" . products_attributes_units_price=$products_copy_from['products_attributes_units_price'] . " where products_id='" . $products_id_to . "' and products_attributes_id='" . $check_attribute['products_attributes_id'] . "'");

$sql_data_array = array(
'options_id' => tep_db_prepare_input($products_copy_from['options_id']),
'options_values_id' => tep_db_prepare_input($products_copy_from['options_values_id']),
'options_values_price' => tep_db_prepare_input($products_copy_from['options_values_price']),
'price_prefix' => tep_db_prepare_input($products_copy_from['price_prefix']),
'products_options_sort_order' => tep_db_prepare_input($products_copy_from['products_options_sort_order']),
);

$cur_attributes_id = $check_attribute['products_attributes_id'];
tep_db_perform(TABLE_PRODUCTS_ATTRIBUTES, $sql_data_array, 'update', 'products_id = \'' . tep_db_input($products_id_to) . '\' and products_attributes_id=\'' . tep_db_input($cur_attributes_id) . '\'');
} else {
// New attribute - insert it
// echo 'New - Insert ' . 'Option ' . $products_copy_from['options_id'] . ' Value ' . $products_copy_from['options_values_id'] . ' Price ' . $products_copy_from['options_values_price'] . ' ';
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . $products_id_to . "', '" . $products_copy_from['options_id'] . "', '" . $products_copy_from['options_values_id'] . "', '" . $products_copy_from['options_values_price'] . "', '" . $products_copy_from['price_prefix'] . "', '" . $products_copy_from['products_options_sort_order'] . "') ");
}

// Manage download attribtues
if (DOWNLOAD_ENABLED == 'true') {
if ($check_attributes_download and $copy_attributes_include_downloads) {
// copy download attributes
// echo 'Download - ' . ' Attribute ID ' . $check_attributes_download['products_attributes_id'] . ' ' . $check_attributes_download['products_attributes_filename'] . ' copy it ';
$new_attribute_query= tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $products_id_to . "' and options_id='" . $products_copy_from['options_id'] . "' and options_values_id ='" . $products_copy_from['options_values_id'] . "'");
$new_attribute= tep_db_fetch_array($new_attribute_query);

$sql_data_array = array(
'products_attributes_id' => tep_db_prepare_input($new_attribute['products_attributes_id']),
'products_attributes_filename' => tep_db_prepare_input($check_attributes_download['products_attributes_filename']),
'products_attributes_maxdays' => tep_db_prepare_input($check_attributes_download['products_attributes_maxdays']),
'products_attributes_maxcount' => tep_db_prepare_input($check_attributes_download['products_attributes_maxcount'])
);

$cur_attributes_id = $check_attribute['products_attributes_id'];
tep_db_perform(TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD, $sql_data_array);
}
}
} // $skip_it
break;
} // end of switch
} // end of product attributes while loop
} // end of no attributes or other errors
} // eof: tep_copy_products_attributes

////
// Check if product has attributes
function tep_has_product_attributes($products_id) {
$attributes_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_id . "'");
$attributes = tep_db_fetch_array($attributes_query);

if ($attributes['count'] > 0) {
return true;
} else {
return false;
}
}

////
// Set attributes_discounted on/off
function tep_discount_products_attributes($products_id, $on_off='1') {
$attributes_discount_query = tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_id . "'");
while ($attributes_discount = tep_db_fetch_array($attributes_discount_query)) {
// echo $attributes_discount['products_attributes_id'] . ' - ' . $on_off . ' ';
tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set attributes_discounted = '" . $on_off . "' where products_attributes_id = '" . $attributes_discount['products_attributes_id'] . "'");
}
}

////
// Set products_price_excluded on/off
function tep_products_price_excluded($products_id, $on_off='1') {
tep_db_query("update " . TABLE_PRODUCTS . " set products_price_excluded='" . $on_off . "' where products_id='" . $products_id . "'");
}

////
////
////
// Set Product Attributes Sort Order to Products Option Value Sort Order
function tep_update_attributes_products_option_values_sort_order($products_id) {
$attributes_sort_order_query = tep_db_query("select distinct pa.products_attributes_id, pa.options_id, pa.options_values_id, pa.products_options_sort_order, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $products_id . "' and pa.options_values_id = pov.products_options_values_id");
while ($attributes_sort_order = tep_db_fetch_array($attributes_sort_order_query)) {
tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_options_sort_order = '" . $attributes_sort_order['products_options_values_sort_order'] . "' where products_id = '" . $products_id . "' and products_attributes_id = '" . $attributes_sort_order['products_attributes_id'] . "'");
}
}

//CLR 030312 add function to draw pulldown list of option types
// Draw a pulldown for Option Types
function draw_optiontype_pulldown($name, $default = '') {
$values = array();
$values[] = array('id' => 0, 'text' => 'Select');
$values[] = array('id' => 1, 'text' => 'Text');
$values[] = array('id' => 2, 'text' => 'Radio');
$values[] = array('id' => 3, 'text' => 'Checkbox');
$values[] = array('id' => 4, 'text' => 'Text Area');
// $values[] = array('id' => 5, 'text' => 'File Upload');
return tep_draw_pull_down_menu($name, $values, $default);
}

//CLR 030312 add function to translate type_id to name
// Translate option_type_values to english string
function translate_type_to_name($opt_type) {
if ($opt_type == 0) return 'Select';
if ($opt_type == 1) return 'Text';
if ($opt_type == 2) return 'Radio';
if ($opt_type == 3) return 'Checkbox';
if ($opt_type == 4) return 'Text Area';
// if ($opt_type == 5) return 'File Upload';
return 'Error ' . $opt_type;
}

?>
Position: Ln 1, Ch 1 Total: Ln 235, Ch 15665
Processing... search

replace

match case regular expressions
find next replace replace all

Editarea 0.8.2

Shortcuts:
Tab: add tabulation to text
Shift+Tab: remove tabulation to text
Ctrl+f: search next / open search area
Ctrl+r: replace / open search area
Ctrl+h: toggle syntax highlight on/off
Ctrl+g: go to line
Ctrl+z: undo
Ctrl+y: redo
Ctrl+e: about
Ctrl+q, Esc: close popup
Accesskey E: Toggle editor

Notice: syntax highlight function is only for small text

© Christophe Dolivet 2007-2010

soundzgood2 · **Posted:** Tue Nov 08, 2011 3:23 am

Er, what is that? Your site's been hacked then ... ?
Simon

Loaded Commerce Community

CRE 6.4B2B PRODUCT ATTRIBUTE ERROR

Who is online

Main Menu

Login

Forums Latest Activity

Top Listing

Members Online