Open Wiki Installation Problems

cWikiLinks

?

SQL Server Installation

I discovered it had to do with upsizing the Access db using SSMA and I must have selected one of the options to create the constraints. I deleted the constraints that began with SSMA and everything is working now.

• Open Wiki/Installation Pages 1 2

Provider error '80004005' 
Unspecified error 
/wiki/ow/owdb.asp, line 53 

• Please double check the permissions on the access db file itself (not only the dir)

• IIS Restart?

Looks like da webserver not is installed! /sEi

'makensis' is not recognized as an internal or external command...

Active Server Pages error 'ASP 0126'
 
Include file not found 

/mywiki/oasscandlew.asp, line 6 

The include file 'ow/owall.asp' was not found. 

<!-- #include virtual="ow/owall.asp" //-->

<!-- #include file="owbase/ow/owall.asp" //-->

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa70 Thread 0xa2c DBC 0x20b1c074 Jet'. 

/web1/owbase/ow/owdb.asp, line 53 

OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=/clients/mysite.com/wwwroot/web1/data/OpenWikiDist.mdb"

OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\clients\mysite.com\wwwroot\web1\data\OpenWikiDist.mdb"

OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath( "OpenWikiDist.mdb")

Error in ow.xsl: The system cannot find the path specified. line: 0 col: 0

 - Asker

Active Server Pages error 'ASP 0126'
 
Include file not found 

/mywiki/ow.asp, line 6 

The include file 'ow/owall.asp' was not found. 

• I have the same problem using W2K Srv with all Windows-Updates. The default Open Wiki works fine, but when I try to create a new site I get the problem. However, I can change the name of the default Wiki from Open Wiki to something else with no problems. vsab/dg July,6 2002

• I am experiencing the same thing on both W2K Server and W2K Pro Workstation running IIS (essentially the ole PWS). Have fiddled with many settings to find a solution. I hope someone will post a soultion soon. 10 JUL 2002

Response object error 'ASP 0156 : 80004005' 

Header Error 

/openwiki/ow/owprocessor.asp, line 325 

I already worked it out. It is all explained in the following link http://support.microsoft.com/default.aspx?scid=kb;en-us;229657 I don't get it myself but I followed the advice and all is working now. I'am happy again.

    Active Server Pages error 'ASP 0223' 

    TypeLib Not Found 

    /openwiki/ow.asp, line 2 

    METADATA tag contains a Type Library specification that does not match any Registry entry. 

HTTP 500.100 - Internal Server Error - ASP error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x8beardedclam0004005)
[Oracle][ODBC]Function sequence error.
/wiki/ow.asp, line 3556



Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; .NET CLR 1.0.2914) 

Page:
POST 77 bytes to /wsausagejockeyiki/Default.asp

The fix is to use the Microsoft Oracle ODBC driver. This would not work for me (it complained I had not installed some components from Oracle). After installing MDAC 2.7, DB2 7.2, re-installing service pack 2 and installing the latest critical updates package the Microsoft Oracle ODBC driver now works and the error goes away... Sigh... Now I know why i like working with MVS and JCL Richard Letts

See /Upgrade? -- lp

     Error: Cannot find the data sources.
     Open the file owconfig.asp in your fav texteditor.
     Make sure you've set the constant OPENWIKI_DB correctly, pointing it to your data sources.

     -2147467259
     Unspecified error

OPENWIKI_DB must have a correct value. If you use a DSN name make sure you've set up a working DSN pointing to the access file in: Start - Control Panel - Administrative Tools - ODBC Data Source Administrator - System DSN

      Error in ow.xsl: The system cannot find the path specified. line: 0 col: 0

I have same error message. Anyone knows why this error occurs? Plz inform me. -- lamb100@korea.com

Posible issue: I had problems with using a DSN, it would die about 80% of the time, but if I give file path directly it would work great. Suggestions?

     msxml2.dll error '80004005'

     Required property does not have a valid value.

     /openwiki/ow.asp, line 756

You've got msxml2 installed. Open Wiki requires that you install msxml3. You can get msxml3 at http://msdn.microsoft.com/xml -- Laurens Pit

I also had MSIE 5.5 installed but still didn't have msxml3 for some reason. Downloading and installing it worked for me. -- Russ Freeman

I'm catching this error now, and will display a nice helpful message. In version 0.73 -- Laurens Pit

     error '8002801d'

     Library not registered.

     /wiki/ow.asp, line 1252

I'm catching this error now, and will display a nice helpful message with a link to the MS knowledge base article. In version 0.73 -- Laurens Pit

• In regedit, search for "regular". (For some reason unknown to me, this does not work in regedt32. Unfortunately, in regedit, you can not change security settings)
• Copy the key, like 3F281000-E95A-11D2-886B-00C04F869F04 and search for in it in regedt32. Uncheck "whole word".
• Check the security settings of the key. There must be a user "everybody" with reading rights. On my machine, this was o.k.
• Open the folder of the key, change to Typelib. There ist another key, like 3F4DACA7-160D-11D2-A8E9-00104B365C9F
• Search for this key, check security settings. And hello, here was the missin link, no user entry. After generating user everybody, rights: read, alle worked fine.

    Error Type:
    Microsoft VBScript compilation (0x800A0411)
    Name redefined
    /openwiki/owconfig.asp, line 4, column 6
                                               -- JimSmith?

There should be exactly one line saying something like:

OPENWIKI_DB = "MySystemDSName"

Make sure you don't have a line like that more than once. Also, make sure the line is not like:

Const OPENWIKI_DB = "MySystemDSName"

-- Laurens Pit

OPENWIKI_DB = "File Name=D:\PATH\OpenWiki.udl"

-- Per Soderlind

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. 

/openwiki/ow.asp, line 3414 

check the properties of the Access file (openwiki.mdb), the attribute Read-Only should be unchecked. If that doesn't help, run the Permissions Wizard in IIS for your website. -- lp

I had to start the Internet Service Manager, enable the write access and set a local account with proper access rights for IUSR_computername as a anonymous user -- Leopold Faschalek

• created a remote directory in openwiki using the Internet information Services tool,

• created a system DSN to the network drive (which is mapped on my machine)

  OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=/openwiki/remote/OpenWiki?.mdbOpen Wiki.mdb"
  OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\Inetpub\wwwroot\openwiki\remote\Open Wiki.mdb"
  OPENWIKI_DB = "OPENWIKI" ' called the ODBC thingy "OPENWIKI"

The default install would be:
  OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\OpenWiki\data\OpenWikiDist.mdb"

Here is what it would be for MSSQL:
  OPENWIKI_DB = "Driver={SQL Server};server=localhost;uid=openwiki;pwd=openwiki;database=OpenWiki"

OPENWIKI_DB = "OPENWIKI"

Error: Cannot find the data sources.
Open the file owconfig.asp in your fav texteditor.
Make sure you've set the constant OPENWIKI_DB correctly, pointing it to your data sources.

OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\inetpub\wwwexttest\openwiki\data\OpenWiki.mdb"

Invalid XML document:

Switch from current encoding to specified encoding not supported. line: 1 col: 44

OPENWIKI_DB = "Driver={SQL Server};server=mymachine;uid=OpenWikiPublic;pwd=XXX;database=OpenWikiPublic"

I have no idea just now, we're using the same setup without problems. The error you get is described at MSKB:q275883 though, maybe that helps?

Andrew Finkenstadt and Steve Andersen wrote me suggesting that the problem was my version of the XML Parser. I upgraded to MS XML Parser 3 SP 2 and rebooted the machine. Now it all works . I never did resolve why I couldn't make the Access database work, but I'm happy with SQL. Any reason not to upgrade further to MSXML 4? -- Al Gaspar

I am using MSXML 4 and it works fine with Open Wiki (change the MSXML_VERSION variable in owconfig.asp). -- Nate Silva

If they've also got MSXML v3 SP 2 or higher installed, then I see no reason why not. Simply upload all the files, and change the values in file owconfig_default.asp. -- lp

• open up owconfig_default.asp and go to this line and set it to '1' (as per the comment):

cAllowAttachments     = 1        ' 1 = allow attachments     0 = do not allow attachments (WARNING: Allowing attachments poses a security risk!! See file owattach.asp)

• create a directory called 'attachments' inside your base openwiki directory (ie the root directory where openwiki resides)
• go to http://www.websupergoo.com/ and download ABCUpload - and install (you will be prompted to go to this page if you try to upload attachments and it is not installed).
• Bob's your uncle! You can use attachments
• What verson? ABCUpload.net or ABCUpload.asp? You didn't specify. It's also $30.00. -- Gary

please see the info in the next block below as it contains further information that I was not aware of if you have any problems...

Open Wiki NG have several upload functions implemented. Also a com less version! --sEi

Perhaps you could provide a link to some instructions that show how to install attachments, because I can't find any at the link you provided! -- PF

Getting the latest build of Open WIki NG - SEE HERE --/sEi

1. You may need to manually create the "attachments" directory.
2. If you have installed using SQL Server, be sure to set OPENWIKI_DB_SYNTAX = DB_SQLSERVER in owconfig_default.asp.

Thanks for the heads-up, I neglected to say that I did indeed create that directory manually. Also the infor re: SQL server is very useful as I'm hoping to migrate my openwiki db there soon... -- Daniel Thomas

If you're looking for config help on settings etc. The best bet is to look in owconfig_default.asp - this is where most of your config settings are found. As for an actual help file - I don't think there is one. Help on formatting, etc is located inside openwiki itself. It's prolly a good idea to specify the config options in a file on this site, something like "open Wiki Configuration Help". Thoughts? -- Daniel Thomas

Import the data from the MSAccess version - the SQL Server version is just empty tables so won't have any of the default entries. -- Jack Stockholm

[Microsoft][ODBC Microsoft Access Driver] The microsoft Jet database engine cannot open the
file '(unknown)'. It is already opened exclusively by another user, or you need permission 
to view its data.

Else
  Set vConn = Server.CreateObject("ADODB.Connection")
  vConn.Open OPENWIKI_DB
  Set vRS = Server.CreateObject("ADODB.Recordset")
End If

'Exclusive mode' is related not to file permissions but .ldb. When you open the database via the MSAccess interface, the File->Open dialog offers a checkbox 'Exclusive' - this may be your problem? If the file is not open in MSAccess, try deleting the .ldb file. Also, ADO for MSAccess requires a default username of 'Admin' with a blank password. If that 'Admin' username isn't specified, it might cause an error. -- Jack Stockholm

Microsoft OLE DB Provider for ODBC Drivers Fehler '80004005' 

[Microsoft][ODBC Microsoft Access Driver] Operation muss eine aktualisierbare Abfrage verwenden. 

/wikiwiki/ow/owdb.asp, line 353

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/OpenWiki/ow/owdb.asp, line 353

UPDATE openwiki_pages SET wpg_changes = wpg_changes + 1, wpg_lastminor = 4, wpg_lastmajor = 4 WHERE wpg_name = 'FrontPage'

• My Computer

• Tools Menu

• Folder Options

• View tab

• Scroll to the bottom and untick "Use Simple File Sharing"

• Click OK

The options we have checked are: "Don't optimize column width", "Return matching rows", "Allow BIG results" and "Safety (Check this if you have problems)". The rest is unchecked. -- lp

When you execute the following command in the My SQL interface, what is the result you get? And which ADO DB version are you using? -- lp

SELECT * FROM openwiki_revisions WHERE wrv_name = 'FrontPage' AND wrv_current = 1

Invalid XML document:

The following tags were not closed: ow:wiki, ow:page, ow:body. line: 0 col: 0

Check out MSKB:q238971. I don't quite understand your last question..? -- lp

In my config file I have the following two lines:

OPENWIKI_DB = "MySQLOpenWiki"
OPENWIKI_DB_SYNTAX = DB_MYSQL

Then in the ODBC Data Source Administrator from Windows I've got a System DSN defined with the name "MySQLOpenWiki?" which is using the My SQL ODBC driver with the following options checked: "Don't optimize column width", "Return matching rows", "Allow BIG results" and "Safety (Check this if you have problems)". The rest is unchecked. -- lp

The website is running on a 600 Mhz, 512 MB, 30Gb HD machine (it's hosting many websites). The MSSQL Server is running on the same machine. The openwiki site that uses My SQL uses My SQL which is installed on a different (unix) machine -- lp

I'm pretty sure the problem is not that your machine might not be fast enough. I've developed Open Wiki on a machine with "only" 128 Mb, 8Gb HD. Supposing it takes 10 seconds the first time you access the recent changes page, then it cannot take the same amount of time the second time you access that page, as pages are cached (in the database), therefor typically you should get the page within a few milliseconds. The cache is cleared only when a page is created and/or updated. Do you experience the same slowness when you use an Access database? -- lp

• owattach.asp

In your IE browser, choose menu options Tools - Internet Options, choose tab Advanced, and uncheck "Show friendly HTTP error messages". Then try to access the wikipage again. Which error message do you get now? -- lp

  :Server Application Error
     The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.
     Checking Event log I get:

     Funny thing is '/LM/W3SVC/1/Root?/' is not a path I recongnize....

The above occurs because there is an application defined for the Virtual folder, so IIS is looking for a .asa file that doesn't exist. Make sure the text box is empty on the Virtual Folder definition, or hit the Remove button if there is one.

You can use the tilde ( ~ ) prefix to tell Open Wiki to not Wikify the following word. Also, you can delimit any phrases you don't want Wikified with the nowiki tag: -- Oddible

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services


Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/OpenWiki/ow/owdb.asp, line 53

See some suggestions in same answer above...

• Temp Clean Inst Probs - working on cleaning this page up a bit -- Oddible

1. Method 1:
1. Double-click your starting page, and an editing area should come up
2. At the end of the editing area, type the macro: <goto> then hit 'Save'
3. You should now have a little input box and button on the page.
4. Type a new page name (like 'NewPage?') in the box and click the button. You should then have made a new page!
2. Method 2:
1. Edit the URL at the top of the page. Just after 'ow.asp' type a question mark followed by the name of your new page

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/wiki/ow/owdb.asp, line 353

           vConn.Open "Provider=MSDataShape?;DBQ=" & server.mappath("\openwiki\openwikidist.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId?=25;FIL=MS Access;MaxBufferSize?=2048;PageTimeout?=5;UID=admin;"

1. In the details pane, click the Web service extension that you want to enable or disable, and then do one of the following:

• To enable a disabled Web service extension, click Allow, and then click OK.
• To disable an enabled Web service extension, click Prohibit, and then click OK
• Basically select Allow for ASP and voila!

cWikiLinks

 cFreeLinks            = 1        ' 1 = use [[word]] links    0 = LinkPattern only
 cWikiLinks            = 1        ' 1 = use LinkPattern       0 = possibly allow [[word]] only

Please provide a value for OPENWIKI_DB in your owconfig.asp file.

  --  Ah, I believe I have found the problem.  It's over in owdb.asp, I think:

        If cWikiLinks = 0 Then
            Set GetPage = New WikiPage
            GetPage.AddChange
            GetPage.Name = "FrontPage"
            GetPage.Text = "Please provide a value for OPENWIKI_DB in your owconfig.asp file."
            Exit Function
        End If

?

   -2147217865
   [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'openwiki_pages'.

SQL Server Installation

OPENWIKI_DB = "Driver={SQL Server};server=myservername;uid=wikisite1;pwd=wikisite1;database=wikisite1"
OPENWIKI_DB_SYNTAX = DB_SQLSERVER

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/ow/owpage.asp, line 365


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) 

Page:
GET /poolwiki/openwiki/web1/Default.asp 

Time:
Thursday, August 18, 2005, 3:59:08 PM 

• Error Type:

Microsoft VBScript runtime (0x800A0C93)
Unknown runtime error
/openwiki/ow/owpage.asp, line 365

• Browser Type:

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4

INSERT openwiki_revisions (wrv_name, wrv_revision, wrv_current, wrv_status, wrv_timestamp, wrv_minoredit, wrv_host, wrv_agent, wrv_by, wrv_byalias, wrv_comment, wrv_text)
SELECT        wrv_name, 
                wrv_revision, 
                wrv_current, 
                wrv_status, 
                wrv_timestamp, 
                wrv_minoredit, 
                wrv_host, 
                wrv_agent, 
                wrv_by,
                wrv_byalias, 
                LEFT(wrv_comment,1024) AS wrv_comment, 
                wrv_text
FROM openwiki_revisions_raw