Jump to content


  • Content count

  • Joined

  • Last visited

  1. dmayo2

    Multiple Newsletters contribution

    Just an FYI. I was having a problem getting the create_account to insert the subscribed newsletters to be saved when someone was creating an account. I followed the above to no apparent avail. However I have the Simple Registration contrib installed. Here's the solution: in /catalog/create_account.php somewhere around line 270 where if (SIMPLE_REGISTRATION == 'off') { $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_newsletter' => $myLetters->selected, 'customers_password' => tep_encrypt_password($password)); the change to the 'customers_newsletter' => input to $myLetters->selected works fine Since this multi-newsletter contrib had you insert the code to show the available newsletters, which the newsletter is not a typical part of Simple_Registration, it seems that it now is. So, in the code above, you have to go to the ELSE part of the statement and add the newsletters to the sql statement like: } else { $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_newsletter' => $myLetters->selected, 'customers_password' => tep_encrypt_password($password)); that solves it.
  2. Cool. Try to narrow it down. In application_top.php just add the first line require(DIR_WS_CLASSES . 'supertracker.php'); then save the file and see if you are having the same problem with a blank index page (if the index page is blank, what about an interior page like /contact_us.php ???).
  3. DELETE from supertracker ORDER by tracking_id ASC LIMIT Seems as if this issue hasn't been solved yet. I too am experiencing this issue, and as indicated it has to do with the version of mysql that is being used. From the mysql documentation: ORDER BY can be used with DELETE beginning with MySQL 4.0.0. I'm using mysql ver 3.23.x so the delete code in Supertracker: DELETE from supertracker ORDER by tracking_id ASC LIMIT " . $rows_to_delete; won't work. SOLUTION: We could figure out what the lowest tracker_id numbers are and start to delete based on those. However, if you use this code instead: DELETE from supertracker limit ".$rows_to_delete; This works for me, as it did delete the lowest numbered row (when I had $rows_to_delete = 1). QUESTION: Since tracker_id is the primary key in the table, if you don't give the query an ORDER BY, won't it default to ordering by the primary key in the ASC order? If this is true, then the above suggested code should work just fine. Question remains... will the table ever be ordered by some other column?
  4. dmayo2

    Country-State Selector

    Jas. I'm using the ajax ver 1.5.5 and it is working well for me. I installed it fresh with a new install of osC, so I couldn't tell you how to upgrade specifically. However, if you follow the 1.4x install directions backwards (and if you left the original code in the source files (which not all contribs have you do), then it should be fairly straight forward to undo your install of 1.4x. Then you could install 1.5x "fresh". I also had some of the same type of issue as you (although the entire page doesn't reload with ajax version), and found it best to rearrange the form so that country comes first -- I know it's kinda' odd for those of us in the US to have that field before the city and/or state (not to mention having that field at all). It is important, imho, that there is a "please select country" option in the country dropdown so that the form won't submit unless a country has been chosen. That is why I trimmed the available countries down from the 140+ to just two -- US and Canada (I put up a contrib for doing this). I know that that is a bit centric of me, but I realize that 99.999999% of my sales come from those two countries, and if there's someone from another country, they end up emailing me. Good luck.
  5. dmayo2

    AJAX Attribute Manager support

    array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in /admin/includes/functions/sessions.php on line 123 Just putting this fix in an easy place to find all associated fixes. I'm not the author of these, just the (re)publisher. open file catalog/admin/includes/functions/sessions.php line 123 find: return array_key_exists($variable, $_SESSION); and replace with: return isset($_SESSION[$variable]); Once I did that, I started getting the warning: Session not registered - You cant access this page directly To fix that, open catalog/admin/attributeManager/attributeManager.php go to line 56: stopDirectAccess::checkAuthorisation(AM_SESSION_VALID_INCLUDE); and comment it out. That brings the attribute manager onto the product page in admin. For what it's worth
  6. dmayo2

    Country-State Selector

    I only wanted to show US and Canada in my country drop down, so there were two options. A). go into the database and delete all those countries that I didn't want. But if I decided to add one of those deleted countries back, I'd be hard pressed to remember the values associated with the records. I opted for method B)... I added a column to the table of countries labeled 'active' and set the default to zero. Then I updated the table to set active=1 for those countries I wanted to show. Then in file /catalog/includes/functions/general.php I altered the query to get only those countries where active=1. I did not build an interface for the admin, but the full instructions can be found on the contribution page: http://addons.oscommerce.com/info/2028 -- dmayo
  7. dmayo2

    Header Tags SEO

    Ok, I found where some of the changes that need to take place to solve my problem http://forums.oscommerce.com/index.php?s=&...t&p=1264339 I'm putting the instructions here, as I still can't find where this is stated in any instructions change these two files: catalog/admin/includes/database_tables.php catalog/includes/database_tables.php Add this code snippet to the bottom: /*** Begin Header Tags SEO ***/ define('TABLE_HEADERTAGS', 'headertags'); define('TABLE_HEADERTAGS_DEFAULT', 'headertags_default'); /*** End Header Tags SEO ***/
  8. dmayo2

    Header Tags SEO

    I'm having the same issue 1146 - Table 'mydbname.TABLE_HEADERTAGS_DEFAULT' doesn't exist select * from TABLE_HEADERTAGS_DEFAULT where language_id = '1' [TEP STOP] except that it's on all pages that I added this to: FIND: <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> REPLACE with: <?php /*** Begin Header Tags SEO ***/ if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } /*** End Header Tags SEO ***/ ?> Installing HeaderTags_SEO_V_3.0.4_1_2 I don't see any instructions that mention changes to database.php file. I installed the database changes via the headertags_seo_install.php file. Thanks.
  9. I too noticed this while doing the manual install. Go with your gut...the instructions are wrong. Also keep reading this post as doing the manual install, the text is disappearing if you update the cart (at least mine is).