Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when posting tsql code on a page. #4

Open
TechGuyAlabama opened this issue Jul 28, 2023 · 0 comments
Open

Error when posting tsql code on a page. #4

TechGuyAlabama opened this issue Jul 28, 2023 · 0 comments

Comments

@TechGuyAlabama
Copy link

I can duplicate this issue. When I create a page with only the following:

<codify sql>
CREATE PROCEDURE GetSessionInfoForCurrentDatabase
AS
BEGIN
    DECLARE @CurrentDatabaseName NVARCHAR(128);
    SET @CurrentDatabaseName = DB_NAME();

    SELECT
        sess.session_id,
        host_name,
        sess.database_id,
        @CurrentDatabaseName AS database_name,
        program_name,
        nt_domain,
        login_name,
        connect_time,
        last_request_end_time
    FROM sys.dm_exec_sessions AS sess
    INNER JOIN sys.dm_exec_connections AS conn ON sess.session_id = conn.session_id
    WHERE DB_NAME(sess.database_id) = @CurrentDatabaseName
    ORDER BY program_name;
END;
</codify>

I am getting this message:

Forbidden
You don't have permission to access this resource.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

If I just use the following on a page, I have no issues:

<codify sql>
Using test
</codify>

I'm not sure if you can duplicate it on your end. I can paste other tsql scripts on a page without issue, just not this one.

I'm using shared hosting with Nixihost.com and Dokuwiki was installed with Softilicious. I'm using Release 2023-04-04a "Jack Jackrum".

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant