8 Replies Latest reply: Jun 25, 2007 4:44 AM by Newsgroup_User RSS

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

    AdonaiEchad Community Member
      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.
        • 1. Re: DW CS3 Insert Record: Record Insertion Form Wizard Error
          Community Member
          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/
          • 2. Re: DW CS3 Insert Record: Record Insertion Form Wizard Error
            AdonaiEchad Community Member
            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
            ----------------
            • 3. Re: DW CS3 Insert Record: Record Insertion Form Wizard Error
              Community Member
              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/


              • 4. Re: DW CS3 Insert Record: Record Insertion Form Wizard Error
                Community Member
                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/
                • 5. DW CS3 Insert Record/Update Record: Record Form Wizard Error
                  AdonaiEchad Community Member
                  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.
                  • 6. Re: DW CS3 Insert Record: Record Insertion Form Wizard   Error
                    Community Member
                    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/
                    • 7. Re: DW CS3 Insert Record: Record Insertion Form Wizard   Error
                      AdonaiEchad Community Member
                      Thank you David, that really helped. My links relative to was set on Site Root rather than Document. It works now. I am trying to learn and I thank you for your patience on this matter specially being a novice at this stuff.
                      • 8. Re: DW CS3 Insert Record: Record Insertion Form Wizard     Error
                        Community Member
                        AdonaiEchad wrote:
                        > Thank you David, that really helped. My links relative to was set on Site Root
                        > rather than Document. It works now. I am trying to learn and I thank you for
                        > your patience on this matter specially being a novice at this stuff.

                        Glad the answer was so simple. Unfortunately, the code used for
                        site-root-relative links isn't universally supported. I've tried to
                        persuade Adobe to change this, but so far without success.

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