Missing web store

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
10/2/2011 3:01:44 PM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Missing web store

I would like to use the web store feature on a personal site, to allow people to enter an event on line. However the web store feature is not there in the drop down list on my site. Reading the docs it seems maybe it's not there because I'm on SQLCE database - is that correct?

If so, any idea when this feature will work on CE ?  And if not soon, is a migration to SQL Server viable? I run other mojo sites in SQL Server, so I know I could set up a new empty database OK, but I'm thinking the process of connecting to the CE file and pushing data across might be tricky. Has anyone written up any guidance?

mojoPortal Version 2.3.6.4 SqlCe

Operating System Microsoft Windows NT 5.2.3790 Service Pack 2

ASP.NET Info v4.0.30319 Running in Full Trust

thanks

10/3/2011 2:35:39 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing web store

Hi Crispin,

Only MS SQL and MySql are currently supported for WebStore and there are no immediate plans to support other databases. WebStore is still in its early stages, possibly after it is more feature complete and matured then we will consider implementing other database layers.

It is possible to Migrate from SQL CE to SQL Server Using WebMatrix.

Best,

Joe

10/22/2011 2:38:30 PM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

Hi Joe

I'm now trying the migration from CE to SQL. On this page http://www.mojoportal.com/using-webmatrix-to-migrate-mojoportal-from-sql-ce-to-sql-server.aspx you say "I've included 2 scripts in the mojoPortal package for SQL CE named sqlce-to-sqlserver-migration-mojoportal-core-procs.sql and sqlce-to-sqlserver-migration-mojoportal-features-procs.sql."

I'm probably being very thick, but I cannot find these scripts in the 2.3.7.0 downloads (CE or SQL) from Codeplex. Can you advise?

10/23/2011 6:24:14 AM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

Hi Joe

I'm having a go at scripting the stored procedures myself from one mojo SQL DB to the one I have converted from CE.

I'm hitting a couple of minor problems so will document them here as I go.

I scripted out alll the sprocs from the "official" SQL database, and ran the script against my new one >>> these errors:

Msg 206, Level 16, State 2, Procedure mp_Blog_SelectByEndDate, Line 17

Operand type clash: ntext is incompatible with int

Msg 206, Level 16, State 2, Procedure mp_Blog_Select, Line 16

Operand type clash: ntext is incompatible with int

On investigation this seems to be because the database migration resulted in the mp_Blogs.Description (and similar) fields being made ntext data type, whereas in the "official" database they are nvarchar(max).  mp_ModuleSettings was similarly affected.

Once the fields in these two tables had been changed to nvarchar(max) I was able to run the scripts to create the two sprocs.

If I hit any more bother I'll post again.

 

10/24/2011 7:45:21 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing web store

Hi Crispin,

You are right I have not been shipping a script for migration, it will be too much work for me to do that so I'll make instructions for people to do as you have.

It is true that one will need to change alll the ntext fields to nvarchar(max). Unfortunately SQL CE does not support nvarchar(max) soo we had to use ntext and it causes this dicrepancy when it gets migrated to SQL Server.

So the basic steps should be.

1. Go through all existing tables and change ntext to nvarchar(max)

2. Use an installation of the same version of mojoPortal for SQL Server and script off the ws_* tables if you want to use WebStore, and script off all the stored procedures and run those scripts on your migrated database to create the missing tables for WebStore and the stored procedures.

3. Replace the mojoPortal files on disk with the same version of mojoPortal using the ms sql package.

Best,

Joe

11/8/2011 11:00:06 AM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

Just to confirm I got this going fine, following the procedures described above. i.e. fixed the ntext fields back to nvarchar(MAX) after using Matrix to migrate the database, then scripting all the tables and sprocs from a SQL Server mojoPortal database into the one created by Matrix.

All working fine so far!

11/23/2011 1:19:25 PM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

Hi Joe

I've just taken first real order through the web store discussed above. Quite a surprise as the race in not until July 2012!  This is the site: http://www.breconfans.org.uk

However, when I look in the Store Manager > Order History, there's nothing there. Also, under the user account (I require registration) there is nothing in the order history.

I did receive the PayPal notification.

I'm wondering if there could be something wrong with my data structure after the migration from CE?  The only relevant item in the system log is this:

2011-11-23 04:31:20,252 INFO 82.110.109.212 - en-GB - /Services/PayPalPDTHandler.aspx?tx=4WN6697765895294B&st=Completed&amt=8.00&cc=GBP&cm=7208f8c7%2d68e8%2d486d%2d9011%2df4a22a70c214&item_number= - mojoPortal.Web.Services.PayPalPDTHandler - invalid ptd request no valid provider found http://www.breconfans.org.uk/Services/PayPalPDTHandler.aspx?tx=4WN6697765895294B&st=Completed&amt=8.00&cc=GBP&cm=7208f8c7-68e8-486d-9011-f4a22a70c214&item_number=

which suggests that perhaps mojoportal could not process the callback from PayPal for some reason.

Any ideas what might be wrong?

11/23/2011 1:25:20 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing web store

Hi Crispin,

invalid ptd request no valid provider found

Its missing some configuration files that were not shipped in the SQL CE package but do exist in the MS SQL package.

I would copy the folder /Setup/ProviderConfig from the MS SQL package of mojoPortal to your installation.

Hope that helps,

Joe

11/23/2011 2:51:32 PM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

Thanks Joe that makes sense - I've copied the files across and will test it.

A question... any way of sending the purchaser a custom email when the purchase is confirmed and mojoPortal receives the call back from PayPal?

 

 

11/25/2011 6:03:55 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing web store

Hi Crispin,

Currently it does send an email when an order is received or completed. If the payment has cleared right away the user gets one confirmation email, but if we first get notification and it is under review then we first send an email saying the order has been received and the payment is being processed. Then once we get the notification that payment has cleared another confirmation is sent.

It uses the following templates from /Data/MessageTemplates/:

en-US-DefaultOrderReceivedPlainTextEmailTemplate.config

and

en-US-DefaultOrderConfirmationPlainTextEmailTemplate.config

You could customize those but then you have to maintain them after upgrades to restore your customization.

Hope that helps,

Joe

12/3/2011 11:32:46 AM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

I've just been testing the "invalid ptd request" fix, with a test PayPal purchase... after completing the purchase I did arrive back at my site, to view the "Order Summary", and it appears in the order history, so it looks like the fix has worked. However the date on the order was incorrect:

Order Date 05/11/2011

Total £0.10

i.e. 5th November instead of 3rd December.

Other dates on the site are reporting correctly. If I go to my order history (under the purchasing user's account), the date shows correctly. This might be a bug, or perhaps be still a symptom of a config problem following my conversion of the site from SQLCE to SQL Server? Anyway I thought I'd better post it - any ideas? 

Later... I've just found that when I log in as site admin, and check the Store order history, the data is also wrong: 05/11/2011 14:29

But in the "PayPal Log" I think I've found the problem. There is a PDT entry for the correct date/time 03/12/2011 17:19:36, but there are also several entries from the date that was misreported above, when I was testing while originally setting up online entry. Table below. It looks like a couple of places are fetching the wrong record from the table for the completed purchase.

Request Type Payment Type Payment Status TransactionId Cart Total Tax Total Fee Settlement Created UTC
StandardCheckout                                          8.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 00:34:40
StandardCheckout                                          8.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 00:39:18
StandardCheckout                                          0.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 00:39:23
StandardCheckout                                          8.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 10:13:42
StandardCheckout                                          12.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:29:36
StandardCheckout                                          4.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:12
StandardCheckout                                          0.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:15
StandardCheckout                                          4.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:30
StandardCheckout                                          4.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:32
StandardCheckout                                          9.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 17:12:45
StandardCheckout                                          17.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    06/11/2011 17:42:24
StandardCheckout                                          17.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    22/11/2011 20:25:03
StandardCheckout                                          13.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    22/11/2011 20:25:12
StandardCheckout                                          8.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    22/11/2011 20:25:17
StandardCheckout                                          8.1000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:08:45
StandardCheckout                                          0.1000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:08:50
StandardCheckout                                          0.2000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:10:54
StandardCheckout                                          0.1000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:11:00
IPN                                    cart                                    Completed                                    31U94777PX1391202                                    0.1000                                    0.0000                                    0.1000                                    0.0000                                    0.0000                                    03/12/2011 17:19:19
PDT                                    cart                                    Completed                                    31U94777PX1391202                                    0.1000                                    0.0000                                    0.1000                                    0.1000                                    0.0000                                    03/12/2011 17:19:36

 

You must sign in to post in the forums. This thread is closed to new posts.