Setup/default.aspx - SQL Code Only Error? - Page 1

Setup/default.aspx - SQL Code Only Error?

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

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.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

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

10/11/2008 9:49:53 PM

smcfarland

Total Posts 9

View Posts

Setup/default.aspx - SQL Code Displayed? ALTER TABLE ...

I am hosting on GoDaddy windows servers. I installed everything and am using MSSQL with the physical path. I changed the config files to Medium Trust, altered user.config and re-uploaded per all of the forum posts. That got rid of a lot of errors.

When I go to setup/default.aspx, I get the following:

ALTER TABLE ws_Offer ADD COLUMN `IsDonation` tinyint(1) unsigned NULL; UPDATE ws_Offer SET IsDonation = 0; ALTER TABLE ws_CartOffers ADD COLUMN `IsDonation` tinyint(1) unsigned NULL; UPDATE ws_CartOffers SET IsDonation = 0;

That is it. No error. Nothing. Just that. I am relatively self taught with all of these things and am middle of the road, just using SQL for the past two years on and off, but I know my way around. Am I missing something uber simple here?

Thanks in advance.

10/12/2008 6:07:36 AM

Joe Audette

Total Posts 18439

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

Thats very strange indeed because that fragment is for MySql not MS SQL. You must have the MySql version of the *Data.dll files in your bin folder. Or else you have put some files in the wrong places somehow, like putting MySql scripts in the folder for MS SQL scripts.

I would re-install the files using only the mojoportal-2-2-7-3-mssqlreleasefiles.zip

Might be good to delete all the files on there first to be sure no files are remaining in incorrect locations.

Hope it helps,

Joe

10/12/2008 12:50:41 PM

smcfarland

Total Posts 9

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

When this install is done, I will buy both of us a beer. :) (Well, it will need to be rum for me, but I digress.)

I copied over the files exactly with FTP Surfer, and then again with FileZilla (twice). I've done three installs total. I keep ending up with the same error. I searched all the files and took out any references I could find to anything other than MSSQL (as far as databases). There *is* MySQL on the server, but that is not the db info I have in there.

Is there a list of specific files that all need to be deleted?

10/12/2008 1:04:13 PM

Joe Audette

Total Posts 18439

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

Which db is used is determined only by which version of the data dlls you have in your bin folder. You must have the MySql version of mojoPortal.Data.dll (and possibly mojoPortal.Features.Data.dll and WebStore.Data.dll) in your bin folder,maybe you followed the instructions in this post, but those instructions were for using MySql and therefore had the extra step about downloading the MySql data layer and replacing the files in the bin folder. That step is not needed for MS SQL.

The dlls for each db have the same names so only 1 possible version can be used at a time, it seems like you copied in the MySql version into your bin fodler before uploading. The ones included in mojoportal-2-2-7-3-mssqlreleasefiles.zip are correct for MS SQL.

So its not about configuration or references, its just about having the right dlls for the chosen db and then setting the connection string for that db. If you are seeing that same error then you definitely must have the MySql dlls.

Hope it helps,

Joe

10/12/2008 1:58:27 PM

smcfarland

Total Posts 9

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

Just in case...

I installed fresh copy on the server. I changed only the web.config (medium trust) and user.config files, using Visual Studios. Same error.

Am I supposed to be changing the DLLs? I followed the steps in the installation online. Am I missing anything?

10/12/2008 2:06:12 PM

smcfarland

Total Posts 9

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

Oh my gosh, the default.aspx in the setup folder was corrupt. Now I have new errors. When I go to the files (fresh unzipped files) there is no galleryimages folder in the 1 folder.

An Error Occurred:Could not find a part of the path 'd:\hosting\dionneross\Data\Sites\1\GalleryImages\test.config'.
Source:mscorlib
Stack Trace at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append) at System.IO.File.CreateText(String path) at mojoPortal.Web.mojoSetup.TouchTestFile(String pathToFile) at mojoPortal.Web.UI.Pages.SetupHome.GetFolderDetailsHtml() at mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

10/12/2008 2:08:34 PM

Joe Audette

Total Posts 18439

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

That error means the /Data folder is not writable by the web process. Somewhere in your web control panel should be a place to manage folder permissions. You need to make the Data folder writable.

Hope it helps,

Joe

10/12/2008 7:48:25 PM

smcfarland

Total Posts 9

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

Ok. I had some files missing, some corrupted, 30 mins on support with GoDaddy telling their tech support what they could and could not do with permissions (anything besides domains is not their forte) and a change with the database string for MSSQL, and it is up and running... however, things are still missing...

In the forms, there are no forms (like the one I am writing in) and the wysiwyg icons are all across the screen. Is there a place to troubleshoot that?

Thanks!

10/13/2008 6:21:30 AM

Joe Audette

Total Posts 18439

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

My guess is you still have some missing or corrupted files. I would try uploading the /ClientScript folder again using FileZilla. I would pay careful attention to whether FileZilla reports any transfer errors and if it does retry on the failed transfers until it gets all the files. /ClientScript has all the javascript including the files for the wysiwyg editor.

When you say "forms" I'm assuming you mean "Forums", like the one I am writing this reply in. You should see it in the dropdown list of things you can add to a page. If you don't see it there then possible more missing files beneath /Setup

Hope it helps,

Joe

10/13/2008 8:26:39 AM

smcfarland

Total Posts 9

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

I do means forms lol

http://www.holistic-fitness.org/_default.aspx

I am going to try to upload using a different FTP client. I didn't notice any errors when it was going via FileZilla.

10/13/2008 9:26:13 AM

Joe Audette

Total Posts 18439

View Posts

Re: Setup/default.aspx - SQL Code Only Error?

Oh, you do mean forms, well, the Form Wizard Pro feature is an add on product on sale in the mojoPortal Store. It is included in the demo site, but its not included in the free download of mojoPortal. Event Calendar Pro is also in the demo site but is not part of the free package, though there is a free Calendar included, its just not as feature rich as the paid one.

Sorry for the confusion, I will add some text to the home page on the demo site to mention that those items are add on features.

Best,

Joe

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