Nothing appears in db.

Guiri

It`s a real estate script that was working fine on two servers until two days ago. When we try to add a new property it does not appear in the db. We can modify and delete existing properties no problem.
Register_globals are on.
No error messages are shown.

Look at code here: http://red-dns.com/php/add_act.txt

swr

Any time you do mysql_query(...) you should instead do this:

mysql_query(...) or die(mysql_error());

Make that change and it will probably give you an error message telling you why your insert is not working.

Guiri

I modified the code, and I get this error 'Duplicate entry '127' for key 1' but not sure what it means.

Guiri

OK, we fixed it, using an alter table command making the auto-increment value larger (smallint or int).

Thanks.

swr

That error usually happens when you have a column in the table that is of type "tinyint" and are trying to insert (maybe through auto increment) a value that is larger than 127. The tinyint data type only supports values of (I think) -128 to 127, and you are probably inserting (or auto incrementing) beyond 127, which can't work with tinyint.

Change the column data type to "int" and the problem will go away. It will eventually run into problems too, but you'll have to do billions of inserts before that happens. 🙂

[Edit]
Looks like you figured it out yourself. 🙂 Be aware that smallint will run into the same problem at 32767. I usually use int for primary keys, which can go to over two billion.