Posted by: amirag - Thursday, 11 June 2009 01:21:52
Greetings every one,
when I install yaf , I got this database error([b]User does not have permission to perform this action.[/b]) which refer to fulltext.sql
I'm running YAF on goddady.
after finishing the installation, I find that so many features don't created such as
- can't create new users
- there's no administration panel...etc
here's my forum http://psbwa.org/forum/
So, what is this error mean ? what can I do ?
Thanks in advance
Posted by: amirag - Thursday, 11 June 2009 02:07:31
Here's the full error msg
[code]FILE:
fulltext.sql
ERROR:
User does not have permission to perform this action.
Full-Text catalog 'YafSearch' does not exist in database 'psdbwa' or user does not have permission to perform this action.
STATEMENT:
if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) = 1
BEGIN
if not exists (select * from dbo.sysfulltextcatalogs where name = N'YafSearch')
BEGIN
EXEC sp_fulltext_catalog N'YafSearch', N'create'
EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'create', N'YafSearch', N'PK_yaf_Message'
EXEC sp_fulltext_column N'[dbo].[yaf_Message]', N'Message', N'add'
EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'activate'
EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'Start_change_tracking'
EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'Start_background_updateindex'
EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'create', N'YafSearch', N'PK_yaf_Topic'
EXEC sp_fulltext_column N'[dbo].[yaf_Topic]', N'Topic', N'add'
EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'activate'
EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'Start_change_tracking'
EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'Start_background_updateindex'
-- enable in yaf_Registry as a default
IF EXISTS ( SELECT 1 FROM yaf_Registry where [Name] = N'usefulltextsearch' )
UPDATE yaf_Registry SET [Value] = '1' WHERE [Name] = N'usefulltextsearch'
ELSE
INSERT INTO yaf_Registry ([Name],[Value],[BoardID]) VALUES (N'usefulltextsearch','1',NULL);
END
END
[/code]
Posted by: Mek - Thursday, 11 June 2009 07:11:12
You have installed with Full Text Search, and not got that enabled on your sql. Reinstall without ticking that option.
Posted by: amirag - Saturday, 13 June 2009 02:08:24
[quote=Mek] Reinstall without ticking that option.
[/quote]
where's that option "Full Text Search" in YAF v 1.9.1.8, I didn't c it through installation steps
I'll upgrade to v1.9.3
Posted by: amirag - Saturday, 13 June 2009 11:20:43
[b]I installed YAF v1.9.3 (new installation), and I got this exception [/b]
[code] Login failed for user 'PHX3\Iusr_4481723'.
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.Data.SqlClient.SqlException: Login failed for user 'PHX3\Iusr_4481723'.
Source Error:
Line 545: private void FixAccess( bool bGrant )
Line 546: {
Line 547: DB.system_initialize_fixaccess(bGrant);
Line 548: }
Line 549: #endregion[/code]
[b]
is "PHX3\Iusr_4481723" should be one of the aspnet_Users table contents ??
Thank You [/b]
Posted by: mddubs - Saturday, 13 June 2009 13:03:41
Login failed for user 'PHX3\Iusr_4481723'
That means that user doesn't have access to one of your databases.
Posted by: amirag - Saturday, 13 June 2009 13:31:40
[b]ya, and don't know why!
I changed db.config to be like this[/b]
[code]
Posted by: mddubs - Saturday, 13 June 2009 13:52:35
Nice, glad it works. If you want to use Integrated Security, try giving the "NT AUTHORITY/NETWORK SERVICE" login dbo permission to your database.
Posted by: amirag - Saturday, 13 June 2009 14:14:27