 |
|
|
Joined: 12/19/2009
Posts: 18
|
|
|
One more note for anyone experiencing this problem. I found out that if you are running version 5.0 or 5.1 (i.e. 5.1.4) then the paypal subscriptions won't work. The problem lies in the same file (PayPalSubscriptions.aspx.vb) in the Page_Load section. That file is incomplete and was updated in version 5.2. You will need to either upgrade to 5.2 or manually update that one file in order to get this to work in version 5
|
| |
|
|
 | |
|
|
 |
Joined: 2/12/2010
Posts: 15
|
|
|
Hi Justin!
I've been reading your posts. And I'm using godaddy installation too. DNN 5.2.2
and I am trying to have my paypal set up. I get the same error; it takes me back to the home page with this error in the URL
Default.aspx?tabid=40&def=ErrorMessage
what i can understand; All I have to do is log in as HOST , go to SQL and paste this info
insert into {databaseOwner}{objectQualifier}PortalSettings ( PortalID, SettingName, SettingValue )
values (0, 'paypalsubscriptionreturn', 'http://www.DOMAIN-NAME.com/dotnetnuke/Congratulations.aspx');
insert into {databaseOwner}{objectQualifier}PortalSettings ( PortalID, SettingName, SettingValue )
values (0, 'paypalsubscriptioncancelreturn', 'http://www.DOMAIN-NAME.com/dotnetnuke/Cancellation.aspx');
insert into {databaseOwner}{objectQualifier}PortalSettings ( PortalID, SettingName, SettingValue )
values (0, 'paypalsubscriptionnotifyurl', 'http://www.DOMAIN-NAME.com/dotnetnuke/Home.aspx');
click execute and run the script???
I wanted to post this first before actually doing it b/c I tried doing this to my local hosted DNN 5.2.2 and i got a long error when I click execute.....
did you receive any errors after running the script above?
|
| |
|
|
| |
|
|
Joined: 12/19/2009
Posts: 18
|
|
|
Hey, forgive me if this sounds too basic, but just want to make sure that you are actually substituting in the proper web address of your website and not just leaving it as "http://www.MY-DOMAIN.COM" as it's listed in your post. I know you probably just put that there as an example, but I wanted to be sure because lots of people don't understand that you have to update that to your actual domain path...
Also, I find that executing scripts in the SQL part of DNN can sometimes throw errors if your script isn't written perfect, so rather than try to track down errors I always just log into the database directly and add the records. You can do this in GoDaddy if you log into your hosting account, click on manage, and then under CONTENT, open your SQL database. you'll have to login to the database (the username is just the database name, which should be listed there, and then the password you setup for the database).
Once in there you can poke around in the traditional "point and click" navigation method, and just add a record to that table by clicking on the little "star" icon... Makes it a lot easier..
If you can't figure it out let me know and I can write out some more detailed instructions...
|
| |
|
|
| |
|
|
|
Joined: 2/12/2010
Posts: 15
|
|
|
HI justin, yes if you could write out some details about adding these settings please, I notice in the PortalSettings table the 3 columns PortalID, SettingName, and SettingValue are there,
in mine the only one with out a KEY beside to the left is the SettingValue,
I also checked a fresh DNN 5.2 instal to a local host and checked the DB in SQL Server after attaching it, and these 3 columns are there too, which tells me nothing I can see changed the PortalSetting default, from the Script error i got.
I see the star on the right to add new,
|
| |
|
|
| |
|
|
Joined: 12/19/2009
Posts: 18
|
|
|
Hey, sounds like messing with the database may be new to you, so please do this with caution... You may want to figure out how to backup the database (and do a restore) from GoDaddy's manager before you mess with the database itself (just in case you screw something up and kill of the entire DNN application.. Problems can be hard to troubleshoot if you don't have a lot of experience working with it)
Those settings are correct and you do NOT want to change any of those...
For a little bit of an explanation, think of the database as being just like an excel spreadsheet, with columns and rows of data. Each "page" of the spreadsheet is a "table" in the database. (so the "settings table" is just one spreadsheet of data). The columns all get a name (as opposed to excel, which would just call them Column A, Column B, and so on.) Your data then becomes the "rows".. In this case, you do NOT want to rename any of the columns or add any new columns, you want to put 3 rows of data into the spreadsheet with the columns that are already there...
So...
Backup one step. Rather than clicking on the actual name of the table in your database manager (which brings you to the screen where you found the column names and the "key" pictures), look on the right side of the screen for a set of icons (one has a pencil, one a red X, one a magnifying glass, etc.). You'll find all these by opening up your database manager and then clicking on "TABLES" on the left to list all the tables, and they will be on the right side of this list...
Scroll down to the PORTAL SETTINGS table, and, on the right side, click on the icon which is farthest left among this group of icons on the right side of the page (looks like a picture of a page of paper with lines of writing. If you hover over it without clicking it you should see a little pop up say "view conents")
This is how you look at the actual DATA in the table (not the definition of the columns)...
Click there and then you can see all the rows of data (i.e. all the settings)
Click the little star in the upper part of the screen to add a new record to the table.. (i.e. a new row to the spreadsheet)
A box will pop up asking you to fill in all the information. Some information is required or the data will not actually be saved. You must enter the portal ID (usually just 0 for a default install- i.e. the number ZERO), you must enter the culture code (type: en-US) and then the setting name. (The first will be: paypalsubscriptioncancelreturn). Finally you'll have to enter the SETTING VALUE, which will be the URL that you mentioned already (i.e. http://www.mydomain.com/home)(<--change this to whatever your home directory is. Most installs go into the "root" but GoDaddy won't let you do that, so I put mine into a folder called "home" Not sure how you have yours setup) Once you've done all this click INSERT and you should see the new row of data appear as a new row in this spreadsheet (make sure you display all rows because the default is 10 and you will only see the first 10 rows and won't be able to see the one you just added)
You will then have to click on the little star two more times and add two more settings... (i.e. repeat everything above)
The setting name for the next one is paypalsubscriptionnotifyurl and the setting value is http://www.mydomain.com/home/admin/Sales/paypalipn.aspx (<--again, change this to point to the proper page on your site. Enter your domain and change "home" to whatever you are using as your install path)
The final setting is paypalsubscription return, and again, this can just be your home page (or whatever). This is where people will be directed after they have paid...
Let me know if you have any questions..
Good luck!
|
| |
|
|
| |