February 15th, 2015
I’ve just been reviving my ubuntu (linux) server on the LAN to do some interface development and testing, and thought it would be easier to work if I had remote access to the MySQL databases to use something a little more productive than phpMyAdmin.
Poof! What a palaver! All up and running now, but time to make some notes in case I ever have to do this again. In case it matters, it’s the long term support LTS version of Ubuntu 12.04 (purple pangolin IIRC).
Anyhow, the default install of a LAMP server (linux/apache/mysql/php) doesn’t allow remote access, so you have to set it up.
The original error was
SQL Error (2003): Can't connect to MySQL server on hostname (10061)
Read the rest of this entry »
February 9th, 2013
Recently released: interface between osC 2.2 and Quickbooks using QBWC
This is a complex & rich implementation, which linked an existing online catalogue & customers with existing inventory and customers in Quickbooks, which is used to record high-street shop customers and transactions. Ongoing functionality keeps stock levels in sync and feeds online transactions and customers to QB.
As well as semi-automated take-on, there’s flexible matching support that makes it straightforward to link the two inventories – no automated product/item creation.
The Quickbooks Web Connector (QBWC, available free from Intuit) runs on a pc alongside the desktop versions of Quickbooks, and communicates with a SOAP server based on ConsoliByte’s PHP integration framework. This was developed to implement the necessary calls, plus a transaction manager within osC to group together the several interface calls needed to support a shop transaction. The main constraint is that QBWC requires SSL (but then, so does a fully integrated implementation of Googlecheckout/Google Wallet).
I expect to begin a simpler QB interface implementation for another site, based on osCommerce 2.3.1
October 4th, 2012
Copying a site from cpanel hosting to cloud hosting… contact page uses cgiemail to send the message.
Testing the contact page (using the domain alias before changing the nameservers) fails with a not found error on accessing the script and include file.
Trying to access the mail script without the following bit of the path attempts to download the file instead of run it, so it appears to be a web server config problem.
Try adding a handler in a .htaccess file in the cgi-bin directory:
Following that, if you get an Internal Server Error (500), try setting the file permissions to 755.
August 5th, 2012
Recently I’ve been setting up a test server within the LAN (to be able to use Quickbooks Web Connector without an SSL licence) and have had to resolve several errors relating to setting up a copy of an osCommerce 2.2 store.
Some issues relating to .htaccess files:
- these are used particularly in shared hosting to set specific system options that you might better set as server options on your own server
- a new LAMP installation typically defaults to not processing .htaccess files, so they are ignored
- when copying a store with URL rewriting enabled, the page links within the store are set to the rewritten URLs, but the server rewriting rules for the store are contained in the .htaccess file in the catalog directory and being ignored by default
- enabling the .htaccess files causes both the catalog and admin sides of the store to fail with Internal Error 500s
- the catalog side fails because other default server settings do not allow the .htaccess files to override server settings so you have to set AllowOverride to On for the URL rewriting
- the admin side fails because the password protection settings for the directory refer to paths and files on the old server
July 5th, 2012
TotalHealthNow is a familyrun alternative health business. The web site contains background information on therapies as well as offering products and mailing list subscription. Future plans include e-commerce.
The layout design expands to fill the full browser width and is optimised for search engines so that the different central content of individual pages is contained nearer the top of the html irrespective of the column layout.
Visit the site and see for yourself: www.totalhealthnow.co.uk
April 18th, 2011
Actually, this is rather old news – it was released back in October 2010!
The site is an e-commerce site based on osCommerce, with a lot of add-ons and a certain amount of bespoke development, including postcode-based shipping calculations. The catalogue was initially seeded by taking on data from an ms-access database.
It’s currently hosted at www.cheapcablesonline.co.uk but may be relocated to a sub-directory of the main company site (www.clubtek.co.uk) at a later date.
April 18th, 2011
Now, just to be clear, I can’t claim much credit for this. It’s a huge add-on developed by lots of people including Jan Zonjee.
All I’ve done is to apply all the specified changes to a 2.3.1 store instead of 2.2, do some testing and bug fixing, and upload the results. I’m also keeping a store online with it implemented (at least for now) and following the thread so I can support any 2.3.1-specific problems.
You can download it from osCommerce Add-ons and get help in the support forum.
April 18th, 2011
There might be thousands of existing add-ons for osCommerce 2.2, and it’s even true that many of them work on 2.3.1, but sometimes there isn’t what you need and you have to get on and do it yourself… so I did.
Initially aimed at converting an already-installed store (eg. from cpanel / Fantastico etc), this add-on has been extended so that you can overwrite the downloaded osc install and then run it in one step.
It basically converts the installed store and sample data from being US-based to UK-based, including date format, currency, address format. It sets up a European tax zone, changes ‘state’ to ‘county’ and leaves this free-text.
If you might need it, you can get it at osCommerce addons and see what it looks like in my development store. If you’ve got questions about it, please use the support forum, unless you want to ask me for paid help in implementing it, in which case get in touch directly.
April 18th, 2011
I now have an osCommerce 2.3.1 store set up, so if you want to see what it looks like, go to http://neo-lasers.co.uk/shop-23/ which hasn’t had any changes to the delivered template (at least, not so far) but has a couple of add-ons loaded that configure the appearance.
May 4th, 2010
Just set up a couple of osCommerce installations, initially to investigate the different behaviours of the two add-ons PWA (Purchase without account) and Checkout Redux, which streamlines things but seems to have a bug or two. Checkout Redux is on shop one while the other store started with PWA and is now getting other stuff on top, towards a suggested initial package for most stores. The front page should carry a current list of add-ons here.