Developer forum

Forum » Development » System.IndexOutOfRangeException: PageNavigationTag

System.IndexOutOfRangeException: PageNavigationTag

E-mail notifications
Ryan Jeppesen
Reply
Posted on 19/08/2011 09:43:02
I have just set up our site in our local test enviroment for testing new features.

I have used the files and database from our online site. But when i try to view the solution local i get a System.IndexOutOfRangeException: PageNavigationTag error (see attachment)

Anyone who can help me?

Thanks in advance

/Ryan 
Unavngivet.png

Replies

 
Pavel Volgarev
Posted on 19/08/2011 09:46:15
Reply
Hi Ryan,

Open /Files/update.xml and change the number in that file to something lower than "425". Save your changes and recycle the application pool.

-- Pavel
 
Ryan Jeppesen
Posted on 19/08/2011 09:58:06
Reply
Hi Pavel

I have already tryed changing update.xml and  UpdateVersion_ecom.xml to 50 and resetting the IIS.

The value of update.xml after reset and refresh is 417 and UpdateVersion_ecom.xml 164

Should i attach the updatelog, can that be used for anything?

/Ryan 
 
Pavel Volgarev
Posted on 19/08/2011 10:05:06
Reply
Hi Ryan,

Yes, that would be great. Please attach the update log (it's huge in size but I only need the bottom pages) as well as the top 10 lines from /Admin/Update/updates.xml.

-- Pavel 
 
Ryan Jeppesen
Posted on 19/08/2011 10:11:38
Reply
Hi Pavel

Here you go :)

/Ryan


 
Pavel Volgarev
Posted on 19/08/2011 10:22:23
Reply
Hi Ryan,

What database type do you use? Is it MS Access or is it SQL Server?

-- Pavel 
 
Pavel Volgarev
Posted on 19/08/2011 10:28:29
Reply
Hi Ryan,

I guess it's SQL Server. I think there is something wrong with the account that you've setup to access the database. Apparently it doesn't have required permissions to execute such queries as "CREATE ..." or "ALTER ...". Please check the permissions and try again.

-- Pavel 
 
Ryan Jeppesen
Posted on 19/08/2011 11:45:03
Reply
Hi Pavel

Yes your right, its a SQL server.

The SQL user account have db_datareader and db_datawriter permission. Do it need any other permissions?

/Ryan
 
Pavel Volgarev
Posted on 19/08/2011 11:52:15
Reply
This post has been marked as an answer
Hi Ryan,

If you say, its in your local test environment then I think it's fine to assign the "db_ddladmin" role to the user. This should fix the issue.

-- Pavel 
Votes for this answer: 0
 
Ryan Jeppesen
Posted on 19/08/2011 12:05:10
Reply
Hi Pavel

Great now it works, but i needed to assign the db_owner to the user also.

Thanks

/Ryan

 

You must be logged in to post in the forum