Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

saho

Pioneers
  • Posts

    45
  • Joined

  • Last visited

Posts posted by saho

  1. I'm having the same problem. my database returns 17 as well, but the instructions are not clear. (Then check the total returned, if it's 0 it is not allocated and you can install the default .sql file, otherwise you need to modify it as explained above. ) It doesn't really explain what to do. I've tried changing the $gID in seo_zones_config.php to 0 and to 17, neither of which returns 0.

    What exactly are you supposed to change in the file and what is meant by the SQL file? I ran the seo_g.sql file in phpmyadmin and received no errors.

    The section on the Database Changes is the only section I do not understand. :'(

    I could really use some help.

     

     

    All SELECT count(*) as total FROM configuration WHERE configuration_group_id=24 does is return the number of configuration_group_id entries. Looking back at that posting enigma was wondering if that person had made the proper entries into the admin/includes/database_tables.php

     

    //-MS- SEO-G Added
     define('TABLE_SEO_URL', 'seo_url');
     define('TABLE_SEO_REDIRECT', 'seo_redirect');
     define('TABLE_SEO_EXCLUDE', 'seo_exclude');
     define('TABLE_SEO_FREQUENCY', 'seo_frequency');
     define('TABLE_SEO_TYPES', 'seo_types');
     define('TABLE_SEO_TO_CATEGORIES','seo_to_categories');
     define('TABLE_SEO_TO_PRODUCTS','seo_to_products');
     define('TABLE_SEO_TO_MANUFACTURERS','seo_to_manufacturers');
    //-MS- SEO-G Added EOM
    
    //-MS- SEO-G Support for Articles Manager
     define('TABLE_SEO_TO_TOPICS','seo_to_topics');
     define('TABLE_SEO_TO_ARTICLES','seo_to_articles');
     define('TABLE_SEO_TO_AUTHORS','seo_to_authors');
    //-MS- SEO-G Support for Articles Manager EOM
    
    //-MS- SEO-G Support for Information Pages Unlimited
     define('TABLE_SEO_TO_INFORMATION','seo_to_information');
    //-MS- SEO-G Support for Information Pages Unlimited EOM
    
    //-MS- SEO-G Support for Links Manager
     define('TABLE_SEO_TO_LINKS','seo_to_links');
    //-MS- SEO-G Support for Links Manager EOM

  2. I am having a bit of trouble. I tested this mod extensively on a test server at the same host I use for my production server.

     

    Test Server works perfectly:

    I have .htaccess file set up correctly where the store is in a folder called live. All admin root ssl pages and admin ssl pages work correctly.

    #-MS- SEO-G Added

    Options +FollowSymLinks

    RewriteEngine On

    # Next line must be changed to match your osCommerce folder

    RewriteBase /live/

    RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING}

    #-MS- SEO-G Added EOM

     

    Production Server:

    All ssl pages at the site root are working fine but all admin ssl pages resolve at cookies_usage.php

    #-MS- SEO-G Added

    Options +FollowSymLinks

    RewriteEngine On

    # Next line must be changed to match your folder

    RewriteBase /

    RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING}

    #-MS- SEO-G Added EOM

     

    As I said all the code is the same, all the settings are the same. There are only two differences. The test site is in a folder/ and it is on a different server but at the same host.

    Does anyone have any idea what may be going on? I would appreciate any leads.

  3. I am having a bit of trouble. I tested this mod extensively on a test server at the same host I use for my production server.

     

    Test Server works perfectly:

    I have .htaccess file set up correctly where the store is in a folder called live. All admin root ssl pages and admin ssl pages work correctly.

    #-MS- SEO-G Added

    Options +FollowSymLinks

    RewriteEngine On

    # Next line must be changed to match your osCommerce folder

    RewriteBase /live/

    RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING}

    #-MS- SEO-G Added EOM

     

    Production Server:

    All ssl pages at the site root are working fine but all admin ssl pages resolve at cookies_usage.php

    #-MS- SEO-G Added

    Options +FollowSymLinks

    RewriteEngine On

    # Next line must be changed to match your folder

    RewriteBase /

    RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING}

    #-MS- SEO-G Added EOM

     

    As I said all the code is the same, all the settings are the same. There are only two differences. The test site is in a folder/ and it is on a different server but at the same host.

    Does anyone have any idea what may be going on? I would appreciate any leads.

  4. Has anyone written or seen an integration of mailchimp into oscommerce. Mailchimp is an email newsletter site (one of the best) they have an API that would allow people to sign up. Could be written into an infobox as well as the create an account page which would allow automated addition to your list through mailchimps API.

  5. I found the answer here:

    http://www.oscommerce.com/forums/index.php?showtopic=199498&hl=

     

    replace the $featured_products_query in catalog/includes/modules/featured.php to make it work with mysql 5

     

     

    $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);

  6. I tried to use the featured products contribution and I ran into a couple of problems. The first I was able to find a topic discussing the fix for it, however once I applied the fix I got another error that said something to the effect of invalid table in statement p.product_id in the on clause. I am new to php and so I started poking around on the net for a solution. I found an article on this forum that talked about this problem being related to older versions of oscommerce running on mysql 5. I have the latest release of oscommerce, but my server is using mysql 5. I am thinking that the offending query in the featured.php file is written using the same syntax that causes problems with mysql 5, but being that I am very new to php I can't figure out how to change it. If anyone could help me out here that would be great.

     

     

    I am having the exact same problem it has to do with mysql 5.0

     

    MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode.

     

    Due to this new setting, MySQL fails on certain SQL queries and produces error messages on the screen.

     

    The error is in catalog/includes/modules/featured.php somewhere in this string:

     

    $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, products_retail_price, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in (" . $featured_products_category_id_list . ") and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);

     

    If anyone can help rewrite this I am sure we would all appreciate it. If you need a guide there are similar strings that had to be rewritten, check here.

     

    http://www.oscommerce.com/ext/update-20051...l#_Toc119473689

  7. For quite sometime I have been using xml tracking 2.0 and I loved it. One day it stopped working. My question is can I reprogram it to point to the UPS.com tracking page

    Example: Rather than http://mystore.com/catalog/tracking.php?tracknum=etc. to my customers when I update to shipped could I send them to:

     

    http://wwwapps.ups.com/etracking/tracking....A650R6034156????

     

    Below I have the original code in the package and below that is my best guess at sending them to the new url.

    Could someone take a look at it and suggest if it would work.

    Thank you in advance for looking at this, I really appreciate it, at the moment tracking is not working.

     

    I am using a June 2002 snapshot with ups xml tracking version2

     

    --------------------------------------------------------------------

     

    $customer_notified = '0';

    if ($HTTP_POST_VARS['notify'] == 'on' & $ups_track_num == '' ) {

    $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

    tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

    $customer_notified = '1';

    }elseif ($HTTP_POST_VARS['notify'] == 'on' & tep_not_null($ups_track_num) ) {

    $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . EMAIL_TEXT_TRACKING_NUMBER . ' ' . tep_catalog_href_link(FILENAME_CATALOG_TRACKING_NUMBER, 'action=track&tracknum=' . $ups_track_num, 'NONSSL') . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

    tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

    $customer_notified = '1';

    }

    ----------------------------------------------------------------------

    Changed code

    ----------------------------------------------------------------------

     

    Can I replace with this:

     

    $customer_notified = '0';

    if ($HTTP_POST_VARS['notify'] == 'on' & $ups_track_num == '' ) {

    $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

    tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

    $customer_notified = '1';

    }elseif ($HTTP_POST_VARS['notify'] == 'on' & tep_not_null($ups_track_num) ) {

    $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . EMAIL_TEXT_TRACKING_NUMBER . ' ' . 'http://wwwapps.ups.com/etracking/tracking.cgi?tracknum=' . $ups_track_num, 'NONSSL') . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

    tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

    $customer_notified = '1';

    }

     

    ------------------------------------------------------------------------

     

    Thank you

×
×
  • Create New...