Latest News: (loading..)

dangerman

Members
  • Content count

    10
  • Joined

  • Last visited

About dangerman

Profile Information

  • Real Name
    Bill
  1. I forgot to mention, after I got the text input fields to work in admin I had to make one more change so they would show up in the confirmation email as well. Open checkout_process.php and find the following: // denuz_arun text attr $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'"); Replace with: // denuz_arun text attr $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");
  2. This is what I did to fix the text input fields showing on the customer side but not in admin issue. Open admin/invoice.php and find the following: // denuz text attr // $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'"); Replace with: // $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'"); Open admin/packingslip.php and find the following: // denuz text attr $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'"); Replace with: // denuz text attr $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'"); Also (this may be a known issue but I was unaware) once you create a text attribute for a product don't use that same attribute for another product. This was causing problems for me as well. Big Bear - sorry, I haven't seen that issue.
  3. If you did a manual install of v1.3.5 and text input fields are not showing in your confirmation email this is how to fix it. Open checkout_process.php 1. FIND FOLLOWING (around line 220) -------------------------------- //------insert customer choosen option eof ---- $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']); $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] .') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n\n"; } 2. AND REPLACE BY FOLLOWING ------------------------ // denuz_arun text attr $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $denux_arunQry = "select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $insert_id. //$HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid . " and pta.products_text_attributes_id = ota.products_text_attributes_id"; //echo ; $attr_q = tep_db_query($denux_arunQry); $denux_arun_ =''; while ($attr = tep_db_fetch_array($attr_q)) { $denux_arun_ .= $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text'])."\n"; } // eof denuz_arun text attr //------insert customer choosen option eof ---- $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']); $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] .') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n". $denux_arun_ . "\n"; } The last line of code has been modified (. $denux_arun_ . "\n") but it is outside of the denuz tag. If you are copy/pasting code blocks obviously it will get missed. :( I am still having the issue of text input fields showing on the customer side but not in admin. The best part is, it's only for some items, others work fine. Also, if the text input does not show in admin it does not show in the confirmation email as well. When it works, it works for both. Anyone seen this or have a solution?
  4. Resolved. It ended up being a 5 second fix. The gd.so extension was not enabled in the php.ini file on my server. enabled it and everything works. :rolleyes:
  5. Removing the matching products addon had no effect. I am still sent to a blank page. Back to the drawing board.
  6. Hi Multimixer, Yes AI was the last thing installed. No it hasn't worked since installing. url for the blank page is "http://mysite.com/catalog/admin/categories.php?action=add_images&cPath=26&pID=238&osCAdminID=uf92aav3ndr73rf1gpb8ae6ct0" I thought it might be categories.php since that was the page I was having the problems on but then realized that I was also getting a blank page if I tried to process any existing images and that is on additional_images.php. url for the blank page is "http://mysite.com/catalog/admin/additional_images.php?osCAdminID=uf92aav3ndr73rf1gpb8ae6ct0&action=generate&list=unprocessed&products_id=238&product_per_page_drop=20&page=1&category_filter=26&manufacturer_filter=&show_images=y&submit=Process" I have an addon called matching products that I had to merge some of the code in categories.php when installing AI. Not sure if that is causing the problem. I may have to try removing that addon and see if anything changes. Here is an example of some of the lines I had to merge. // BOF: Additional Images: Added: , products_image_med, products_image_pop, products_image_description $product_query = tep_db_query("select products_quantity, products_model, products_image, products_image_med, products_image_pop, products_image_description, products_price, products_matching, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); // EOF: Additional Images // Matching Products Contrib Edited Below // $product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_matching, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); // BOF: Additional Images: Added: , products_image_med, products_image_pop, products_image_description -and- , '" . tep_db_input($product['products_image_med']) . "', '" . tep_db_input($product['products_image_pop']) . "', '" . tep_db_input($product['products_image_description']) . "' tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_image_med, products_image_pop, products_image_description, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_image_med']) . "', '" . tep_db_input($product['products_image_pop']) . "', '" . tep_db_input($product['products_image_description']) . "', '" . tep_db_input($product['products_price']) . "', '" . tep_db_input($product['products_matching']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); // EOF: Additional Images // Matching Products Contrib Edited Below // tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_image, products_price, products_matching, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', '" . tep_db_input($product['products_matching']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id();
  7. Hi, When trying to save an additional Image I am sent to a blank page and when I go back to the product it says "No Additional Images!". Also if I edit a product and add an image and go to preview I am sent to a blank page as well. I went back and compared all the files and don't see anything that I may have missed but obviously something has gone wrong. It seems that categories.php is where I am having the issue. I'm hoping someone can point me in the right direction. Thanks.
  8. The secret is phpMyAdmin. select the builder_categories table on the left and click the browse tab at the top of the main window. click insert new row at the bottom of the main window and in the new window under the value column enter your new information. I just followed the same format of the other 3 categories. Below is an example of the information that you will enter. Field Type Function Null [b]Value[/b] cpb_category_id int(11) [b]40[/b] cpb_depends_category_id int(11) [b]30[/b] cpb_category_name varchar(32) [b]Component 4[/b] <--- Edit category name here cpb_category_image varchar(32) [b]component4.gif[/b] osc_category_id int(11) [b]33[/b] Click the Go button and your new row should now show up in the table. You can now return to the the osCommerce admin and your new category will be listed in the Custom Products > Categories section.
  9. Does anyone know what the secret is for adding a new category? In the Categories section of Admin is says "Add new category" but nothing changes when I update. I also tried "Rename category" as well and that doesn't change anything either. there is component 1 - 5 in the dropdown image selection which seemed to indicate that you could have more than 3 categories. Other than that everything seems to be pretty straight forward and working well. Thanks.