Database Results Wizard Error

[Ted]

Hi
When i try to change a record in a database (FP2003) i get the following
message.

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

The page has been ok for about a year without any problem. Suddenly one day
without doing anything this problem occured. The webhotel has restarted the
domain, uninstalled and reinstalled FP server ext.

The db workes ok when I do searches but when I try to change a record this
happens.

This is what I have in the dbw

UPDATE huvudrubriker
SET hrub_akt_sid1='::frmHrub_akt_sid1::'
WHERE id=::id::

I appreciate any answer
Ted

 

[Harikumar H [MSFT]]

Hi Ted,

The error message is of generic in nature. Please do the following steps
to get a detailed error message.

To turn on the Debug Messages, do the following

1. Ensure the "Show hidden files and folders" option under Tools->Site
Settings->Advanced Tab is turned ON.
2. Open the file _fpclass\fpdbrgn1.inc
3. search for the line (usually line 19),
fp_DEBUG = False
4. replace it to,
fp_DEBUG = True
Now browsing to the page will give you a debug error message.

Hope this helps


regards

Hari
MSFT

This posting is provided "as is" with no warranties and confers no rights

--------------------
| Hi
| When i try to change a record in a database (FP2003) i get the following
| message.
|
| Database Results Wizard Error
| The operation failed. If this continues, please contact your server
| administrator.
|
| The page has been ok for about a year without any problem. Suddenly one
day
| without doing anything this problem occured. The webhotel has restarted
the
| domain, uninstalled and reinstalled FP server ext.
|
| The db workes ok when I do searches but when I try to change a record
this
| happens.
|
| This is what I have in the dbw
|
| UPDATE huvudrubriker
| SET hrub_akt_sid1='::frmHrub_akt_sid1::'
| WHERE id=::id::
|
| I appreciate any answer
| Ted
|
|
|
|
|
|
|
|

 

[Ted]

Thanks Hari
I did this and the message now is:
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

/Ted

 

[Kathleen Anderson [MVP - FrontPage]]

Ted:
You may want to read this thread:
http://www.frontpagewebmaster.com/m-175524/tm.htm

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Ted]

Thanks Kathleen
That was interesting and just what I also found out. I edit my webfiles
again in FP 2000 and saved it and (magic) it juts worked again. I can´t
beleive this is true that an upgrade to FP2003 will cause this kind of
problem do you know if MS is planning to release a permanent fix for this
propblem.
Ted

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Ted:
I don't know if or when they are planning on fixing this. You can submit a
request through the Microsoft Wish Program:
http://support.microsoft.com/default.aspx?kbid=114491

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Thanks Kathleen
That was interesting and just what I also found out. I edit my
webfiles again in FP 2000 and saved it and (magic) it juts worked
again. I can´t beleive this is true that an upgrade to FP2003 will
cause this kind of problem do you know if MS is planning to release a
permanent fix for this propblem.
Ted

Ted:
You may want to read this thread:
http://www.frontpagewebmaster.com/m-175524/tm.htm

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Thanks Hari
I did this and the message now is:
Your page contains a query with user input parameters that could not
be resolved.
This could happen if your DatabaseRegionStart webbot has an empty or
missing s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

/Ted



"Harikumar H [MSFT]" <[email protected]> skrev i
meddelandet Hi Ted,

The error message is of generic in nature. Please do the following
steps to get a detailed error message.

To turn on the Debug Messages, do the following

1. Ensure the "Show hidden files and folders" option under
Tools->Site Settings->Advanced Tab is turned ON.
2. Open the file _fpclass\fpdbrgn1.inc
3. search for the line (usually line 19),
fp_DEBUG = False
4. replace it to,
fp_DEBUG = True
Now browsing to the page will give you a debug error message.

Hope this helps


regards

Hari
MSFT

This posting is provided "as is" with no warranties and confers no
rights

--------------------
Hi
When i try to change a record in a database (FP2003) i get the
following message.

Database Results Wizard Error
The operation failed. If this continues, please contact your
server administrator.

The page has been ok for about a year without any problem.
Suddenly one day without doing anything this problem occured. The
webhotel has restarted the domain, uninstalled and reinstalled FP
server ext.

The db workes ok when I do searches but when I try to change a
record this happens.

This is what I have in the dbw

UPDATE huvudrubriker
SET hrub_akt_sid1='::frmHrub_akt_sid1::'
WHERE id=::id::

I appreciate any answer
Ted

 

[Willem]

Hi Ted, I had the similar problem, and fixed it as follows:
1. The intranet is running IIS 6 on Windows Server. This Intranet suddenly
cracked.
2. I have a Windows 2000 Professional machine, also with IIS. This is used
as a development machine. A new web was created on the WIn2k machine, and
into this web, we copied directly the user folders only (e.g. debtors,
creditors, etc). The Frontpage files inside these folders were copied as is,
but the hidden folders (private etc were deliberately left aside). This "new"
web was then published back to the server and problem suddenly resolved.
I am sure if you create a new web on your intranet server and perform such a
copy, the results will be the same.
Good luck and enjoy a working web!!!!