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

[news]

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.uk) 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

[Jerry Stuckle]

ne**@smutchin.co.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.uk) 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.
js*******@attglobal.net
==================

[davek]

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

[Jerry Stuckle]

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.
js*******@attglobal.net
==================