Hello to all.

First of all let me say that i'm new to this (using mojoPortal), and during the setup i encountered some erros.

So i'm using IIS6 with WS 2003 Web Edition and PostgreSQL 8.3 as DBMS and i was following the guide topics regarding setup.

For database setup i used pgadminIII and followed the steps mencioned in the documentation. Since my database is in the webserver machine i already have the pg...config's prepared to handle tcpip local and network communications.

So using pgadminIII, i just created the database and user to log to it and using a few GIS applications i was able to login to the database and insert information in it just to ensure that the login was connectiong well.

In the web.config i just filled in the information regarding the connection string.

The i run the .../Setup/Default.aspx, and almost went well except a few errors (please see the install log bellow) but in the end i was able to get to use the application, so no application major errors were found until now.

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
pgsql database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.7.8 - 00:00:00.4531453
Running script mojoportal-core - 2.2.7.9 - 00:00:02.5938662
Running script mojoportal-core - 2.2.8.0 - 00:00:02.7657489
Running script mojoportal-core - 2.2.8.1 - 00:00:02.8907545
Creating site with default settings... - 00:00:03.1563914
Creating roles and admin user... - 00:00:03.7970451
Configuring feature Html Content - 00:00:04.8439670
Configuring feature Site Statistics - 00:00:05.0783525
Configuring feature Web Part - 00:00:05.4221179
Running script blog - 0.0.0.1 - 00:00:05.6565034
Running script blog - 0.0.0.2 - 00:00:06.0471459
Running script blog - 0.0.0.3 - 00:00:06.1721515
Running script blog - 0.0.0.4 - 00:00:06.3284085
Configuring feature Blog - 00:00:06.4534141
Running script contactform - 0.0.0.1 - 00:00:08.9222747
Npgsql.NpgsqlException: relation "mp_contactformmessage" already exists Severity: ERROR Code: 42P07 at Npgsql.NpgsqlState.d__a.MoveNext() at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() at Npgsql.ForwardsOnlyDataReader.NextResult() at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteNonQuery() at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(NpgsqlTransaction transaction, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:08.9535261
Running script contactform - 0.0.0.2 - 00:00:09.0629060
Configuring feature Contact Form - 00:00:09.1879116
Running script eventcalendar - 0.0.0.1 - 00:00:09.7660625
Running script eventcalendar - 0.0.0.2 - 00:00:10.0942022
Configuring feature Event Calendar - 00:00:10.2192078
Running script feed-manager - 0.0.0.1 - 00:00:10.8598615
Running script feed-manager - 0.0.0.2 - 00:00:11.2036269
Running script feed-manager - 0.0.0.3 - 00:00:11.3286325
Configuring feature Feed Manager - 00:00:11.4536381
Configuring feature Image Gallery (Simple Folder Version) - 00:00:12.6099399
Running script forums - 0.0.0.1 - 00:00:12.8443254
Running script forums - 0.0.0.2 - 00:00:13.2818450
Configuring feature Forums - 00:00:13.4224763
Configuring feature Google Map - 00:00:13.8287445
Configuring feature Html Fragment Include - 00:00:14.7506608
Running script imagegallery - 0.0.0.1 - 00:00:15.0006720
Running script imagegallery - 0.0.0.2 - 00:00:15.3444374
Configuring feature Image Gallery - 00:00:15.4694430
Running script linksmodule - 0.0.0.1 - 00:00:15.9850911
Running script linksmodule - 0.0.0.2 - 00:00:16.2819794
Configuring feature Links - 00:00:16.4069850
Running script pollfeature-byChristianFredh - 0.0.0.2 - 00:00:16.6882476
Running script pollfeature-byChristianFredh - 0.0.0.3 - 00:00:16.9851359
Configuring feature Poll - 00:00:17.1101415
Running script sharedfiles - 0.0.0.1 - 00:00:17.3601527
Running script sharedfiles - 0.0.0.2 - 00:00:17.6882924
Configuring feature Shared Files - 00:00:17.8289237
Running script surveyfeature - 0.0.1.2 - 00:00:18.0633092
Running script surveyfeature - 0.0.1.3 - 00:00:18.4227003
Configuring feature Survey - 00:00:18.5633316
Configuring feature Xml/Xsl - 00:00:18.9383484
Ensuring all features are installed in server admin sites... - 00:00:19.1102311
No pages found so creating default content...
Setup is complete, click the link below to go to the home page.
Site Home Page

Database Platformpgsql
Version2.2.8.1
StatusYour installation is up to date.

Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

To try to troubleshoot this i tried to change the web.config's connectionstring from unicode to utf8, but it produced the same error log descrbed above. However after visiting the portal, all aparently was working no aplication errors, except there was no CSS or any skin showing only plain html.

I've also tryed to run eache *.sql file located in the directory called "legacy-dbscripts" and one of them "3CreateStoredProcedures.sql" could not ruu. After exploring the sql files i've seen that these are for prior versions os Postgresql bellow version 8 i think and that's maybe one of the reasons why there's error's in the setup log file.

However rigth now i'm trying to put the skins to work but none of the supplyed skins work, but i've downloaded some comunity default (unmodified) skins that should not be working and they worked, so only the default skins are not workning, so i ask what coud be the source of these?

I also have tried to clean the browser cache in order to make sure that skins changes show up but nothing happens. Only the community insupported skins work, not the default ones.

Thanks in advance.

Regards.

Hello Joe.

I've looked into the file and comment that create table and now no errors while installing.

However, now i've got the .Net 3.5 SP1, so after instaling that i get some asp.net erros that did not show before in the event viewer. 

NET Runtime 2.0 Error Reporting Event ID: 5000

EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 webstore.business, P5 1.0.0.0, P6 494fa855, P7 312, P8 0, P9 system.typeloadexception, P10 NIL.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

and

ASP.NET 2.0.50727.0 ID:1334

An unhandled exception occurred and the process was terminated.

Application ID: /LM/W3SVC/2/Root/bio3cms

Process ID: 3380

Exception: System.TypeLoadException

Message: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3278.17598, Culture=neutral, PublicKeyToken=null'.

StackTrace: at WebStore.Data.DBProduct.GetProductByPage(Int32 siteId, Int32 pageId)
at WebStore.Business.Product.GetBySitePage(Int32 siteId, Int32 pageId)
at WebStore.UI.Helpers.ProductSearchIndexBuilder.RebuildIndex(PageSettings pageSettings, String indexPath)
at mojoPortal.Business.WebHelpers.IndexHelper.RebuildSiteIndex(String indexPath, IEnumerable`1 menuPages)
at mojoPortal.Business.WebHelpers.IndexHelper.RebuildSiteIndexAsyncCallback(Object objArrayList)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Regarding file permissions i believe that i i've set them up ok, i even add to the main application folder, for ASPNET, IUSR, NETWORK SERVICE and IIS_WPG full access to write,read,modify... etc... for testing pourposes.

Never the less while using the application it works more or less ok, still no skins just plain html and i can edit any HTML container, i keep getting this error: Error loading "http://internal.bio3.pt/bio3cms/Services/EditorStyles.ashx" (HTTP Status: 404).

Do you want to see the server response dump?

The file asked aboe exists in the application, and seems strange the aplication not beeing able to find it, is the FCKEditor used too old?

Thanks in advance.

Regards.

GP.

Hello Joe.

I'll keep it short, so....

Please delete the file /Setup/ProviderConfig/indexbuilders/webstoreproductindexbuilder.config

WebStore is not implemented in pgsql and I did not realize the presence of this file would cause this error but now I realize it from thinking through it.

Then it may be best to delete all rows from the mp_IndexingQueue and mp_TaskQueue tables then immediately recycle the app by touching web.config

I´ve done the previus and no error shows up  maybe it was really the presence of that file.

For the next error if you have a relevant error thats fine, all that .ashx service does is read and render the xml from /ClientScript/mojofckstyle.xml

 

Have you pasted the url http://internal.bio3.pt/bio3cms/Services/EditorStyles.ashx into your browser? What happens there?

 

About the skins, if you view the source of the page and are using one of the included skins (please don't try to solve it with those old skins active), then look for the url of the main css file, it should be .../csshandler.ashx?... Copy the fullurl and paste into the browser, do you see css or an error?

Regarding this, i've activated directory browsing for the website, and the complete html entry you mention is in my case:

<link href='http://internal.bio3.pt/bio3cms/Data/Sites/1/skins/dcarter-sq2/csshandler.ashx?skin=dcarter-sq2&amp;config=style.config&amp;add=' type='text/css' rel='stylesheet' />
 

So, if i take all the url http://internal.bio3.pt/bio3cms/Data/Sites/1/skins/dcarter-sq2/csshandler.ashx?skin=dcarter-sq2&amp;config=style.config&amp;add= and use the browser to run it, i get "page can not be found, error 404", however using only http://internal.bio3.pt/bio3cms/Data/Sites/1/skins/dcarter-sq2/ it shows the folder documents (i've activated directory browsing for all the application for troubleshooting), and i can view some documents and images using this url.

Also when using the complete url http://internal.bio3.pt/bio3cms/Services/EditorStyles.ashx in the browser the file is in there and it throws "page can not be found" however the file is in there, but if i use http://internal.bio3.pt/bio3cms/Services/ the folder contents shows up and you can see the file.

I've seen that the "EditorStyles.ashx" calls the class "mojoPortal.Web.Services.EditorStyles", could it have any error?

I've setup all permissions for handling these files and they should be read by the IIS/Browser.

Also related to the skining error, i've noticed that while browsing the mojoportal using IE7 i get an error in the status bar "Finished with errors" and its details says "'Sys' not declared", using Firefox i dont get it but in the end, the skins don't show up in both. 

Also, since your site is running in a sub folder virtual directory /bio3cms/ see if there is another web.config file 1 folder up in the folder that corresponds to the root. If there is one it can be interfering.

Regarding any web.config for http://internal.bio3.pt/ it does not exist in the folder regarding this url.

Thanks in advance.

Regards.

Hello again.

The root folder refering to http://internal.bio3.pt had the ashx files maped but the folder bio3cms did not, so it was just necessary to map them tomake it work, and now i can change the html contens of the modules.

However the CSS problem remains, no CSS or skins are loaded.

Ill leave here a complete list of mapped file extensions (bellow), maybe you can see if any of them are missing..

File extention: asa,ashx,asp,aspx,browser,cd,cdx,cer,idc,java,mdb,mdf,refresh,shtml,sitemap,skin,soap and stm.

Do you think that the reason for the skins not showing (the css and image content) require re register the .NNET in the IIS?

Thanks in advance.

Regards.

Hello again.

Well yes i keep not seeing the css using the complete css url even after clearing the browsers cache.

http://internal.bio3.pt/bio3cms/Data/Sites/1/skins/dcarter-sq2/csshandler.ashx?skin=dcarter-sq2&amp;config=style.config&amp;add=;

However i've noticed something a bit strange also related to the css. I'f you see this site as well as my version has the the css w3s validator in the footer.

When i visit the link in this site (mojoportal.com), it's found and gived the following result:

W3C CSS Validator results for http://www.mojoportal.com/Data/Sites/1/skins/mojosite-brightside/style.css (CSS level 2.1)

(.....)

Passed

However my version throws an error when pressing the link and says that i dont have the style.css file.

Maybe skin css folders require the style.css file and none of them have one, so thats why the skins are not loading.

Can i be correct?

I'm not using the old community skins because you say that they are not supported, however they have the style.css file and thats one of the reasons why they are still +/- working.

Thanks in advance.

Regarding the css validator, ok i see :)

Regarding the css, as i say i cant see the css skin.

You can check it you by youself.

Just visit http://internal.bio3.pt/bio3cms/ and from there browse the source code and try the complete url.

It's not working, so i ask if to make it work does it require reregister the asp in iis? i believe not bt i dont now what it depens on to be working...

Thanks.