airsickmoth
  • Posts: 56
  • Joined: 14/01/2008
Hey, this causes an SQL error when the script gets this far when I am updating a DB that was 1.9.3.x to 1.9.3.3

Line 553 in contraints.sql

if not exists(select 1 from dbo.sysindexes where id=object_id('[{databaseOwner}].[{objectQualifier}User]') and name='PK_{objectQualifier}User')
	alter table [{databaseOwner}].[{objectQualifier}User] with nocheck add constraint [PK_{objectQualifier}User] primary key clustered(UserID)   
go


I commented it out and it finished the upgrade A-OK.

Great update BTW!
Demigod
  • Posts: 59
  • Joined: 02/04/2007
I am attempting to dpgrade from v1.9.1 to v1.9.3.3. I've integrated it into my VS2008 project. I was running the upgrade/install when I received an error.



The parameter 'username' must not contain commas.
Parameter name: username
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: The parameter 'username' must not contain commas.
Parameter name: username

Source Error: 

Line 190:						{
Line 191:							RoleMembershipHelper.SyncRoles( PageBoardID );
Line 192:							RoleMembershipHelper.SyncUsers( PageBoardID );
Line 193:						}
Line 194:						e.Cancel = false;
 
Source File: c:\Projects\Delta\forum\install\default.aspx.cs    Line: 192 


I have found that 2 users have commas in their name. Now that the install has aborted... where do i go from here? If I correct the usernames and start over will it actualy start over and work?
Demigod
  • Posts: 59
  • Joined: 02/04/2007
I fixed the names, erased all the tables, views, procedures and functions that were created and started over. It worked... sort of.

Once it was done I went to view the forum and received this error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Specified cast is not valid. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidCastException: Specified cast is not valid.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[InvalidCastException: Specified cast is not valid.]
   YAF.Classes.Utils.Mession.get_LastVisit() +99
   YAF.Classes.Base.ForumPage.ForumPage_Load(Object sender, EventArgs e) +481
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 


I have NO idea... I do remember altering the original User DB to add a few fields of my own to make the user accounts more integrated into my website, but I don't recall altering the LastVisit field. Any idea on this one?
Demigod
  • Posts: 59
  • Joined: 02/04/2007
I got it to work. How dare I already have a session variable called LastVisit... what was I thinking.

That brings me to another problem. When I go to Log In, the header and footer are there, but there is nothing in between. I've commented out all of the session variables I was using in my site just to make sure it wasn't something else, but it's still not working. I've checked the Event Log table and there is nothing after the last Invalid cast error.
Demigod
  • Posts: 59
  • Joined: 02/04/2007
All is good. I was still dropping cookies with my own code and that seemed to be messing things up.

One thing to add to the docs is to make sure to move all of your themes over to the new system before accessing it.

Oh, one more thing, none of my profile information was moved over during the upgrade. My name, password, email.. that was all moved, but the other stuff About Me, Location, Home page.. all those things seem to be missing from my profile on the upgraded site....
eddr666
  • Posts: 46
  • Joined: 11/08/2007
Installed 1.9.3.3 & it's working, but there is a message error when I try to expand/collapse any windows in the main page - Active Discussions, for example.

It says that there was an error in 'gettitle' function.

I'm using English.
I find it hard.... it's hard to find...
yea, well, whatever.. nevermind..
guest
  • Posts: 448
  • Joined: 18/03/2003
Hello, I'm installing the 1.9.3.3 Alpha and getting a windows dialog error that "Keyword not supported: 'id'."

I'm trying to initialize/upgrade database. This is a new install against SQL 2000.

What do i need to change to make the install work against sql 2000?
guest
  • Posts: 448
  • Joined: 18/03/2003
Sorry, forgot to add where it is occuring.
when installing a new instance it breaks here:

private void FixAccess( bool bGrant )
{
using ( YAF.Classes.Data.YafDBConnManager connMan = new YafDBConnManager() )
Demigod
  • Posts: 59
  • Joined: 02/04/2007
Is there some kind of roadmap for this Alpha version that can give me some idea what kind of progress is being made and when we might see a Beta or final release?
Lac
  • Posts: 66
  • Joined: 29/12/2007
Dear authors, if it will not take a cost, tell please when next build will be posted? 🙂 our users wait it very much 🙂
Demigod
  • Posts: 59
  • Joined: 02/04/2007
So when are we going to see another update to 1.9.3? I'm getting anxious!
ReFleX
  • Posts: 2
  • Joined: 24/11/2007
When will be ready Release version of forum:?:
Ederon
  • Posts: 902
  • Joined: 07/01/2007
I can say for myself I'll try to do something for YAF this week(end).
When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.
UserPostedImage 
Sirusdv
  • Posts: 11
  • Joined: 27/11/2005
Ederon wrote:

I can say for myself I'll try to do something for YAF this week(end).



*crosses fingers*
Demigod
  • Posts: 59
  • Joined: 02/04/2007
Sirusdv wrote:

*crosses fingers*



I'm with ya.
Users browsing this topic
  •  guest (14)
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved