technophobe

Thanks, i kind of figured that out about 30 minutes after i posted this and have now installed the form version you mention. I have it working now, but will take your advise and investigate the server version.

I have just installed the SagePay Form Payment Module V1.20.2 and when i click on the confirm order button is get the following error. Firefox can't find the file at https://test.sagepay.com/vps2form/submit.asp. The re direct is not there. I have searched on here and cant see anyone else with this problem. I uploaded the files to the correct place on my server and installed the payment module as suggested in the installation instructins, and that seems very easy so not sure what is going on.

Thanks, that worked.

Thanks now removed that command and get the following error. #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `configuration_group` (`configuration_group_id`, `c I know this relates to the ID number as pointed out in the warning, but i have changed the ID many times and still get the error. How do you find the next id in PHPmyadmin?

I have tried to install the SQL, and i get the following error. #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 11 Can anyone help? Looks like a great contribution by the way.

Thanks, I have enabled the logging and had a look at the log and this is an example of a test i did. I also had the insurance enabled before, so have disabled this now. The package is about 0.5KG, but UP rounds this up to 1KG, and this seems to be sent to UPS and returned as 1KG, but the price returned from UPS, is actually higher than the published rates. I did see this in the log "<RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning>" Any ideas? ------------------------------------------ DATE AND TIME: 2009-08-25 19:14:12 UPS URL: https://www.ups.com:443/ups.app/xml/Rate UPS REQUEST: <?xml version="1.0"?> <AccessRequest xml:lang="en-US"> <AccessLicenseNumber>##################</AccessLicenseNumber> <UserId>######</UserId> <Password>######</Password> </AccessRequest> <?xml version="1.0"?> <RatingServiceSelectionRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Rating and Service</CustomerContext> <XpciVersion>1.0001</XpciVersion> </TransactionReference> <RequestAction>Rate</RequestAction> <RequestOption>shop</RequestOption> </Request> <Shipment> <Shipper> <ShipperNumber>######</ShipperNumber> <Address> <City>Poole</City> <StateProvinceCode>DORS</StateProvinceCode> <CountryCode>GB</CountryCode> <PostalCode>BH153TB</PostalCode> </Address> </Shipper> <ShipTo> <Address> <City>Bournemouth</City> <StateProvinceCode>DORS</StateProvinceCode> <CountryCode>GB</CountryCode> <PostalCode>BH88JY</PostalCode> <ResidentialAddressIndicator/> </Address> </ShipTo> <Package> <PackagingType> <Code>02</Code> </PackagingType> <PackageWeight> <UnitOfMeasurement> <Code>KGS</Code> </UnitOfMeasurement> <Weight>1</Weight> </PackageWeight> </Package> <RateInformation> <NegotiatedRatesIndicator/> </RateInformation> </Shipment> </RatingServiceSelectionRequest> UPS RESPONSE: <?xml version="1.0"?> <RatingServiceSelectionResponse><Response><TransactionReference><CustomerContext>Rating and Service</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</ResponseStatusDescription></Response><RatedShipment><Service><Code>11</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>KGS</Code></UnitOfMeasurement><Weight>1.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>20.03</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>20.03</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery/><ScheduledDeliveryTime/><RatedPackage><TransportationCharges><CurrencyCode/><MonetaryValue/></TransportationCharges><ServiceOptionsCharges><CurrencyCode/><MonetaryValue/></ServiceOptionsCharges><TotalCharges><CurrencyCode/><MonetaryValue/></TotalCharges><Weight>1.0</Weight><BillingWeight><UnitOfMeasurement><Code/></UnitOfMeasurement><Weight/></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>65</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>KGS</Code></UnitOfMeasurement><Weight>1.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>38.59</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>38.59</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>1</GuaranteedDaysToDelivery><ScheduledDeliveryTime>11:30 P.M.</ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode/><MonetaryValue/></TransportationCharges><ServiceOptionsCharges><CurrencyCode/><MonetaryValue/></ServiceOptionsCharges><TotalCharges><CurrencyCode/><MonetaryValue/></TotalCharges><Weight>1.0</Weight><BillingWeight><UnitOfMeasurement><Code/></UnitOfMeasurement><Weight/></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>54</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>KGS</Code></UnitOfMeasurement><Weight>1.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>67.44</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>67.44</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>1</GuaranteedDaysToDelivery><ScheduledDeliveryTime>9:00 A.M.</ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode/><MonetaryValue/></TransportationCharges><ServiceOptionsCharges><CurrencyCode/><MonetaryValue/></ServiceOptionsCharges><TotalCharges><CurrencyCode/><MonetaryValue/></TotalCharges><Weight>1.0</Weight><BillingWeight><UnitOfMeasurement><Code/></UnitOfMeasurement><Weight/></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>07</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>KGS</Code></UnitOfMeasurement><Weight>1.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>39.32</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>GBP</CurrencyCode><MonetaryValue>39.32</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>1</GuaranteedDaysToDelivery><ScheduledDeliveryTime>12:00 Noon</ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode/><MonetaryValue/></TransportationCharges><ServiceOptionsCharges><CurrencyCode/><MonetaryValue/></ServiceOptionsCharges><TotalCharges><CurrencyCode/><MonetaryValue/></TotalCharges><Weight>1.0</Weight><BillingWeight><UnitOfMeasurement><Code/></UnitOfMeasurement><Weight/></BillingWeight></RatedPackage></RatedShipment></RatingServiceSelectionResponse>

I found out from UPS, that they update their system on a sunday, so it can take up to a week for your rates to appear, but my rates are still not showing after two weeks. The rate that is coming up, is also not correct for the published rate. As an example, 40KG from the UK, Hamel, MN 55340 in the United States is published as £174.85 (UPS Expedited), but it is coming up as £141.62. Our cost is £87.43. Also, when i change it in admin to give 70% discount the cost for expedited goes up to 202.31. All very strange. This is the first time i installed this contribution, so no updating was done, and all i did was upload the reuqested files, updated the database witht he attached sql and changed catalog/admin/modules.php as mentioned in the readme. Also i have no dimension support added, so it is only looking at the weight. I do have a contribution for individual weights for attributes, and that seems to be working. Have i missed anything? I really hope i can get this one working, it will save me a lot of time manually entering the rates into a zones based shipping module.

Tare weight is set to 0. OK, i will wait a few days to see if the rates change.

I have dont a clean install and it all seems to be working, but it is not picking up my rates. I have selected true under "Negotiated rates" and put my account number in, but the quotes i get seem very high. I am in the UK, and for 1KG is comes up as £21.79 for standard.

Forget that, i have figured it out. Was a setting in the admin, i did not have it in debug mode. :blush: :blush:

I have just noticed that i no longer get error reports come through after the update. I spoke to a customer and he said that he tried to pay by credit card but got an error, and before the update i would get an error report from paypal. Any ideas of where to look?

Compared to the contribution version, and there were a few lines that were not in my version, so after a bit of tinkering, i have got it working. Thanks Great contribution.

thanks Steve, i dont have an express chechout button, infact the /includes/header.php has not been modified from its current form. I was under the usumption that the header.php was just modified to show the links? This happens when i click on the checkout button on the home page. Thanks

Thanks for the reply. The checkout shipping page is the first page you get to after loging in after clicking on the checkout button, so this screen is before you select the payment type. I have compared it to the page i had before i added the version 0.7 and could not see any obviose issues, but will have a look at it against the version in the contribution.

I have just upgraded from Version 0.7 and after a bit of fidling i have got it working and taking payments, but there seems to be a problem on the chechout_shipping.php in that the shipping address does not show. We have the arrow and the title saying Shipping Address, but no actual address. this showed before the upgrade. a screen shot is here http://www.slidesandballscrews.com/images/...ut_shipping.php screenshot.jpg I can still checkout but it reverts to the billing address. when doing the upgrade, i removed all instances of the old version and then did a clean install. Any help woud be great.