Jump to content


Member Since 22 Mar 2013
OFFLINE Last Active Apr 12 2017 14:40

Topics I've Started

Will older versions of PayFlow Direct Payments continue to work after May 31?

05 April 2017 - 11:26

I have been upgrading one of my stores on a Centos 5 website  from 2.3.3 to 2.3.4. It has been a slog. I've had to upgrade PHP, CURL and OpenSSL so that my website would be TLS 1.2 compliant.  Along the way, I noticed a major change in the PayPal Payflow Payments modules, beginning with Version 3.0  which comes installed with OsCommerce 2.3.4:

  • Older Versions. The PayFlow module (and the check-out window) gets a token from PayPal which it uses to set up a window into the PayPal website. Customers enter credit card numbers on PayPal's website, not on our website, using that window.
  • Versions 3.0 and 3.1. Credit card numbers are collected on our website and passed to PayPal through a secure connection which will have to be TLS 1.2 compliant starting on June 1.

Will the earlier versions of the PayFlow Direct Payments module also have to be TLS 1.2 complaint after May 31? I have another store, on a different Centos 5 website, that I'm hoping will continue to work with PayFlow after May 31.

How I upgraded my database from 2.3.3 to 2.3.4

24 March 2017 - 16:08

I decided to switch my OSCommerce 2.3.3 store to a different URL. Instead of using 2.3.3 again in the new site, I decided to use 2.3.4 (the official version, not the Responsive/BootStrap version).


1. I installed my 2.3.4 store on my new URL. (Recommendation: don't change your username and password from those in your old store, since they are stored in the database.) In order to complete that installation, I used MySQL to created a new database which I called oscommerce234.


2. I logged into the admin of my 2.3.3 store and created a backup of my old database. Then I used FTP to download it to my home computer. Then I renamed it as backup233.sql and I used FTP to upload it to the backup directory (oscommerce-2.3.4/catalog/admin/backups) of my new store.


3. I downloaded the add-on which provides a .sql file for upgrading databases from 2.2MS2 to 2.3.3 (http://addons.oscommerce.com/info/8731).  It has been kept current and now includes the codes for upgrading from 2.3.3 to 2.3.4. (It does not, however, include the commands for upgrading to 2.3.4 Responsive/BootStrap.)


4. On my home computer I edited that upgrade file using my text editor (Notepad++). I only kept the commands for moving from 2.3.3 to 2.3.4. Then I saved the file with the name 233_to_234.sql and uploaded it using FTP to the backup directory (oscommerce-2.3.4/catalog/admin/backups) of my new store.  Here are the comments (lines that start with #) and commands that were in that file:



#2.3.4 SQL


#Increase column size

alter table sessions modify sesskey varchar(128) not null;

#Adds "Administration Tool -> Configuration -> Shipping/Packaging -> Allow Orders Not Matching Defined Shipping Zones"

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Allow Orders Not Matching Defined Shipping Zones ', 'SHIPPING_ALLOW_UNDEFINED_ZONES', 'False', 'Should orders be allowed to shipping addresses not matching defined shipping module shipping zones?', '7', '5', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now());


5. Then I used Putty to log into the website of my new store. I logged into MySQL. Then at the MySQL prompts (mysql>) I created a new database which I called oscommerce233 and then I upgraded it by uploaded my backup233.sql file into it and then my 233_to_234.sql file into it. (Note that /var/www/html is the absolute path to my oscommerce-2.3.4 store; your absolute path will be different.)


mysql> CREATE DATABASE oscommerce233;

mysql> use oscommerce233;
mysql> source /var/www/html/oscommerce-2.3.4/catalog/admin/backups/backup233.sql;
mysql> source /var/www/html/oscommerce-2.3.4/catalog/admin/backups/233_to_234.sql;
mysql> quit;


6. Then I used FTP to download the two configure.php files (catalog/includes/configure.php and catalog/admin/includes/configure.php). I edited each of them using my text editor (notepad++) changing database references from oscommerce234 to oscommerce233. Then I uploaded both configure.php files back to the website. As a result, the following statement now appears in those configuration files:


define('DB_DATABASE', 'oscommerce233');


That's all there was to it. It seems that everything is working, but I won't know for sure until I get my store operational. If this doesn't work out, I can change the database references in those configuration files back to the way they were before (oscommerce234 instead of oscommerce233), and I'll be using the oscommerce234 database that was created when first setting up the oscommerce 2.3.4 store.

New Payflow requirement: TLS 1.2 & HTTP/1.1

20 March 2017 - 12:58

I just got a notice from PayPal that, starting in June 2017, versions older than TLS 1.2 and HTTP/1.1 will not be able to communicate with Payflow.  Are we covered in Version 2.3.4?  How about my stores that still run 2.3.3 - will I need to upgrade to 2.3.4 before June?