HomeHome Product Discus... Product Discus...SmithCartSmithCartPaypal not returning payment status correctly. Paypal not returning payment status correctly.
Previous
 
Next
New Post
8/6/2010 3:17 PM
 

To fix the paypal standard issue you should download cart v3.01 from the downloads page and install. Then download the paypal hotfix and copy the dll to your \bin folder.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/6/2010 3:34 PM
 
Can I just install over the top of the current module?
 
New Post
8/6/2010 3:37 PM
 

Yes you can install over the top of your current module just make sure that you have a full backup of your dnn install and database in case you need to rollback.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/9/2010 8:35 AM
 
I just tried to install the module and got this problem

Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - Smith.BuyNow
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 02.93.00.SqlDataProvider
Info Executing 02.93.00.SqlDataProvider
Info Start Sql execution: 02.93.00.SqlDataProvider file
Info End Sql execution: 02.93.00.SqlDataProvider file
Info Created - 02.94.00.SqlDataProvider
Info Executing 02.94.00.SqlDataProvider
Info Start Sql execution: 02.94.00.SqlDataProvider file
Info End Sql execution: 02.94.00.SqlDataProvider file
Info Created - 02.95.00.SqlDataProvider
Info Executing 02.95.00.SqlDataProvider
Info Start Sql execution: 02.95.00.SqlDataProvider file
Info End Sql execution: 02.95.00.SqlDataProvider file
Info Created - 02.96.00.SqlDataProvider
Info Executing 02.96.00.SqlDataProvider
Info Start Sql execution: 02.96.00.SqlDataProvider file
Info End Sql execution: 02.96.00.SqlDataProvider file
Info Created - 02.97.00.SqlDataProvider
Info Executing 02.97.00.SqlDataProvider
Info Start Sql execution: 02.97.00.SqlDataProvider file
Info End Sql execution: 02.97.00.SqlDataProvider file
Info Created - 02.98.00.SqlDataProvider
Info Executing 02.98.00.SqlDataProvider
Info Start Sql execution: 02.98.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'SortOrder'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Smith_ListCatSubCat @TabModuleId int, @PortalId int AS SELECT c.CategoryID, c.CategoryName,c.SortOrder, c.Share, c.ParentID, c.catseourl, p.categoryname as 'parentcategoryname' FROM Smith_Category c left join Smith_Category p on c.parentid = p.categoryid WHERE ( C.TabModuleId = @TabModuleId OR C.Share = 1) and c.PortalId = @PortalId ORDER BY [SortOrder]
Info End Sql execution: 02.98.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - Smith.BuyNow
Info Starting Installation - Smith.AffiliateTracking
Info Starting Installation - Module
Info Module registered successfully - Smith.AffiliateTracking
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly updated - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info Creating backup of previous version - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info Created - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info Assembly updated - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info Creating backup of previous version - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info Created - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - AffiliateTrackingSettings.ascx
Info Created - AffiliateTrackingSettings.ascx
Info Creating backup of previous version - TrackAffiliateId.ascx
Info Created - TrackAffiliateId.ascx
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.AffiliateTracking
Info Starting Installation - Smith.CategoryMenu
Info Starting Installation - Module
Info Module registered successfully - Smith.CategoryMenu
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly updated - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info Creating backup of previous version - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info Created - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info Assembly updated - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info Creating backup of previous version - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info Created - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - CategoryMenu.ascx
Info Created - CategoryMenu.ascx
Info Creating backup of previous version - CategoryMenu.css
Info Created - CategoryMenu.css
Info Creating backup of previous version - CatMenuSettings.ascx
Info Created - CatMenuSettings.ascx
Info Creating backup of previous version - tv_collapser.gif
Info Created - tv_collapser.gif
Info Creating backup of previous version - tv_expander.gif
Info Created - tv_expander.gif
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.CategoryMenu
Info Starting Installation - Smith.FeaturedProducts
Info Starting Installation - Module
Info Module registered successfully - Smith.FeaturedProducts
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly updated - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info Creating backup of previous version - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info Created - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info Assembly updated - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info Creating backup of previous version - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info Created - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - FeaturedProducts.ascx
Info Created - FeaturedProducts.ascx
Info Creating backup of previous version - FeaturedProducts.css
Info Created - FeaturedProducts.css
Info Creating backup of previous version - FeaturedSettings.ascx
Info Created - FeaturedSettings.ascx
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.FeaturedProducts
Info Starting Installation - Smith.MiniCart
Info Starting Installation - Module
Info Module registered successfully - Smith.MiniCart
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly updated - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info Creating backup of previous version - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info Created - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - checkout.gif
Info Created - checkout.gif
Info Creating backup of previous version - MiniCart.ascx
Info Created - MiniCart.ascx
Info Creating backup of previous version - minicart.css
Info Created - minicart.css
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.MiniCart
Info Starting Installation - Smith.MyAccount
Info Starting Installation - Module
Info Module registered successfully - Smith.MyAccount
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly updated - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info Creating backup of previous version - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info Created - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info Assembly updated - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info Creating backup of previous version - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info Created - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info Assembly updated - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info Creating backup of previous version - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info Created - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - myaccount.css
Info Created - myaccount.css
Info Creating backup of previous version - MyAccountInvoice.ascx
Info Created - MyAccountInvoice.ascx
Info Creating backup of previous version - MyAccountManageOrders.ascx
Info Created - MyAccountManageOrders.ascx
Info Creating backup of previous version - MyAccountSettings.ascx
Info Created - MyAccountSettings.ascx
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.MyAccount
Info Deleted temporary install folder
EndJob Installation Failed
 
New Post
8/9/2010 10:41 AM
 

We have fixed this issue in the sql install file and uploaded a new cart v3.01 to the downloads page. Please download the new version and try installing again.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/9/2010 11:19 AM
 
I downloaded that and installed it. It installed fine but now I have this error when I go to my shopping cart page
A critical error has occurred.
Parameter count does not match Parameter Value count.
 
New Post
8/9/2010 11:23 AM
 

Something must have gotten out of sync in your cart build when the first install failed. I recommend you do a clean install please follow these steps for a clean install:



Clean Install Instructions
-------------------------------

  1. From the dnn->host menu uninstall all 6 modules; Smith.BuyNow, Smith.AffliateTracking, Smit.CategoryMenu, Smith.MiniCart, smith.featuredproducts and Smith.MyAccount. Make sure you check the delete files box when you uninstall
  2. Confirm that all stored procs and tables with a prefix of smith in your database are deleted
  3. Confirm that all files in /desktopmodules/smith.buynow are deleted and the folder is removed
  4. Install the latest module you downloaded today
  5. Configure the cart settings
  6. Add one category, manufacturer and product and test

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/9/2010 12:08 PM
 
That's not necessarily an option because we have hundreds of products and I don't want to have to export/import everything again. I have updated your product three times trying to fix different errors and every time you have told me I need to do a fresh install. If this is the only we we can ever update, then I'm going to look for a new shopping cart module for any of our future purchases.
 
New Post
8/9/2010 12:53 PM
 

In your dnn - host - module definitions screen what version does it say next to the smith cart modules?

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/9/2010 2:17 PM
 
So I just did do a complete reinstall. I have the settings the exact way we have discussed. When I try to use paypal to checkout instead of a credit card via authorize.net I get this error

We couldn't complete your payment.

Status : False
Message : Credit card number is required.
 
New Post
8/9/2010 2:56 PM
 

Is that the message displayed on the confirm page after returning from paypal?


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/9/2010 3:00 PM
 
I should have been more specific sorry. It is on the actual page that would redirect you to paypal. When you click checkout with paypal, you can see the problem. The problem is live here https://www.yandasmpa.com/Storefront.aspx. There's a product called test.
 
New Post
8/9/2010 3:39 PM
 

I am looking into the issue with configuring Auth.net and Paypal Standard as checkout options. While I am looking into this can you test and see if it works when you configure the primary gateway as paypal standard without checking the "Show Paypal Checkout Option checkbox.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/19/2010 10:13 AM
 
Where are we at on this? I really need this fixed to work with both asp.net and paypal. Right now, our customers cannot check out at all.
 
New Post
8/27/2010 6:19 AM
 
Do you have an ETA on this?
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartPaypal not returning payment status correctly. Paypal not returning payment status correctly.