PollFeature&New Gallery Problem.

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

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

2/23/2008 5:16:15 AM

bob

Total Posts 126

View Posts

YAF developer

PollFeature&New Gallery Problem.

I have got a problem with Poll Feature and MySQL. Before SubSonic experiments it did't work anyway with the latest release. So I've installed svn version, but it gives the error:

Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 56: SetSQLProps();
Line 57: InitSetDefaults();
Line 58: LoadByKey(keyID);
Line 59: }
Line 60:

Source File: \mojoPortal.Data.Common\Generated\Poll.cs Line: 58

P.S. The new Gallery feature doesn't work for me too. I can see folders after the module is added, but I can't make my own folders.

2/23/2008 6:07:40 AM

Joe Audette

Total Posts 18439

View Posts

Re: PollFeature&New Gallery Problem.

Hi Bob,

There is a new Web.config setting that must be correct for SubSonic:

<add key="SubSonicProvider" value="subsonicMSSQL" />

you need to set it to subsonicMySql that should fix the first issue.

The new folder gallery I have not yet tested on Mono, but it doesn't have a feature to create folders, it can upload files into an existing folder but ideally you just organize your images into a folder then upload the folder. You could use the File Manager to create folders as an alternative. You may need to save the folder setting before it works even with the default folder. Saving the folder setting doesn't create a folder it just tells it where the start of the gallery is. I'll look at it today its still a little buggy.

Joe

2/23/2008 6:23:08 AM

Joe Audette

Total Posts 18439

View Posts

Re: PollFeature&New Gallery Problem.

Oh, when I started experimenting with SubSonic, I initially began working with the Poll module but then switched to using the links module. Apparently I forgot to back out my changes in DBPoll.cs, I'll do that. The Links module was an easier one to test in all data layers and I got it working in all of them. SubSonic is going to make things much easier going forward.

Joe

2/29/2008 6:15:20 AM

bob

Total Posts 126

View Posts

YAF developer

Re: PollFeature&New Gallery Problem.

I'm afraid the PollFeature doesn't work again with MySQL. After your post it worked in a svn version. But now the problem is the same as in the current release. I can't add poll. I can see data in some tables, but i.e. mp_pollmodules table is empty. It's a pity, as I can't update my site. The problem persists with Mono and .NET Framework :-(

2/29/2008 6:32:45 AM

Joe Audette

Total Posts 18439

View Posts

Re: PollFeature&New Gallery Problem.

I'll take a look at this today and post again later.

Thanks,

Joe

3/2/2008 4:23:39 AM

bob

Total Posts 126

View Posts

YAF developer

Re: PollFeature&New Gallery Problem.

Hi, Joe.

Now, it works seeamingly fine again. Thanks, that you've found time to look into it.

Best regards, bob.

P.S. I've tried WebStore with the MySQL Data Layer on .NET Framework with 3483.

At first glance there is a bug

The MySqlParameterCollection only accepts non-null MySqlParameter type objects.
Parameter name: value

in DBCategory.cs in GetCount method, because ws_category is empty at the moment. Of cause, I understand, that the feature is under heavy development. Sometimes I see into it as I hope attach an option for WebMoney payments (PayPal don't very like my country :-( ) then the feature will be usable to some extent.

3/2/2008 5:48:05 AM

Joe Audette

Total Posts 18439

View Posts

Re: PollFeature&New Gallery Problem.

Oh, yeah, sorry, forgot to post again after I fixed the Poll issue.

Thanks for letting me know about the MySql webstore bug you found. I just fixed it in my working copy.

Also fyi, there were some bugs in the schema creation scripts for MySql web store that I have since fixed, but depending on when you got the code from svn your tables may have some problems. Best to drop all tables with a ws_ prefix and remove the row for the webstore from the mp_SchemaVersion table, then visit /Setup/Default.aspx to re-install it to be sure its correct.

I have implemented the code for PayPal provider but haven't yet tested it or written the code to plug it in to the store. I'll be doing that soon. At the moment it only can use Authorize.NET. If you post some links to the documentation about integrating WebMoney, I'll take a look at it and see what is involved to integrate it.

Best,

Joe

3/2/2008 10:38:14 AM

bob

Total Posts 126

View Posts

YAF developer

Re: PollFeature&New Gallery Problem.

I didn't look into it too closely as yet, but I really have some info.

An approach is here: http://www.codeplex.com/wmclasses/Release/ProjectReleases.aspx?ReleaseId=7422

Every command can be signed with this: http://www.wmsigner.com/En/Default.aspx

A general XML-interfaces description is here:

http://www.wmtransfer.com/eng/developers/interfaces/xml/index.shtml

There's a ready control and some more small utilities for a personal sertificate owners only and not in English site section. I don't have one as I don't need it as yet.

But I can't see what for they do so? It's under heavy development anyway and imitates Windows clients. I think there is simply no need for the very bulky interface as the WebStore is not at the stage then it can be used for very hacker-attracting stores now. So I think about first variant. In any case it may be useful to find a time look into it, to chart a common approach for payment likes.

3/2/2008 12:35:51 PM

bob

Total Posts 126

View Posts

YAF developer

Re: PollFeature&New Gallery Problem.

And some more about the PollFeature with Mysql.

1)Then an anonymous voting is permitted, then I can vote many times in the same session then I simply update a page, for example.

2)Then I'm a registered user, there's no check, if I voted before, so I can see voting options again and again and should vote to see the poll results, but my vote is not counted which is good news. And I can't see the label that I've already voted.

3/4/2008 8:19:46 AM

bob

Total Posts 126

View Posts

YAF developer

Re: PollFeature&New Gallery Problem.

The GalleryFeature (simple folder) doesn't work with MySQL. The files aren't seen. They are on the server in a folder. I don't know is it a problem with this DataLayer only.

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