YAF v1.9.3.3 ALPHA (UPDATED: 2/6/2008)· Page 9

airsickmoth
86% (Honored)
YAF Forumling

15 years ago

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
95.60001% (Exalted)
YAF Commander

15 years ago

#122

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
95.60001% (Exalted)
YAF Commander

15 years ago

#123

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
95.60001% (Exalted)
YAF Commander

15 years ago

#124

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
95.60001% (Exalted)
YAF Commander

15 years ago

#125

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
84.8% (Honored)
YAF Forumling

15 years ago

#126

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
Guest

15 years ago

#127

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
Guest

15 years ago

#128

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
95.60001% (Exalted)
YAF Commander

15 years ago

#129

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?