#9 Can't save pages with MySQL 5.0

[Anonymous]

1. Install openwiking.
   -had to fix SQL syntax for openwiki_referer and
   openwiki_macrohelp in owdb.asp

2. Open wiki in browser.

3. Edit FrontPage and save.

The following error occurs:

The page cannot be displayed
There is a problem with the page you are trying to
reach and it cannot be displayed.

Please try the following:

* Click the Refresh button, or try again later.
* Open the 10.0.0.106 home page, and then look for

links to the information you want.

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 Driver Manager] Invalid string
or buffer length
/bswiki/ow/owdb.asp, line 374

* 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

* Page:
  POST 81 bytes to /bsgwiki/ow.asp


* POST Data:

save=Save&text=%3D%3D+Welcome+%3D%3D&rc=1&comment=&revision=&newrev=1&p=FrontPage

* Time:
  Wednesday, June 28, 2006, 9:37:59 AM


* More information:
  Microsoft Support

---

1. Go back to FrontPage, Edit and Save.

The following error occurs:

The page cannot be displayed
There is a problem with the page you are trying to
reach and it cannot be displayed.

Please try the following:

* Click the Refresh button, or try again later.
* Open the 10.0.0.106 home page, and then look for

links to the information you want.

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

(0x80040E14)
[MySQL][ODBC 3.51
Driver][mysqld-5.0.19-nt]Duplicate entry 'TitleIndex'
for key 1
/bswiki/ow/owdb.asp, line 344

* 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

* Page:
  POST 76 bytes to /bsgwiki/ow.asp


* POST Data:

save=Save&text=%3D+Welcome+%3D&rc=1&comment=&revision=&newrev=1&p=TitleIndex

* Time:
  Wednesday, June 28, 2006, 1:00:43 PM


* More information:
  Microsoft Support