Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

About breamillman

  • Birthday 06/28/1973

Profile Information

  1. I read through all 30 pages and you are the only one that mentions finding and having success with a new(er) cc_validation.php page to fix the error with valid card thing. Can you copy it here (if allowed)- or pm me the cc_validation page you are using??? I searched all over and found a few things in the contributions that I could use but they are SOOOO different then the current page I have i'm afraid to try.. unless I have to... please and thanks...
  2. breamillman

    Down for Maintenance v2.1?

    Can you tell us what you did Please?!?! All of the other fixes for this haven't seemed to work.. thanks!
  3. breamillman

    customers text not showing in emailed order

    Well I certainly didn't get it working. As with just about EVERY contribution I try. I just gave up on getting it into the emails and deleted the contrib all together. No luck with any text option contributions at all! So i'm back to just having customers write stuff in the comments section. Funny thing is every once in awhile the comments section disappears from the emails too!! ugh it's all a headache. :huh:
  4. breamillman

    Official PayPal IPN Support Thread

    DELETED COMMENTS! Here is my issue that I've been trying to ignore for months. Occassionally I receive payment notification but no order email. From reading here I gather it's from customer not clicking return to site or whatever that final click is. A pain, but not a big deal. This is the real problem. When I go into my admin to retrieve the order that I magically have a payment for- the COMMENTS section has been deleted. A Lot of my customers use the comments section for various reasons and it's embarassing to email a customer and say there's been a glitch in the system and to please confirm their order and comments. Anyone know how to fix this??? Oh - and when I do get an order conf. email- the comments are there- but if I double check in my admin with those orders too- the comments have been deleted there as well. So I guess I either need to make sure i always get an email confirmation (that has the comments still there) or figure out what is deleting the comments from the database. And it's just with paypal - no problems with my other payment methods and comments. Any ideas would be greatly appreciated. Sorry to bother- I know we all feel like we live around here trying to fix things that aren't working right! Thanks in advance.
  5. I need some serious help. I have tinkered and tinkered and put through at least 200 orders testing this and still can't figure it out. I have the Imprint Option contrib. installed. It allows customers to type in a personalization and have it added as a type of attribute to the item. It shows up in the shopping cart perfectly. It shows up in my admin orders fine. It DOES NOT show up in the emailed order (or in the printable invoice or packing slip). I desperately want it to show up in the order email otherwise it is basically worthless and i'll just go back the unprofessional way of having a customer type stuff in the comments, which I hate. I have also tried the option type text contrib or whatever it's called and after 3 reinstalls never got it to work. At least with this Imprint Option- it WORKS- I just can't get it in the emails. This is what I have in checkout_process.. I orginally thought I needed to add something in the "lets start with email confirmation" section-- but realized it has no effect no matter what I put. Also if I add a spot there about the regular attributes it will actually write the same attributes twice in the email- so it is being called from elsewhere in the code.. I have bits and pieces of useless code all over the place where I was trying to get things to work.. PLEASE can someone help, i'm at my wits end. :'( thanks... <?php /* $Id: checkout_process.php,v 1.128 2003/05/28 18:00:29 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions [url=http://www.oscommerce.com]http://www.oscommerce.com[/url] Copyright ? 2003 osCommerce Released under the GNU General Public License */ include('includes/application_top.php'); // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(array('mode' => 'SSL', 'page' => FILENAME_CHECKOUT_PAYMENT)); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } if (!tep_session_is_registered('sendto')) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); } if ( (tep_not_null(MODULE_PAYMENT_INSTALLED)) && (!tep_session_is_registered('payment')) ) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); } // avoid hack attempts during the checkout procedure by checking the internal cartID if (isset($cart->cartID) && tep_session_is_registered('cartID')) { if ($cart->cartID != $cartID) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } } include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS); // load selected payment module require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment($payment); // load the selected shipping module require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping($shipping); require(DIR_WS_CLASSES . 'order.php'); $order = new order; // load the before_process function from the payment modules $payment_modules->before_process(); require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; $order_totals = $order_total_modules->process(); $sql_data_array = array('customers_id' => $customer_id, 'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'], 'customers_company' => $order->customer['company'], 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'] . ' ' . $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_address_format_id' => $order->delivery['format_id'], 'billing_name' => $order->billing['firstname'] . ' ' . $order->billing['lastname'], 'billing_company' => $order->billing['company'], 'billing_street_address' => $order->billing['street_address'], 'billing_suburb' => $order->billing['suburb'], 'billing_city' => $order->billing['city'], 'billing_postcode' => $order->billing['postcode'], 'billing_state' => $order->billing['state'], 'billing_country' => $order->billing['country']['title'], 'billing_address_format_id' => $order->billing['format_id'], 'payment_method' => $order->info['payment_method'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => $order->info['order_status'], 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value']); tep_db_perform(TABLE_ORDERS, $sql_data_array); $insert_id = tep_db_insert_id(); for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) { $sql_data_array = array('orders_id' => $insert_id, 'title' => $order_totals[$i]['title'], 'text' => $order_totals[$i]['text'], 'value' => $order_totals[$i]['value'], 'class' => $order_totals[$i]['code'], 'sort_order' => $order_totals[$i]['sort_order']); tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array); } $customer_notification = (SEND_EMAILS == 'true') ? '1' : '0'; $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => $customer_notification, 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); // initialized for the email confirmation $products_ordered = ''; $subtotal = 0; $total_tax = 0; for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { if (DOWNLOAD_ENABLED == 'true') { $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa ON p.products_id=pa.products_id LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad ON pa.products_attributes_id=pad.products_attributes_id WHERE p.products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"; // Will work with only one option for downloadable products // otherwise, we have to build the query dynamically with a loop $products_attributes = $order->products[$i]['attributes']; if (is_array($products_attributes)) { $stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'"; } $stock_query = tep_db_query($stock_query_raw); } else { $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } if (tep_db_num_rows($stock_query) > 0) { $stock_values = tep_db_fetch_array($stock_query); // do not decrement quantities if products_attributes_filename exists if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) { $stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty']; } else { $stock_left = $stock_values['products_quantity']; } tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } } } // Update products_ordered (for bestsellers list) tep_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $order_products_id = tep_db_insert_id(); // denuz text attr $attr_q = tep_db_query("select * from customers_basket_text_attributes where session_id = '$osCsid' and products_id = " . tep_get_prid($order->products[$i]['id'])); while ($attr = tep_db_fetch_array($attr_q)) { tep_db_query("insert into orders_text_attributes values ($insert_id, " . tep_get_prid($order->products[$i]['id']) . ", " . $attr['products_text_attributes_id'] . ", '" . $attr['products_text_attributes_text'] . "')"); } tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_prid($order->products[$i]['id']) . " and session_id = '" . $osCsid . "'"); // eof denuz text attr //------insert customer choosen option to order-------- $attributes_exist = '0'; $products_ordered_attributes = ''; if (isset($order->products[$i]['attributes'])) { $attributes_exist = '1'; for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) { if (DOWNLOAD_ENABLED == 'true') { $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad on pa.products_attributes_id=pad.products_attributes_id where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"; $attributes = tep_db_query($attributes_query); } else { $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); } $attributes_values = tep_db_fetch_array($attributes); //clr 030714 update insert query. changing to use values form $order->products for products_options_values. $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'products_options' => $attributes_values['products_options_name'], 'products_options_values' => $order->products[$i]['attributes'][$j]['value'], 'options_values_price' => $attributes_values['options_values_price'], 'price_prefix' => $attributes_values['price_prefix']); tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); if ((DOWNLOAD_ENABLED == 'true') && isset($attributes_values['products_attributes_filename']) && tep_not_null($attributes_values['products_attributes_filename'])) { $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'orders_products_filename' => $attributes_values['products_attributes_filename'], 'download_maxdays' => $attributes_values['products_attributes_maxdays'], 'download_count' => $attributes_values['products_attributes_maxcount']); tep_db_perform(TABLE_ORDERS_PRODUCTS_DOWNLOAD, $sql_data_array); } //clr 030714 changing to use values from $orders->products and adding call to tep_decode_specialchars() //$products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . tep_decode_specialchars($order->products[$i]['attributes'][$j]['value']); $products_ordered_text_attributes .= "\n\t" . $text_attributes_values['products_text_attributes_id'] . ' ' . $text_attributes_values['products_text_attributes_text']; $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; } } //------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 . $products_text_attributes_text . "\n"; } // lets start with the email confirmation $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($order->info['comments']) { $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR . "\n" . $products_ordered . EMAIL_SEPARATOR . "\n"; for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) { $email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_MAIL . $order->customer['email_address'] . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n"; } $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $billto, 0, '', "\n") . "\n\n"; if (is_object($$payment)) { $email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $email_order .= $payment_class->title . "\n\n"; if ($payment_class->email_footer) { $email_order .= $payment_class->email_footer . "\n\n"; } } tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); // send emails to other people if (SEND_EXTRA_ORDER_EMAILS_TO != '') { tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } // load the after_process function from the payment modules $payment_modules->after_process(); $cart->reset(true); // unregister session variables used during checkout tep_session_unregister('sendto'); tep_session_unregister('billto'); tep_session_unregister('shipping'); tep_session_unregister('payment'); tep_session_unregister('comments'); tep_redirect(tep_href_link(FILENAME_CHECKOUT_SUCCESS, '', 'SSL')); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  6. breamillman

    Imprint Text Options

    A few questions: 1) Anyone know how to get the TEXT ATTRIBUTES (or any attributes) to SHOW IN the EMAIL ORDER copy??? It seems to only show in admin- but not in any of the emails. 2) This 1 i'm sure is easy- but I can't seem to find the right area of code.. Where do I change the SIZE OF THE TEXT BOX? It seems rather small (although I know text keeps typing past the end of the box) but the box itself gets lost in the product page and customers need huge neon lights that say type here!! So I just want the box bigger but can't find the code! 3) Anyone figure out how to allow the SAME PRODUCT to be ADDED more than once to the cart without losing product a's text info?? and I've tried the other contrib - option text type or whatever it's called and it sucks (installed 3 times and never got it working) -- so this is the contrib for me. Many Thanks in advance!! :thumbsup: ~BREA
  7. breamillman

    Option Type Feature v1.6 (for osc 2.2 MS2)

    Did you ever figure this out?? Having the same issue of dropdown boxes where text/textarea/input boxes should be. Any help would be greatly appreciated. Thanks!
  8. breamillman

    option type feature

    Did you ever figure this out? Having the same problem. Thanks!
  9. breamillman

    Official PayPal IPN Support Thread

    I totally forgot about this post until I got that email reply notification thing. In case others encounter the same problems, I just wanted to add that I have processed several paypal payments after making the above changes, and the addresses do in fact show up in the shipping. AND the ones that are verified show up confirmed and eligible for seller protection. So VOILA problems fixed. No more typing in addresses and no more ineligible seller protection!
  10. breamillman

    Official PayPal IPN Support Thread

    I'd appreciate it, Thank you! Hope you find a fix. ;)
  11. breamillman

    Official PayPal IPN Support Thread

    Yep same thing happened to me. I couldn't figure out a way to fix it so I went around it. Instead of transferring the shopping cart contents to paypal I changed it to just say shopping cart items or something like that. Not as great as having the paypal payment show the EXACT items purchased- but the order invoice #'s still match so you can look at their order in your admin or the copy that should be emailed to you. Customers don't seem to care that they get the cart contents in one email and a paypal payment email without the items ordered. If you go into your admin panel- modules- payment- paypal ipn and edit it there is a spot where it says transaction type and there are 2 choices aggregate and something else which I forget- like itemized or something. Anyway- choose aggregate. Worked for me! Now I can have coupons and paypal is happy because they don't see them! :thumbsup: good luck!
  12. breamillman

    Official PayPal IPN Support Thread

    I was looking for the same answer - having the same issues - & it was driving me nuts with all the typing!! So when reading through all these millions of posts founds this. I just changed the code & haven't actually processed the order, but I checked up to the point of hitting "PAY" and it in fact does have my stored paypal addresses to choose from in a drop down menu. So I would ASSUME that if I select one of those - then hit Pay- it would show up in the order preprinted and have the eligible for seller protection. Course I didn't test it all the way through- i'm just going to let the next customer who uses paypal test it. hahah But the page up to that point at least looks like what it used to at the old store I was using pre-oscomm and paypal ipn.. But this is the only change About line 328 of includes/modules/paypal_ipn.php replaced this: $parameters['no_shipping'] = '1'; with this: $parameters['no_shipping'] = '0'; Another post somewhere later explained it as "1" is for "intangible" items... "0" is for "tangible"- i.e. something that needs to be shipped! Let me know what happens if you test it... or i'll post back if someone uses paypal at my store in the meantime. :thumbsup:
  13. Thank you- I installed the fix-- But I think that just handles the highlighting... not the pointer image. It is originally set to have the pointer_blue for categories that contain subcategories. And pointer_blue_light for categories that do NOT have subcats. Before clicking to reveal any subcats it shows the 2 different arrows (pointers). It looks weird and customers probably think why is that arrow different?? So I changed it so that all the arrows (pointers) for ALL the categories (despite the presence of subcats or not) showed the pointer_blue. What I would like is for once a cat is clicked- and the subcats are shown- the subcats show the pointer_blue_light while all the cats still show the pointer_blue. I have to come up with a few lines of code to reference the subcats directly- however to do that is beyond my php abilities. So far everything i've done has created errors or no effect... I tried if (tep_has_subcategories($counter)) { ? ? $categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue_light.gif', ''); and else { ? ? $subcategories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue_light.gif', ''); hahaha-- but none of that worked.. :-" One would think it would be set up to do it this way in the first place- as it's really not necessary to define which cat has subcats in the main menu-- they are all going to have some type of product in there-- and the reason for the difference is not known by the customer- so really it just messes with the overall neatness of the design.
  14. No one has posted here in forever- but it's worth a try. I have the category box enhancement installed on my site and it works great. One thing I didn't like was on the main page (when just showing cats and no subcats) the cats WITH sub cats had the arrow looking different than the others- it kind of threw things off. so I changed this original- $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; ? ?if (tep_has_category_subcategories($counter)) { ? ? ?$categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue.gif', ''); ? ?} ? ?else { ? ? ?$categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue_light.gif', ''); ? ?} to this: $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; ? ?if (tep_has_category_subcategories($counter)) { ? ? ?$categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue.gif', ''); ? ?} ? ?else { ? ? ?$categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue.gif', ''); ? ?} My question is this- Does anyone know what code I can enter to get JUST the actual subcats displaying with the different arrow? When I changed the else statement it not only stopped the cats without subs to the solid arrow- but the actual subcats as well... I played around with the code a little and apparently I'm an idiot because I can't figure it out! my site is here is anyone wants to look at what the heck i'm talking about.. http://mylipstuff.netfirms.com/retailstore...talog/index.php Thanks a lot!
  15. WHY DO I BOTHER WITH CONTRIBUTIONS!!!!!!!!!!!! I was installing the stupid Product Attributes- Option Type Feature V 1.7 trying to allow customers to type in personalizations. In Step 1 (sigh) Add the following field to table customer_basket_attributes NAME: products_options_value_text TYPE: text NULL: Yes DEFAULT: Null I did that- then got a message that said something like you have an SQL ERROR and listed the above code. I had no idea what to do to fix it so I moved on with Step 2- hoping once the rest of the code was entered things would be fixed. Of course they were not. Now I can't even get into my PHPMYADMIN it keeps giving me this "page cannot be displayed". I assume it's because I screwed something up. Also my store is saying the same thing when I try to go there. Any ideas how to fix this without deleting and redoing the whole ENTIRE thing. Any help would be greatly appreciated. I'd go to this specific contribution help page- but there is no reference to it in the readme files of the download and the search feature here isn't finding that page for me. HELP ME PLEASE! Thanks