Latest News: (loading..)

Rachael w.

  • Content count

  • Joined

  • Last visited

About Rachael w.

  • Rank
  • Birthday March 1

Profile Information

  • Real Name
  • Gender
  • Location
  1. I've tried the fixes mentioned here and I still can't get rid of the error: Number field should not be quoted: 'ecomm_totalvalue' When I try either of the fixes the page shows no tags. With the original code it's just the error. Anyone still working on this?
  2. Have you created a separate thread for this? I'm still working migrating to the most recent version of oscommerce and I have the old version with a footer.php called on the pages. I can't seem to get this to work right. I'm not getting errors, I'm just not seeing anything google on the page. Thank you for your help. Please respond with a link to your thread so we don't highjack the merchant feed thread. :)
  3. Thank you so much Jack! I apologize for returning so late to respond. Your code DID WORK (the first suggestion)! I appreciate your dedication.
  4. I finally figured it out! I turned on the error reporting in the application top. I had the old googlecheckout payment option. I had deleted the google checkout file which threw an error when it was trying to find it as a payment method.
  5. I have this same issue. Were you able to fix it? Do you remember how you did it?
  6. I had to update my server since on of my sites was getting hacked pretty regularly (not an osc site). Now the order editor is giving me problems. It seems to be ending the page right after the address information. The payment method column titles are there but nothing after it. I'm not getting any errors in my log so I'm not quite sure of the actual problem. Here is the part that starts with the payment information: 'payment_method' => tep_db_input(tep_db_prepare_input($_POST['update_info_payment_method'])), 'currency' => tep_db_input(tep_db_prepare_input($_POST['update_info_payment_currency'])), 'currency_value' => tep_db_input(tep_db_prepare_input($currency_value['value'])), 'cc_type' => tep_db_prepare_input($_POST['update_info_cc_type']), 'cc_owner' => tep_db_prepare_input($_POST['update_info_cc_owner']), 'cc_number' => tep_db_input(tep_db_prepare_input($_POST['update_info_cc_number'])), 'cc_expires' => tep_db_prepare_input($_POST['update_info_cc_expires']), 'last_modified' => 'now()'); tep_db_perform(TABLE_ORDERS, $sql_data_array, 'update', 'orders_id = \'' . tep_db_input($oID) . '\''); $order_updated = true; Any ideas on what I need to change here to get the rest of the page to load?
  7. I have the most recent code: GoogleBase V 3.5. The only difference I see is the mysqli. Whether I have it as mysql or mysqli it still doesn't produce products.
  8. I had to do some upgrades on my server, now using php 5.4. Not sure if this is the reason but my feed is not returning any products (0). The column headers are created but there are no products in the feed. I am not getting any errors either. Here is the page after running the script: Any help would be greatly appreciated. The file did work correctly prior to the php upgrade.
  9. I installed an update on my server (damn pci compliance stuff) and it truncated every description in my store. I didn't notice until weeks after (since I had a heck of a time updating all the code to make the site function properly) and my backup from the previous month backed up the truncated description. Our products are pretty much the same in every category so writing over every product is the best route. I only have one category where their descriptions vary and I plan to update those individually through the admin. We have over 150,000 products on our site. Updating via sql is the quickest and easiest way to go. Our individual product pages have their own individual titles and we have those included in the description area (along with their manufacturers, etc.) so it will create descriptions which have some individual information. SEO hasn't been a problem for these since we have a very niche product catalog. Thank you bruyndoncx, I'll try that on my test site. Edited to add: I thought about Easy Populate over the past years. This site is a beast, even trying to open the sql file locally takes forever and editing it is horrible. Just this category has over 50,000 products. Another has 60,000 and others vary from 100 to 10,000. I'm still amazed the site works at all.
  10. I am looking to update my product_descriptions based on the category via phpmyadmin sql query. Example: Category: Carrots Product: Yellow Carrots Product Description: These are purple carrots. What I want to do is change the Product Description for the Yellow Carrot Product in the Carrot Category. Which would show this after: Category: Carrots Product: Yellow Carrots Product Description: These are yellow carrots. I've started it but got lost. I am writing over the current description with the new one. Here is what I have so far and I know I need more. I don't know how to write it so it compares the product_id in products_description to the product_id in products_to_categories then only changes the products_description on products in the category_id 32. Thank you in advance for your help.
  11. Yes, I upgraded the server to php 5.6. I've been going through the pages. Most of my issues were with the post, get, cookie and ereg's. I think I've found them all. I have been watching the error reports and no errors are coming up for that page.
  12. I just uninstalled it. I think I was so outdated it wasn't helping much anyway. But... while I have your attention could I hit you up for assistance in another matter? I am having an issue where the shipping is not being included in the order total in checkout_confirmation.php. The order total seems to be working properly. If I put it in the cart it shows the subtotal, tax, shipping and total just as it should. The checkout_shipping has the correct rate. So, as you move through checkout everything is fine. Once you hit the confirmation the shipping disappears. Orders are placed with no shipping included. I am using a table rate, haven't changed any of that in any way. Thank you for helping me out. I spent hours trying to figure this out with no luck.
  13. I guess I asked this question too soon. I pulled the new html_output.php and sessions.php from the files. Changed the $_GET, $_POST, and $_COOKIE and it appears to be working. Now onto the next error.
  14. I had to update my php on the server for pci compliance. Now the admin is giving me fits. I have two problems at the moment. First is this error: I did see there was another post about this but it was from 2007. I was wondering if there is a more recent secure fix. The second problem I am having is that somehow the admin is putting too many directories in the url. This is in all the pages in the admin, not just the orders. I haven't made any changes to configure.php so I am not sure where this is coming from. I am assuming it might be an array in the html_output.php but I haven't found it, nor am I sure I'm looking in the right place. Thank you in advance for your help.
  15. I fixed all you noted here and no improvement. Still getting the error. I give up. Just removed the whole rss thing.