Q: I am getting an error while loading the forum right after the database installation. The error shows the following:
Cannot find table 0.
Description: Anunhandledexception occurred during the execution of the current webrequest.Please review the stack trace for more information about theerror andwhere it originated in the code.
Exception Details: System.IndexOutOfRangeException: Cannot find table 0.
Source Error:
An unhandled exception was generated during the execution of thecurrent web request. Information regarding the origin and location ofthe exception can be identified using the exception stack trace below.
Stack Trace:
[IndexOutOfRangeException: Cannot find table 0.]
System.Data.DataTableCollection.get_Item(Int32 index) +58
ASPPG.Data.DAL.InitializeApplicationVariables(Hashtable objDict) in H:\My Document\Visual Studio 2008\Projects\forumu\Utility\Data_DAL.vb:1293
ASPPG.Data.ApplicationDataRelated.loadApplicationVariables(Hashtable objDict) in H:\My Document\Visual Studio 2008\Projects\forumu\Utility\Data_ApplicationRelated.vb:68
ASPPG.Data.ApplicationDataRelated.ApplicationsHash() in H:\My Document\Visual Studio 2008\Projects\forumu\Utility\Data_ApplicationRelated.vb:55
ASPPG.PGDSessionHandler.sessionHeartBeat(Object Sender, EventArgs e) in H:\My Document\Visual Studio 2008\Projects\forumu\Utility\HM_PGDSessionHandler.vb:55
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
A: To resolve this problem, try setting the
DBOwnerPrefix to "" (blank) in your web.config file, like this:
<add key="DBOwnerPrefix" value="" />
And try loading the software again.
Also, you should be able to find an error log under ~/upfiles/logs/ that contains a line similar to this:
System.Data.SqlClient.SqlException: Could not find stored procedure 'xxxx.spFetchConfig'.
This tells you that you set the
DBOwnerPrefix wrong. "
xxxx."is your current value, and you should change it to the correct schema (from SQL Management Studio) or just leave it blank.
<message edited by Samuel on 08/08/2008 06:18:40 PM>