Until I bought my BMW 5 series I heard that BMW drivers were generally regarded is tossers. So after I bought it and found this out I began to drive as a tosser cause it was expected of me.
Today however I and an other BMW driver were possibly started to change that perception as we both let other vehicles out into a busy roundabout.
So, I needed a VPN and my router did not support the creation of an incomming VPN connection. So I started digging around for VPN software and I stumbled upon www.logmein.com. Here they have a free to use VPN software called Hamachi it enables secure remote access to your network, anywhere there’s an Internet connection. I Think its pretty cool.
I tend to have to move one SQL database to an other SQL server. With this I alway forget about the table owners so I have to use the sp.changeobjectowner.
In 2000 it seemed fairley straight forward and I was able to do it, but in SQL 2005 I was struggleing, but really it is easy.
sp_changeobjectowner '[oldowner].[tabe1]', 'newowner'
go
I downloaded PayPal WPP Uk from paypal and installed
Got the error
Invalid vendor account
After uninstalling ect I final got round to emailing paypal to find out that even in test mode my account was not set up correctly.
Once that was sorted I then porceeded to test and got the next error
Field format error: 10744
This is an invalid country code. With a bit of a hack I was able to get passed that to then get the following error
Field format error: 10711
and then
Field format error: 10710
Which are invalid state and city.
Its draggin on a bit now so lets cut to the chase.
in paypal_wpp_uk.php at line 375 I have inserted
‘COUNTRY’ => $order->billing['country']['id'],
‘STATE’ => $order->billing['state'],
‘CITY’ =>$order->billing['city'],
which now brings me to a new error message of 10501, which basically means my account is not setup correctly, so I am having to wait again on PayPal to get back to me.
Hope this helps as I have been….. Well lets just say i am glad its comming to an end. 
If like me you used the first UK Zones contribution, your addresses will be showing a short code for the county of that address.
There are two ways around this.
- Use a more uptodate contribution
- Alter the code in general.php
in includes/functions/general.php
around line 524 change
CODE
$state = tep_get_zone_code($address['country_id'], $address['zone_id'], $state);
to
CODE
$state = tep_get_zone_name($address['country_id'], $address['zone_id'], $state);
Firstly when you start using OScommerce you will tend to find that its very American Based. With that in mind you have to enter all the Counties in the UK.
There are a number of contributions out there, but after digging around you might want to use this one here
This one removes the need to change the code in the general.php to show the county Zone_name rather that zone_code as the zone_code has been changed to be the name.
INSERT INTO zones (zone_country_id,zone_code,zone_name) VALUES("222","Cambridgeshire","England - Cambridgeshire");
instead of
INSERT INTO zones (zone_id, zone_country_id,zone_code,zone_name) VALUES('',222,'ALD','Alderney');
I have had a couple of Oscommerce sites before, but I have never really took them any further than the loaded version that I downloaded.
Now that I am, and I will use the term loosely ‘Developing’ my oscommerce I really need to capture all the little bits of code and alterations that I make.
No doubt that if I get the hang of this blogging lark, it will become more than just oscommerce.