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 [...]
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 [...]
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 [...]
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 [...]