|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
Hello Clean installation of 1.9.3 Beta gives the following error:  Windows XP SP2 SLQ 2000 SP4 Regards touradg "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
|
Interested... I just tested a fresh install of v1.9.3 BETA. I didn't test on SQL 2000 though... "When you are grateful, fear disappears and abundance appears”." 
|
|
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
|
Got it... Just open up the tables.sql file and modify this line: Code:
DROP INDEX [IX_{objectQualifier}User_ProviderUserKey] ON [{databaseOwner}].[{objectQualifier}User]
and change to... Code:
DROP INDEX [{databaseOwner}].[{objectQualifier}User].[IX_{objectQualifier}User_ProviderUserKey]
"When you are grateful, fear disappears and abundance appears”."
|
|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
Hi Jaben, Fixed.Now this one:  "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
any idea? "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
Hi I really don't want to create overhead for yaf developers but I simply can not test and translate this beta. The script is just ok in SQL2005 but not in SQL2000.Most of my friends have the same problem on 2000. I googled it and tried to fix the script but with no luck.I guess that it happens because of the fact that In a DELETE, INSERT, or UPDATE command, SQL Server (2000) does not allow text, ntext, or image column references in the inserted and deleted tables.I found an interesting aarticle here which may help you: Managing ntext, text, and image Data in SQL2000Regards Touradg "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: Advanced Member
Joined: 8/31/2007
Posts: 50
Location: Persia (Iran) the land of Greater cyrus
|
help me plz : 
|
|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
rtech wrote:help me plz : This is the first problem i had.See the third reply by the jaben. "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
|
herman_herman wrote:any idea?
Try replacing (in procedures.sql) with this and re-running install: Code:
create procedure [{databaseOwner}].[{objectQualifier}board_poststats](@BoardID int) as
BEGIN
SELECT
Posts = (select count(1) from [{databaseOwner}].[{objectQualifier}Message] a join [{databaseOwner}].[{objectQualifier}Topic] b on b.TopicID=a.TopicID join [{databaseOwner}].[{objectQualifier}Forum] c on c.ForumID=b.ForumID join [{databaseOwner}].[{objectQualifier}Category] d on d.CategoryID=c.CategoryID where d.BoardID=@BoardID AND (a.Flags & 24)=16),
Topics = (select count(1) from [{databaseOwner}].[{objectQualifier}Topic] a join [{databaseOwner}].[{objectQualifier}Forum] b on b.ForumID=a.ForumID join [{databaseOwner}].[{objectQualifier}Category] c on c.CategoryID=b.CategoryID where c.BoardID=@BoardID AND (a.Flags & 8) <> 8),
Forums = (select count(1) from [{databaseOwner}].[{objectQualifier}Forum] a join [{databaseOwner}].[{objectQualifier}Category] b on b.CategoryID=a.CategoryID where b.BoardID=@BoardID),
Members = (select count(1) from [{databaseOwner}].[{objectQualifier}User] a where a.BoardID=@BoardID AND (Flags & 2) = 2 AND (a.Flags & 4) = 0),
MaxUsers = (SELECT CAST([Value] as nvarchar(255)) FROM [{databaseOwner}].[{objectQualifier}Registry] WHERE LOWER(Name) = LOWER('maxusers') and BoardID=@BoardID),
MaxUsersWhen = (SELECT CAST([Value] as nvarchar(255)) FROM [{databaseOwner}].[{objectQualifier}Registry] WHERE LOWER(Name) = LOWER('maxuserswhen') and BoardID=@BoardID),
LastPostInfo.*,
LastMemberInfo.*
FROM
(
SELECT TOP 1
LastMemberInfoID= 1,
LastMemberID = UserID,
LastMember = [Name]
FROM
[{databaseOwner}].[{objectQualifier}User]
WHERE
(Flags & 2) = 2
AND (Flags & 4) = 0
AND BoardID = @BoardID
ORDER BY
Joined DESC
) as LastMemberInfo
left join (
SELECT TOP 1
LastPostInfoID = 1,
LastPost = a.Posted,
LastUserID = a.UserID,
LastUser = e.Name
FROM
[{databaseOwner}].[{objectQualifier}Message] a
join [{databaseOwner}].[{objectQualifier}Topic] b on b.TopicID=a.TopicID
join [{databaseOwner}].[{objectQualifier}Forum] c on c.ForumID=b.ForumID
join [{databaseOwner}].[{objectQualifier}Category] d on d.CategoryID=c.CategoryID
join [{databaseOwner}].[{objectQualifier}User] e on e.UserID=a.UserID
WHERE
(a.Flags & 24) = 16
AND (b.Flags & 8) <> 8
AND d.BoardID = @BoardID
ORDER BY
a.Posted DESC
) as LastPostInfo
on LastMemberInfoID=LastPostInfoID
END
GO
"When you are grateful, fear disappears and abundance appears”."
|
|
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
|
Let me know if that works... "When you are grateful, fear disappears and abundance appears”."
|
|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
Hello Jaben, It worked. Good job. I got couple of more db installation errors. What I did was to just remove each section that had error to go on with the rest of the scripts and to check all of them at one. Here is the result: After fixing the second problem by using “SELECT CAST([Value] as nvarchar(20))” I came to another similar one at line 3687 file procedures.sql:  I remove the procedure to go on with the rest of the scripts and it brought me to this at line 106 file Providers/Tables.sql:  As you can see both are very similar to those we already have. I tried to fix using the methods you have used but I jut end up syntax error  I didn’t get any other error after that. But I was not able to run the forum too. It gave me some errors regarding different variables (Null to string), which is quite normal as I have removed some procedures and tables. And therefore variables do not exist. Regards Touradg "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: Advanced Member
Joined: 8/31/2007
Posts: 50
Location: Persia (Iran) the land of Greater cyrus
|
Jaben wrote:Let me know if that works... thanks , but now this error : 
|
|
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
|
Hey guys... Try the updated attached SQL. It replaces SQL in \provider too. "When you are grateful, fear disappears and abundance appears”."
|
|
|
Rank: YAF All-the-Time
Joined: 5/19/2007
Posts: 186
Location: Persia (Iran) the land of Greater Darius
|
Hi Now this one:  "Our greatest glory is not in never falling but in rising every time we fall - Confucius"
|
|
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
|
Messed up on that one. I updated the SQL again -- try download one more time "When you are grateful, fear disappears and abundance appears”."
|
|
|
| Users browsing this topic |
|
Guest
|