Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

blaine109

Members
  • Posts

    176
  • Joined

  • Last visited

Everything posted by blaine109

  1. Jack, I'm not fluent enough in PHP to follow all that is going on in the includes/header_tags.php file. I've tried to figure it but was not successful at figuring it out. I may need to enlist your help on it. I will make a suggestion for you to consider. Since the data that your script is putting out is in HTML you may consider cleaning all the arrays by converting any special character with HTML significance (htmlspecialcharacters) so that it doesn't interfere with the HTML syntax. It would still be nice to have a special characters conversion like you have in your SEO URLs contribution.
  2. Jack, I've looked and didn't see one but was wondering if there was a special character conversion tool for this contribution. I know you have one in your SEO URLS contribution. I sell items that are measured in inches and I use the quotation mark (") in my tags and titles but that seems to prematurely close my keywords, meta, etc. tags. If not, is there somewhere I can hardcode that in to make this conversion: "=>inch Thanks, Blaine
  3. Jack, Does it matter which duplicate I delete?
  4. Jack, When I was having difficulty upgrading this past weekend and made all the changes then reverted them and made them again I ended up running the db update twice. So now in Configuration->HeaderTagsSEO I have all the options listed out twice. Please advise the best course of action to removing the duplicates as each duplicate does have a separate cID. Thanks, Blaine
  5. I figured out my issue. Somehow my install of 2.2RC2a, which is a Fantastico install, had an old MS1 file for includes/boxes/categories.php. I replaced it with a fresh copy with a real 2.2RC2a copy of the file and all is working now.
  6. I am using 3.2.8, I just didn't have the issues till I did the big upgrade to 3.2.7. The lines that the error is point to on line 36 and 43 of categories.php is: if ( ($id) && (in_array($counter, $id)) ) {
  7. Hi Jack, After updating to 3.2.7 I have an error in my categories box but only when you click on a manufacturer in the manufacturers box. Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/****/public_html/includes/boxes/categories.php on line 36 Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/****/public_html/includes/boxes/categories.php on line 43 Those error codes are repeated several times before it starts to display the actual categories. Once again, this only shows up if you click on a manufacturer in the manufacturers box.
  8. Ultimate SEO URL's v2.2d-10 I recently did up a new store with and am replacing an old installation. Because of this, the old product_id's do not match the new ones. I just moved moved the beta site to the main public_html directoy and I put all the redirect url's in the .htaccess file. The problem is that when you type in one of those old URL's or click on it from google it now adds ?products_id=X to the end of the new redirect URL which prompts it to lookup and show the wrong item. For example: Old URL = http://www.customwheelsexpress.com/gear-alloy-20-gear-alloy-718mb-718-blackjack-carbon-black-matte-black-rims-set-of-p-418.html Redirect URL = http://www.customwheelsexpress.com/gear-alloy-718b-718-blackjack-matte-black-custom-rims-wheels-p-55.html If you copy that Old URL into your browser and hit go to it you will see that the new URL on the site is = http://www.customwheelsexpress.com/gear-alloy-718b-718-blackjack-matte-black-custom-rims-wheels-p-55.html?products_id=418 How can I get this redirect to discard the old product_id information and use the one specified in the redirect. Snippet of redirect code in .htaccess file #301 Redirects from Old Store to New Store redirect 301 /chrome-xpressions-16quot-chrome-xpressions-810mb-810-cx11-machined-black-rims-set-of-p-205.html http://www.customwheelsexpress.com/chrome-xpressions-810mb-810-cx11-machined-black-custom-rims-wheels-p-48.html redirect 301 /chrome-xpressions-17quot-chrome-xpressions-810mb-810-cx11-machined-black-rims-set-of-p-206.html http://www.customwheelsexpress.com/chrome-xpressions-810mb-810-cx11-machined-black-custom-rims-wheels-p-48.html redirect 301 /chrome-xpressions-18-chrome-xpressions-810mb-810-cx11-machined-black-rims-set-of-p-207.html http://www.customwheelsexpress.com/chrome-xpressions-810mb-810-cx11-machined-black-custom-rims-wheels-p-48.html Thanks, Blaine
  9. 1064 Error when trying to duplicate a product. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from products_description where products_id = '182'' at line 1 select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, from products_description where products_id = '182' [TEP STOP] I am running Header Tags SEO V 3.2.5 Around line 348 you will find the following code: /*** Begin Header Tags SEO ***/ $description_query = tep_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_head_title_tag']) . "', '" . tep_db_input($description['products_head_desc_tag']) . "', '" . tep_db_input($description['products_head_keywords_tag']) . "', '" . tep_db_input($description['products_url']) . "', '0')"); } /*** End Header Tags SEO ***/ There is an extra comma in the $description_query after products_url that shouldn't be there. Winmerge is a wonderful program!
  10. Figured it out. For those who have the "buySafe" code in their orders.php file please take note that the instructions tell you to copy some code before "include(DIR_WS_CLASSES . 'order.php');" around line 91. There are 2 instances of this in the orders.php file if there is the buySafe code in it. You will want to copy it before the 2nd instance of that code and not in the middle of the buySafe code. Jack, if you would like to clarify this in future instructions all that would need to be changed for that instruction is: Find: include(DIR_WS_CLASSES . 'order.php'); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> Add Before: .................. Thanks, Blaine
  11. Jack, I'm running v1.4 and have noticed that on the orders.php page when you go into admin and click Customers->Orders->Click on an order. On that page it says "Customers #: " It does not display the customers number. It does display it correctly on both the invoice.php and the packingslip.php pages. Any ideas? Here is the code that I have where it query's that info and displays it on that page. /*** BOF: Additional Orders Info ***/ // Look up things in orders if (tep_not_null($oID)) { $the_extra_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'"); $the_extra = tep_db_fetch_array($the_extra_query); $the_customers_id = $the_extra['customers_id']; } else if (isset($_GET['cID'])) { $orders_query_raw = tep_db_query("select o.customers_id, o.orders_id from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_STATUS . " s on ( o.orders_status = s.orders_status_id ) where s.language_id = '" . (int)$languages_id . "' and o.customers_id = '" . (int)$_GET['cID'] . "' order by o.orders_id DESC"); $the_extra = tep_db_fetch_array($orders_query_raw); $the_customers_id = $the_extra['customers_id']; $oID = $the_extra['orders_id']; } else { $orders_query_raw = tep_db_query("select o.customers_id, o.orders_id from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"); $the_extra = tep_db_fetch_array($orders_query_raw); $the_customers_id = $the_extra['customers_id']; $oID = $the_extra['orders_id']; } // Check for other orders $numOtherCompletedOrders = 0; $numOtherOrders = 0; $ttlOtherOrders = 0; $parts = explode(",", SHOW_ORDERS_STATUS_CHECK); $where = " where ( "; for ($i = 0; $i < count($parts); ++$i) { if ($where !== " where ( ") $where .= " or "; $where .= " orders_status_name LIKE '" . strtolower(trim($parts[$i])) . "'"; } $where .= " ) "; $the_extra_query= tep_db_query("select o.orders_id, o.orders_status, ot.text from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where o.orders_id != '" . tep_db_input($oID) . "' and o.customers_id = '" . $the_customers_id . "' and ot.class = 'ot_total'"); while ($the_extra= tep_db_fetch_array($the_extra_query)) { $order_status_query = tep_db_query("select orders_status_id from " . TABLE_ORDERS_STATUS . $where . " and language_id = '" . (int)$languages_id . "'"); while ($orders_status = tep_db_fetch_array($order_status_query)) { if ($the_extra['orders_status'] == $orders_status['orders_status_id']) $numOtherCompletedOrders++; } $numOtherOrders++; $ttlOtherOrders += GetNumber($the_extra['text']); } // Look up things in customers $the_extra_query= tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $the_customers_id . "'"); $the_extra= tep_db_fetch_array($the_extra_query); $the_customers_fax= $the_extra['customers_fax']; $aiPartsPayment = explode(",", SHOW_ORDERS_HIGHLIGHT_PAYMENT); /*** EOF: Additional Orders Info ***/ /*** BOF: Additional Orders Info ***/ ?> <!-- Customers ID# // --> <tr> <td class="main"><b>Customers # </b></td> <td class="main"><?php echo $the_customers_id; ?></td> </tr> <!-- add Order # // --> <tr> <td class="main"><b>Order # </b></td> <td class="main"><?php echo tep_db_input($oID); ?></td> </tr> <!-- add date/time // --> <tr> <td class="main"><b>Date & Time</b></td> <td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td> </tr> <tr> <td class="main"><b>Shipping Method:</b></td> <td class="main"><?php echo tep_get_orders_shipping_method($oID); ?></td> </tr> <?php /*** EOF: Additional Orders Info ***/
  12. You must mean admin/includes/functions/sitemonitor_functions.php
  13. Also, the instruction to change the cron styntax from sitemonitor.php to sitemonitor_0.php refers to a file that is non-existant.
  14. Jack, I installed the update from v2.7 to v2.8 and ran the top upgdate button and got this error in the left column just above "Site Monitor": Notice: Use of undefined constant ENABLE_SSL - assumed 'ENABLE_SSL' in /home/.../catalog/admin/includes/functions/html_output.php on line 24 This error did not appear when I ran the update with v2.7. Thanks, Blaine
  15. Jack, Does your version of this contribution have your "Version Checker" feature? Thanks, Blaine
  16. I sell all three types of conditions on my site (new, used, and refurbished). Is there a way to assign a condition to each product and have the googlefeeder file pull the condition from that? Thanks, Blaine
  17. In the mean time I have implemented a work-around by having PayPal Express redirect customers back to the checkout_shipping.php page instead of the checkout_confirmation.php page so that it regenerates the shipping quote. And since the PayPal token is saved they can click through all the pages in the checkout process without getting redirected to PayPal which preserves the shipping quote and charges the appropriate amount. However, this will probably be confusing to the customer as to why they are having to choose which payment option they wish to use again.
  18. Unfortunately I believe that I have to use PayPal Express Checkout because I am using PayPal Website Payments Pro. Forgive me but I am not fluent in PHP or MySQL but it seems to me that all we need to do is figure out how to get the quote from the previous page (checkout_shipping.php) stored for use by PayPal. It sounds simple but I don't know if you have to regenerate the quote all over again on the checkout_payment.php page. You figure that it has already been generated once and shouldn't need to be generated again but like I said, not fluent in PHP/MySQL. Any help would certainly be appreciated. Thanks, Blaine
  19. Jim, It looks like the only popular PayPal IPN that is out there is for MS2 and I have RC2. How much coding do you think would be involved to make PayPal Express work with MVS? The only thing that it is not doing is transferring the shipping calculations. Thanks, Blaine
  20. Jim, Is it possible that a variable has changed and the PayPal Express module is trying to grab an old variable that is no longer used or has changed? To put it another way...does code need to be changed/modified in the PayPal Express code so that is looks for shipping info with MVS instead of the standard OSCommerce shipping methods? I've also got a thread started in PayPal section but from searching you would think that some other people would be having the same issue but I did not find any. Thanks, Blaine
  21. I am having a problem with the cart not sending the shipping charges to PayPal. On the checkout_shipping.php page it correctly displays the available shipping methods and prices. If the order is completed by paying with a Credit Card on the site itself everything works fine. However, if the customer chooses the PayPal Express option it does not include the shipping. When the customer chooses PayPal Express it takes them to the PayPal login page where they login, choose their funding source, shipping info, etc. and returns them to the checkout_confirmation.php page and the shipping charges are not shown. If the customer finishes the transaction the shipping charges are not included in the payment. Now this is interesting. If i clear the cart and add the item again while still logged in it bypasses the PayPal login page (cause you're still logged in) and it displays the correct shipping charges/method on the checkout_confirmation.php page. Any ideas? Thanks, Blaine
  22. I am having a problem with the cart not sending the shipping charges to PayPal. On the checkout_shipping.php page it correctly displays the available shipping methods and prices. If the order is completed by paying with a Credit Card on the site itself everything works fine. However, if the customer chooses the PayPal Express option it does not include the shipping. When the customer chooses PayPal Express it takes them to the PayPal login page where they login, choose their funding source, shipping info, etc. and returns them to the checkout_confirmation.php page and the shipping charges are gone. Now this is interesting. If i clear the cart and add the item again while still logged in it bypasses the PayPal login page (cause you're still logged in) and it displays the correct shipping charges/method on the checkout_confirmation.php page. I figured this would be a MVS issue as all the shipping methods are prices are now controlled through it.
  23. I created a new Order Status called "Order Sent to Shipper" and set it to send the email when I change the status of the order to that. That way I can review the order, confirm payment, shipping, etc. and then assign the order status to "Order Sent to Shipper" and the email is sent.
  24. Just to let you know if you have Google XML SEO Sitemap contribution installed it has the Configuration Group ID of 289. I simply changed that value in the SQL query to 290 to get around it.
  25. Sounds like one of your language files have not been uploaded to your store.
×
×
  • Create New...