Print Page | Close Window

Forum big problem.

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5849
Printed Date: 03 April 2026 at 6:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Forum big problem.
Posted By: chinguyen
Subject: Forum big problem.
Date Posted: 19 September 2003 at 10:25am

I unzip and put the forum folder in my server as instructed.

It ruan beautifully. I login as administrator and make some initial setup, change admin username and pwd.  Logout, register few new users, make some posts, log all out,  Browse other site.  Back to my forum, No problem. Every user still can log in including the administrator (as expected)

But When I shut down the server then on again, the forum CRASH ! It shows, but can not do anything, cannot login, can not register !!!

When I login I got this error message:

=====

  • Error Type:
    Microsoft JET Database Engine (0x80004005)
    Operation must use an updateable query.
    /old/forum1/common.asp, line 403

  • Browser Type:
    Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.0.3705)

  • Page:
    GET /old/forum1/Default.asp
  • ===

    I'm running windows 2000 professional sevice pack 4 with IIS

    my test site is: http://nguoiviet.no-ip.info/old/forum1 - http://nguoiviet.no-ip.info/old/forum1

    It looks to me like I need update something

     

    PS: If I did not turn of the server or reboot the server then the forum runs perfectly




    Replies:
    Posted By: ljamal
    Date Posted: 19 September 2003 at 11:02am
    If you had read the documentation that comes with the forum or searched this site or Google then you would know that this is a permissions problem. You will need to give write permissions to the folder containing the database.

    -------------
    L. Jamal Walton

    http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming


    Posted By: chinguyen
    Date Posted: 19 September 2003 at 8:18pm

    Thanks for your reply.

    But the folder of my Dbase WAS already grant FULL access (Read, write and other stuffs) to: administrator, everyone and system.

    As I described: If I did not reboot the system, then all info and data to the data base were saved (member register, posts ...) I check the database and see that it is updated.

    Only when I reboot the server, then I got that problem. I'm running win 2000 professional, with IIS

    I think I need to update some SQLserver stuffs (?)

     



    Posted By: dpyers
    Date Posted: 19 September 2003 at 10:39pm
    If you're running MSSQL, make sure it's started and that you're using the right connection string.

    -------------

    Lead me not into temptation... I know the short cut, follow me.


    Posted By: WebWiz-Bruce
    Date Posted: 20 September 2003 at 2:42am

    It's not everyone you need to grant the permissions for, this is why you are probably getting the update error.

    You need to grant full access to the IUSR account on the directory containing the access database and the database.



    -------------
    https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
    https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


    Posted By: chinguyen
    Date Posted: 20 September 2003 at 8:28am

    To Dpyers: Your reply makes me download MySQL and isntall to my server (I'm using win2000 pro only).

    To  boRg: I follow your instruction to grant the full access to IUSR acct instead of everyone

    I then reboot my system: my FORUM WORKS. 

    THanks to all of you, my forum always "died" when I reboot, so, I dare not reboot it, and that was why I did as both of you told me (MySQL and IUSR acct). Now it works and really don't know which really causes. 

    Once again, thanks for all, I'm happy man now.



    Posted By: WebWiz-Bruce
    Date Posted: 20 September 2003 at 8:56am

    The fourm doesn't support mySQL only Microsoft Access and Microsoft SQL server version 7 and 2000.

    mySQL and MS SQL server are two different products.



    -------------
    https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
    https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


    Posted By: chinguyen
    Date Posted: 20 September 2003 at 9:34am

    hi boRg

    I installed "mySQL-4.0.15-win" and now I know that it is different than MS SQL ! So my forum works for the reason of reset full access to my IUSR acct.

    Thanks so much, bottom line is my forum is working. I'm happy now



    Posted By: chinguyen
    Date Posted: 25 September 2003 at 1:09pm

    To -boRg- :

    I ran my forum for 5 days beautifully, reboots after reboots, still running.

    This morning, I login the forum, make some admin changes (from a remote computer) log out and run OK.

    THe server never turns off again, but now I get same problem a before, cannot open the database!

    I already install MDAC 2.8, download from microsoft. Myserver doen't have MS Office installed

    The databse folder and the database itselft were granted Read write to IUSR_ acct

    Please help




    Print Page | Close Window

    Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
    Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net