Skip navigation
Currently Being Moderated

Firefox fails to display form content from mysql

Apr 9, 2012 7:39 AM

Firefox 11 is failing to display text from a mysql dbase.  Within the form there are various text boxes and text areas that function correctly, but one text area that remains inert. No content from the dbase and will not display flashing curser. It functions OK in IE8.  I can see no reason for this.  Can you?

The code of the whole code is quoted below. I have enboldened the relevant miscreant line.

:

  <td colspan="2" rowspan="10"><form name="form1" method="POST" action="<?php echo $editFormAction; ?>">

      <table width="100%"  border="0" cellspacing="0" cellpadding="2">

        <tr>

          <td width="20%" class="right_cell">**Name of Organisation or Service:</td>

          <td colspan="4"><input name="cel_org" type="text" id="cel_org" onBlur="MM_validateForm('textfield','','R','textarea','','R');return document.MM_returnValue" value="<?php echo $row_rstUpEntry['cel_org']; ?>" size="60" maxlength="60">

      Town

        <input name="ck_town" type="text" id="ck_town" value="<?php echo $row_rstSix['ck_town']; ?>" size="20" maxlength="20"></td>

        </tr>

        <tr>

          <td class="right_cell">Telephone Number: </td>

          <td colspan="4"><input name="cel_tel" type="text" id="cel_tel" value="<?php echo $row_rstUpEntry['cel_tel']; ?>" size="30"></td>

        </tr>

        <tr>

          <td class="right_cell">Fax Number : </td>

          <td colspan="4"><input name="cel_fax" type="text" id="cel_fax" value="<?php echo $row_rstUpEntry['cel_fax']; ?>"></td>

        </tr>

        <tr>

          <td class="right_cell">Helpline Number :</td>

          <td colspan="4"><input name="cel_hlp" type="text" id="cel_hlp" value="<?php echo $row_rstUpEntry['cel_hlp']; ?>"></td>

        </tr>

        <tr>

          <td class="right_cell">Email address: </td>

          <td colspan="4"><input name="cel_email" type="text" id="cel_email" value="<?php echo $row_rstUpEntry['cel_email']; ?>" size="40"></td>

        </tr>

        <tr>

          <td class="right_cell">Website address:<br>

      Please use format www.etc.....</td>

          <td colspan="4"><input name="cel_web" type="text" id="cel_web" value="<?php echo $row_rstUpEntry['cel_web']; ?>" size="75" maxlength="100"></td>

        </tr>

        <tr>

          <td class="right_cell"><p>Address of Organisation:<br>

        (on single line) </p></td>

          <td colspan="4"><input name="cel_add" type="text" id="cel_add" value="<?php echo $row_rstUpEntry['cel_add']; ?>" size="75" maxlength="100"></td>

        </tr>

        <tr>

          <td class="right_cell"><p>**Description of your service:<br>

          </p></td>

          <td colspan="4" class="top_cell"><textarea name="cel_blb" cols="75" rows="8" id="cel_blb"><?php echo $row_rstUpEntry['cel_blb']; ?></textarea></td>

        </tr>

        <tr>

          <td class="right_cell">Message for email if there are handouts: </td>

          <td colspan="4" class="top_cell"><input name="cel_hndts" type="text" id="cel_hndts" value="<?php echo $row_rstUpEntry['cel_hndts']; ?>" size="100" maxlength="200"></td>

        </tr>

        <tr>

          <td class="right_cell"><h3>Contact Details</h3></td>

          <td colspan="4" class="top_cell"> </td>

        </tr>

        <tr>

          <td class="right_cell">Manager:</td>

          <td colspan="4" class="top_cell"><input name="ck_manager" type="text" id="ck_manager" value="<?php echo $row_rstSix['ck_manager']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">Contact's Full name:</td>

          <td colspan="4" class="top_cell"><input name="ck_contact" type="text" id="ck_contact" value="<?php echo $row_rstSix['ck_contact']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">First name:</td>

          <td colspan="4" class="top_cell"><input name="ck_firstname" type="text" id="ck_firstname" value="<?php echo $row_rstSix['ck_firstname']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">Last name: </td>

          <td colspan="4" class="top_cell">

            <input name="ck_lastname" type="text" id="ck_lastname" value="<?php echo $row_rstSix['ck_lastname']; ?>" size="35">

          </td>

        </tr>

        <tr>

          <td class="right_cell">Contact's position:</td>

          <td colspan="4" class="top_cell"><input name="ck_position" type="text" id="ck_position" value="<?php echo $row_rstSix['ck_position']; ?>" size="35"></td>

        </tr>

        <tr>

          <td height="24" class="right_cell">Contact's tel:</td>

          <td colspan="4" class="top_cell"><input name="ck_tel" type="text" id="ck_tel" value="<?php echo $row_rstSix['ck_tel']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">Contact's email: </td>

          <td colspan="4" class="top_cell"><input name="ck_email" type="text" id="ck_email" value="<?php echo $row_rstSix['ck_email']; ?>" size="45"></td>

        </tr>

        <tr>

          <td class="right_cell"> </td>

          <td colspan="4" class="top_cell"> </td>

        </tr>

        <tr>

          <td class="right_cell"> </td>

          <td colspan="4" class="top_cell"> </td>

        </tr>

        <tr>

          <td class="right_cell">My own notes: </td>

          <td colspan="4" class="top_cell"><textarea name="ck_notes" cols="75" rows="4" id="ck_notes"><?php echo $row_rstSix['ck_notes']; ?></textarea></td>

        </tr>

        <tr>

          <td class="right_cell">Confirm and Submit: </td>

          <td width="10%"><input type="submit" name="Submit" value="Submit">

          </td>

          <td width="22%"><a href="../index.htm">Return To Website</a></td>

          <td width="9%"><a href="chk_access.php?org=<?php echo $row_rstSix['ck_organisation']; ?>">Access</a></td>

          <td width="39%"><a href="chk_insert.php">List</a></td>

        </tr>

        <tr>

          <td class="right_cell">**These fields are required.</td>

          <td colspan="4"> </td>

        </tr>

        <tr>

          <td class="right_cell"> </td>

          <td colspan="4"> </td>

        </tr>

      </table>

      <input type="hidden" name="MM_update" value="form1">

    </form></td>

 

Any help most gratefully received.

 
Replies
  • Currently Being Moderated
    Apr 12, 2012 5:41 PM   in reply to smiffy47

    Do you have any style definitions for the id "cel_blb" ?

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 12, 2012 11:20 PM   in reply to smiffy47

    Try loading your site on http://browserlab.adobe.com and compare multi-browsers there. Let us know what the results are.

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 13, 2012 2:43 AM   in reply to smiffy47

    Can you upload your files and give us an active link so we could test it?

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 13, 2012 9:16 AM   in reply to smiffy47

    A couple of options I see in this scenario:

     

    1. Try loading up the page on a previous version of Firefox

    2. Try opening Firefox 11 with add-ons disabled (safe mode) - if I'm not wrong, the hotkey is to hold ALT or OPT when opening

     

    See if these work

     

    If possible, atleast post a DB Schema here with the collation types. FF 11 has some issues fetching certain table types in MySQL and I've personally experienced these.

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 13, 2012 10:40 PM   in reply to smiffy47

    I guess there seems to be an issue with one or more of add-ons you've installed in Firefox. Did you also check in FF4 (without Safe Mode)?

     

    Try doing the following:

     

    First backup your Database, then try one of these 2 options:

     

    1. Change your DB collation type to utf8_general

    Check in FF11.

     

    2. Change the type of cel_blb to text instead of mediumtext

    Check in FF11.

     

    See of either of these options work.

     

    If not, let us know what character set you're using in your HTML header (post your HTML header if possible). Also, post a list of all your add-ons that you've installed on Firefox. In firefox, type about:addons in your addressbar to bring up the list of all add-ons.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 14, 2012 9:21 AM   in reply to smiffy47

    I wonder if the use of TinyMCE is causing the problem.

     

     

    Captain Obvious just made a comment to me: I wonder if you can remove TinyMCE to test that theory.

     

    best,

    Shocker

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 14, 2012 9:33 AM   in reply to smiffy47

    smiffy47 wrote:

     

    Thanks for following this up, Sudarshan.

    Your 2 suggestions in the previous post yielded no improvement.

    I post below the portion of the webpage that precedes the form quoted above.  I wonder if the use of TinyMCE is causing the problem.

    We're getting there. What version of TinyMCE are you currently on? 3.5b3 is the latest version and I guess they've resolved the render issue caused with most textboxes in this release as this came out after FF11.

     

    If you're not already on 3.5b3, try to upgrade and post your results here.

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 14, 2012 10:53 PM   in reply to smiffy47

    That's good news.

     

    To continue having a rich WYSIWYG editor functionality on your site, why dont you consider using CKEditor (formerly FCK Editor)?

     

    I've implemented this on multiple websites and it works like a charm.

     

    Please see screenshots:

     

    The CMS that we built - notice there are 2 textarea editors:

     

    Screen Shot 2012-04-15 at 11.19.43 AM.png

    The Frontend - Notice the content from the backend showing up without a glitch:

    Screen Shot 2012-04-15 at 11.20.36 AM.png

     

    Your scenario and mine are different - but I see this as a possible solution.

     

    Let us know if this is any good for you.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points