Skip to main content
A
Anonymous
June 24, 2007
Answered

DW CS3 Insert Record/Update Record: Record Form Wizard Error

  • June 24, 2007
  • 3 replies
  • 3244 views
I have just bought Dreamweaver CS3 and I am running into some problems. I also have Dreamweaver MX 2004. When I use the Insert Record: Record Insertion Form Wizard on my Dreamweaver MX 2004 I have no problems using the Insert Record function. However, when I use the Dreaweaver CS3, I am running into errors. The error I am getting is the following..."Apache HTTP Server has encountered a problem and needs to close. We are sorry for the inconvenience."

As well, when I use the update form wizard, when you place all your settings and place a redirection after updating to a page it does not do it, it stays on the same page and gives me the following error..."Warning: Cannot modify header information - headers already sent in C:\wamp\www\edit.php on line 50".

This happens on all internet browsers when I want to insert a new record. It takes a long time to load the page and then it finally gives me an error which I stated above. I never had a problem before. I thought maybe I installed the application wrong, so I unistalled and reinstalled the DW CS3. I still get the same issue. I became so frustrated that I formatted my hard drive thinking make I have a adware or spyware, so to be cautious I formatted my computer and installed everything with a fresh install and still I get this error. Now my testing server that I use is called WAMP. I never had problems with it before using DW MX 2004 or when I used the trial of DW 8. So now I am out of options. Is there a glitch in the new CS3 Web Premium that includes DW CS3 upgrade software and if there is, is there a download. Can anyone help me, please.
This topic has been closed for replies.
Correct answer Newsgroup_User
AdonaiEchad wrote:
> For example. In the insert page in MX2004 I do not need to
> make a recordset, however, for the CS3 insert page I noticed when I use the
> insert record form wizard it does not work unless I make a recordset where in
> MX2004 I did not need to do this.

You don't need a recordset to insert a new record.

> I noticed that in the following code difference in...
> MX2004 = <?php echo $row_rsTest['test']; ?>
> CS3 = <?php echo htmlentities($row_rsTest['test'], ENT_COMPAT, 'utf-8'); ?>
> There is a big difference.

No there isn't. Read the PHP manual for htmlentities():

http://www.php.net/manual/en/function.htmlentities.php

All that the extra code is doing is making your code safer.

> MX2004 - add.php
>
> <?php require_once('../Connections/conTest.php'); ?>

> CS3 - add.php
>
> <?php virtual('/Connections/conTest.php'); ?>

The preceding two lines are the most important change. It means that you
have set your site definition to use links relative to the site root in
CS3, instead of relative to the document in MX 2004. The virtual()
function works only if you are using PHP as an Apache module.

Try switching your site definition back to using document-relative
links, get rid of all existing files in your Connections folder, and
start again.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

3 replies

N
Newsgroup_User
Inspiring
June 24, 2007
Nancy - Adobe Comm. Expert wrote:
> The server behaviors were
> significantly changed in 8.02 and beyond for ASP. Is the same true for PHP?

Yes. That's what I said. The server behaviors in CS3 are the same as in
8.0.2.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
N
Newsgroup_User
Inspiring
June 24, 2007
The OP was using DMX 2004, though, correct? The server behaviors were
significantly changed in 8.02 and beyond for ASP. Is the same true for PHP?

--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"David Powers" <david@example.com> wrote in message
news:f5mab9$3fk$1@forums.macromedia.com...
> AdonaiEchad wrote:
>> When I use the Insert Record: Record Insertion Form Wizard on my
>> Dreamweaver MX 2004 I have no problems using the Insert Record function.
>> However, when I use the Dreaweaver CS3, I am running into errors. The
>> error I am getting is the following..."Apache HTTP Server has encountered
>> a problem and needs to close. We are sorry for the inconvenience."
>
>> Is there a glitch in the new DW CS3 and if there is, is there a download.
>
> None that I am aware of. I have been using CS3 for a very long time
> without problems. The code that it generates for Insert Record is
> identical to Dreamweaver 8.0.2.
>
> --
> David Powers, Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/


A
Anonymous
June 24, 2007
It looks like on my end it does also change for PHP. I do not know why I am getting the error.

David, quick question. I was told by Adobe that my upgrade for CS3 Web Premium I do not need to have the acutual Studio MX 2004 on my computer, I just need the license key. Could not having the actual Dreamweaver MX 2004 application cause this error. Adobe told me that I do not need to have the Dreamweaver MX 2004 on my computer. When I installed my CS3 Web Premium it was installed with no Studio MX 2004. All my other applications from CS3 work fine except Dreamweaver CS3.
N
Newsgroup_User
Inspiring
June 24, 2007
AdonaiEchad wrote:
> When I use the Insert Record: Record Insertion Form
> Wizard on my Dreamweaver MX 2004 I have no problems using the Insert Record
> function. However, when I use the Dreaweaver CS3, I am running into errors.
> The error I am getting is the following..."Apache HTTP Server has encountered a
> problem and needs to close. We are sorry for the inconvenience."

> Is there a glitch in the new DW CS3 and if there is, is there
> a download.

None that I am aware of. I have been using CS3 for a very long time
without problems. The code that it generates for Insert Record is
identical to Dreamweaver 8.0.2.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
A
Anonymous
June 24, 2007
Please bare with me David. I know something is wrong because I have made two folders, one that is done in MX2004 and the other done in CS3. CS3 is generating errors. For example. In the insert page in MX2004 I do not need to make a recordset, however, for the CS3 insert page I noticed when I use the insert record form wizard it does not work unless I make a recordset where in MX2004 I did not need to do this. I've created a add.php and a edit.php of MX2004 and CS3. I will place it in the attach code so you can see side by side what it is generating. I can see that there are a few things that CS3 does change and some how it is making my internet browsers show an error saying......"Warning: Cannot modify header information - headers already sent in C:\wamp\www\edit.php on line 50".

What do I do?

I noticed that in the following code difference in...
MX2004 = <?php echo $row_rsTest['test']; ?>
CS3 = <?php echo htmlentities($row_rsTest['test'], ENT_COMPAT, 'utf-8'); ?>
There is a big difference.


My database is the following...

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 24, 2007 at 04:29 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mysample`
--
CREATE DATABASE `mysample` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `mysample`;

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

--
-- Table structure for table `test`
--

CREATE TABLE `test` (
`testID` int(11) NOT NULL auto_increment,
`test` longtext NOT NULL,
PRIMARY KEY (`testID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`testID`, `test`) VALUES
(3, 'Sample Test');

=======================================================================
I use the program called WAMP.
=======================================================================


PHP PAGES
----------------
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices