/setup/default.aspx stays empty

8/1/2007 3:06:35 PM

BertHerngreen

Total Posts 9

View Posts

Hello,

I downloaded the 'mojoportal-2-2-3-3-b-firebirdreleasefiles' zip-file. After extracting, creating the database by using the 3 scripts, I created a new virtual folder with IIS, pointing to the right dir. After that I adjusted all the rights for the dir.

Now, when I start the default page, it navigates automatically from default to /setup/default.aspx, but this page stays empty. No warning, nothing, does anybody knows what this means?

I used Ultidev cassini after this which has the same problem, /setup/default.aspx stays empty

Kind regards,

Bert

8/1/2007 3:29:39 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

Look in the Web.config file and make sure both ShowConnectionErrorOnSetup and ShowHistoryOnUpgradePage are set to true and perhaps it will give a message.

Also look in the db in the MP_SCHEMASCRIPTHISTORY table and see if there are any error messages there, if so let me know the message and I may be able to help.

Thanks,

Joe

8/1/2007 3:39:25 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

Hi Joe,

Both settings are on:

but no warning appears. Probably It's something in the database, because all three scripts where executed correctly according to IBexpert, but they all have 'erroroccurred' = 1.

No messages in the errormessage field.

Bert

8/1/2007 4:14:08 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Ok, I think I know what happened, though not sure why it didn't happen on my system in testing. If its what I think then it will be easy to fix.

Look in the table MP_SCHEMAVERSION.

If it already has a row in there update it to Major 2, Minor 2, Build 3, Revision 3

If there is no row add one with ApplicationID = 077e4857-f583-488e-836e-34a4b04be855 and the other fields as specified above.

Let me know if that fixes it.

Thanks,

Joe

8/1/2007 4:15:17 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

If the above doesn't help, try looking in the error log for clues, its located at siteroot/Data/currentlog.config

Joe

8/2/2007 1:22:45 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

Hi Joe,

The record in the MP_SCHEMAVERSION was exactly as you specified (major, minor etc.). The ApplicationID string is also correctly.

I took a look at the currentlog.config file and it contains the below mentioned errors.

Is 'no sites found or couldn't connect to db' caused by the fact that it did not yet complete some process initiated by setup/default.aspx? Or does it mean it can't find the database?

I tried C:\mojoportal.fdb and also mojoportal (the defined alias), however no difference. My firebird dotnet provider works correctly, because I can connect to it/see al tables by an other .net tool making use of the firebird dotnet provider:

"data source=localhost;Database=C:\MOJOPORTAL.FDB;user id=SYSDBA;password=masterkey"

If the database connection isn't the problem maybe the 'Token unknown - line 1, char 76' tells something more?

Kind regards,

Bert

2007-08-02 20:04:34,671 [1432] ERROR mojoPortal.Web.Global [(null)] - no sites found or couldn't connect to db
2007-08-02 20:04:36,140 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:36,796 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,000 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,171 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,203 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,203 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,218 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,234 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,250 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,265 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,265 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,296 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,312 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,312 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,312 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,343 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,343 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()

8/2/2007 1:46:17 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

What version of Firebird are you using? Its normal to get errors until there is data but those token errors sound like invalid sql so it makes me wonder about your db version.

It should handle the errors and take you to the Setup/Default.aspx page where it should show a link to click and create initial site data.

Joe

8/2/2007 1:55:09 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

I'm using the combination:

Server Version: WI-V2.0.0.12748 Firebird 2.0

FB .net Provider: 2.0.1.0

Can I determine which query/stored procedure(s) are called, then I can execute them directly?

Bert

8/2/2007 2:24:19 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

In the current implementation stored procedures are only used in places where there are inserts. The rest is using sql statements embedded directly in the code in mojoPortal.Data.dll so the only way to see them is to get the source code and look at the method where the error is happening. In this case, I just looked at the code for dbPortal.SiteSettings_GetSite(String HostName) and I do see an error in the syntax, it was just a typo in the code, a copy paste error.

I think the reason I didn't spot it in my testing is because I have 1 or 2 web.config setting different than yours and its not hitting that code on my machine.

Try setting UseFoldersInsteadOfHostnamesForMultipleSites=true and also AllowMultipleSites=true in Web.config and see if it gets past the error.

Thanks,

Joe

8/2/2007 2:42:47 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

Hi Joe,

It's not working, I see about 10 times this message:

2007-08-02 21:38:55,343 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - CacheHelper failed to load siteSettings

Bert

8/2/2007 2:46:43 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Yes but that error is expected until a site is created. If the token error is no longer happening then its some progress.

If you nvaigate to siteroot/Setup/Default.aspx do you see any message or a link to create a site?

Joe

8/2/2007 2:52:29 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

No, the page stays empty.

is the code you are talking about:

sqlCommand.Append("ORDER BY SiteID ");
sqlCommand.Append(" 1 ;");

8/2/2007 2:53:59 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

What do you see if you navigate to siteroot/Setup/Upgrade.aspx?

8/2/2007 2:58:25 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Any other errors in the log?

8/2/2007 3:04:36 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

Upgrade.aspx redirects to Default.aspx.

No other messages

8/2/2007 3:15:16 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Set RedirectHomeFromSetupPagesWhenSystemIsUpToDate=false in web.config and see what Upgrade.aspx says. I suspect it will say your system is up to date. I cannot think why you don't see the link to create site data. On Setup/Default.aspx, view the source of the page (right click page and choose view source) Does the html look ok, do you see any errors or do you see a link that maybe isn't visible for some reason?

Are there any rows in MP_SITES?

Joe

8/2/2007 3:38:22 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

The content that belongs here is too complex to display securely.

8/2/2007 3:59:12 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Yes, that was the syntax error, the 1 shouldn't be there.

If there are no more errors in the log I'm kind of stumped.

All I can say is I'm working on an improved setup process which should be ready within the next few weeks, maybe it will go more smoothly.

You do have the Charset in the conenction string set to match the Charset of the db right?

Are you using the SYSDBA user in your connection string? If not try it and see if any difference.

You mentioned you have FB .net Provider: 2.0.1.0, is that installed in the GAC? mojoPortal includes its own version in the bin folder Firebird.Data.FirebirdClient.dll, I had to make a few small changes due to some bugs I ran into using it. If its installed in the GAC on your machine it may be using that version instead of the custom one in the bin folder. You might try removing it from the GAC.

Joe

8/2/2007 6:42:30 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

Can you delete your Data/currentlog.config, then edit log4net.config and set loglevel to debug

Then try to run your site so it raises the errors and does whatever it does or doesn't do.

Then zip the currentlog.config file and send it to me at joe.audette [at] g mail dot com

This will hopefully give me more clues.

Thanks,

Joe

8/3/2007 9:13:57 AM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

Nothing very helpful in your log. If it were not for the fact that it shows the version on the upgrade page I would suspect it is not connecting to the db but it must be to show the version.

In the connection string in your web.config you did not specify Charset. On my machine when I created the db using Flamerobin I specified the Charset as UTF8 and I specifed this in the connection string. I notice your connection string doesn't have the pooling, fetch size, conection timeout, Lifetime settings specified.

My Connection string is like this:

Data Source=localhost;Server Type=0;Port Number=3050;Database=C:\Users\JoeAudette\devprojects\mojoportal\mojoportal.fdb;Dialect=3;Charset=UTF8;Pooling=True;Min Pool Size=0;Max Pool Size=200;Connection Timeout=10;Connection Lifetime=60;Fetch Size=200;User Id=SYSDBA;Password=masterkey

Can you try putting these settings in your connection string?

What Charset is your db using? If not UTF8 can you try making a new db using UTF8?

Thanks,

Joe

8/3/2007 1:37:13 PM

BertHerngreen

Total Posts 9

View Posts

Re: /setup/default.aspx stays empty

Hi Joe,

After the initial installation, the connectionstring was like yours. I read the readme.txt

But I modified it some times to see if that would help. Well, I created a new db, UTF8 charset, but still the same messages in the log. No new ones/success. The html-source is also still the same.

I'm sure it connects to the db, because I modified on purpose the pasword to see what happened, then I received messages about a wrong password. (After that I put it back.)

Could you send me your 'mojoportal.fdb'?

Kind regards,

Bert

8/3/2007 2:08:14 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

I've sent you the file. I should note also that I'm running Firebird-2.1.0.15999_0_win32

Perhaps Firebird 2.1 is needed. The note on the Using Firebird Sql page says it works with 2.0 and above, but that note is leftover from when Garreth first implemented Firebird for mojoPortal 1.x so it could be wrong. I haven't tested with any other versions than the one I have.

Hope it helps,

Joe

8/9/2007 1:23:36 PM

Joe Audette

Total Posts 18409

View Posts

Re: /setup/default.aspx stays empty

Hi Bert,

I had concluded from our previous discussion that mojoPortal only works with Firebird 2.1 beta, but today I uninstalled that version and installed Firebird-2.0.1.12855-1-Win32.exe and it worked fine for me without having to make any syntax changes. I have been working on the setup process so maybe something there had some effect. My changes are in svn trunk so if there is any chance you could test that version it would be very helpful. I want to make a new release soon and I would like to know that it works with Firebird for others who try it as it does for me.

Best Regards,

Joe

8/10/2007 4:35:57 PM

federico

Total Posts 22

View Posts

Re: /setup/default.aspx stays empty

Hi,

I have exactly the same problems that Bert faces; the only difference is that I'm attempting to use MySQL. I tried all the changes in web.config suggested on this thread, but the result is still the same.

I hope this info might at least help tracking the problem.

best regards
Federico