mysql_errno Stops form :(

[Clint Malarchuk]

I purchased a website that has a small program where users enter data to a database.

None of the files have been edited.

I transferred the files to a different server today, created the new database (with the same names/password) and imported the tables.

Now when I enter a form like I did on the previous server I get this error "Problem adding to database"

That is the message that happens when filling out the form fails.

    if (mysql_errno() != 0) {
        echo "Problem adding to database";
        echo "\nsql=$sql\n";
        echo mysql_error();
    } 

I'm confused why this would happen.

[NogDog]

Do you get any of the other debug info after that message (the stuff that would be output by the following echo of $sql and then mysql_error())?

[Clint Malarchuk]

Do you get any of the other debug info after that message (the stuff that would be output by the following echo of $sql and then mysql_error())?

Yes

The form is actually really big (but like it said it worked perfectly on the other server).

When I hit 'send' instead of the form success page I get an error like this...

Problem adding to database sql=insert into mydatabasename.database (

and after that is the full list of each field and the values

[NogDog]

What is the very last part of the error output, i.e. the result of the mysql_error() call? That should tell you what part of the query MySQL did not like.

[Clint Malarchuk]

Because of confidnetiality reasons I can't pubicize the form details but there are a few things that are coming up that I think you're looking for is

on duplicate key
Incorrect integer value

But like I said on the only server the forms still work perfectly.

[NogDog]

Probably a PHP version issue. See http://bugs.mysql.com/bug.php?id=18551.

[Clint Malarchuk]

Thanks, I found out that both servers use the same version of PHP

[Clint Malarchuk]

I have discovered that one server uses Windows and the other (working) server uses Linux. Does that mean anything?

[NogDog]

I suppose it's possible, though it would seem unlikely. I'd be more suspicious that one MySQL installation is configured to run in MySQL 4 compatibility mode while the other is not (see the "bug" report link in my previous reply). You can try adding the following to your script after the mysql connection is made but before the query is executed, in order to make it run in MySQL 4 mode, too:

mysql_query("set sql_mode = ''"); 

[NogDog]

PS: Or you could just try to fix the query.

If the issue is the same as described in that "bug" report, it could be a case where you are trying to assign an empty string to an integer field, in which case you should use the keyword NULL instead of empty quotes for that value (or else a zero if that's what you really want).

[Clint Malarchuk]

mysql_query("set sql_mode = ''"); 

worked, thanks.

[Clint Malarchuk]

It looks like I jumped the gun.

The code you gave me allowed the me to get past any errors but it didn't actually add anything to the database