"call to undefined function" mysql_error when adding new rows to table

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • news@smutchin.co.uk
    #1

    "call to undefined function" mysql_error when adding new rows to table

    Hi all, hope you can help me.

    I have recently set up a mysql database of local pubs, with a web form
    to add new listings (using PHP to generate an INSERT query).

    I've just been doing a bit of data entry, adding a bunch of new pubs,
    and all was going swimmingly. But suddenly it has stopped working - now
    when I try to add a new pub I get an error message "call to undefined
    function". I have not altered the script in any way since the last
    successful addition was made.

    I ran a SELECT * query on the pubs table to proofread the entries, but
    couldn't spot any glaring errors. Then I ran a SELECT COUNT(*) on the
    table. The result was 100, ie there were rows numbered 0-99.

    I'm wondering if there could be a problem with handling three-figure
    row numbers. It sounds highly unlikely (I've checked the documentation
    so I know the table [MyISAM] is supposed to be able to handle many more
    rows than that).

    Maybe it's a restriction imposed by my webhost? (Supanames.co.u k) This
    also sounds unlikely.

    But in any case, I'm completely baffled. Can anyone suggest any
    possibilities?

    (Btw, I don't know which version of PHP Supanames has installed.)

    cheers,

    David

    Tags: None
    • Jerry Stuckle
      #2
      Re: "call to undefined function" mysql_error when adding new rowsto table

      news@smutchin.c o.uk wrote:
      Hi all, hope you can help me.
      >
      I have recently set up a mysql database of local pubs, with a web form
      to add new listings (using PHP to generate an INSERT query).
      >
      I've just been doing a bit of data entry, adding a bunch of new pubs,
      and all was going swimmingly. But suddenly it has stopped working - now
      when I try to add a new pub I get an error message "call to undefined
      function". I have not altered the script in any way since the last
      successful addition was made.
      >
      What function is undefined?
      I ran a SELECT * query on the pubs table to proofread the entries, but
      couldn't spot any glaring errors. Then I ran a SELECT COUNT(*) on the
      table. The result was 100, ie there were rows numbered 0-99.
      >
      I'm wondering if there could be a problem with handling three-figure
      row numbers. It sounds highly unlikely (I've checked the documentation
      so I know the table [MyISAM] is supposed to be able to handle many more
      rows than that).
      >
      Shouldn't be any PHP problem. If you suspect a MySQL problem try
      comp.databases. mysql.
      Maybe it's a restriction imposed by my webhost? (Supanames.co.u k) This
      also sounds unlikely.
      >
      Did you ask them?
      But in any case, I'm completely baffled. Can anyone suggest any
      possibilities?
      >
      Sorry, my crystal ball is in the shop and you didn't give enough
      information to even know where to start!
      (Btw, I don't know which version of PHP Supanames has installed.)
      >
      Did you try phpinfo()?
      cheers,
      >
      David
      >

      --
      =============== ===
      Remove the "x" from my email address
      Jerry Stuckle
      JDS Computer Training Corp.
      jstucklex@attgl obal.net
      =============== ===

        Comment

        • davek
          #3
          Re: "call to undefined function" mysql_error when adding new rows to table

          Jerry Stuckle wrote:
          What function is undefined?
          "mysqlerror ()" [sic]

          I hadn't noticed the typo before because the mysql_query it related to
          hadn't previously returned a 'false' value... And it turns out the
          reason for the 'false' value was because the primary field in the table
          was a TINYINT and it was trying to enter a value higher than 127...
          doh!

          Apologies for wasting your time/bandwidth.
          (Btw, I don't know which version of PHP Supanames has installed.)
          >
          Did you try phpinfo()?
          No, didn't occur to me. Thanks for reminding me of that option!

          David

            Comment

            • Jerry Stuckle
              #4
              Re: "call to undefined function" mysql_error when adding new rowsto table

              davek wrote:
              Jerry Stuckle wrote:
              >
              >>What function is undefined?
              >
              >
              "mysqlerror ()" [sic]
              >
              I hadn't noticed the typo before because the mysql_query it related to
              hadn't previously returned a 'false' value... And it turns out the
              reason for the 'false' value was because the primary field in the table
              was a TINYINT and it was trying to enter a value higher than 127...
              doh!
              >
              Apologies for wasting your time/bandwidth.
              >
              No problem - been there, done that, got the T-Shirt (multiple, in fact
              :-) ).
              >
              >>>(Btw, I don't know which version of PHP Supanames has installed.)
              >>>
              >>
              >>Did you try phpinfo()?
              >
              Always a good thing to remember!
              >
              No, didn't occur to me. Thanks for reminding me of that option!
              >
              David
              >


              --
              =============== ===
              Remove the "x" from my email address
              Jerry Stuckle
              JDS Computer Training Corp.
              jstucklex@attgl obal.net
              =============== ===

                Comment

                Previous template Next
                Working...